[Bucardo-general] Multi-Master configuration in Bucardo

ning chan ninchan8328 at gmail.com
Mon Jan 8 22:18:06 UTC 2018


Hi Bucardo experts,

I am new to bucardo and have a question about how should i setup
multi-master db using bucardo.

Here is the list commands I execute on each node:

Node#1
./bucardo add db mmdb01 dbname=test host=mmdb01 user=bucardo
./bucardo add db mmdb02 dbname=test host=mmdb02 user=bucardo
./bucardo add db mmdb03 dbname=test host=mmdb03 user=bucardo
./bucardo add all tables -T test1 herd=mmdb_herd
./bucardo add dbgroup mmdb_db_group  mmdb01:source
./bucardo add dbgroup mmdb_db_group  mmdb02:target
./bucardo add dbgroup mmdb_db_group  mmdb03:target
./bucardo add sync mmdb_sync herd=mmdb_herd dbs=mmdb_db_group autokick=0
./bucardo validate mmdb_sync
./bucardo update sync mmdb_sync autokick=1
./bucardo start

Node#2
./bucardo add db mmdb01 dbname=test host=mmdb01 user=bucardo
./bucardo add db mmdb02 dbname=test host=mmdb02 user=bucardo
./bucardo add db mmdb03 dbname=test host=mmdb03 user=bucardo
./bucardo add all tables -T test1 herd=mmdb_herd
./bucardo add dbgroup mmdb_db_group  mmdb02:source
./bucardo add dbgroup mmdb_db_group  mmdb01:target
./bucardo add dbgroup mmdb_db_group  mmdb03:target
./bucardo add sync mmdb_sync herd=mmdb_herd dbs=mmdb_db_group autokick=0
./bucardo validate mmdb_sync
./bucardo update sync mmdb_sync autokick=1
./bucardo start

Node#3
./bucardo add db mmdb01 dbname=test host=mmdb01 user=bucardo
./bucardo add db mmdb02 dbname=test host=mmdb02 user=bucardo
./bucardo add db mmdb03 dbname=test host=mmdb03 user=bucardo
./bucardo add all tables -T test1 herd=mmdb_herd
./bucardo add dbgroup mmdb_db_group  mmdb03:source
./bucardo add dbgroup mmdb_db_group  mmdb02:target
./bucardo add dbgroup mmdb_db_group  mmdb01:target
./bucardo add sync mmdb_sync herd=mmdb_herd dbs=mmdb_db_group autokick=0
./bucardo validate mmdb_sync
./bucardo update sync mmdb_sync autokick=1
./bucardo start

Does it seems to be a reasonable setting for multi-master database?
Reason i asked is that as soon as one of the node is gone, it stall
replication right way, is that the expected behavior?

Thanks~
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180108/dd79742a/attachment.html>


More information about the Bucardo-general mailing list