DR between two AWS Regions

[linuxanoop]

Creating a DR between two Regions in AWS. At the database layer using RDS SQL instances . Need to know what are the possible
ways to  copy data ( RDS Instance )from one region to another. Hope my question is clear.

[andreas.chatzakis]

Hi,

RDS does not currently support multi-region replication (nor any type of replication outside the RDS context).

You can copy data by doing exports and imports which can be time consuming depending on your DB size.

If multi-AZ is really not good enough for your requirements (for most apps it is a very cost effective availability measure), it sounds like you would want to build your own setup on EC2 instances.

That would allow you to implement any type of replication scheme supported by your DB of choice (Master-Slave, Master-Master). but obviously it does come with extra data transfer costs and extra operational complexity.

What is your use-case? Would the DB instance on the remote region be just a passive instance for DR scenarios?

Or do you need to run read queries to that (or writes even)?

How large is the DB??

Andreas

[Anoop Mohan]

Thanks for your reply.

DR is in active passive mode.
Database is passive in another region. Data is about 300 gb. So replication to remote region is an issue. Thought of checking cloudopt.com as a solution. Or is there any workaround?

[Andreas Chatzakis]

I am not familiar with cloudopt but it certainly looks interesting.

Check if it works with RDS, otherwise a DB cluster running on EC2 instances would give you full control and the ability to implement what you are describing.

Andreas

--

http://gr.linkedin.com/in/achatzakis

Follow @achatzakis on twitter

[Thomas Pliakas]

Hello,
  RDS Multi-AZ option if for availability zones and not for regions. Another issue that you have to explore is regarding performance and pricing.

You can check also this whitepaper (in case that you are not aware) http://aws.amazon.com/disaster-recovery-whitepaper/

Regards
Thomas

On Wed, Sep 26, 2012 at 12:46 PM, Anoop Mohan <linux...@gmail.com> wrote:

[Anoop Mohan]

Hi Thomas,

I believe import export is only for s3 and end. But here question is how can copy data from rds backup from one aws region to another aws region daily basis in a DR scenario.

Any help will be really appreciated.