BDR 0.9.0 released

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>
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>
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/>
http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA,
Training & Services