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

[Michelle Sullivan]

A. David wrote:
> 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 :-)

Read up on 'custom select' ;-)

Michelle

-- 
Michelle Sullivan
http://www.mhix.org/