Search Postgresql Archives

Re: BDR Selective Replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On 26 April 2015 at 10:05, swaxolez <willem@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux