Is it possible for RDS Proxy to ignore a reader instance?

We have an Aurora cluster with multiple read-only instances. So far we have set up a custom endpoint in the cluster itself to keep one of those readers from being used in production, so that we can run diagnostic and reporting queries without impacting the production system. This week we migrated to use an RDS Proxy, but I have not figured out how to sync it to my custom endpoint/prevent it from using that one instance. Is this possible with a Proxy?

Topics

Migration & Modernization Analytics Database

Tags

Amazon Relational Database Service Amazon Aurora Aurora MySQL

Language

English

jonb

asked 2 years ago1124 views

1 Answer

Newest
Most votes
Most comments

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

RDS proxy does not currently support custom endpoints. It goes with the default reader end point. The option would to assign a tiering to all of your reader instances and the instance with highest tiering ( lowest number) will be promoted in case of a failover.

Devinder-theDBGuy

answered 2 years ago

jonb
2 years ago
Thanks for your reply, it helps knowing it's not there. Tiering the reader, though, doesn't prevent it from being used, does it?

I'm thinking the solution I need is to actually make a separate read-only replica cluster as described here https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Replication.html#AuroraMySQL.Replication.MySQL
Devinder-theDBGuy
2 years ago
Tiering will def not help your issue where you want connections to not go to a specific reader instance, but it can help in case of failover.

Relevant content

Is it possible to create RDS proxy for a RDS read replica in different region?
Tanmoy
asked 9 months ago
we have a requirement to connect docker to aurora mysql in rds
AWS-User-4586895
asked 2 years ago
RDS Proxy RO Endpoint fallback to writer instance?
fred
asked a year ago
What control over RDS Aurora Serverless V2 buffer cache/cache do we have? It is causing issues when users make GET requests before we have written to the DB, returning emtpy sets for some time.
Oisin
asked 6 months ago
Why is it taking so long to restore a snapshot of my Amazon RDS for MySQL DB instance?
AWS OFFICIALUpdated 3 years ago
How do I create a read replica for an Amazon Aurora MySQL DB instance?
AWS OFFICIALUpdated 2 years ago
Why is my connection redirected to the reader instance when I try to connect to my Amazon Aurora writer endpoint?
AWS OFFICIALUpdated a year ago
How do I use Amazon RDS Proxy to connect to my Amazon RDS for MySQL DB instance or Aurora MySQL-Compatible DB cluster?
AWS OFFICIALUpdated 8 months ago
EMR Cluster failure with "Master instance startup failed due to an internal error"
SUPPORT ENGINEER
Yokesh NK
published 7 days ago
Connect to your Amazon Aurora MySQL DB cluster
EXPERT
Gayathri Krishnamoorthy
published 9 months ago