2ndQuadrant is delighted to announce the release of BDR 0.9.0, introducing some significant new features and enhancements to this open source PostgreSQL replication solution. These include:
· Dynamic SQL-level configuration of connections between nodes
· Joining new nodes no longer requires restarting all nodes
· Easy node removal
· UDR (Uni-Directional Replication)
· Replication Sets
· Documentation expanded and moved into the source tree
More details on each of these improvements are explained at http://bdr-project.org/docs/0.9.0/release-0.9.0.html
One of the most significant enhancements in the latest release is the introduction of Dynamic Configuration, which eliminates the need to restart any of the nodes during the node join or removal process, and cluster configuration can be done via plain SQL interfaces.
0.9.0 also features Replication Sets for the first time. Replication Sets allow admins to specify sets of tables that each node should receive changes on. It is now possible to exclude tables that are not of interest to a particular node, or to include only a subset of tables for replication to a node.
Replication sets can be used for data distribution, for data integration and for limited sharding.
Introducing UDR
With this release we’re also announcing a lighter version of BDR called UDR (Uni-Directional Replication) which brings the master-slave logical replication solution for the unmodified release of PostgreSQL 9.4. With UDR you get the same performance of native logical replication as BDR (as it does not require any triggers).There is also no need to run and monitor external deamons because it runs inside the PostgreSQL server itself. UDR brings all the advantages of logical replication like replication sets or the ability to use temporary or unlogged tables on the receiving side but with no query cancels for replication. This makes reporting from read-replicas much easier.
These latest enhancement bring even greater flexibility to users looking for an efficient method to manage distributed multi-node PostgreSQL databases.
For more details about the BDR Project, including links to documentation, packages, manuals and a start-up guide, visit http://2ndquadrant.com/bdr
BDR provides asynchronous multi-master logical replication. This means that you can write to any server and the changes will, after they have been committed, be sent row-by-row to all the other servers that are part of the same BDR group. BDR offers a far more efficient method of handling schema changes safely with a lower overhead than trigger based solutions.
--
Howard Rolph Worldwide Marketing Manager
Tel: +44 870 766 7756 http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services
