MySQL Backup: Secure and efficient full hot copy script using rsync

This script makes a hot copy of the database in a two passes process:
The first one will be longest while the second one will only sync the data modified during the first pass.

Finally, the script will acquire a global read lock on the database to make an ultimate sync that will took a very little amount of time and ensure total data integrity.

 

Leave a Reply

Your email address will not be published. Required fields are marked *