Multi-Master Replication (BDR)

Traditional PostgreSQL replication involves one primary (master) and one or more standbys (replicas). Writes only happen on the primary, and reads can be offloaded to replicas.

Multi-master replication (MMR) is different. It allows writes to occur on multiple database servers simultaneously, with all changes synchronized across the cluster.

MMR offers significant advantages over traditional single-master setups:

• High Availability: If one master node fails, others can continue accepting writes, ensuring continuous operation.
• Write Scalability: Distribute write operations across multiple nodes, potentially improving performance for write-heavy applications.
• Geographic Distribution: Place active database nodes closer to users in different regions, reducing latency for local operations.