CloudGuild · Blog · Cheat sheets · Lessons · Certifications
Scaling Reads in RDS: A Question Breakdown
Learn how to effectively scale read-heavy workloads in AWS RDS. We break down the SAA-C03 exam question to enhance your preparation.
A read-heavy reporting workload can overwhelm a production RDS database. Candidates often trip over this scenario when determining the best way to scale reads. Let’s analyze a specific exam question to clarify the best approach.
The question
A read-heavy reporting workload is overloading a production RDS database with read queries. What is the MOST appropriate way to scale reads?
A. Enable Multi-AZ
B. Add RDS Read Replicas and direct read traffic to them
C. Increase the backup retention period
D. Enable deletion protection
Think before you scroll
Before jumping to the answer, consider what each option does. You need to identify solutions that specifically address read scaling. Some options may improve availability or data safety but won't help with read throughput.
The answer
The correct option is B: Add RDS Read Replicas and direct read traffic to them. This option directly addresses the need to scale reads by offloading read queries from the primary database.
Why the other options lose
- A. Enable Multi-AZ: This option is designed for high availability and failover support, not for scaling reads. While it enhances the database's resilience, it does not improve read performance.
- C. Increase the backup retention period: This action has no impact on read performance. It merely extends how long backups are kept, which is unrelated to scaling reads.
- D. Enable deletion protection: This feature prevents accidental deletion of the database. Again, it does not address the issue of read query overload.
The concept behind it
The underlying principle here is read scaling. In AWS RDS, implementing Read Replicas allows you to distribute read traffic across multiple database instances. This setup increases read throughput and enhances performance for read-heavy applications. Understanding when and how to use Read Replicas will help in various scenarios.
Exam trap to remember
Always remember: Multi-AZ is for availability, while Read Replicas are your go-to for scaling reads. Keep this rule in mind to avoid confusion in the exam.