I’m not sure if this is the right forum to ask this, but I want to set up MySQL master slave replication. Is it possible to do this on my shared hosting account? I don’t see the option in PHPMyAdmin.
I develop Wordpress sites, and I have a local MAMP server I use when developing locally and then I sync my changes to the remote server. To sync the database I have to export from my local PHPMyAdmin and then import to the remote PHPMyAdmin. If I could set up master/slave I can just set the remote database as the master, and my local database would be the slave. All my writes would go to the remote server, and my reads would come from my local server, speeding up my development and keeping both DBs in sync! I already gave myself remote access to my Dreamhost DB, and Wordpress has a plugin called HyperDB which enables using Wordpress with a master/slave setup. So I’m halfway there, I just need to figure out how to set up replication on the Dreamhost end.