CODEWITHSUNDEEP
amazon-web-servicesamazon-rdsautoscaling
Rahul Kumar
Rahul Kumar

Reputation: 726

Does AWS support Autoscaling for RDS Instance

One of my RDS instance take high cpu some times due to heavy load. That time we manually need to upgrade instance. So I think to use auto scaling feature of RDS to automatically increase instances, but not getting any details about it.

Please some one confirm that If Autoscaling supports for RDS instances or not..

Thanks in advance.

Upvotes: 14

Views: 39666

Answers (5)

antoweb
antoweb

Reputation: 31

Best solution is using a script in crontab using cli for modify db instance class in crontab. Is also possible in the script to retrieve the cpu usage and for example scaling up if cpu is higher than 90% and down when goes less than 60% but if RDS is not multi AZ this scaling generate downtime

Upvotes: 0

isubodh
isubodh

Reputation: 53

Another solution can be set a difference between allocated storage and max allocated storage. It give a storage buffer that you can use whenever a database faces storage crunch. Ofcourse you have to set a max value for this beforehand

Upvotes: 0

Simon Woodside
Simon Woodside

Reputation: 7314

The previous answers are now out of date. The newer AWS RDS Aurora does support autoscaling. Aurora Auto Scaling is available for both Aurora MySQL and Aurora PostgreSQL.

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Integrating.AutoScaling.html

Upvotes: 26

Amin Ahmed Khan
Amin Ahmed Khan

Reputation: 461

AWS RDS supports Vertical scalling only. Horizantal scalling can be applied only for read intensive RDS instances by creating read replicas under an ELB

https://aws.amazon.com/blogs/database/scaling-your-amazon-rds-instance-vertically-and-horizontally/

Upvotes: 5

hearnden
hearnden

Reputation: 572

No, it does not.

The scaling you're describing is vertical scaling, which is upgrading the class or type of an instance. Autoscaling, in general, is for horizontal scaling: adding more instances. RDS supports neither horizontal nor vertical autoscaling, but it does support manual horizontal scaling (by adding read replicas) and manual vertical scaling (by upgrading/downgrading an existing instance).

Upvotes: 17

Related Questions