A serverless application on Lambda connects to an Amazon RDS for MySQL instance and users are now seeing frequent "too many connections" errors. The DB is already configured with the highest available max_connections. What should the SysOps administrator do to prevent these connection errors?
Choose an answer
Tap an option to check your answer.
Correct answer: Deploy Amazon RDS Proxy and update the Lambda function's connection string to use the proxy..
Why this is the answer
Deploying Amazon RDS Proxy is the most effective solution because it pools and reuses database connections, preventing the "too many connections" error that frequently occurs with serverless functions like Lambda. Lambda functions are stateless and can scale rapidly, opening new database connections with each invocation. RDS Proxy manages these connections efficiently, reducing the load on the RDS instance. Creating an RDS read replica helps with read scalability but does not solve the connection limit issue for write operations or the primary instance. Increasing maxconnecterrors only affects how many failed connection attempts are tolerated before a host is blocked, not the total number of active connections. Raising Lambda's reserved concurrency limits would allow more concurrent Lambda invocations, potentially exacerbating the "too many connections" problem rather than solving it.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed