You could try doing a multi-master configuration by setting up mysql proxy
to receive changes from 1, 2, and 3 and replicate to 4.
From: Nunzio Daveri [mailto:nunziodaveri@stripped]
Sent: Monday, August 23, 2010 3:28 PM
Subject: Creating a dedicated reporting server for management?
Hello Gurus, I have a customer who wants to create a reporting server for
management team. He wants to take server 1,2,3 and move the 3 databases
all 3 servers to one server server 4 and then have the management team run
the reports from server 4 since there are tons and tons of joins. How can I
accomplish this? I can't do replication since server 4 is going to be a
AND a slave can only have one master so I am sitting here trying to figure
how to get this done? This is an ongoing transfer of data as the reports
to be in sync with the 3 master servers so replication would be perfect.
Any help, docs and directions is most appreciated.
Thanks In Advance :-)