I’m wondering if any one has suggestions for software to use with MySQL for hot backup site.
We have our main data center in St. Louis and our secondary center in Seattle. So, geographically we have a bit of distance between machines. What we want is the ability to shutdown St. Louis (for maintenance only hopefully, but it’s called a disaster recovery solution for a reason) and have Seattle automatically take over. We are okay with having a manual recovery back if need be, but seamless both ways would be ideal.
I’ve looked at Clustering and DRBD. It doesn’t seem like either of those solutions are made for cross country fail over. We have replication in place so we could manually switch things over. I’ve looked at mCluster a little bit, but wasn’t really sure if it would work. Does anyone have any other suggestions on this issue?
I’d appreciate any help.
Thanks so much,