A solutions architect is reviewing application resilience. A database administrator recently failed over an Amazon Aurora PostgreSQL writer instance during a scaling exercise, causing 3 minutes of downtime. Which solution will reduce downtime for scaling exercises with the LEAST operational overhead?

Amazon RDS Proxy minimizes downtime during failovers by maintaining a pool of established database connections. When a failover occurs, RDS Proxy automatically routes new connection requests and existing connections to the new writer instance, masking the change from the application. This significantly reduces the time applications spend re-establishing connections, leading to near-instant failover times and less operational overhead compared to manual endpoint updates. Creating more read replicas addresses read scaling, not writer failover downtime. A secondary Aurora cluster requires application endpoint updates during failover, increasing operational overhead. ElastiCache for Memcached is a caching solution and does not directly address database writer instance failover downtime.