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 moni

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 wrote: > *You have no guarantee the data on the slave match

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 > Might want to check out LVM snapshots: > > > http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-bac

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/ Using a slave to pull backups from is something I would not do.

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