How can I replicate a mysql database from 1 shared account to another shared account so that I can have a redundant copy of my website data. I am looking to setup roundrobin DNS as well so the replication needs to be fairly quick.
I know it is pretty late to reply this thread However I would like to share my experience, MySQL database replication is not possible with shared account. On Linux VPS it is recommended, but not for Windows VPS. Mostly It can be implemented on dedicated servers. Thanx