I'm new to MySQL but I have experience with other major RDBMS like Oracle and MSSQL.
I'm trying to find out what are some of the widely used methods (or best practices) when it
comes to refreshing one or more MySQL databases between two servers on a nightly basis.
For example: refresh the "QA" server from "PROD". I would like to develop an automatated process to handle this refresh/reload and put it on a scheduled job and have it run nightly. The current setup is running under Linux.
I would like to get some feedbacks or suggestions from those who have done this before or provide me with a few pointers.