How to Autoscale AWS RDS Read Slaves

I don’t see a lot of links on autoscaling AWS RDS read slaves.

Is the reason:

  • AWS RDS users are simply content with relying on features as they arrive?
  • users could just be upsizing RDS masters or moving to Aurora, etc. as load increases?
  • only a small percentage of businesses have big data issues?
  • software developers at other companies religiously run EXPLAIN? 🙂

Below are some insightful comments and some projects that have implemented this.

Jeff Barr, AWS [2010]

“It should be fairly easy to create a data-driven auto scaling database cluster using Read Replicas and CloudWatch metrics.
At the low end, this cluster would consist of a Small DB Instance running in one Availability Zone with 5 GB of storage.

At the high end it would consist of a High Memory Quadruple Extra Large Multi-AZ deployment (primary/secondary pair) DB Instance with 1 TB of storage and 5 associated Read Replicas. That’s quite a range!”

harish11g.com: Load Balancing Amazon RDS Read Replica’s using HAProxy
github.com: ReDS – ReActive Database System – Terraform – Auto-Scale for RDS Instances

Other Resources

docs.aws.amazon.com: Replication with a MySQL or MariaDB Instance Running External to Amazon RDS

This entry was posted in Cloud, Linux, MySQL, Open Source, Oracle, Tech. Bookmark the permalink.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.