The write wall example with 8,000 writes a second and a 4,800 cap finally made sharding click for me. Where do people get stuck most on level 9, splitting shards or realizing the replica still eats every write?
Glad it clicked! I don’t have enough data yet to say for sure, but from how the level is built, the replica is the trap. Most people try a read replica or a bigger database first, because that fixed the earlier levels. But every replica still has to apply every write, so 8,000 writes a second hits each copy just the same. Once that lands, the split itself is easy: 4 shards at about 2,000 writes each fits under the 4,800 cap with room to spare.
The part people don’t expect is the bill. Sharding turns out to be the most expensive line in the design, which is exactly why teams put it off as long as they can.