SAA-C03 Question 307
Single answerA company runs a MySQL database on Amazon RDS to support their e-commerce platform. They experience high read traffic during sales events and want to improve read performance and availability without affecting write operations. What is the best solution to address this requirement?
- A
Enable Multi-AZ deployment for the database instance.
- B
Create read replicas for the database instance.
- C
Upgrade the database instance to a larger instance size.
- D
Migrate the database to Amazon Aurora.
Show answer and explanation
Correct answer: B
Explanation
The most appropriate solution for handling high read traffic without affecting write operations is to create read replicas. Read replicas allow you to scale out read operations by distributing the read workload across multiple instances, improving performance and availability during peak events like sales. Multi-AZ, upgrading instance size, or migrating to Aurora are not as suitable for the given scenario.
- A. Incorrect.
Multi-AZ deployment improves availability and provides failover support for write operations, but it does not improve read performance as the secondary instance is only for standby and cannot be used for read traffic.
- B. Correct.
Creating read replicas is the best solution here as it offloads read traffic from the primary database. Read replicas can handle high read workloads without affecting write operations on the primary instance.
- C. Incorrect.
Upgrading the database instance to a larger instance size might improve performance overall, but it does not specifically address the problem of high read traffic. It is also less cost-effective compared to using read replicas.
- D. Incorrect.
Migrating to Amazon Aurora may provide some performance benefits, but it is a more complex and time-consuming solution compared to simply creating read replicas.