SAA-C03 Question 158
Single answerA company is running a MySQL database on Amazon RDS to support a high-traffic e-commerce website. They notice increased read latency during peak shopping seasons due to heavy read traffic. Which solution should the company implement to improve the database's performance?
- A
Enable Multi-AZ deployment for the RDS instance to improve read performance.
- B
Migrate the database to Amazon DynamoDB to handle the read traffic.
- C
Add read replicas to the RDS instance and redirect read queries to the replicas.
- D
Scale up the RDS instance to a larger instance size to handle the increased load.
Show answer and explanation
Correct answer: C
Explanation
Read replicas are ideal for distributing read traffic and improving the performance of a database experiencing high read latency. They allow you to offload read queries from the primary instance to the replicas, which is a scalable and efficient solution for handling high read workloads. Other options like Multi-AZ are designed for failover, not performance, and scaling up the instance may not be cost-effective.
- A. Incorrect.
Multi-AZ deployment is designed for high availability and failover, not for improving read performance. It does not distribute read traffic.
- B. Incorrect.
While Amazon DynamoDB is a NoSQL database that can handle massive scale, it requires a complete application rewrite and is not a direct solution for read performance in an RDS MySQL database.
- C. Correct.
Adding read replicas is the recommended solution for distributing read traffic, as it offloads read requests from the primary database and improves overall performance.
- D. Incorrect.
Scaling up the RDS instance may temporarily improve performance, but it is not a cost-efficient or scalable solution for handling high read traffic.