Hi, I'm looking for a host that will enable me to replicate run a "slave" of mySQL to replicate my master database. This is purely a "write" only and is used for backup only. Any hosts that offer this service?
Get two hosting providers, or one provider with two hosts, or just run a slave yourself, depending on your needs. Ask the master hosting provider to open the MySQL port on the master server for the slave. Then you can set up replication according the instructions in the MySQL manual.
I don't even know if true replication exists in mysql like it does in mssql - but miroring the data daily can be easily done with any schduling task app
To run a slave though doesn't the .ini file have to be edited hence needing a dedicated server? The server where the master is running is dedicated so its not a problem, dont' really want the expense of a dedicated for the slave.
Yes, most hosting providers will not let you run their shared MySQL server as a slave. However, if you have VPS, you have full control over your MySQL instance. You can find a deal on a VPS somewhere around $20 a month if you shop around. It is not necessary to edit my.cnf in most cases to run a slave any more. You can just use CHANGE MASTER TO command. The only thing to watch out for is that the server-id of the slave is not the same as the master.
Good advice thanks! Recommend any good current VPS deals? So the "server-id" has to be synced basically? Is this editable in the .cnf? Thanks
You can try Linode or Gate.com. server-id is set in my.cnf and you need to make sure that the master and the slave have different values, just like they should have a different IP address.