Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Postgres-BDR Replication

Bi-Directional Replication for PostgreSQL (Postgres-BDR, or BDR) is the first open source multi-master replication system for PostgreSQL to reach full production status. Developed by 2ndQuadrant, BDR is specifically designed for use in geographically distributed clusters, using highly efficient asynchronous logical replication, supporting anything from 2 to more than 48 nodes in a distributed database.

Organizations with geographically distributed databases will understand the complexity of replication and the goal of achieving efficient and accurate replicas of data. Unlike other solutions, BDR doesn't rely on using triggers to collect changes and insert them into a queue table. Instead it processes the WAL using the changeset extraction mechanism developed by 2ndQuadrant for version 9.4 of PostgreSQL. This solution avoids the write amplification involved in trigger-based solutions.


Postgres-BDR has some very impressive results, which you can view [here].


(NEW! Postgres-BDR 2.0 on Server Version 9.6 Now Available!)
2ndQuadrant is proud to announce the availability of BDR 2.0 running as an extension to community PostgreSQL 9.6 for its support customers. You can now make full use of the additional features offered with PostgreSQL 9.6 while using Multi-Master Replication from BDR,
(Postgres-BDR 1.0.2 on Server version 9.4.13 Released - August 21, 2017)
Postgres-BDR is available as RPMs via yum for Fedora, CentOS, & RHEL, and as DEBs via apt for Debian and Ubuntu. For installation instructions, please click here.
You can view the release notes here.
The complete source code for Postgres-BDR is available here.

How to Get Started

For an example setup visit our [start-up guide], which will explain how to get a simple setup of Postgres-BDR running on Linux in just a few minutes.

Postgres-BDR Documentation

The full BDR reference manual is available here.

Postgres-BDR vs Other Open Source Replication Solutions

Postgres-BDR has a lower impact on the masters(s) than trigger-based replication solutions. There is no write-amplification, as it does not require triggers to write to queue tables in order to replicate writes.

Support for Postgres-BDR

Community Support
You can raise a query with the Postgres-BDR community by sending an email to bdr-list@2ndQuadrant.com. Alternatively, you can access it via Google Groups at https://groups.google.com/a/2ndQuadrant.com/forum/#!forum/bdr-list.
Professional Support
Postgres-BDR is developed and supported by 2ndQuadrant. 2ndQuadrant provides professional support for BDR, as well as consultation and training.  With our deep knowledge of distributed databases, we will ensure that you are able to evaluate your use case and applications and determine the most suitable product or solution.
Postgres-BDR is also available in 2ndQuadrant Cloud, initially on AWS.


Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

PostgreSQL Monitoring Tools

PostgreSQL pgBadger