0

I have a db.r5.large for the master/writer.

I want to add some readers.

Do they need to be the same instance type as the master? Or can i add for example 3x db.t3.medium ?

1 Answer 1

0
  • All the writes to a Primary are sent to each Replica and then applied there. For this reason, the Replica should (in general) be at least as beefy as the Primary.
  • Often, you need to do reads on the Primary in support of what you then write.

Hence, the characteristics of the Primaries and Replicas are similar.

If the database is sort of "write once and read many times", then you might want the Replicas to be beefier in general, but still a "database" type, as categorized by the cloud provider.

You may find that db.r5.large is overkill for your Primary, especially if you move a lot of the read traffic off to at least 2 Replicas. (Based on my first bullet item, having only one Replica is not very helpful.)

If you want a deeper review of your application, provide RAM size, SHOW GLOBAL STATUS and SHOW VARIABLES.

1
  • I was thinking on having a beefer writer (db.r5.large) and 2 or 3 db.t3.medium read replicas with aurora autoscaling. Is this a bad practice ?
    – AFRC
    Dec 3, 2020 at 15:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.