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

[A. David]

I think that only applies to the columns you want to select ?

Also forgot to mention I am using the github version hence:


Remove the customselect parameter. Use the customcols command, instead.

    [David Wheeler]

Will this allow to have a "WHERE clause" or it will only allow me to
do "column1, columnN..."
?



Thanks.



On Fri, Sep 13, 2013 at 4:17 PM, Michelle Sullivan <michelle at sorbs.net>wrote:

> 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/
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130913/39d2f430/attachment-0001.html>