2ndQuadrant, global experts in PostgreSQL support, training, development, migration and consultancy, have announced a free and open source extension to PostgreSQL (licensed under the same terms): Bi-Directional Replication (BDR).
An asynchronous multi-master replication system for PostgreSQL, BDR is the first of several replication technologies the company will announce this year to dramatically enhance the replication possibilities of PostgreSQL.
Aimed at organisations with geographically distributed databases, 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.
The company has a long history of advancing the development of PostgreSQL in general and has contributed a number of notable improvements to replication features. BDR features and modifications have (and will continue to be) moved into future releases of PostgreSQL.
2ndQuadrant’s CTO, Simon Riggs, commented: “BDR is a major enhancement to replication design. With up to 48 master nodes supported, it offers a significant opportunity to reduce the overhead and headaches experienced with previous approaches to replication. For any organisation with distributed PostgreSQL databases replicated across multiple master nodes, BDR should be seriously considered.”
BDR is available as open source software, direct from 2ndQuadrant, with consultancy and support contracts available to ensure users can successfully design and implement a stable replicated environment. Head to 2ndQuadrant’s site for more info. You can find a quick-start guide to setting up BDR over here.