MYSQL Backup on SLAVE

[Varun Datta]

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