Examkin

Question

Difficulty: EasyDatabase High Availability

A company's production environment runs on a single-node Amazon RDS for MySQL DB instance. Due to recent network issues, a SysOps Administrator is tasked with configuring the database for high availability to ensure it can survive an Availability Zone outage with minimal downtime. Which actions should the administrator take to achieve this configuration? (Select TWO.)

  1. Modify the RDS DB instance to enable the Multi-AZ deployment option.Answer
  2. Configure the application connection string to point to the single DB instance endpoint, which remains unchanged during a failover.Answer
  3. C
    Deploy an RDS Read Replica in a different Availability Zone and configure the application to write to the read replica's endpoint.
  4. D
    Configure an Amazon Route 53 failover routing policy to direct write traffic to an RDS Read Replica when the primary instance becomes unhealthy.
  5. E
    Create a secondary DB instance in a separate Availability Zone and configure the application to manually swap connection strings when an outage is detected.

Answer

To configure the Amazon RDS DB instance for high availability, the administrator must modify the DB instance to enable the Multi-AZ deployment option and ensure the application connects to the single database endpoint, which RDS automatically updates to point to the standby instance during a failover.
High availability and automated failover in Amazon RDS are achieved by enabling the Multi-AZ deployment option, which provisions a synchronous standby replica in another Availability Zone. Amazon RDS manages the DNS configuration for the DB instance endpoint, automatically updating it to point to the standby instance during a failover so that the application connection string remains unchanged.

Step-by-Step Solution

1
Enable Multi-AZ deployment in the Amazon RDS console or via the AWS CLI for the target DB instance.
Amazon RDS provisions a standby replica in a different Availability Zone and begins synchronous data replication.
This sets up the physical infrastructure and synchronous data replication required for automatic failover without data loss.
2
Verify that the application is configured to connect using the primary RDS DB endpoint rather than any hardcoded IP addresses or secondary endpoints.
The application remains pointed at a single DNS name that handles connection routing.
During an outage, Amazon RDS automatically updates the DNS record to point to the standby instance, keeping the endpoint name the same and avoiding application configuration updates.

Key Concept

Amazon RDS Multi-AZ deployments provide high availability and automated failover by replicating data synchronously to a standby instance in a different Availability Zone, utilizing a single DNS endpoint that RDS automatically updates during a failover event.
Estimated Time:1m 0s
Rate this question

Topics

Database High Availability

More questions from this topic