When do you need to use a read replica? Probably not when you think.

A extremely common issue I notice in Speedshop Tune clients is that they've chosen to use read replica before it was necessary.What's a read replica? Generically, a read replica is a SQL database that's set up to "follow" another one. It's a total replication of the "primary" database, and is continuously updated so it's always a very short amount of time behind the primary (how far behind it is is sometimes called "replication lag").You can set them up pretty easily on AWS and Heroku. Heroku calls them "followers" and it can be set up in just one command: https://devcenter.heroku.com/articles/heroku-postgres-follower-databases.


When do you need to use a read replica? Probably not when you think. #ruby #rubydeveloper #rubyonrails https://rubyonrails.ba/single/missing-email-when-do-you-need-to-use-a-read-replica-probably-not-when-you-think

Nezir Zahirovic

Contractor Ruby On Rails (8+ years) / MCPD .Net / C# / Asp.Net / CSS / SQL / (11 years)

related articles