A global ecommerce company runs its critical workloads on AWS. The workloads use an Amazon RDS for PostgreSQL DB instance that is configured for a Multi-AZ deployment. Customers have reported…

Question

Options

• ACreate an Amazon RDS Proxy. Assign the proxy to the DB instance.
• BCreate a read replica for the DB instance Move the read traffic to the read replica.
• CEnable Performance Insights. Monitor the CPU load to identify the timeouts.
• DTake regular automatic snapshots Copy the automatic snapshots to multiple AWS Regions

• A
  61% (41)
• B
  25% (17)
• C
  9% (6)
• D
  4% (3)

Explanation

Amazon RDS Proxy: RDS Proxy is a fully managed, highly available database proxy that makes applications more resilient to database failures by pooling and sharing connections, and it can automatically handle database failovers. Reduced Failover Time: By using RDS Proxy, the connection management between the application and the database is improved, reducing failover times significantly. RDS Proxy maintains connections in a connection pool and reduces the time required to re-establish connections during a failover. Create an RDS Proxy instance. Configure the proxy to connect to the RDS for PostgreSQL DB instance. Modify the application configuration to use the RDS Proxy endpoint instead of the direct database endpoint. Operational Benefits: This solution provides high availability and reduces application timeouts during failovers with minimal changes to the application code.

No community discussion yet for this question.