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/ _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
