[Bucardo-general] Question about replication chain by using Bucardo
Guizhen wang
gzqiu at yahoo.com
Thu Oct 13 22:00:48 UTC 2011
Our database replication is chained.
replicated
database 1 (Master) ========> database 2 (slave/master) and database 3 (slave)
Then database 2 is also a master that replicated to database 4 and database 5. Database 2 also contains more tables than database1 to be replicated.
replicated
database 2 (Slave/Master) ========> database 4 (slave) and database 5 (slave)
When tried Bucardo 4.4.6, I setup two Bucardo instances.
One handles the replication from
replicated
database 1 (Master) ========> database 2 (slave) and database 3 (slave)
Another one handles the replication from
replicated
database 2 (Slave/Master) ========> database 4 (slave) and database 5 (slave)
Is the way above right setup from Bucardo replication? If not, what are the better setups to handle the replication chain case? One Bucardo instance or multiple instances?
When the data were replicated into database 2 from database 1 but nothing was going to bucardo_delta table in database 2 even though the delta triggers have been created for the tables in database 2.
When two Bucardo databases are running same machine but using different port number, start one bucardo always kills another bucardo instance. Is it true that only one Bucardo instance can be run on one machine?
Thanks,
Guizhen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20111013/399b3369/attachment.html
More information about the Bucardo-general
mailing list