A solutions architect has created an AWS Lambda function that makes queries to an Amazon Aurora MySQL DB instance. When the solutions architect performs a test, the DB instance shows an error for too

Question

Options

• ACreate a read replica for the DB instance. Query the replica DB instance instead of the primary
• BMigrate the data to an Amazon DynamoDB database.
• CConfigure the Amazon Aurora MySQL DB instance for Multi-AZ deployment.
• DCreate a proxy in Amazon RDS Proxy. Query the proxy instead of the DB instance.

• A
  2% (1)
• B
  2% (1)
• C
  5% (3)
• D
  92% (59)

Explanation

AWS RDS Proxy is a fully managed, highly available database proxy that allows applications to pool and share database connections efficiently. In serverless architectures like Lambda, rapid invocations can open numerous concurrent connections to Aurora, potentially overwhelming the database and causing "too many connections" errors. By using Amazon RDS Proxy, the solution: Pools database connections. Maintains warm connections that can be reused. Supports IAM authentication and Secrets Manager integration. Requires minimal application change and low operational effort. This directly supports the Performance Efficiency pillar of the AWS Well-Architected Framework, ensuring the application scales without overloading the DB.

No community discussion yet for this question.