Re: MySQL Enterprise Backup Remotely
I haven't heard about any issues with FLUSH LOGS, but I also don't know if anybody flushes logs every 5 minutes. Probably there is a sense to use some hardware solution like RAID arrays which ensures every piece of data is double-written?
Btw if you are going to do incremental backups every 15 minutes consider increase innodb_log_file_size and use option incremental-with-redo-log-only (http://dev.mysql.com/doc/mysql-enterprise-backup/3.7/en/backup-incremental-options.html) available in 3.7. This is much faster than "traditional" incremental backup.
Subject
Views
Written By
Posted
3470
March 05, 2012 03:39PM
1681
March 06, 2012 09:07AM
1763
March 07, 2012 10:28AM
Re: MySQL Enterprise Backup Remotely
1846
March 07, 2012 11:16AM
1714
March 08, 2012 09:07AM
1604
March 09, 2012 09:41AM
2132
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.