From the course: Designing Highly Scalable and Highly Available SQL Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using read replicas to improve query performance

Using read replicas to improve query performance

From the course: Designing Highly Scalable and Highly Available SQL Databases

Start my 1-month free trial

Using read replicas to improve query performance

“

- [Instructor] Read replicas are an important tool in our sort of toolbox when it comes to scalable databases. So let's take a look at what they do. Now typically when we have, let's just say a modest size database. We have probably a single server maybe beefed up pretty well. You know maybe eight cores, 32 gigs of RAM, and we can handle a pretty decent workload with that. And by workload, what I mean is write operations, like for example, the red arrows are data coming into the primary, black arrows are data going out in the form of query results. And a single node can handle that particular load. Now there may be times where either we have really disproportionate amount of reads or our server just can't scale up to handle say a growing workload. And so what we really like to do is somehow like, split up the workload a little bit between a couple of nodes or maybe multiple nodes. Well, one way to do this is to add…

Contents