Bitzu

SAA-C03 ยท High-performing databases and caching

RDS Proxy: pooled connections, faster failover, IAM auth

Connection pooling with RDS Proxy for Lambda and bursty apps, faster failover and IAM authentication to the proxy.

Key points

  • RDS Proxy: between app and RDS or Aurora, pools connections shared by many clients.
  • Prevents connection storms, e.g. thousands of Lambda invocations.
  • Excess requests queued or throttled; beyond limits, shed.
  • Failover: keeps client connections open, shorter disruption.
  • Can require client IAM auth; reaches the DB with Secrets Manager credentials or IAM database auth.
  • In the DB's VPC, never public; apps only change the endpoint.

Source: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-proxy.html

Practice questions

Single choice

What is the main job of Amazon RDS Proxy?

  1. Pooling and sharing database connections between clients
  2. Adding read replicas automatically as load grows
  3. Replicating a database to a second AWS Region
  4. Caching query results in memory for faster reads
Show answer

Answer: A. Pooling and sharing database connections between clients

RDS Proxy pools and reuses database connections so many clients share a controlled number of them. It does not cache query results (that is ElastiCache), does not add read replicas, and does not replicate data across Regions.

Select all that apply

Which statements about Amazon RDS Proxy are correct?

  1. The proxy can be made publicly accessible from the internet
  2. The proxy must be in the same VPC as the database
  3. The proxy can require clients to authenticate with IAM
  4. The proxy can use an RDS read replica as its target instance
  5. The proxy can connect with credentials held in Secrets Manager
Show answer

Answer: B. The proxy must be in the same VPC as the database, C. The proxy can require clients to authenticate with IAM, E. The proxy can connect with credentials held in Secrets Manager

The proxy must be in the same VPC as the database, it can require IAM authentication from clients, and it can use Secrets Manager credentials to reach the database. A proxy cannot be publicly accessible, and for RDS instances in a replication setup it can be associated only with the writer, not a read replica.

True or false

Adopting RDS Proxy usually means rewriting the application to use a special proxy SDK instead of the normal database driver.

Show answer

Answer: False

False. RDS Proxy is compatible with the engine versions it supports, so most applications keep their usual driver and only change the connection endpoint to the proxy's.

Practice 8 questions on this topic in Bitzu

Short lessons, instant explanations and spaced review of what you get wrong. Free on iOS and Android.

Download on the App StoreGet it on Google Play

More SAA-C03 topics in this module