Amazon EC2 High Availability Database Architecture

views:

598

answers:

+3 Q:

Amazon EC2 High Availability Database Architecture

I'm currently spec'ing out a solution running on EC2. Setting up web servers, utilizing S3, Cloud Front, Cloud Watch, etc have been straightforward enough. Using Elastic Load Balancers for HA cross Availability Zone for our web servers has also been straightforward.

I would really like to have cross Region Availability in addition to cross Availability Zone. This would help alleviate the potential for an outage due to region outage.

I haven't been able to find much information about folks running two way replication cross region for their dbs. Is this possible? What is the performance like?

+6 A:

Before investing much time and effort, you may want to take into consideration that Amazon is promising a High-Availability offering on top of the Amazon Relational Database Service (RDS).

New Features for Amazon RDS Coming Soon

High Availability Offering — For developers and business who want additional resilience beyond the automated backups provided by Amazon RDS at no additional charge. With the high availability offer, developers and business can easily and cost-effectively provision synchronously replicated DB Instances in multiple availability zones, to protect against failure within a single location.

Daniel Vassallo 2010-01-08 19:26:11

+1 for a sensible suggestion.

jldupont 2010-01-08 19:32:08

I am definitely leaning towards RDS but am still curious about cross region replication ... will this be supported in RDS?

Keith Fitzgerald 2010-01-08 22:58:14

Yes, Amazon announced cross region replication "cost-effectively provision synchronously replicated DB instances **in multiple availability zones**, to protect against failure within a single location" as coming soon. From their track record, when Amazon says it is coming soon, it normally means very soon, even though it may stay in beta for some months.

Daniel Vassallo 2010-01-08 23:29:06

However, at the moment there is no access to the binary log in RDS and replication is disabled. Source: http://www.webyog.com/blog/2009/11/16/top-10-things-to-know-about-amazon-rds/

Daniel Vassallo 2010-01-08 23:52:54

thanks! and thanks for that link on top 10 rds.

Keith Fitzgerald 2010-01-10 18:06:00

@Daniel Vassallo: I think that having replicated DB instances in multiple availability zones here doesn't necessarily mean having cross region replication.

Kaitsu 2010-04-29 21:32:28

@Kaitsu: Yes true. The Amazon HA offer for RDS appears to be targeting cross availability zone. This feature is still listed as "Coming Soon".

Daniel Vassallo 2010-04-29 21:47:28

ansaurus

tags:

views:

answers:

Amazon EC2 High Availability Database Architecture

related questions