Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am trying to find out if it is possible to do a hot backup of a MySQL slave without stopping the replication... but I cannot find any clear info implying it is possible or not.

I read about Percona's xtrabackup tools and in the documentation they say that using the safe slave backup option, which stops the replication, is always recommended when taking backups from a slave server.

At the same time I see on several blogs on the topic that they do not use this option and just follow the first backup run with a second one with an apply log option.

So, is the safe backup optional and one can backup a slave without stopping the replication?

Or is there any other way/tool?

I want to add that the backup should be able to be used to setup a new slave that would be in sync with the master after it catches up.

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.