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.
-Travis -----Original Message----- From: Nunzio Daveri [mailto:nunziodav...@yahoo.com] Sent: Monday, August 23, 2010 3:28 PM To: mysql@lists.mysql.com Subject: Creating a dedicated reporting server for management? Hello Gurus, I have a customer who wants to create a reporting server for his management team. He wants to take server 1,2,3 and move the 3 databases from all 3 servers to one server server 4 and then have the management team run all 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 slave AND a slave can only have one master so I am sitting here trying to figure out how to get this done? This is an ongoing transfer of data as the reports have 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 :-) Nunzio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
