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?

Sujets

Migration et modernisation Analytique Base de données

Balises

Amazon Relational Database Service Amazon Aurora Aurora MySQL

Langue

English

jonb

demandé il y a 2 ans1154 vues

1 réponse

Le plus récent
Le plus de votes
La plupart des commentaires

Ces réponses sont-elles utiles ? Votez pour la bonne réponse pour aider la communauté à bénéficier de vos connaissances.

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

répondu il y a 2 ans

jonb
il y a 2 ans
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
il y a 2 ans
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.

Contenus pertinents

account is currently blocked and not recognized as a valid account
Yves Boah
demandé il y a un an
[ACTION REQUIRED] Update your TLS connections to 1.2 : quelles applications sont concernées ?
rePost-User-7550145
demandé il y a un an
error 403 / cloud front
nico-HPF
demandé il y a 2 mois
My account is not recognized
juan ortega
demandé il y a un an
Comment résoudre l'erreur « javasqlSQLException: No more data to read from socket » lorsque j'essaie de me connecter à mon instance Amazon RDS for Oracle ?
AWS OFFICIELA mis à jour il y a 2 ans
Comment résoudre l’erreur « [AWS service] was unable to place a task because no container instance met all of its requirements » rencontrée dans Amazon ECS ?
AWS OFFICIELA mis à jour il y a un an
Comment utiliser le proxy Amazon RDS pour me connecter à mon instance de base de données Amazon RDS ou à mon cluster de base de données Aurora compatible MySQL ?
AWS OFFICIELA mis à jour il y a 8 mois
Comment résoudre l'erreur AWS Glue « The specified subnet does not have enough free addresses to satisfy the request » (Le sous-réseau spécifié ne dispose pas de suffisamment d'adresses libres pour répondre à la requête) ?
AWS OFFICIELA mis à jour il y a 2 ans