MySQL Forums
Forum List  »  Backup

MYSQL Backup on SLAVE
Posted by: Varun Datta
Date: December 11, 2012 03:51AM

Hi,

We have a Master-Slave Replication Setup.

We want to take daily full backup on Slave and binlogs backup from Master.

In case of failure of Slave, Master will Starting taking full backup and backup of binlogs.

Now, in order to take consistent backup at Slave we are stopping Slave to process any data from Master and then take backup using MYSQL Enterprise Backup 3.8 and then Start Slave process again.

Command used:-

mysqlbackup --port=3306 --protocol=tcp --user=root --password=mysql123 --backup-dir=$BACKUP_DESTINATION <TYPE OF BACKUP>


Please confirm whether we should use backup or backup-and-apply-log for <TYPE OF BACKUP>

Our requirement is that Backup should be consistent and should be restored easily using copy-backup option.

Please confirm which type of backup to be used.

Thanks,
Varun Datta

Options: ReplyQuote


Subject
Views
Written By
Posted
MYSQL Backup on SLAVE
2995
December 11, 2012 03:51AM
1619
December 11, 2012 05:08AM
1672
December 11, 2012 05:41AM
1435
December 12, 2012 04:38AM
1558
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.