Free Indexes, queries and scale lessonsIndexes, queries and scale · Stage 3 · Scaling out · Step 1
Replication and sharding
Two ways to go beyond one machine: copies for reads and availability, and splitting data by key for writes and size. About 15 minutes.
Writes have outgrown a single machine. Which is true?
- AAdding read replicas won't help, since every replica must apply every write: shard instead
- BAdding read replicas increases write capacity
- CA cache removes the need for any writes
Show the answer
Adding read replicas won't help, since every replica must apply every write: shard instead. Replication copies all data and all writes to each replica.
4 questions on this idea
Short questions that apply the idea to new cases: trace it, work out a number, put steps in order. A wrong answer explains itself.
Answer them in your browserFree account, no card. Your progress is saved, and the idea comes back in a quick review later.
Sign up free to solve