Bi-Directional Replication
Bi-Directional Replication (BDR) is a project used to allow multimaster replication with PostgreSQL. There is a range of possible architectures. The first use case we support is "all-nodes-to-all-nodes". BDR will eventually support a range of complex architectures, which is discussed later.
BDR is a fully open source project owned by the PostgreSQL Global Development Group. BDR aims for eventual inclusion within core PostgreSQL, though knowing that is a long and rigorous process, it also aims to provide working software solutions, now!
BDR aims to allow the nodes of the cluster to be physically distributed, allowing worldwide access to data and allowing for disaster recovery. Each BDR master node runs individual transactions; there is no globally distributed transaction manager.
BDR includes replication of data changes and data definition (DDL) changes. New tables are added automatically, ensuring that managing BDR is a low-maintenance overhead for applications...