[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