Notice: Undefined index: order_next_posts in /nas/content/live/gadgetmag/wp-content/plugins/smart-scroll-posts/smart-scroll-posts.php on line 194

Notice: Undefined index: post_link_target in /nas/content/live/gadgetmag/wp-content/plugins/smart-scroll-posts/smart-scroll-posts.php on line 195

Notice: Undefined index: posts_featured_size in /nas/content/live/gadgetmag/wp-content/plugins/smart-scroll-posts/smart-scroll-posts.php on line 196

Bi-Directional Replication for PostgreSQL announced by 2ndQuadrant

Low overhead, low maintenance technology for geographically distributed databases supports up to 48 nodes


BDR Basic Schema32ndQuadrant, 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.

You can view the results of BDR performance tests here.

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.