Re: Mirroring 2 servers in different locations

[Mike Kruckenberg]

Rick,

MySQL does not offficially support multi-master replication where you can write to multiple machines (it's rumored to be coming in 5.2, or beyond). There are folks who have attempted to build workarounds to this by architecting their databases in a way that MySQL's problems with multi-master replication are avoided. If you have your data segragated between the two different sites you might be able to pull it off.

I can recommend Zawodny's book, High Performance MySQL, which goes into detail about multi-master replication and how to organize your data so it works: http://www.oreilly.com/catalog/hpmysql/

MySQL does have a cluster, but you're right that if you don't have good interconnects that probably won't be much good to you.

Mike Kruckenberg
Co-author of Pro MySQL (Apress)
http://mike.kruckenberg.com