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

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.