Examkin

Question

Difficulty: EasyDatabase High Availability

A SysOps Administrator is managing an Amazon RDS for MySQL DB instance. To prepare for potential Availability Zone failures, the database must be configured to support automated failover to a standby instance in a different Availability Zone with minimal downtime. Which configuration change will meet these requirements?

  1. A
    Create an RDS Read Replica in a different Availability Zone and configure Amazon Route 53 to automatically promote it during an outage.
  2. B
    Configure an Amazon Route 53 active-active failover routing policy to distribute traffic between the primary database and a read replica.
  3. Modify the RDS DB instance to a Multi-AZ DB deployment to enable automatic failover to a synchronous standby replica.Answer
  4. D
    Deploy an Amazon Aurora Read Replica in a different Availability Zone and configure AWS Database Migration Service (AWS DMS) to handle the failover.

Answer

Modify the RDS DB instance to a Multi-AZ DB deployment to enable automatic failover to a synchronous standby replica.
Enabling Multi-AZ on an Amazon RDS instance automatically provisions and maintains a synchronous standby replica in a different Availability Zone. In the event of an AZ outage or primary instance failure, Amazon RDS automatically performs a failover by updating the DNS record of the DB instance to point to the standby instance, resulting in minimal downtime without requiring manual administrator action.

Step-by-Step Solution

1
Identify the high availability requirement.
The requirement specifies automated failover to a standby instance in a different Availability Zone with minimal downtime.
This establishes that the solution must provide synchronous replication and automated DNS failover within the same AWS Region.
2
Evaluate Amazon RDS high availability features.
Amazon RDS Multi-AZ deployments provide synchronous replication, automated failover detection, and automatic DNS endpoint redirection to the standby replica.
Multi-AZ is the native AWS mechanism designed to handle AZ outages seamlessly.
3
Eliminate alternative configurations that do not support automated failover.
Read replicas use asynchronous replication and require manual promotion. Route 53 cannot automate DB replica promotions, and AWS DMS is for data migration rather than native DB failover.
This confirms that Multi-AZ is the only valid option for synchronous, automated failover.

Key Concept

Amazon RDS Multi-AZ Deployments
Rate this question

Topics

Database High Availability

More questions from this topic