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: 602

Filed under:

mysql-replication

|

topology

|

synchronization

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

MySQL replication Slave_IO_Running: No

as seen on Server Fault - Search for 'Server Fault'
Hi all, I have two servers that I am trying to get replication of one database between. I found a setup guide on sourceforge that I followed and I have tried various other settings since then, but no matter what I do, when I start the slave, the 'Slave_IO_Running' setting is always No.... I have… >>> More
MySql Replication with a star topology

as seen on Server Fault - Search for 'Server Fault'
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… >>> More
Fixing MySQL Replication

as seen on Internet.com - Search for 'Internet.com'
Continuing last months article on "MySQL Replication Pitfalls," Sean Hull discusses what to do to make your replication setup more resilient. >>> More
Advanced MySQL Replication - Improving Performance

as seen on Internet.com - Search for 'Internet.com'
MySQL Replication can be made quite reliable and robust if the right tools are used to keep it running smoothly--but what if enormous loads on the primary server are overloading the slave server. Are there ways to speed up performance, so the slave can keep up? >>> More
MySQL Replication Error

as seen on Server Fault - Search for 'Server Fault'
I recently updated my master server to 5.1.41 and noticed that the slave was no longer replicating. It was returning this erorr: 091208 12:53:31 [ERROR] Slave I/O: error connecting to master '[email protected]:3306' - retry-time: 10 retries: 86400, Error_code: 2026 091208 12:53:41 [ERROR] Slave I/O:… >>> More

Related posts about topology

Setup MSSQL replication with peer to peer topology: problem setting up Conflict Detection

as seen on Server Fault - Search for 'Server Fault'
Hi, I'm setting up a SQL Replication strategy, using MSSQL2008 with peer-to-peer publications (2 servers, each one subscribes to the other). I followed this HOWTO from MSDN, and the setup seems to be working fine: add a record to one table on server A, query on server B shows the new record. So far… >>> More
What's Switched LAN Topology ?

as seen on Super User - Search for 'Super User'
If somebody can tell me clearly what "Switched LAN Topology"is, it'll be great. I can't even understand what it's due to the following picture . Any answers are most welcome. >>> More
Resources for Programmatic Rendering of Topology Maps

as seen on Stack Overflow - Search for 'Stack Overflow'
Servus, Do you know of any frameworks, APIS, languages, or other resources that are well suited for drawing topology maps that allow a user to interact with objects on the map? I am not constrained by language choice and the program can be web-based, or stand-alone. I thought I would check before… >>> More
Basic questions about network topologies

as seen on Server Fault - Search for 'Server Fault'
I have just started learning about network topologies, but there are a lot of confusion about different types of network topologies i have learnt so far. First of all, BUS topology. If i have like 100 PCs in the same wire connected using BUS topology, and the network connection speed is 100Mbps,… >>> More
Layer 2 topology discovery

as seen on Server Fault - Search for 'Server Fault'
I have been given a network (it is a LAN) comprised of switches and I need to discover the topology of that. (There may be Link Aggregation Groups (LAGs) in the network as well.) I have done a lot of search on layer 2 topology discovery and I have seen many articles talking about using SNMP MIBs… >>> More