Multi-Master Replication capability allows you to write to any node in the cluster, replicating data through all masters, achieving efficiency and accuracy. BDR supports fully automatic replication for both DDL and DML across multiple masters.
Cutting edge CAMO technology ensure that no transactions are duplicated across nodes or skipped. This works for Session and Transaction mode pooling and ensures that any in-flight transactions with unknown state are fully resolved.
BDR is specifically designed to support worldwide clusters, without any limitations on distance. It provides the flexibility to choose between “eager” and “efficient (async)” modes, depending on tolerance for consistency vs performance. BDR also provides the ability to store select data on local site only, without replicating to other nodes.
BDR presents true high availability for your PostgreSQL databases providing up to 99.9999% (6 nines) of availability. This level of AlwaysOn Availability in BDR is achieved via the following provisions:
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, BDR allows a quick promotion of a standby to a master in under 100ms, preventing any service interruption.
Tolerance of Software Failure. Logical and physical replication can run simultaneously, so the cluster is protected by two kinds of replication; providing a higher tolerance to software failure.
Rolling Upgrades. BDR runs across various configurations, CPU architectures, and software versions, allowing the solution to perform rolling upgrades with zero downtime. The upgrades can be rolled across nodes for new software versions, they can also be rolled across for database schema upgrades.
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 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 BDR – which runs as an extension on top of it – providing the essential logical replication and other technologies for its features.
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-premises, 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 BDR to ensure up to 99.9999% (6 nines) availability, providing scalable and reliable PostgreSQL clusters in a geographically distributed environment.
Project Management SaaS company ClickUp enlisted BDR to enhance scalability and performance requirements of their distributed database clusters. BDR’s implementation helped the company achieve consistent performance globally and grow their business in multiple regions.
Chilean Telecommunication company Telefónica del Sur implemented BDR to provide customers with uninterrupted service and access to updated data. BDR ensures efficient management of data and a high performing, highly available database environment.
Global award-winning digital creative studio Animal Logic uses Multi-master replication technology to support their custom production workflow system. The company uses Postgres-BDR for their studios based in 2 different 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.
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 BDR, BDR architecture, high availability, disaster recovery, rolling upgrades, latency and geographical distribution with 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: the latest on pglogical and BDR, an overview of existing features, updates on new features, and an associated roadmap.