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?

주제

마이그레이션 및 현대화 분석 데이터베이스

태그

아마존 Relational Database Service 아마존 Aurora 오로라 MySQL

언어

English

jonb

질문됨 2년 전1154회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

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

답변함 2년 전

jonb
2년 전
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년 전
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.

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

관련 콘텐츠