Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I run my website from EC2. Due to AWS outages, I am contemplating replicating my setup on Rackspace and switch over from DNS in case of an outage.

I am looking to learn ways to replicate my MySql database across these data centers.

Can someone educate me about the methodology, costs, advantages and pitfalls in this approach?

My site serves around 30K users per day with around 30 GB of Database data.

share|improve this question
possible duplicate of:… – quanta Aug 30 '11 at 9:25

Costs: Another server as hot standby

Advantages: Relativly simple approach, impact on current production system is low


  • Takes some time to setup (you need to copy your whole database to Rackspace) in sync with binary log
  • You also need to sync your web contents to the other data center (rsync might be enough)

  • Replication can fall behind or even break, you need to monitor it

  • You might want to consider to encrypt your communication to the other datacenter
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.