CODEWITHSUNDEEP
amazon-web-servicesamazon-rdsamazon-aurora
Francisco Albert
Francisco Albert

Reputation: 1711

AWS - Aurora replicas

Scenario:

Why?, is because this second replica is ONLY to prevent failures of the first one?, cannot be possible to make both to share the load?

Upvotes: 1

Views: 479

Answers (1)

sfblackl
sfblackl

Reputation: 471

In your RDS console, you should be able to look at each of the 3 instances

  1. aurora-databasecluster-xxx.cluster-yyy.us-east-1.rds.amazonaws.com:3306
  2. zz0.yyy.us-east-1.rds.amazonaws.com:3306
  3. zz1.yyy.us-east-1.rds.amazonaws.com:3306

If you look at the cluster tab you will see two end points and the 2nd is the following: aurora-databasecluster-xxx.cluster-ro-yyy.us-east-1.rds.amazonaws.com

Aurora allows you do either explicitly get to specific read replica. This would allow a set of read only nodes for OLTP performance and another set for data analysis - with long running queries that won't impact performance.

If you use the -ro end point, it should balance cross all read only nodes or you can have your code take a list of read only connection strings and do your own randomizer. I would have expected the ro to be better...but I am not yet familiar on their load balancing technique (fewest connections, round robin, etc)

Upvotes: 5

Related Questions