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?

Argomenti

Migrazione e modernizzazione Analisi Database

Tag

Amazon Relational Database Service Amazon Aurora Aurora MySQL

Lingua

English

jonb

posta 2 anni fa1154 visualizzazioni

1 Risposta

Più recenti
Maggior numero di voti
Maggior numero di commenti

Queste risposte sono utili? Dai un voto positivo alla risposta corretta per aiutare la community a trarre vantaggio dalle tue conoscenze.

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

con risposta 2 anni fa

jonb
2 anni fa
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 anni fa
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.

Contenuto pertinente

Come posso risolvere l'errore "Your current user or role does not have access to Kubernetes objects on this EKS cluster" in Amazon EKS?
AWS UFFICIALEAggiornata un anno fa
In che modo posso risolvere l'errore "Waiting for the slave SQL thread to free enough relay log space" in Amazon Aurora MySQL?
AWS UFFICIALEAggiornata 3 anni fa
Come faccio a correggere l'errore "“Bucket cannot have ACLs set with ObjectOwnership's BucketOwnerEnforced setting” (Il bucket non può avere ACL impostate con l'impostazione BucketOwnerEnforced di ObjectOwnership) in CloudFormation?
AWS UFFICIALEAggiornata un anno fa
Ho ricevuto il messaggio "NetworkInterfaces associated with the Lambda Function to be cleaned up" durante l'eliminazione di uno stack CloudFormation.
AWS UFFICIALEAggiornata 3 anni fa