Post reply

Auto scaling options in Amazon RDS vs Amazon AWS EC2 SQL server 2008

  • August 25, 2014 at 12:42 pm

    #310371

    HI,

    I am looking for as in which cloud service has better options for auto scaling SQL server. I know that AWS webservices Ec2 has auto scaling feature to scale only the webservers and application servers but it is not achievable for SQL servers. Can i know if this can be achievable with Amazon RDS or is it good that we can achieve auto scaling for SQL servers by choosing P2P replication in Amazon webservices EC2 itself?

  • November 10, 2014 at 9:53 am

    #1757480

    RDS does not support auto scaling. You can however spin up read replicas on demand. But they are exactly that, read only copies of the RDS instance that you can offload read only queries to.

    Even if you were running SQL server on EC2 instances auto scaling would not be an option as SQL server only allows you to scale up and not out. So your only option would be to add additional resources to the existing instance.

    Can you give any more information on why you want the SQL server to be scaleable? Is it just to support more IO and processing?

    MCITP SQL 2005, MCSA SQL 2012

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply