MySQL Forums
Forum List  »  Backup

Re: MYSQL Backup on SLAVE
Posted by: Varun Datta
Date: December 11, 2012 05:41AM

Hi,

Thank you for Reply.

Will BACKUP-AND-APPLY-LOG will work the same way if backups are taken form Master or Slave only difference being Slave will be stopped when apply-log operation is done?

After taking backup on Slave, Bin log position shown using Show Master Status\G increases a bit .Normally when Slave recieve changes from Master in Replication, it does not create any bin logs.Please explain this behaviour.

My Question is whether there is any drawback of using BACKUP-AND-APPLY-LOG for backup on Slave.

Thanks,
Varun Datta

Options: ReplyQuote


Subject
Views
Written By
Posted
3093
December 11, 2012 03:51AM
1693
December 11, 2012 05:08AM
Re: MYSQL Backup on SLAVE
1715
December 11, 2012 05:41AM
1481
December 12, 2012 04:38AM
1616
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.