SAA-C03 · Question #404
A company runs a MySQL database on a single Amazon EC2 instance. The company needs to improve availability of the database to prepare for power outages. Which solution will meet this requirement?
The correct answer is C. Migrate the MySQL database to Amazon RDS and enable Multi-AZ deployment.. Amazon RDS Multi-AZ deployment provides automated failover and increased availability for MySQL databases. In case of infrastructure failure or power outage in one Availability Zone, RDS automatically fails over to a standby replica in another AZ, minimizing downtime. This is the
Question
A company runs a MySQL database on a single Amazon EC2 instance. The company needs to improve availability of the database to prepare for power outages. Which solution will meet this requirement?
Options
- AAdd an Application Load Balancer (ALB) in front of the EC2 instance.
- BConfigure EC2 automatic instance recovery to move the instance to another Availability Zone.
- CMigrate the MySQL database to Amazon RDS and enable Multi-AZ deployment.
- DEnable termination protection for the EC2 instance.
How the community answered
(33 responses)- A6% (2)
- B12% (4)
- C79% (26)
- D3% (1)
Explanation
Amazon RDS Multi-AZ deployment provides automated failover and increased availability for MySQL databases. In case of infrastructure failure or power outage in one Availability Zone, RDS automatically fails over to a standby replica in another AZ, minimizing downtime. This is the AWS- recommended way to achieve high availability for relational databases.
Community Discussion
No community discussion yet for this question.