Using RDS Proxy in a scalable way

Multi-AZ DB clusters don't support the following features: Amazon RDS Proxy

So how can I work with RDS Proxy if I use the multi az cluster structure? Do I need to add proxies to instances in different regions?

In such a case I will have 3 proxies for 3 AZs. How do I decide which proxy to use in application code?

Kyle_B SUPPORT ENGINEER
7 months ago
Hi,

I just want to clarify, you are referring to a Multi-AZ Cluster as listed here: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/multi-az-db-clusters-concepts.html#multi-az-db-clusters-concepts.Limitations

And not a single RDS instance with Multi-AZ Enabled, or Aurora with instances in other availability zones, correct?

If it is the first, you wouldn't be able to create RDS Proxy regardless, it is not an option at this current time with this configuration. When you create the Target Group it wont list any of the instances. I tested this in my own environment.
Murat AKSU
7 months ago
Yes it is correct. I'm talking about this: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/multi-az-db-clusters-concepts.html#multi-az-db-clusters-concepts.Limitations

Is there a similar solution if we cannot use an RDS proxy? Wouldn't this be a big problem for using lambda? Will using pooling in application code be sufficient?

Topics

Tags

Language

English

asked 7 months ago394 views

2 Answers

Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.

Using Amazon RDS Proxy can help reduce the database load, improve scalability, and increase application availability.

So if you did not use a proxy it`s not a big problem if you have a small load for rds.

Regards, Andrii

EXPERT

answered 7 months ago

Pandit Prasad
7 months ago
Please contact pjprasad@ for roadmap items regarding Multi-AZ DB Clusters

Hi,

I just wanted to update this, but RDS Proxy can now be used for Multi-AZ Clusters as listed here:

and:

SUPPORT ENGINEER

answered 5 months ago

Relevant content