Hundreds of concurrent Lambdas each open a new RDS connection per i…

Question

Hundreds of concurrent Lambdas each open a new RDS connection per invoke and exhaust maxconnections. What should the team implement?

Accepted Answer

Use connection pooling via Amazon RDS Proxy (and reuse connections carefully in the execution environment) so Lambdas do not open a raw connection per invoke — Lambda scales out; naive one-connection-per-invoke knocks over RDS. Put RDS Proxy (and smart reuse) between the functions and the database so connections are pooled.

Answer

Raise Lambda reserved concurrency without changing how connections are opened

Answer

Switch every query to DynamoDB Scan to avoid relational connections entirely in this release

Answer

Store the database password in plaintext environment variables to speed connects

Hundreds of concurrent Lambdas each open a new RDS connection per invoke and exhaust max_connections. What should the team implement?

Short Explanation

Full Explanation