A company’s data platform uses an Amazon Aurora MySQL database with multiple read replicas and DB instances across Availability Zones. Users report errors indicating too many connections. The company wants to reduce failover time by 20% when a read replica is promoted to primary writer. Which solution meets this requirement?

Amazon RDS Proxy is the correct solution because it pools and shares database connections, reducing the overhead of establishing new connections and improving application resilience during failovers. By maintaining a warm connection pool, RDS Proxy can significantly reduce failover times for Aurora databases, often by up to 66%, exceeding the 20% requirement. Switching to Amazon RDS with Multi-AZ cluster deployment would involve a migration and doesn't directly address the connection management or failover time reduction for an existing Aurora setup. Amazon DynamoDB and Amazon Redshift are NoSQL and data warehousing solutions, respectively, and are not suitable replacements for an existing relational Aurora MySQL database, nor do they directly solve the connection management or failover time for the current architecture.