Cron sync mysql tables
I have a remote server that needs to access my mysql database a lot. So I figured instead of sending a bunch of remote mysql commands it would be more effecient to sync the database to the remote server. Is there a program that easily does this and that I can configure to only sync specified tables and possibly columns?
Solution 1:
Mysql offers replication, which should do the trick.