AlwaysOn Multi-Master Clusters for Distributed Postgres
Postgres-BDR is a ground-breaking multi-master clustering tool for distributed PostgreSQL databases. With the increasingly challenging demands of the modern business environment, the 3rd generation of BDR achieves efficiency and accuracy, ensuring up to 99.9999% (6 nines) of availability in a geographically distributed cluster. Postgres-BDR is fully backed by 2ndQuadrant’s renowned 24/7 Production Support and Remote DBA services.
Developer Support. Get access to our PostgreSQL expertise for developers.
Consulting. Get expert advice from a BDR specialist for your use case.
Postgres-BDR v3 from 2ndQuadrant presents true high availability for your PostgreSQL databases providing up to 99.9999% (6 nines) of availability. BDR guarantees an AlwaysOn service, regardless of node failure with these unique features:
Shadow Masters. A second master, working in passive, receive-only mode that is ready to accept write connections at any point. This allows the cluster to switchover without the application noticing any delays.
Automatic Switchover. In case of failure or loss of a master node, Postgres-BDR almost instantaneously (less than 100ms) switches over to the shadow master, preventing service interruptions.
Tolerance of Software Failure. Logical and physical replication can run simultaneously, so the cluster is protected by two kinds of replication, providing higher tolerance to software failure.
To have a deeper view of the scenarios when designing an ‘Always On’ architecture for PostgreSQL, download the AlwaysOn.
The 3rd generation of Postgres-BDR gives you the advantage of keeping your PostgreSQL instances updated all the time. There is no need of matching configuration, CPU architecture or software versions among the master nodes. This allows Postgres-BDR to perform one-by-one upgrades with zero downtime when a new PostgreSQL release or update is available.
Geographically Distributed Clusters
Postgres-BDR is specifically designed for geographically distributed databases, providing the flexibility to choose between “eager” and “efficient” modes. The following characteristics can be tweaked based on your latency-consistency needs: tolerance of network latency, replication lag, and latency for read/write access to data.
Point-in-Time Recovery (PITR)
Postgres-BDR v3 allows any node to be backed up from any node in a cluster and then restored using Point-In-Time Recovery. Each node can perform backups, ensuring that whole-cluster backups are taken in every region to guarantee full disaster recovery capability.
Tools and Solutions
OmniDB is an interactive and powerful, yet lightweight, database management tool. OmniDB allows users to manage multiple databases in a unified workspace with a user-friendly and fast-performing interface.
OmniDB supports Postgres-BDR groups, allowing the user to view/add/remove nodes from groups and perform all tasks in every node.
pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. pglogical forms the foundation for Postgres-BDR – which runs as an extension on top of it – providing the essential logical replication and other technologies for its features.
Internet of Things
The IoT Solution from 2ndQuadrant is a distributed data storage platform for the Internet of Things that provides on-demand horizontal scalability, complex data analytics, and deep learning features. The storage solution can be deployed on-premise, in the cloud, on edge devices, or a hybrid of the three.
With this solution, data can be stored in the form of time series or spatial to run analytics and gain valuable information such as predictive analytics. The IoT solution is powered by Postgres-BDR to ensure up to 99.9999% (6 nines) availability, providing scalable and reliable PostgreSQL clusters in a geographically distributed environment.
Telefónica del Sur is a Chilean telecommunications company that stands out as a technological pioneer. Telefónica del Sur aims to offer their customers across the country an uninterrupted service, to achieve this a high performing, highly available database environment was needed. Several PostgreSQL replication tools were tested and Postgres-BDR stood out as the best option for their requirements.
Animal Logic – one of the world’s most creative digital studios producing award-winning, groundbreaking animation, visual effects, and design – has been using PostgreSQL as a core database technology for many years. Animal Logic chose Postgres-BDR and 2ndQuadrant to support their custom production workflow system that is geographically distributed between two studios located on two continents.
Choosing the best deployment option for your enterprise software can depend on a number of factors. 2ndQuadrant provides several options to deploy Postgres-BDR based on budget, internal resources, access to hardware, and more.
The BDR experts at 2ndQuadrant will help you evaluate the best deployment option based on your business needs, among the following options:
Postgres Cloud Manager (PCM). PCM offers a quick and easy deployment of highly available BDR clusters using Trusted Postgres Architecture (TPA) from 2ndQuadrant. PCM is available for deployment on the Cloud – both public and private.
Docker Images.This option provides a flexible and quick deployment model for Postgres-BDR clusters. Docker images manage to reduce deployment times significantly, allowing you to create containers without external runtime requirements. It gives you the possibility of creating a personalized architecture with minimal configuration.
Binary Repository.Postgres-BDR is available for deployment via 2ndQuadrant’s yum & apt repositories – designed and maintained for production use. The binaries, in the form of RPMs and DEBs respectively, can be installed using the native package managers of the operating system of your choice. This provides a stable and reliable access to the software, on-premise and in the Cloud.
Interested in learning more about BDR?
Postgres-BDR Whitepaper This whitepaper offers an in-depth overview of BDR3, the third generation of Postgres-BDR, including its features and their benefits, use cases, and deployment options.
AlwaysOn Postgres Whitepaper A deeper look into the scenarios when designing an ‘Always On’ architecture for PostgreSQL, including the desirable features and benefits of delivering geographically distributed, AlwaysOn Postgres in a business environment.
This webinar held on May 16, 2018 and conducted by Simon Riggs, CEO at 2ndQuadrant covered the following topics: introduction to Postgres-BDR, BDR architecture, high availability, disaster recovery, rolling upgrades, latency and geographical distribution with Postgres-BDR, common use cases, and making applications compliant.
This webinar held on January 8, 2019 and conducted by Simon Riggs, CEO at 2ndQuadrant covered the following topics: latest on pglogical and Postgres-BDR, overview of existing features, updates on new features, and roadmap.