How to scale horizontally Amazon RDS instance?

amazon-web-services amazon-ec2 load-balancing amazon-rds autoscaling
Alessandro Corradini picture Alessandro Corradini · Feb 7, 2015 · Viewed 15.2k times · Source

How to scale horizontally amazon RDS instance? EC2 and load balancer+autoscaling is extremly easy to implement, but if I want scaling amazon RDS? I can ugrade my RDS instance with more powerfull instance or I can create a read replica and I can direct SELECT queries to it. But in this mode I don't scale anything if I have a read-oriented web application. So, can I create RDS read replica with autoscaling and balance them with load balancer?

Answer

Magda picture Magda · May 6, 2015

You can use a HAProxy to load-balance Amazon RDS Read Replica's. Check this http://harish11g.blogspot.ro/2013/08/Load-balancing-Amazon-RDS-MySQL-read-replica-slaves-using-HAProxy.html. Hope this helps.

Related questions

AWS Load Balancer with a static IP address

I have a set-up running on Amazon cloud with a couple of EC2 Instances running through a load balancer. It is important that the site has a unique(static) IP or set of IPs as I'm plugging in 3rd party …

Read More
A(Host) Records with AWS Load Balancer

I have a question regarding AWS Load Balancers. I can point my CNAME www to my load balancer's DNS perfectly and i know it will always work, BUT I also need to point the @ record to the load balancer so …

Read More
Elastic Beanstalk without Elastic Load Balancer

I would like to switch off Elastic Load Balancer (ELB) for my Elastic Beanstalk environment. Currently I don't need it and I don't want to pay for it. It is possible to delete the ELB in EC2 managment window but …

Read More