You could do that, if you have 5.5+ Still no guarantee that the slave matches the master 100%, even says so in the manual. In my opinion, you shouldn't pull backups from the slave. YMMV.
On Mon, Dec 27, 2010 at 11:14 AM, Wagner Bianchi <wagnerbianch...@gmail.com>wrote: > *You have no guarantee the data on the slave matches the master 100%.* > * > * > Try it with *semi-synchronous* replication. > > Best regards. > -- > Wagner Bianchi > > > 2010/12/27 Johnny Withers <joh...@pixelated.net> > > Might want to check out LVM snapshots: >> >> >> http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/ >> >> < >> http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/ >> >Using >> a slave to pull backups from is something I would not do. You have no >> guarantee the data on the slave matches the master 100%. >> >> >> >> On Mon, Dec 27, 2010 at 5:19 AM, Adarsh Sharma <adarsh.sha...@orkash.com >> >wrote: >> >> > Dear all, >> > >> > Back-up is the most important thing that need special attention. We have >> a >> > production Mysql Server of near about 200 GB data and expect to grow @ >> 50 GB >> > per month. >> > >> > Our application continuously writes data in Mysql tables. >> > >> > I followed some Links but want some more thoughts to choose best option. >> > >> > http://www.zmanda.com/mysql-backup-considerations.html >> > >> > I also read about RAID and some other features too. >> > >> > But I want to know what is the best back up plan for 24/7 running Large >> > Production Mysql Cluster. >> > >> > >> > >> > >> > >> > Thanks & Regards >> > >> > Adarsh Sharma >> > >> > -- >> > MySQL General Mailing List >> > For list archives: http://lists.mysql.com/mysql >> > To unsubscribe: >> http://lists.mysql.com/mysql?unsub=joh...@pixelated.net >> > >> > >> >> >> -- >> ----------------------------- >> Johnny Withers >> 601.209.4985 >> joh...@pixelated.net >> > > -- ----------------------------- Johnny Withers 601.209.4985 joh...@pixelated.net