Re: BDR Selective Replication

On 26 April 2015 at 10:05, swaxolez <willem(at)pcfish(dot)ca> wrote:

> It's not clear to me but is selective replication working in BDR? Does
> anyone have any examples if so?

Yes, selective replication (using replication sets) is supported in the
current 0.9 stable series.

The documentation on replication sets is very sparse at the moment; the
next iteration will improve that.

http://bdr-project.org/docs/stable/replication-sets.html

There are also some improvements needed to the user interface - in
particular, providing a function interface for changing replication set
memberships for connections so there's no need to manually restart the
apply backends after a change, and providing default replication sets for a
node. Current development priorities mean that these aren't expected in the
next few releases.

Note that selective replication affects *only* replication of rows. DDL is
still replicated on tables that are not members of any active replication
set. Also, changing replication set memberships won't synchronise the added
table's rows from other nodes, it'll just start replicating new changes
from its current state. You generally want to set up replication sets
before starting to add data to tables.

All this applies to 0.9.0 and is, of course, subject to change in future
releases, time and resources permitting.

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services