RDS Replication across regions

Posted by Bryan Migliorisi on Server Fault See other posts from Server Fault or by Bryan Migliorisi
Published on 2012-07-02T14:22:08Z Indexed on 2012/07/02 15:17 UTC
Read the original article Hit count: 270

We are using Amazon AWS for our web services but given the recent instabilities in their infrastructure, we are trying to figure out how to run our application across multiple regions for additional redundancy.

Ideally, we would run our entire app in a active-active configuration in multiple regions but our main concern is that we are using RDS, which I understand cannot replicate across regions.

One possible solution (though we have not tried or proven it would work) would be to do mysqldump or EBS snapshots every hour or so but this would mean that we would be forced to run in an active-passive configuration. Our data would be at most an hour behind. This carries its own issues around data synchronization when we failover and the master comes back up, so its not the best solution.

Are there any proven solutions for replicating RDS across regions?

© Server Fault or respective owner

Related posts about amazon-web-services

Related posts about amazon-rds