Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

BDR (Bi-directional replication)

BDR was initially developed at 2ndQuadrant; others have joined the effort. Contributions are appreciated and welcome. Multiple 2ndQuadrant customers contribute funding to make BDR development possible.
2ndQuadrant, a Platinum sponsor of the PostgreSQL project, continues to develop BDR to meet internal needs and those of customers. 2ndQuadrant is also working actively with the PostgreSQL community to integrate BDR into PostgreSQL. Other companies as well as individual developers are welcome to participate in the efforts.
Multiple technologies emerging from BDR development have already become integral part of core PostgreSQL, such as Event TriggersLogical DecodingReplication SlotsBackground Workers,Commit TimestampsReplication OriginsDDL event capturegeneric WAL messages for logical decoding.

I. Getting started
1. BDR overview
2. Quick-start guide
3. Installation
II. BDR administration manual
4. Configuration Settings
5. Node Management
6. Command-line Utilities
7. Monitoring
8. DDL Replication
9. Multi-master conflicts
10. Global Sequences
11. Replication Sets
12. Functions
13. Catalogs and Views
14. Upgrading BDR

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.

Simple BDR Setup


Popular posts from this blog

rman interview and scenario based questions and answer and also rman(backup and recovery) discussions panel

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 pgBadger