48. Design a Ticket Booking System like Ticketmaster
Hold seats with one conditional write, pay by authorize and capture, and put ten million fans in a fair waiting room without selling a seat twice.
Start with a template. Work through each step. Ask Coach when you need a second opinion.
Company tags are community-reported. Counts on cards show how many people reported that design.
Hold seats with one conditional write, pay by authorize and capture, and put ten million fans in a fair waiting room without selling a seat twice.
Take bids on 10 million live auctions with one consistent highest bid, lose none, push the price to every watcher and end each auction fairly.
Show what 10,000 small warehouses can deliver within the hour in under 100 ms, and take multi-item orders without ever selling a unit twice.
Sell 10,000 units to a million people at noon with a lottery waiting room, a Redis gate before an Aurora ledger and holds that expire.
Serve a product page a million times a second: a cheap query, replicas, Redis and the edge, with hot keys, stampedes and invalidation handled.
A relational database like PostgreSQL: WAL and MVCC on one server, quorum replication and failover, then a sharded fleet.
Record every money movement as balanced, append-only entries, exactly once, with holds, payouts and reconciliation.