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.
“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!”
docs.aws.amazon.com: Replication with a MySQL or MariaDB Instance Running External to Amazon RDS