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?

主題

遷移與現代化分析資料庫

標籤

Amazon Relational Database Service Amazon Aurora 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?

相關內容