[Bucardo-general] Bucardo and Selective row sync in Master / Master mode

[A. David]

Hello,

I have a question in regards of Master / Master setup.

Consider the following setup: 1 table to sync (T1) across 3 (A,B,C) servers

T1 structure
    id (prim key)
    server_id INT
    message VARCHAR(..)

Let's assume A has server_id 1, B has server_id 2 and C has server_id 3

Is it possible to have the following scenario:

A,B,C able to write data into T1
B will only sync the data from T1 if server_id is 2 and ignore anything else
C will only sync the data from T1 if server_id is 3 and ignore anything else

Basically,
A's T1 will hold all the rows coming from B's T1 and C's T1
A can also write data to T1 but B and C will only sync the data from A's T1
if the server_id is 1 for B and server_id is 2 for C

?

Right now I am considering to solve this by creating multiple tables and
isolating the sync
to be done on each table for each server instead of having it all inside
one table.

Any suggestions welcome :-)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130912/555751cb/attachment.html>