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