How to Minimize Downtime During RDS Multi-AZ Failover
A company uses Amazon RDS for MySQL with Multi-AZ deployment. During a recent failover, they experienced a few minutes of downtime because the application's connection string pointed to the primary instance DNS name. What is the MOST effective solution to minimize downtime during failover?
Quick Answer
The answer is to use the RDS Multi-AZ DNS name (CNAME) that automatically updates after failover. This is correct because the Multi-AZ DNS record is a static endpoint that always resolves to the current primary instance; when a failover occurs, AWS automatically updates the DNS mapping to the new primary, so applications that reconnect using this name experience minimal downtime. On the AWS Certified Solutions Architect Professional SAP-C02 exam, this question tests your understanding of RDS high-availability architecture versus application-layer workarounds—a common trap is over-engineering with load balancers or read replicas, which do not handle automatic failover. The key insight is that RDS Multi-AZ already provides a built-in failover mechanism via its CNAME, so you must avoid changing the connection string to the primary instance’s direct DNS. Memory tip: think “CNAME for the win” — the CNAME is the single, resilient pointer that survives a failover, while the primary DNS is a fragile, direct address.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use the RDS Multi-AZ DNS name (CNAME) that automatically updates after failover.
The RDS Multi-AZ deployment automatically provides a CNAME (DNS name) that always points to the current primary instance. After a failover, this CNAME is updated to point to the new primary, so the application using this DNS name will experience minimal downtime. Option B is incorrect because Elastic IP addresses are not supported for RDS instances; they are used for EC2 instances. Option C is incorrect because a read replica in another Region is designed for disaster recovery and read scaling, not for automatic failover within the same region; manual promotion would cause significant downtime. Option D is incorrect because a Network Load Balancer adds unnecessary complexity and latency; RDS Multi-AZ already provides automatic failover with DNS update.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Use the RDS Multi-AZ DNS name (CNAME) that automatically updates after failover.
Why this is correct
The Multi-AZ DNS name automatically points to the new primary after failover.
- ✗
Assign an Elastic IP address to the RDS instance.
Why it's wrong here
Elastic IPs are not supported for RDS.
- ✗
Create a read replica in another Region and promote it during failover manually.
Why it's wrong here
Manual promotion causes downtime.
- ✗
Configure a Network Load Balancer in front of the RDS instance.
Why it's wrong here
NLB adds unnecessary complexity and is not recommended for RDS.
Go deeper
Related to this question
About these practice questions
Courseiva writes every SAP-C02 question from scratch — 1,660 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on SAP-C02
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A company uses Amazon RDS for MySQL with Multi-AZ deployment. During a recent failover, the application experienced a 5-minute downtime. The application uses a connection pool with a 30-second connection timeout. The RDS DNS name is used as the endpoint. What is the MOST likely cause of the downtime?
hard- ✓ A.The DNS TTL for the RDS endpoint is set too high
- B.The connection pool timeout is too short to allow failover
- C.The Multi-AZ failover took longer than expected
- D.The application is using the wrong endpoint after failover
Why A: During an RDS Multi-AZ failover, the DNS name remains the same but the underlying IP address changes. If the DNS TTL is set too high (default is 60 seconds but can be configured higher), clients may continue to use the old cached IP address for the duration of the TTL, leading to connection failures until the cache expires. This explains the 5-minute downtime, as the application's connection pool with a 30-second timeout cannot recover until the DNS record is refreshed. Option B is incorrect because the 30-second timeout is sufficient to wait for failover, but the issue is DNS propagation, not timeout duration. Option C is incorrect because Multi-AZ failover typically completes within 1-2 minutes, not 5 minutes. Option D is incorrect because the endpoint (DNS name) does not change after failover; only the IP changes.
Variation 2. A company uses Amazon RDS for MySQL with Multi-AZ deployment. They notice that during a failover, the application experiences a brief outage but then recovers. They want to minimize the failover time. Which action will most effectively reduce the failover time?
medium- A.Disable Multi-AZ to avoid failover altogether.
- B.Create a read replica and promote it during failover.
- ✓ C.Enable Amazon RDS Proxy.
- D.Increase the DB instance size to improve performance.
Why C: Enabling Amazon RDS Proxy provides connection pooling and reduces failover time by keeping connections alive during failover. Option A is wrong because disabling Multi-AZ removes high availability and increases downtime. Option B is wrong because read replicas are for read scaling and promoting a replica involves manual intervention and DNS changes, which does not minimize failover time as effectively as RDS Proxy. Option D is wrong because increasing the DB instance size improves performance but does not directly affect failover time.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SAP-C02 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SAP-C02 exam.