Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Amazon RDS vs EC2 Expand / Collapse
Author
Message
Posted Wednesday, March 13, 2013 3:53 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 11, 2014 10:20 PM
Points: 1,192, Visits: 574
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
Posted Wednesday, March 13, 2013 3:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:49 AM
Points: 5,216, Visits: 5,110
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
Posted Friday, March 15, 2013 6:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 11, 2014 10:20 PM
Points: 1,192, Visits: 574
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 »

Add to briefcase

Permissions Expand / Collapse