Examkin

Question

Difficulty: EasyResilient Database Configurations and High Availability

A company runs a critical transactional workload on a single-instance Amazon RDS for MySQL database in a single Availability Zone. The database tier must be redesigned to survive an Availability Zone outage with a Recovery Point Objective (RPO) of zero (no data loss) and a Recovery Time Objective (RTO) of less than 2 minutes. Which configuration will meet these requirements with the least administrative effort?

  1. Modify the Amazon RDS for MySQL database instance to a Multi-AZ DB instance deployment.Answer
  2. B
    Create an Amazon RDS Read Replica in a different Availability Zone and configure the application to promote it manually during a failover.
  3. C
    Configure AWS Backup to take hourly database snapshots and restore them to a new DB instance in a different Availability Zone upon failure.
  4. D
    Deploy a second independent RDS DB instance in a different Availability Zone and use Route 53 latency-based routing to distribute database traffic.

Answer

Modify the Amazon RDS for MySQL database instance to a Multi-AZ DB instance deployment.
Modifying the DB instance to a Multi-AZ deployment is correct because Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone. Updates are synchronously committed to both the primary and standby databases, achieving an RPO of zero. In the event of an AZ outage, RDS automatically handles failover to the standby instance, typically completing in under 2 minutes (meeting the RTO requirement) without manual intervention.

Step-by-Step Solution

1
Analyze recovery requirements.
Determined that RPO = 0 requires synchronous data replication, and RTO < 2 minutes requires automated failover.
Asynchronous replication mechanisms cannot guarantee zero data loss, and manual failover procedures take too long.
2
Evaluate Amazon RDS deployment options.
Amazon RDS Multi-AZ deployments provide synchronous replication to a standby instance in a second Availability Zone and support automatic DNS failover.
This matches all recovery parameters with no manual intervention required during an outage.

Key Concept

Amazon RDS Multi-AZ Deployment
Rate this question

Topics

Resilient Database Configurations and High Availability

More questions from this topic