2ndQuadrant | PostgreSQL
Bases de Datos de Misión Crítica
  • Contacto
  • ES
    • EN
    • FR
    • IT
    • DE
    • PT
  • Soporte & Servicios
    • Soporte
      • Soporte 24/7 para PostgreSQL
      • Soporte para Desarrolladores
    • Servicios DBA
      • DBA Remoto
      • Monitoreo para Bases de Datos
    • Servicios de Consultoría
      • Health Check
      • Ajustes de Rendimiento
      • Auditoría de Seguridad para Bases de Datos
      • Actualice PostgreSQL
    • Servicios para la Migración
      • Migrar a PostgreSQL
      • Evaluación de Migración
  • Productos
    • Postgres-BDR ®
    • Alta Disponibilidad PostgreSQL
    • Operadores Kubernetes para BDR & PostgreSQL
    • Administrar PostgreSQL en el Cloud
    • Instaladores
      • Postgres Installer
      • 2UDA
    • 2ndQPostgres
    • pglogical
    • Barman
    • repmgr
    • omniDB
    • SQL Firewall
    • Postgres-XL
  • Descargas
    • Instaladores
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Caso de Negocio para Soporte PostgreSQL
      • Postgres AlwaysOn
      • PostgreSQL con Alta Disponibilidad
      • Mejores Prácticas de Seguridad
      • BDR
    • Casos de Estudio
      • Migración de Bases de Datos
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
      • Ajustes de Rendimiento
        • BenchPrep
        • tastyworks
      • Clústeres de Bases de Datos Distribuidas
        • ClickUp
        • Agencia Espacial Europea (ESA)
        • Animal Logic
        • Telefónica del Sur
      • Actualizaciones de Bases de Datos
        • Instituto Alfred Wegener (AWI)
      • Soporte & Administración de Bases de Datos
        • Met Office
        • Agilis Systems
        • London & Partners
  • Centro de Aprendizaje Postgres
    • Webinars
      • Próximos Webinars
      • Biblioteca de Webinar
    • Whitepapers
      • Caso de Negocio para Soporte PostgreSQL
      • Postgres AlwaysOn
      • PostgreSQL con Alta Disponibilidad
      • Mejores Prácticas de Seguridad
      • BDR
    • Blog
    • Formación
      • Catálogo de los Cursos
    • Casos de Estudio
      • Ajustes de Rendimiento
        • BenchPrep
        • tastyworks
      • Clústeres Distribuidos
        • ClickUp
        • Agencia Espacial Europea (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Administración de Bases de Datos
        • Agilis Systems
      • Formación Profesional
        • Met Office
        • London Partners
      • Actualizaciones de Bases de Datos
        • Instituto Alfred Wegener (AWI)
      • Migración de Bases de Datos
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Libros
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2a Edición
      • PostgreSQL 9 Administration Cookbook – 3a Edición
      • PostgreSQL Server Programming Cookbook – 2a Edición
      • PostgreSQL 9 Cookbook – Edición en Chino
    • Videos
    • PostgreSQL
      • PostgreSQL – La historia
      • ¿Quién usa PostgreSQL?
      • Preguntas Frecuentes sobre PostgreSQL
      • PostgreSQL VS MySQL
      • Caso de Negocio para PostgreSQL
      • Información de Seguridad
      • Documentación
  • Sobre nosotros
    • Sobre 2ndQuadrant
    • La Pasión de 2ndQuadrant por PostgreSQL
    • Noticias
    • Trabaje con Nosotros
  • Blog
  • Menú Menú
Usted está aquí: Inicio1 / Telefónica del Sur

Telefónica del Sur

Chilean Telecommunication Company Successfully Implements Postgres-bdr for Phone Number Portability Database

Telefónica del Sur  is a telecommunications branch of Grupo GTD in Chile, providing services for the southern part of the country. Telefónica del Sur stands out as a technological pioneer, offering customized solutions for telecommunications networks. They were the first to offer direct national dialing, implementation of call identifiers, digital television, and ADSL broadband in cities outside of Santiago.

Telefónica del Sur uses PostgreSQL as a database for multiple platforms and have implemented Postgres-BDR (Bi-Directional Replication for PostgreSQL) for efficient multi-master replication in geographically distributed telecommunication networks.

Need for multi-master replication

Telefónica del Sur focuses on user-oriented products and services where a small number of products are aimed at millions of users, leading to a variety of data management challenges. Having a high performing, distributed database across various locations was needed for increased availability and efficient management of data. It was crucial for Telefónica del Sur to ensure the network stays up and running at all times, and that customers receive uninterrupted service where they can always have access to updated data. A high availability application architecture working with Multi-master replication for a distributed cluster would ensure round-the-clock system availability, tolerant of node failure.

Introduction to Postgres-BDR

Postgres-BDR is a ground-breaking multi-master replication tool for PostgreSQL databases. In the complex environment of replication, BDR achieves efficiency and accuracy, ensuring very high availability of all nodes in a geographically distributed cluster.

In the beginning of 2015, Telefónica del Sur researched and tested several PostgreSQL replication tools available in the market in an attempt to find a solution that could satisfy their requirements. They started evaluating Postgres-BDR and performed several failure tests. BDR stood its ground in all the assessments and was in production by the end of the year. Félix Jara, Development Engineer at Telefónica del Sur explains:

“We were looking for a solution with a high failure tolerance for our distributed infrastructure, and we found BDR to be the perfect solution because of its robustness.”

Telefónica del Sur currently runs several BDR clusters in Chile, stretching from Santiago to Coyhaique. Their largest BDR cluster consists of 28 nodes, and is used for efficient management of their phone number portability database.

“Postgres-BDR has become a standard replication solution for all the systems in our company. Any project/application that uses PostgreSQL as the backend database uses BDR by default.”

José Calquín, Development Engineer, Telefónica del Sur

It was of paramount importance to Telefónica del Sur to offer high-quality and uninterrupted services, and that was made possible through the implementation of Postgres-BDR. At the time of this writing, they had not faced any data loss or service interruption, even during the most challenging situations.

“We would like to tell our story with BDR, to show that nowadays, it is possible to work with open-source PostgreSQL and have a solid multi-master replication solution that offers robustness for geographically distributed systems. We have thousands of kilometers spread between nodes and we have not experienced any problems, even with real-time replication clusters. We use BDR for telecommunications, the service we offer to our clients allows them to control their phone usage in real-time; how long their phone call lasted, the remaining minutes in their account, and generate a record of information in a matter of seconds.”

Félix Jara, Development Engineer, Telefónica del Sur

Download the case study here.

About 2ndQuadrant

2ndQuadrant provides PostgreSQL solutions for the Enterprise. Our support engineers have over 100 years of combined code contributions to the PostgreSQL project, making us the only company to contribute enterprise features to all of the last 13 releases.

This is paired with 17+ years of hands-on experience through client engagements and allows us to integrate customized solutions with our customers – making 2ndQuadrant the Gold Standard for PostgreSQL products & services.

Recent Posts

  • PG Phriday: 10 cosas que Postgres podría mejorar – Parte 3 noviembre 8, 2020
  • Búsqueda de texto completo desde PostgreSQL 8.3 noviembre 5, 2020
  • Webinar: Mejores prácticas para la carga masiva de datos en PostgreSQL [continuación] noviembre 4, 2020
  • Números aleatorios noviembre 4, 2020
  • ¿Qué partición de mi base de datos PostgreSQL contiene una fila determinada? noviembre 1, 2020
  • Twitter
  • Linkedin
  • Facebook
  • Youtube
  • Mail

Soporte y Servicios

Soporte de producción 24/7

Soporte para desarrolladores

DBA remoto para PostgreSQL

Monitoreo para bases de datos PostgreSQL

Health Check para PostgreSQL

Ajustes de Rendimiento para PostgreSQL

Auditoría de seguridad para bases de datos

Actualice PostgreSQL

Evaluación de Migración hacia PostgreSQL

Migre desde Oracle

Productos

PostgreSQL de alta disponibilidad

BDR

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

Firewall SQL

Postgres-XL

OmniDB

Postgres Installer

2UDA

Centro de Aprendizaje Postgres

PostgreSQL

Blog

Webinars

Libros

Videos

Formación

Casos de Estudio

Eventos

Sobre nosotros

Sobre 2ndQuadrant

¿Qué significa «2ndQuadrant»?

Noticias

Trabaje con nosotros

Nuestro equipo

© 2ndQuadrant Ltd. All rights reserved | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Desplazarse hacia arriba
×