# Amazon RDS Proxy

Amazon RDS Proxy is a managed database proxy that pools and shares connections to supported Amazon RDS and Amazon Aurora databases.

Cloud service · AWS. Updated 2026-11-12. Page: https://blowstack.com/tools/cloud-services-hub/amazon-rds-proxy

> Amazon RDS Proxy sits between applications and supported relational databases to reduce connection overhead, control database connection pressure, and improve connection handling during failover. It provides database-protocol endpoints, integrates with AWS authentication and monitoring services, and operates within an Amazon VPC.

Practice exams covering Amazon RDS Proxy: [SOA-C03 AWS Certified CloudOps Engineer - Associate](https://blowstack.com/practice-exams/aws-certified-cloudops-engineer-associate), [DVA-C02 AWS Certified Developer - Associate](https://blowstack.com/practice-exams/aws-certified-developer-associate).

## 8 key features of Amazon RDS Proxy

1. **Managed connection pooling**: Maintains database connections and reuses them across client connections when session state permits. This reduces connection establishment overhead and helps protect databases from bursts of short-lived application connections.
2. **Connection pressure controls**: Configure the maximum database connection percentage, idle pool behavior, and connection borrow timeout. Requests can wait for an available connection rather than immediately opening more database connections, although they can still time out under sustained saturation.
3. **Failover-aware connectivity**: Tracks supported database failovers and directs connections to the available target. Applications must still handle disconnected sessions and failed transactions because the proxy does not provide automatic transaction replay.
4. **Secrets Manager and IAM authentication**: Supports database credentials stored in AWS Secrets Manager and IAM database authentication in supported configurations. Configure client-side and database-side authentication separately, and verify engine support before choosing end-to-end IAM authentication.
5. **Private networking and TLS**: Exposes endpoints through VPC networking and uses security groups to control access. Require TLS on client connections where appropriate and configure database drivers to validate the server certificate.
6. **Additional proxy endpoints**: Create additional endpoints for supported scenarios such as access from another VPC or read-only access to Aurora readers. Read-only endpoints require a compatible Aurora topology and do not inspect SQL to route reads automatically from a read/write endpoint.
7. **Operational visibility**: Publishes CloudWatch metrics for client connections, database connections, connection borrowing, and related behavior. Use these metrics with database monitoring to distinguish connection contention from slow SQL or insufficient database capacity.
8. **Session-aware connection reuse**: Preserves database session semantics by retaining a backend connection when a session cannot safely be multiplexed. Monitor session pinning and review engine-specific pinning conditions when pooling efficiency is lower than expected.

## Where Amazon RDS Proxy is used

1. **Database access from Lambda functions**: Place the proxy between VPC-connected Lambda functions and a supported database to absorb bursts of client connections. Set function concurrency and proxy pool limits together so database demand remains bounded.
2. **Autoscaling application fleets**: Use a shared proxy endpoint for applications running on Amazon ECS, Amazon EKS, or Amazon EC2. Pooling reduces connection churn as tasks, pods, or instances start and stop.
3. **More resilient database failover handling**: Use the proxy to reduce connection recovery work during supported RDS or Aurora failovers. Combine it with driver timeouts, bounded retries, and idempotent operations rather than relying on the proxy to preserve in-flight transactions.
4. **Separating Aurora reader traffic**: For supported Aurora clusters, send suitable read-only workloads to a read-only proxy endpoint and writes to the read/write endpoint. Applications must explicitly choose the endpoint and account for replica lag.
5. **Standardizing database authentication**: Adopt IAM authentication where supported or let the proxy retrieve database credentials from Secrets Manager. This can reduce distribution of long-lived database passwords to application runtimes.

## How Amazon RDS Proxy is priced

- **Provisioned database capacity pricing**: For supported provisioned RDS and Aurora databases, proxy pricing is based on the vCPU capacity of the underlying database instances covered by the proxy. Regional rates, minimum billable capacity, and billing rules apply; resizing the database can change proxy charges even when request volume is unchanged.
- **Aurora Serverless capacity pricing**: For supported Aurora Serverless configurations, pricing uses Aurora Capacity Unit hours rather than provisioned-instance vCPU hours. Check the applicable minimum capacity charge and how capacity changes affect billing when estimating a serverless deployment.
- **Additional endpoints and supporting services**: Additional proxy endpoints incur AWS PrivateLink charges. Budget separately for applicable data transfer, Secrets Manager, AWS KMS, and monitoring charges; database charges are not included in the proxy price.

## Services Amazon RDS Proxy works with

A common architecture places VPC-connected Lambda functions or ECS tasks behind an application endpoint and sends their database traffic through RDS Proxy to a supported RDS instance or Aurora cluster. Security groups should explicitly permit application-to-proxy traffic and proxy-to-database traffic on the database port. Keep application connection pools small enough that scaling the compute fleet does not create excessive client connections.

For authentication, applications can use IAM database authentication where supported, while the proxy uses either configured Secrets Manager credentials or supported end-to-end IAM authentication. Secret-backed deployments require an IAM role that can retrieve the selected secrets and decrypt them when necessary. Database users and privileges still control which SQL operations an authenticated session may perform.

CloudWatch supplies the operational feedback needed to tune this architecture. Compare client connections, backend connections, borrowing latency, and session pinning with database load. For compatible Aurora deployments, route explicitly selected read-only workloads through a reader endpoint. Across these patterns, retain application-level timeout handling, transaction retries, and idempotency safeguards because connection pooling and failover handling do not guarantee successful transaction completion.

- **[AWS Lambda](https://blowstack.com/tools/cloud-services-hub/aws-lambda)**: VPC-connected Lambda functions can use a proxy endpoint instead of connecting directly to a supported database. For example, an order-processing function can reuse a client connection across warm invocations while the proxy manages backend connection pooling. Coordinate Lambda concurrency with database capacity and configure security groups for the function-to-proxy and proxy-to-database paths.
- **[Amazon Aurora](https://blowstack.com/tools/cloud-services-hub/amazon-aurora)**: RDS Proxy registers a supported RDS database instance or Aurora cluster as its target and manages connections to that target. For example, an Aurora application can use the default read/write endpoint for transactions and a supported read-only proxy endpoint for reader traffic. Verify engine, version, Region, and topology support before provisioning the proxy.
- **[AWS Secrets Manager](https://blowstack.com/tools/cloud-services-hub/aws-secrets-manager)**: In secret-backed configurations, the proxy retrieves database credentials from Secrets Manager using an authorized IAM role. For example, store an application's database username and password in a secret and grant the proxy access to that secret. Coordinate credential rotation with the database and grant decrypt permission when the secret uses a customer-managed KMS key.
- **[Amazon CloudWatch](https://blowstack.com/tools/cloud-services-hub/amazon-cloudwatch)**: RDS Proxy publishes operational metrics to CloudWatch and can produce diagnostic logs. For example, create alarms for increasing connection borrow latency and compare client connection counts with backend database connections. Enable detailed logging only when needed for diagnosis, considering its performance impact and the sensitivity of logged information.
- **[AWS Fargate](https://blowstack.com/tools/cloud-services-hub/aws-fargate)**: Applications running in ECS tasks, including tasks on Fargate, can connect to the proxy through VPC networking. For example, an autoscaling API service can use a modest local connection pool per task while RDS Proxy manages aggregate backend connections. Keep application pools bounded because the proxy does not remove client connection limits or database throughput constraints.
- **[Amazon Aurora Serverless](https://blowstack.com/tools/cloud-services-hub/amazon-aurora-serverless)**: Amazon RDS Proxy supports Aurora Serverless v2 databases, pooling and reusing connections as application demand changes. Aurora Serverless v1 databases aren't supported.
- **[Amazon RDS](https://blowstack.com/tools/cloud-services-hub/amazon-rds)**: Amazon RDS Proxy pools connections to supported RDS for MariaDB, Microsoft SQL Server, MySQL, and PostgreSQL databases. It limits connection pressure on the database and reconnects to an available database instance during failover.
- **[Amazon EventBridge](https://blowstack.com/tools/cloud-services-hub/amazon-eventbridge)**: Amazon RDS Proxy publishes proxy lifecycle and availability events through Amazon RDS to Amazon EventBridge. EventBridge rules can route these events to notification or automation targets.
- **[Amazon VPC](https://blowstack.com/tools/cloud-services-hub/amazon-vpc)**: Amazon RDS Proxy runs in a VPC and uses selected subnets and security groups to control connectivity between clients, the proxy, and its database. Additional proxy endpoints can provide access from another VPC.
- **[AWS Certificate Manager (ACM)](https://blowstack.com/tools/cloud-services-hub/aws-certificate-manager-(acm))**: Amazon RDS Proxy uses certificates from AWS Certificate Manager for TLS connections from clients. Applications connecting through the proxy don't need to manage the underlying database's RDS certificate rotation.
- **[AWS CloudFormation](https://blowstack.com/tools/cloud-services-hub/aws-cloudformation)**: Amazon RDS Proxy can be provisioned with AWS CloudFormation using DBProxy, DBProxyEndpoint, and DBProxyTargetGroup resources. Templates can define the proxy's authentication, networking, database targets, and connection-pool settings.
- **[AWS CloudTrail](https://blowstack.com/tools/cloud-services-hub/aws-cloudtrail)**: Amazon RDS Proxy management API calls are recorded by AWS CloudTrail as Amazon RDS API activity. These records let you audit actions such as creating a proxy, changing its configuration, or registering database targets.
- **[AWS Identity and Access Management (IAM)](https://blowstack.com/tools/cloud-services-hub/aws-identity-and-access-management-(iam))**: Amazon RDS Proxy uses IAM policies to control proxy administration and IAM database authentication to authorize client connections. It also uses an IAM role to retrieve database credentials from Secrets Manager, or can use end-to-end IAM authentication with supported databases.
- **[AWS Key Management Service (AWS KMS)](https://blowstack.com/tools/cloud-services-hub/aws-key-management-service-(aws-kms))**: Amazon RDS Proxy's IAM role needs permission to decrypt database credentials stored in Secrets Manager with an applicable AWS KMS key. For a customer-managed key, its permissions must allow the proxy role to use the key through Secrets Manager.
- **[AWS PrivateLink](https://blowstack.com/tools/cloud-services-hub/aws-privatelink)**: Amazon RDS Proxy uses AWS PrivateLink for additional proxy endpoints, enabling private access to a proxy from another VPC. Clients can connect through an endpoint in their own VPC without making the database publicly accessible.

## Amazon RDS Proxy exam questions

Real practice exam questions on Amazon RDS Proxy, with the correct answer and its explanation.

### Question 1 (SOA-C03)

**Question:**

A company runs a write-intensive application on an Amazon EC2 Auto Scaling group. The application uses an Amazon RDS for PostgreSQL Multi-AZ DB instance. Each application process maintains its own connection pool, resulting in many idle database connections as the fleet scales out.

During a failover test, the new primary becomes available before the application recovers. Investigation shows that application processes continue trying to connect to the old primary's IP address until their cached DNS records expire. Transactions interrupted by a failover can already be safely retried by the application.

A CloudOps engineer must reduce backend connection overhead across the fleet and reduce dependence on application-side DNS refresh during database failovers. The solution must retain the existing database deployment and minimize operational effort.

Which solution BEST meets these requirements?

**Correct answer:** Create an Amazon RDS Proxy associated with the DB instance, configure authentication and network access, and update the application to connect through the proxy endpoint.

**Explanation:** RDS Proxy maintains a shared pool of backend database connections and can reuse them across application clients when transaction and session state permit. During failover, it tracks the database's primary instance and redirects backend connections, reducing reliance on application-side DNS refresh. Interrupted transactions still require application retries, which the application already supports.

### Question 2 (DVA-C02)

**Question:**

A developer maintains a synchronous order API that uses AWS Lambda and an Amazon RDS for PostgreSQL database. During traffic bursts, Lambda creates many execution environments. Each environment already reuses one database connection across invocations. Monitoring shows that idle database sessions consume substantial memory and that connection establishment causes latency spikes, while SQL execution time remains low. Each request performs a short, independent write transaction without session-specific state. The developer must reduce database connection overhead and memory usage without increasing the database instance size or reducing the API's peak request throughput. Which solution best meets these requirements?

**Correct answer:** Create an Amazon RDS Proxy for the database and update the function to connect through the proxy endpoint, retaining connection reuse within each execution environment.

**Explanation:** RDS Proxy maintains a shared pool of database connections and can reuse backend connections across client connections between transactions. The short transactions and absence of session-specific state make this workload suitable for multiplexing, reducing backend session memory and connection-establishment overhead without limiting Lambda concurrency.

## Practice Amazon RDS Proxy in a full exam

Questions on Amazon RDS Proxy in each practice exam, with every answer option and an explanation for each:

- [SOA-C03](https://blowstack.com/practice-exams/aws-certified-cloudops-engineer-associate): 6 questions
- [DVA-C02](https://blowstack.com/practice-exams/aws-certified-developer-associate): 1 question

## What is Amazon RDS Proxy

Amazon RDS Proxy provides a managed connection layer between applications and supported Amazon RDS or Amazon Aurora databases. Applications connect to a proxy endpoint using their normal database drivers, while the proxy maintains a pool of connections to the target database. This is particularly useful when application instances or functions create many short-lived connections that would otherwise consume database memory and processing capacity.

RDS Proxy runs on serverless compute that automatically scales with the database workload. Its infrastructure spans multiple Availability Zones, with compute, memory, and storage independent of the database instance.

Supported database targets include Aurora Serverless clusters, but not Aurora Serverless v1 clusters.

The proxy can reuse a database connection across different client connections when transaction and session state allow it. This multiplexing reduces the number of database connections required for a workload, but it does not eliminate connection limits. Transactions hold database connections while active, and certain statements or session settings can pin a client session to a particular backend connection. Test representative application behavior and monitor session pinning before assuming a specific pooling benefit.

Deploy the proxy in a VPC with network access to its database target. Configure subnets and security groups so applications can reach the proxy and the proxy can reach the database port. A proxy is associated with a database target rather than functioning as a general-purpose router across unrelated databases. Applications normally adopt it by changing their database hostname to the proxy endpoint and configuring the appropriate authentication and TLS settings.

The proxy must reside in the same VPC as its database and cannot be publicly accessible, even if the database is publicly accessible.

Reserve free subnet IP addresses for proxy scaling and maintenance. Insufficient free addresses can prevent scaling and cause higher query latency or client connection failures; RDS reports this condition through event RDS-EVENT-0243.

Each proxy supports at most 20 user-defined endpoints in addition to its default endpoint, for a total of 21 endpoints. The default endpoint cannot be modified.

For RDS DB instances in replication configurations, a proxy can be associated only with the writer DB instance, not a read replica.

Authentication options depend on the database engine and proxy configuration. RDS Proxy supports AWS Secrets Manager credentials and IAM database authentication in supported configurations, including end-to-end IAM authentication where available. Distinguish authentication from the application to the proxy from authentication between the proxy and the database. When using stored credentials, grant the proxy access only to the required secrets and any necessary AWS KMS decryption permissions.

During a supported database failover, the proxy tracks the database target and redirects connections to the available writer. This reduces reliance on application-side DNS refresh and connection recreation, but does not guarantee uninterrupted transactions. In-flight work can fail, and applications still need bounded retries, transaction rollback handling, and idempotency controls. The proxy does not replay failed transactions automatically.

Connection pool settings let engineers limit the database connections used by the proxy and control how long requests wait to borrow one. Tune these settings alongside application concurrency, transaction duration, and database capacity. Use Amazon CloudWatch metrics and proxy logs to investigate connection saturation, borrow latency, authentication failures, and session pinning.

RDS Proxy reserves part of the MaxConnectionsPercent quota for internal monitoring connections, so that quota is not entirely available to application workloads. Keep at least 30% connection headroom above expected peak demand to accommodate spikes and internal connection redistribution.

Check engine, version, Region, and topology support before deployment. For supported Aurora configurations, additional proxy endpoints can provide read-only access to readers or connectivity from another VPC. RDS Proxy is not a query cache, a replacement for database scaling, or a universal solution for slow queries; query tuning, indexing, and transaction design remain necessary.

## Learn Amazon RDS Proxy in lessons

1 short lesson on Amazon RDS Proxy in 1 certification course.

- SOA-C03: Amazon RDS Proxy: connection pooling and database pressure (Premium), https://app.blowstack.com/lessons/amazon-rds-proxy-connection-pooling-and-database-pressure-soa-c03

## Concepts related to Amazon RDS Proxy

- [Connection Pooling](https://blowstack.com/tools/cloud-concepts-hub/connection-pooling): Connection pooling maintains a reusable set of network connections so applications can borrow them instead of establishing a new connection for every operation.
- [Connection Multiplexing](https://blowstack.com/tools/cloud-concepts-hub/connection-multiplexing): Connection multiplexing allows multiple logical client connections to share fewer underlying connections while preserving the isolation required by the application protocol.
- [Reverse Proxy](https://blowstack.com/tools/cloud-concepts-hub/reverse-proxy): A reverse proxy is an intermediary that receives client requests on behalf of backend servers and forwards those requests to the appropriate backend.
