A company has an application that uses a MySQL database that runs on an Amazon EC2 instance. The instance currently runs in a single Availability Zone. The company requires a fault- tolerant…

Question

Options

• AMigrate the MySQL database to Amazon RDS. Create a read replica in a second Availability
• BMigrate the MySQL database to Amazon RDS for MySQL. Configure the new RDS for MySQL
• CCreate a second MySQL database in a second Availability Zone. Use native MySQL commands
• DCreate a copy of the EC2 instance that runs the MySQL database. Deploy the copy in a second

• A
  6% (2)
• B
  75% (24)
• C
  3% (1)
• D
  16% (5)

Explanation

Amazon RDS Multi-AZ deployments provide automatic failover for relational databases such as MySQL, ensuring high availability and durability. The feature maintains synchronous replication between a primary DB instance and a standby in a separate Availability Zone. AWS guarantees that failover typically completes within minutes, ensuring an RTO and RPO of less than 2 Option A requires manual promotion of replicas, which cannot meet the strict RTO/RPO Option C depends on custom scripts and manual synchronization, introducing operational risk. Option D creates active-active EC2-based databases, which do not provide synchronous replication or automated failover. Therefore, Multi-AZ RDS (B) is the managed, resilient, and operationally efficient solution that meets the business requirements.

No community discussion yet for this question.