MySQL Forums
Forum List  »  Backup

Re: MYSQL Backup on SLAVE
Posted by: sreekar reddy
Date: December 11, 2012 05:08AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
2987
December 11, 2012 03:51AM
Re: MYSQL Backup on SLAVE
1614
December 11, 2012 05:08AM
1668
December 11, 2012 05:41AM
1432
December 12, 2012 04:38AM
1555
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.