I'm looking at putting MySQL on two servers in two separate datacentres, using either Master-Slave Replication if the latency is low enough because it's more reliable, otherwise Master-Master Replication. I'd rather each server be from a different provider too with separate upstreams. The traffic between then will go through an OpenVPN tunnel.

Obviously with this, latency is an issue. What do I really need to look for when choosing the providers?

Should I look to have a VLAN setup between the two?
Will peering between the two be sufficient? Should I ask for traceroutes between the two providers? What sort of latency should I look for?

I've run MySQL Replication for a long time, just not between multiple datacentres.

Thank you for any advice you can give me,
splinter

__________________
Registered User