lessons

The copy is always a little behind

middlingA second copy of the database takes the reads off the first one, and answers with what it knew a moment ago. Which reads can live with that is the design.

0 of 4 done

1Read the diagram

A news site. Six thousand article reads a second at peak, and about two hundred writes — a published edit, a comment, a view counter — all on one SQL database, which is out of headroom. Somebody suggests a second copy of it. What can that copy take off the first one?