You misunderstand. The slave is LIVE. Every write to the master writes to BOTH slaves. You can add as many slaves to a master as you want.
My point was IN ADDITION to that benefit, it also affords you the ability to take down one of the slaves for an offsite archive. So if you need master/slave for prod, and slave for reports that all have to be up 100% then setup a 3rd slave then that is a live backup and you can then take it down at whatever interval you like to make a tarball for offsite backups. When you start the slave up again, it will re-synch itself to the master again automatically. Rinse. Repeat. I don't care how many slaves you have, they don't count as a real backup. If I say "DROP DATABASE foo" on the master, it will happily replicate to the slaves and you're whole company is now fsck'd in a way you can't even begin to comprehend. :) Ala http://www.geek.com/articles/news/disgruntled-employee-kills-journalspace-w ith-data-wipe-2009015/ > -----Original Message----- > From: nunziodav...@yahoo.com [mailto:nunziodav...@yahoo.com] > Sent: Friday, August 27, 2010 5:01 PM > To: Daevid Vincent > Subject: Re: Creating a dedicated reporting server for management? > > Thanks for the idea. The sales guys want real time access so > tarballing daily or even several times a day won't work. > > Nunzio > Sent via BlackBerry from T-Mobile > > -----Original Message----- > From: "Daevid Vincent" <dae...@daevid.com> > Date: Mon, 23 Aug 2010 16:11:47 > To: 'Travis Ard'<travis_...@hotmail.com>; 'Nunzio > Daveri'<nunziodav...@yahoo.com>; <mysql@lists.mysql.com> > Subject: RE: Creating a dedicated reporting server for management? > > 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
