I have a script that will query remote database at times. But the connection speed from my local server to the remote one is too slow. I'd like to know whether there is some kind of script which can download data from a remote database and update them to local one regularly. If so, the query response will be much faster.
I've read about master-slave setup. But there isn't an option to edit my.cnf in cPanel. So is it possible to use a script to automatically back up database to local server and update them in local database?