CODEWITHSUNDEEP
amazon-web-servicesamazon-rdsamazon-auroraaws-serverlessaws-aurora-serverless
Alvin
Alvin

Reputation: 41

Can AWS RDS Aurora custom endpoint combine Writer and Reader instance?

In AWS RDS Aurora Serverless v2, I can create a custom endpoint in Regional Cluster for Writer Instance and Reader Instance, but I was wondering is there any load balancing if I doing this way?
Thanks

Upvotes: 4

Views: 3128

Answers (1)

Max Webster
Max Webster

Reputation: 334

Yes, it only makes sense to connect to the custom endpoint to do read-only sorts of things. For the writer instance, the idea is that you don't know ahead of time if an instance will be a writer or a reader. (Because an automatic or manual failover could happen at any time.) So the writer instance can't really be prohibited from being part of a custom endpoint.

For example, if you made a custom endpoint e.g. with a few x2g instances to do queries that required lots of memory, when you connected you might find that one of the instances in that custom endpoint was now the writer. But the point of connecting to the custom endpoint would still be to do SELECTs, which you can guaranteed do with either kind of instance.

Upvotes: 0

Related Questions