A company launched an Amazon RDS for MySQL DB instance. Most connections come from serverless applications, and traffic spikes unpredictably. During high demand, applications receive database connection rejection errors. Which solution will resolve this issue with the least operational overhead?
Choose an answer
Tap an option to check your answer.
Correct answer: Create an RDS Proxy. Configure the users’ applications to use the DB instance through RDS Proxy..
Why this is the answer
RDS Proxy is the correct solution because it pools and shares database connections, effectively managing unpredictable traffic spikes and preventing connection rejection errors for serverless applications. It also handles credential management and provides failover support, reducing operational overhead. ElastiCache for Memcached caches query results, which can reduce database load but doesn't solve connection limits directly. Migrating to a higher I/O instance class increases performance but doesn't inherently address the connection limit issue. Multi-AZ provides high availability and disaster recovery, but it doesn't increase the number of concurrent connections a single DB instance can handle or pool connections for serverless applications.
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