Answer-first summary for fast verification
Answer: Implement Amazon RDS Proxy for connection pooling and update Lambda to connect via the proxy.
The best solution to meet the requirements is using Amazon RDS Proxy. Amazon RDS Proxy efficiently handles large numbers of simultaneous connections by pooling and sharing database connections, improving database efficiency and application scalability. This reduces the number of connections to the database and effectively handles unpredictable peak loads without requiring the database to be down outside of scheduled maintenance hours. Options A, C, and D either reduce performance, potentially cause downtime, or do not directly address the connection issue.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
An AWS-hosted application with an HTTP API via Amazon API Gateway, integrated with a Lambda function, and using an Amazon RDS MySQL DB instance (2 vCPUs, 64 GB RAM), is experiencing unpredictable peak usage times resulting in HTTP 500 errors due to 'too many connections' as reported by CloudWatch Logs. The company requires a solution to ensure application resilience without database downtime outside scheduled maintenance. Which solution meets these criteria?
A
Reduce DB instance vCPUs and raise max_connections.
B
Implement Amazon RDS Proxy for connection pooling and update Lambda to connect via the proxy.
C
Set a CloudWatch alarm to scale DB instance class at connection counts over 1,000.
D
Create an Amazon EventBridge rule to adjust max_connections based on CPU utilization thresholds.
No comments yet.