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