AWS - RDS and Relational Databases
You have a high-traffic web app using an AWS RDS MySQL database. You want to improve read performance without affecting writes. Which setup is best?
You have a high-traffic web app using an AWS RDS MySQL database. You want to improve read performance without affecting writes. Which setup is best?
hard📝 Best Practice Q15 of 15
Step-by-Step Solution
Solution:
Step 1: Identify the goal
The goal is to improve read performance without slowing down writes.Step 2: Evaluate options
Creating multiple read replicas allows distributing read traffic, reducing load on the main DB and improving read speed.Step 3: Compare other options
Increasing instance size helps but may be costly and less scalable; multi-AZ improves availability, not read performance; a single replica may become a bottleneck.Final Answer:
Create multiple read replicas and direct read queries to them -> Option AQuick Check:
Multiple read replicas scale read performance best [OK]
Quick Trick: Use many read replicas to spread read load [OK]
Common Mistakes:
- Relying only on bigger main DB instance
- Confusing multi-AZ with read scaling
- Using only one read replica for heavy reads
Master "RDS and Relational Databases" in AWS
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore AWS Quizzes