MySql Replication with a star topology

Posted by Riotopsys on Server Fault See other posts from Server Fault or by Riotopsys
Published on 2010-02-11T18:57:55Z Indexed on 2010/04/03 20:03 UTC
Read the original article Hit count: 634

My company currently operates in 3 separate locations connected by slow vpn links. Each site hosts a dedicated MySql server. I need to aggregate the data from all three of them onto a single server for corporate reporting. The powers that be have stated I cannot use circular replication or federated tables. Is there a third party tool for MySql that can replicate from multiple masters? Basically the diagram would be a daisy with the reporting server slave at center with multiple replication connections coming in from the master sites on the petals.

© Server Fault or respective owner

Related posts about mysql-replication

Related posts about topology