Amazon RDS vs EC2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Cloud Computing » General Cloud Computing Questions » Amazon RDS vs EC2

Amazon RDS vs EC2

Rate Topic

Display Mode

Topic Options

Author

Message

Tarun Jaggi

Posted Wednesday, March 13, 2013 3:53 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 06, 2013 2:52 AM
Points: 973, Visits: 463

We are planning to move our warehouse database (which is around 1TB) to the cloud. Currently we are looking at Amazon RDS and EC2 (as these supports multiple features which SQL Azure doesn't support). Also we need high availability along with failover cluster, and backups.

Can you guys please suggest when to use RDS and when to use EC2?

Post #1430271

anthony.green

Posted Wednesday, March 13, 2013 3:57 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

I would go RDS if you want "Failover Clustering", while it is not true failover clustering, RDS allows the option for having the server in multiple AZ within a region so if the AZ dies it moves to another. EC2 you would have to put something like mirroring in place, so you would need 2 EC2 hosts.

Backups you will need to do yourself and depending on what your strategy is, you will need S3 storage or pull it to your office to back it up as that is something which Amazon doesnt do.

Jeremiah Peschka did a good article on Brent Ozar's site on EC2, might be worth a read

http://www.brentozar.com/archive/2011/09/sql-server-ec/

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1430274

Tarun Jaggi

Posted Friday, March 15, 2013 6:59 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 06, 2013 2:52 AM
Points: 973, Visits: 463

Thanks all for your valuable suggestion!!

I found that Microsoft provides “SQL Server in Windows Azure Virtual Machine” which provides full SQL Server box product features and gives the administrator full control over a dedicated SQL Server instance and cloud-based VM.
Can you please suggest some pros n cons of SQL Server in Windows Azure Virtual Machine over EC2?

Post #1431514

« Prev Topic | Next Topic »

Permissions