Question

A company runs a critical order-processing application backed by an Amazon RDS for PostgreSQL Multi-AZ DB instance. During a recent AZ disruption, the primary instance failed over to the standby, but the application experienced an extended outage because it could not reconnect to the database. On investigation, you find the application configuration references the primary instance's private IP address directly. Which change will ensure the application automatically reconnects after future Multi-AZ failovers with minimal downtime?

Accepted Answer

Configure the application to connect using the RDS DB instance endpoint (DNS name) and implement connection retry logic with reasonable timeouts.

Answer

Create an Elastic IP address, associate it with the RDS primary instance, and reference the Elastic IP in the application configuration.

Answer

Deploy a read replica in the second AZ and point the application to the read replica's endpoint so it can serve traffic during a failover.

Answer

Increase the RDS backup retention period to 35 days and enable point-in-time recovery so the application can recover after failover.