[Bucardo-general] Multi-Master configuration in Bucardo
Tyler.Hains at ingenico.com
Thu Jan 18 14:17:19 UTC 2018
The whole point of clustering is to remove single points of failure. How does one set up bucardo on multiple nodes so that you don’t end up with the only bucardo daemon offline, and effectively without a cluster?
From: bucardo-general-bounces at bucardo.org [mailto:bucardo-general-bounces at bucardo.org] On Behalf Of David Christensen
Sent: Monday, January 08, 2018 5:26 PM
To: ning chan <ninchan8328 at gmail.com>
Cc: bucardo-general at bucardo.org
Subject: Re: [Bucardo-general] Multi-Master configuration in Bucardo
You should only run the bucardo commands on a single node (the server that you are running the “bucardo daemon” on). That node can be, but need not be, one of the database nodes. There is a single Bucardo daemon, not one that runs on each nose, so it is unnecessary (and unadvised) to have them running on each node.
When setting up a multi-master database cluster, you will just add each of the databases in the database groups as sources; it will work out that you mean to do a multi-master cluster.
Updating your example:
./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:source
./bucardo add dbgroup mmdb_db_group mmdb03:source
./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
As far as the stalling behavior, that is currently how Bucardo is written, so this is a known issue.
End Point Corporation
david at endpoint.com<mailto:david at endpoint.com>
This email and its content belong to Ingenico Group. The enclosed information is confidential and may not be disclosed to any unauthorized person. If you have received it by mistake do not forward it and delete it from your system. Cet email et son contenu sont la propriété du Groupe Ingenico. L’information qu’il contient est confidentielle et ne peut être communiquée à des personnes non autorisées. Si vous l’avez reçu par erreur ne le transférez pas et supprimez-le.
The information contained in this email and any attachments is private and is the confidential property of Ingenico Group. If you are not the intended recipient(s) or have otherwise received this email in error, please delete this email and inform the sender as soon as possible. Neither this email nor the information contained in any attachments may be disclosed, stored, used, published or copied by anyone other than the intended recipient(s). All orders for Ingenico Group products and services are accepted by Ingenico Group subject to the terms and conditions of sale set forth on the Ingenico Groups website, as such terms and conditions of sale may be changed from time to time without notice.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Bucardo-general