*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 >