Re: MySQL Enterprise Backup Remotely
Hi Sveta,
Thanks for you response it's much appreciated.
I agree and think taking incremental backups from the slave make sense. We will be running semi-syncronous replication which increases the odds of our slaves containing the latest information.
Our incremental backups will be taken every 15 minutes. I'm thinking of perhaps flushing the logs and backing up the binary log on the master every 10 or even 5 minutes. Then our worst case scenario would be losing 5 minutes worth of data. Is there any thoughts on doing a flush logs every 5 minutes ? Any other caveats worth mentioning ?
Thanks,
Chris
Subject
Views
Written By
Posted
3470
March 05, 2012 03:39PM
1681
March 06, 2012 09:07AM
Re: MySQL Enterprise Backup Remotely
1762
March 07, 2012 10:28AM
1846
March 07, 2012 11:16AM
1714
March 08, 2012 09:07AM
1604
March 09, 2012 09:41AM
2131
March 09, 2012 10:00PM
1499
March 09, 2012 10:19AM
2009
March 09, 2012 10:02PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.