Prompt solution for partial one way mysql data sync

Question

linux

Hello!

There is such a task: we have 2 servers, live and admin, the client edits the content on admin and runs complex scripts, after which (only after and not during) you need to copy all the updated data (mysql and files) quickly to live.

There was an idea to use replication for the database, but I'm not sure that this is correct.
Now it all comes down to writing your bike. Maybe there are already free solutions for this?

Answer 1

Replication is a good way.
>only after and not during
It is done by commands start slave, stop slave
For rsync files.
If synchronization is one-time, i.e. once after updating the data, you can use the tool from the Maatkit kit, and if it is possible to temporarily disable both databases, synchronize database files or upload using mysqldump