I am planing to migrate a MySQL database using rsync utility. MySQL database runs in a red hat cluster and added to the high availability service. I just want to perform a test Migration when the database and application services are online. I am going to rsync the mysql data directory to a different machine when the application and database is online. Will this cause any issue to the database like file corruption or file inconsistency? I am worried about my production database state during this activity. Please assist me if anyone have came across this situation.
Will it cause any file lock if I copy the mysql data directory during peak business hours?
Please sign in to leave a comment.