SOA-C02 Question 127
Single answerYour organization uses an Amazon RDS MySQL instance for its production database. The database is experiencing increased traffic, and there is a need to scale it to handle the additional load. You are tasked with provisioning additional capacity while minimizing downtime. Which action should you take?
- A
Modify the instance type of the RDS instance to a larger size.
- B
Enable Multi-AZ deployment for the RDS instance.
- C
Create a read replica of the RDS instance and distribute read traffic to it.
- D
Manually back up the database and migrate to a new larger instance.
Show answer and explanation
Correct answer: C
Explanation
To handle increased traffic on an Amazon RDS MySQL instance with minimal downtime, creating a read replica is the most suitable option. Read replicas allow you to offload read operations from the primary database, effectively scaling the database to meet increased demand without causing downtime. Other options either involve downtime or do not directly address the need for scaling.
- A. Incorrect.
While modifying the instance type to a larger size is a valid option for scaling an RDS instance, it would cause downtime during the modification process. Since the requirement is to minimize downtime, this is not the best choice.
- B. Incorrect.
Enabling Multi-AZ deployment improves database availability and fault tolerance but does not directly address the need for scaling to handle increased traffic.
- C. Correct.
Creating a read replica allows you to offload read traffic from the primary RDS instance, thereby scaling the database for increased traffic with minimal downtime. This is the most appropriate option in this scenario.
- D. Incorrect.
Manually backing up the database and migrating to a larger instance would involve significant downtime and operational overhead. This is not an efficient solution for the given requirement.