A company uses Amazon RDS for MySQL with Multi-AZ deployment. The database instance fails and AWS automatically fails over to the standby. After the failover, the application cannot connect to the database. The engineer checks the RDS console and sees that the instance status is Available. What is the MOST likely cause of the connectivity issue?
Trap 1: The security group for the RDS instance has changed during failover.
Security groups remain the same.
Trap 2: The DNS record for the RDS endpoint has not propagated to the…
RDS DNS updates quickly and is not usually the issue.
Trap 3: The database instance is still in the process of failover and is…
The status is Available, so failover is complete.
- A
The security group for the RDS instance has changed during failover.
Why it fails: Security groups remain the same.
- B
The application is using the database's DNS endpoint for the old primary, which is no longer the writer.
After failover, the writer endpoint points to the new primary, but if the application caches the old endpoint, it may fail.
- C
The DNS record for the RDS endpoint has not propagated to the application's DNS resolver.
Why it fails: RDS DNS updates quickly and is not usually the issue.
- D
The database instance is still in the process of failover and is not yet accepting connections.
Why it fails: The status is Available, so failover is complete.