AWS Certified Solutions Architect Associate SAA-C03 Practice Question
How does using Amazon RDS Proxy help improve the performance and scalability of an Amazon RDS database?
It maintains a pool of established database connections and multiplexes application requests, reducing the number of idle connections that reach the database.
It periodically restarts the database instance to clear idle sessions and reclaim resources.
It automatically creates and manages read replicas to offload read traffic without changing application code.
It compresses all SQL traffic between the application and the database, cutting network latency by half.
Amazon RDS Proxy sits between your application and the database, keeps a pool of established connections, and multiplexes application requests onto a smaller set of database connections. This reduces the CPU and memory overhead on the database that would otherwise be spent opening, maintaining, and closing large numbers of idle or transient connections, allowing the database to devote more resources to serving queries.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What exactly is a database proxy and how does it work?
Open an interactive chat with Bash
What is connection pooling and why is it important?
Open an interactive chat with Bash
What are idle connections and how do they affect database performance?