Bidirectional Replication is coming to PostgreSQL 9.6
blog.2ndquadrant.com
Bidirectional Replication is coming to PostgreSQL 9.6
1–10 of 71 posts
Re: Bidirectional Replication is coming to PostgreSQL 9.6
#2Now that is something very interesting. I would love to use this ASAP! :)
Re: Bidirectional Replication is coming to PostgreSQL 9.6
#3While indeed very exciting, it's important to note that this makes the BDR extension from 2ndquadrant compatible with stock Postgres. This does not include BDR shipping with core Postgres.
This continued improvement with the core code and extension APIs will make more and more extensions feasible which will mean more are able to plug-in and add value without things having to be committed to core. Though in time this is one that has a good chance of actually being in core much like pg_logical.
Re: Bidirectional Replication is coming to PostgreSQL 9.6
#4Would love to see this land in Amazon RDS's list of supported extensions!
Re: Bidirectional Replication is coming to PostgreSQL 9.6
#5I have not used 2ndquadrant's BDR extension. Anyone comment as to how easy it is to setup?
Re: Bidirectional Replication is coming to PostgreSQL 9.6
#6The title is misleading, the replication is not coming to stock Postgresql 9.6.
A replication extension got the patches it needs to run into Postgresql 9.6 so you can use the extension without patching Postgres.
Re: Bidirectional Replication is coming to PostgreSQL 9.6
#7Some info from 2nd Quadrant on what BDR is: https://2ndquadrant.com/en/resources/bdr/
Bi-Directional Replication for PostgreSQL (Postgres-BDR, or BDR) is the first open source multi-master replication system for PostgreSQL to reach full production status, developed by 2ndQuadrant and assisted by a keen user community. BDR is specifically designed for use in geographically distributed clusters, using highly efficient asynchronous logical replication, supporting anything from 2 to more than 48 nodes in a distributed database.
Re: Bidirectional Replication is coming to PostgreSQL 9.6
#8Some info from 2nd Quadrant on what BDR is: https://2ndquadrant.com/en/resources/bdr/ Bi-Directional Replication for PostgreSQL (Postgres-BDR, or BDR) is the first open source multi-master replication system for PostgreSQL to reach full production status, developed by 2ndQuadrant and assisted by a keen user community. BDR is specifically designed for use in geographically distributed clusters, using highly efficient…
> anything from 2 to more than 48 nodes in a distributed database
Why specify a range if you're going to leave it open-ended?
Re: Bidirectional Replication is coming to PostgreSQL 9.6
#9Looking forward to playing around with this. Native master-master replication is the only thing keeping me on MySQL.
Re: Bidirectional Replication is coming to PostgreSQL 9.6
#10Some info from 2nd Quadrant on what BDR is: https://2ndquadrant.com/en/resources/bdr/ Bi-Directional Replication for PostgreSQL (Postgres-BDR, or BDR) is the first open source multi-master replication system for PostgreSQL to reach full production status, developed by 2ndQuadrant and assisted by a keen user community. BDR is specifically designed for use in geographically distributed clusters, using highly efficient…
> anything from 2 to more than 48 nodes in a distributed database Why specify a range if you're going to leave it open-ended?
It's good to know what range people have tested with, even if it's not a hard cap.