Not the answer you need?
Register and ask your own question!

--safe-slave-backup on Master?

dchicksdchicks ContributorCurrent User Role Beginner
In my preparations to implement a backup strategy with innobackupex, I came across a line in the online documentation that states it is recommended to use the --safe-slave-backup option when backing up master databases. I wanted to ask about it to see if anyone can tell me why this would be recommended?

I'm estimating that my backup against my master database will require somewhere between 90 and 120 minutes. During that time period, a great deal of activity will still be taking place, and it is replicated on 4 other servers. If I halt the slave process during the backup, then my slaves will all be nearly 2 hours behind by the time the backup is finished. Two of the 4 servers are used as read-only replicants. So, the data queried from them would be incorrect for some queries. For this reason, I'm hesitant to use that option when backing up my Master. I'm not even sure I like the idea when backing up my slaves - for the same reason.

Thanks,
Dave

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.