A company’s ecommerce website has unpredictable traffic and uses AWS Lambda functions to directly access a private Amazon RDS for PostgreSQL DB instance. The company wants predictable database performance and to ensure Lambda invocations do not overload the database with too many connections. What should a solutions architect do to meet these requirements?

The correct solution is to point the client driver at an RDS proxy endpoint and deploy the Lambda functions inside a VPC. AWS RDS Proxy is a fully managed, highly available database proxy that makes applications more resilient to database failures and more secure. It pools and shares database connections, reducing the overhead of establishing new connections for each Lambda invocation, which is crucial for unpredictable traffic patterns and preventing database overload. Deploying Lambda functions inside a VPC