A financial services company runs a multi-tier application across two Availability Zones. The database tier uses Amazon RDS MySQL with a standby replica. During a planned maintenance window, the primary RDS instance fails over to the standby. Applications experience 30–60 seconds of connection errors. Which approach BEST minimizes this disruption for future failovers?
-
A
Enable RDS Proxy to pool and proxy database connections, absorbing the failover transparently
-
B
Switch to Amazon DynamoDB to eliminate relational database failover delays entirely
-
C
Add a second standby replica in a third Availability Zone to reduce failover time
-
D
Increase the application's database connection retry interval to 90 seconds