A company has a Single-AZ Amazon RDS MySQL DB instance and wants to improve its reliability. A SysOps Administrator plans to convert this instance into a Multi-AZ deployment. Which of the following statements correctly describe the behavior or configuration of this transition? (Select TWO.)
- Modifying the DB instance to enable Multi-AZ automatically provisions a synchronous standby replica in a different Availability Zone.Answer
- Amazon RDS automatically updates the DNS CNAME record of the DB instance to point to the standby instance during a failover.Answer
- CThe newly created standby replica can be immediately used to serve read-only queries to offload the primary database.
- DA read replica must be manually promoted to primary and the application's connection endpoints updated to achieve failover.
- EA Route 53 active-active failover routing policy must be manually configured to route traffic to the standby database instance.
Answer
Modifying the DB instance to enable Multi-AZ automatically provisions a synchronous standby replica in a different Availability Zone, and Amazon RDS automatically updates the DNS CNAME record of the DB instance to point to the standby instance during a failover.
When converting a Single-AZ instance to a Multi-AZ deployment, Amazon RDS automatically creates a synchronous standby replica in a different Availability Zone. If a failure occurs, RDS automatically switches to the standby replica by updating the DNS CNAME record of the DB endpoint. This keeps the database endpoint URL unchanged, requiring no code modifications in the application.
Step-by-Step Solution
Key Concept
Amazon RDS Multi-AZ deployments provide high availability and failover support natively by synchronously replicating data to a standby instance in a different Availability Zone and automatically updating the endpoint's DNS CNAME record during failovers.