While not elegant, you could setup multiple instances of mysql on different ports on the same box so each instance is a slave to a different master.
>From your web GUI, this is transparent to the end user since your configuration files and DB wrappers would handle the connections to "4". We do something similar now where we have DEV 01/02 TEST 03/04 PROD 05/06 and have an 07 slave that runs several instances so each 01,03,05 have a dedicated slave and the 07 secondary slave. Then we have a script that takes 07 mysql down, tarballs (7zip) the /var/lib/mysql and /var/log/mysql dirs (it's WAY faster than a mysql_dump for both import and export), rsyncs them to a master offsite backup server/tape. > -----Original Message----- > From: Travis Ard [mailto:travis_...@hotmail.com] > Sent: Monday, August 23, 2010 3:52 PM > To: 'Nunzio Daveri'; mysql@lists.mysql.com > Subject: RE: Creating a dedicated reporting server for management? > > 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=dae...@daevid.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
