SOA-C02 Question 86
Single answerA company is running a critical web application on Amazon RDS with a MySQL database. The application requires high availability and minimal downtime in the event of a failure. Which deployment strategy should the company choose to best meet these requirements?
- A
Deploy the Amazon RDS instance in a single Availability Zone.
- B
Deploy the Amazon RDS instance in a Multi-AZ configuration.
- C
Use Amazon RDS Read Replicas in the same Availability Zone.
- D
Deploy two separate Amazon RDS instances in different Availability Zones and manage failover at the application level.
Show answer and explanation
Correct answer: B
Explanation
A Multi-AZ deployment for Amazon RDS ensures that a standby database instance is automatically maintained in a different Availability Zone. In the event of a failure, Amazon RDS automatically performs a failover to the standby instance, minimizing downtime and ensuring high availability. This makes Multi-AZ the best choice for applications requiring high availability and reliability.
- A. Incorrect.
Deploying the Amazon RDS instance in a single Availability Zone does not provide high availability. If the Availability Zone becomes unavailable, the database will be unreachable.
- B. Correct.
A Multi-AZ deployment automatically provisions a standby instance in a different Availability Zone, ensuring high availability and minimal downtime during failover events.
- C. Incorrect.
Read Replicas are designed for read scalability, not high availability. They do not handle automatic failover and are unsuitable for this critical application requirement.
- D. Incorrect.
Manually managing failover between two RDS instances increases complexity and operational overhead. Multi-AZ deployments provide a managed solution specifically for high availability.