SOA-C02 Question 319
Single answerYour organization is running an e-commerce application on an Amazon RDS MySQL database. During peak shopping events, the application experiences high latency due to a sudden increase in read operations. As the SysOps Administrator, you need to implement a performance optimization strategy to handle the read-heavy workload without impacting the primary database. Which solution would best address this issue?
- A
Enable Multi-AZ deployment for the RDS instance
- B
Scale up the RDS instance to a larger instance type
- C
Configure read replicas for the RDS instance
- D
Enable automatic backups for the RDS instance
Show answer and explanation
Correct answer: C
Explanation
Read replicas in Amazon RDS are specifically designed to improve performance for read-heavy workloads by allowing you to scale out read operations. In this scenario, read replicas are the most effective way to handle the increased read traffic during peak events without overloading the primary database. Other options, while beneficial in certain contexts, do not adequately address the performance optimization needs described in the scenario.
- A. Incorrect.
Multi-AZ deployment is designed for high availability and failover rather than improving performance for read-heavy workloads. It does not directly address the need to optimize read performance.
- B. Incorrect.
Scaling up the RDS instance may improve performance by increasing CPU, memory, and IOPS capacity, but it is not the most efficient or cost-effective solution for handling a read-heavy workload.
- C. Correct.
Configuring read replicas allows you to offload read requests from the primary database to the replicas, improving overall performance during read-heavy workloads. This is the most suitable solution for the given scenario.
- D. Incorrect.
Enabling automatic backups improves data durability and recovery but does not address performance optimization for read-heavy workloads.