Question #654
A company operates a mission-critical application that relies on an Amazon RDS for MySQL database configured in Multi-AZ mode. During a planned maintenance event, the database experienced a 35-second outage during failover. The solutions architect must ensure future failovers result in less than 15 seconds of downtime. Which three actions should be taken? (Choose three.)
Deploy Amazon ElastiCache for Memcached to cache database queries.
Implement Amazon ElastiCache for Redis to reduce read latency.
Use RDS Proxy to manage database connections.
Migrate the database to Amazon Aurora MySQL.
Create an Amazon Aurora Replica.
Configure an RDS for MySQL read replica.
Explanation
To reduce RDS MySQL Multi-AZ failover downtime below 15 seconds:
- C: RDS Proxy manages database connections, allowing seamless rerouting during failover without application reconnection delays.
- D: Migrate to Aurora MySQL utilizes Aurora's shared storage architecture, enabling faster failover (typically under 30 seconds, often meeting the 15-second target).
- E: Aurora Replica ensures high availability with near-instantaneous promotion due to Aurora's replication mechanism.
Why other options are incorrect:
- A/B (ElastiCache): Caching reduces read load but doesn't address failover downtime.
- F (MySQL Read Replica): Asynchronous replication doesn't support fast Multi-AZ failover.
Key Points: RDS Proxy handles connections, Aurora's architecture enables faster failover, and Aurora replicas provide rapid promotion.
Answer
The correct answer is: CDE