[Bucardo-general] multi master

Vitaly Burshteyn vburshteyn at broadway.com
Fri Feb 26 16:31:21 UTC 2010


Thanks for the bellow solutions,

Both of these solutions worked.  With 100+ tables the direct approach was preffered :)
bucardo_ctl update table affiliates_affiliate standard_conflict=latest
If there are many tables, you may want to use direct SQL on it:
UPDATE goat SET standard_conflict = latest;

Just curious, in swap mode, is the update instant on the "target" as it was in the other mode?

I made few changes to one of the DB and no changes are being propagated.  The logs look clean so there are no errors.

Vitaly Burshteyn
Senior Network Engineer
Broadway.com, Theatre Direct International
729  7th Avenue
New York, New York 10019
Phone: 212.817.9117
Cell# 917-701-5732

-----Original Message-----
From: Greg Sabino Mullane [mailto:greg at endpoint.com] 
Sent: Thursday, February 25, 2010 3:14 PM
To: Vitaly Burshteyn
Cc: bucardo-general at bucardo.org
Subject: Re: [Bucardo-general] multi master

>    If I need to create master – master config
>    Do I create say:
>    bucardo_ctl add all tables --herd=m1 db=master1
>    bucardo_ctl add all tables --herd=m2 db=master2
>    bucardo_ctl add sync s1 source=m1  targetdb=master2 type=swap
>    bucardo_ctl add sync s2 source=m2  targetdb=master1 type=swap

You don't need to add things twice, just do this:

bucardo_ctl add all tables herd=m1 db=master1 standard_conflict=source bucardo_ctl add sync s1 source=m1 targetdb=master2 type=swap

Note that tables in a swap sync need to know how to resolve conflicts, so in the example above I set all tables to use a resolution of source, which means that the source database (master1) always wins in case of a conflict.

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8

The information contained in this transmission may contain privileged 
and confidential information.  It is intended only for the use of the 
person(s) named above. If you are not the intended recipient,  you are 
hereby notified that any review, dissemination, distribution or 
duplication of this communication is strictly prohibited. If you are 
not the intended recipient, please contact the sender by reply email 
and destroy all copies of the original message.

More information about the Bucardo-general mailing list