6

I created an RDS Proxy with existing Aurora PostgreSQL cluster.

But I want to pair the proxy with specific read replica instance of the cluster. Is that possible?

jtoberon
  • 8,706
  • 1
  • 35
  • 48
Kim-Jimin
  • 674
  • 2
  • 9
  • 19

3 Answers3

5

From what AWS claims about RDS proxy:

The same consideration applies for RDS DB instances in replication configurations. You can associate a proxy only with the writer DB instance, not a read replica.

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html

Dharman
  • 30,962
  • 25
  • 85
  • 135
Binh Nguyen
  • 1,891
  • 10
  • 17
  • 2
    As of March 2021 this is supported - Please check https://aws.amazon.com/about-aws/whats-new/2021/03/amazon-rds-proxy-adds-read-only-endpoints-for-amazon-aurora-replicas/#:~:text=Amazon%20RDS%20Proxy%20now%20lets,connected%20through%20the%20RDS%20Proxy. – Ameen Ibrahim Raffic - 'AIR' Apr 22 '21 at 13:43
  • @AmeenIbrahimRaffic-'AIR' Its supported only in Amazon Aurora Replicas, Not supported in MySQL replicas yet. – Ruchit Patel Nov 16 '21 at 11:19
  • I was not able to connect to the RDS replica. You can create a read only endpoint but it is my understanding that it is still uses the writer instance. I submitted a question to AWS to confirm. – JB11 Nov 24 '21 at 19:06
1

Should be possible now as per https://aws.amazon.com/about-aws/whats-new/2021/03/amazon-rds-proxy-adds-read-only-endpoints-for-amazon-aurora-replicas/

Igor K
  • 383
  • 5
  • 10
0

Try RDS Proxy Endpoint, which allows you to get use of read replicas:

You can create and connect to read-only endpoints called reader endpoints when you use RDS Proxy with Aurora clusters. These reader endpoints help to improve the read scalability of your query-intensive applications. Reader endpoints also help to improve the availability of your connections if a reader DB instance in your cluster becomes unavailable.

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html#rds-proxy-endpoints

Siyuan Xing
  • 1
  • 1