March 13, 2013 at 3:53 am
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?
March 13, 2013 at 3:57 am
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
March 15, 2013 at 7:00 am
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?
September 29, 2016 at 3:03 pm
I have play around with both cloud providers. I actually just finish taken a AWS class on last week. If your going to migrate a sql server database to the cloud definitely go with Microsoft. RDS/EC2 is lacking big time in the tools and options. If your force to go the Amazon route go with EC2. That way you will still have some control over your sql server environment. RDS is for people who don't really want do any administration. Make sure you read the SLA. IMO
March 2, 2020 at 6:18 am
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply