Re: MYSQL Backup on SLAVE
you can use either BACKUP sub-command or BACKUP-AND-APPLY-LOG according to your requirement
If you do "backup and apply-log" at a time your slave will be stopped for some more extra time.
If you want to backup only... while restoring you have to apply-log which takes some more time. but it is not that significant. As long as you have the backup in your hand you can apply-log on it later.
So use BACKUP sub command for some what quick backups.
Subject
Views
Written By
Posted
2958
December 11, 2012 03:51AM
Re: MYSQL Backup on SLAVE
1599
December 11, 2012 05:08AM
1654
December 11, 2012 05:41AM
1417
December 12, 2012 04:38AM
1542
December 23, 2012 10:35AM
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.