2 Answers
- Newest
- Most votes
- Most comments
1
You need to specifically target the reader instance with your application. Any query routing would need to happen in the app as well.
Check out this doc page for more details: Replication with Amazon Aurora
answered 2 years ago
1
Take a look at Amazon Aurora connection management.
You control where SELECTS are sent by connecting to an endpoint, Cluster, Reader, Instance, or Custom.
Relevant content
- Accepted Answerasked 2 years ago
- Accepted Answerasked 3 years ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 years ago
Got it.but thinking about a scenario where my cluster only has one Reader. In case this Reader overloads with queries, is the load balanced with the Writer?
You need to create a Custom (ANY) endpoint for that scenario.
Also, take a look auto scaling your read replicas: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Integrating.AutoScaling.html