Read Consistency with Database Replicas
Shopify routes reads to MySQL replicas while giving apps consistency guarantees such as monotonic reads.
At the far end of the replica approach, OpenAI offloads ChatGPT's reads to nearly 50 Postgres replicas. When reads aren't the bottleneck any more, see when teams chose sharding over more replicas.
- Published
- 2021-02-22
- Scale
- Not stated in source
- Techniques
- read replicas consistency
- Stack
- MySQL
Try this stack yourself
- Railway · Deploy something like this on Railway: spin up MySQL plus your app in a few clicks. New accounts get $20 in credit (applied when you pick a paid plan).
Railway isn't part of Shopify's setup in this story. It's just an easy place to try the same building blocks.
Some links above are affiliate links: if you sign up, How They Scaled may earn a commission at no extra cost to you. We only list tools that fit the stack in the story.