MySQL non-realtime table-by-table mirroring
I've got a development server and production server.
I want all web site changes to be done on the development server, tested, and synched to the production server.
For the moment, MySQL is what I'm concerned with.
The problem is that while all changes done by company staff to the database will be done on the local server, there is much data that will need to be entered on the remote server.
By and large, I believe I can separate tables into ones that need to be edited locally, and ones that need to be edited remotely.
So what I want is a solution that will let me mirror a single table from one server to another.
About the only thing I've thought of so far is to have a list of each type of table, and a script that manipulates the mysql client and mysqldump to connect to each server individually and do the necessary mirroring.
Any advice would be appreciated.