MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MYSQL Backup on SLAVE
2956
Varun Datta
December 11, 2012 03:51AM
Re: MYSQL Backup on SLAVE
1599
sreekar reddy
December 11, 2012 05:08AM
Re: MYSQL Backup on SLAVE
1652
Varun Datta
December 11, 2012 05:41AM
Re: MYSQL Backup on SLAVE
1417
Varun Datta
December 12, 2012 04:38AM
Re: MYSQL Backup on SLAVE
1542
Rick James
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.