Re: Back-up Plan for Large Database
On 27/12/2010 19:14, Wagner Bianchi wrote: *You have no guarantee the data on the slave matches the master 100%.* * * Try it with *semi-synchronous* replication. Best regards. -- Wagner Bianchi Hiya Thats why you nagios monitor replication of your slaves (I do master master replication monitoring) I use mylvmbackup. Works like a bomb. HTH Brent -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Back-up Plan for Large Database
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=arch...@jab.org
Re: Back-up Plan for Large Database
Hello there, ZMANDA is a good tool to extract backups from MySQL databases. But, when subject is fault tolerant and keep databases on air 24x7, you need to think about replication to have a SLAVE server as a online copy of your environment, other SLAVE servers to permit you switch among servers in case of MASTER fails and things like that. In advance to have ZMANDA as you backup tool, do you have server replicating data on you environment? Best regards. -- Wagner Bianchi 2010/12/27 Adarsh Sharma adarsh.sha...@orkash.com 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=wagnerbianch...@gmail.com
Re: Back-up Plan for Large Database
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.comwrote: 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
Re: Back-up Plan for Large Database
*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
Re: Back-up Plan for Large Database
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.comwrote: *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