Survive a Database Failure
Medium About 35 min Katabench Pro
The whole product runs on one database, so the night it dies the product dies with it. Add a standby replica the primary streams to and can fail over to.
The full brief is part of Katabench Pro
Pro opens this kata's brief and its grader. To see how the track works first, try Cache the Hot Path, which is free with an account.
How it is graded
You build the design on a canvas, and Katabench checks the topology against the challenge's design rules.
What it practices
- Replication and failover
- Survive a database loss with replicas and failover, fencing stale writers out.
Do these first
Related katas
- Fence the Retired Writer Hard Pro An old process wakes after cutover and overwrites recovered data. Enforce shared ownership epochs at the target.
- Cache the Hot Path Medium Free with account The product page hammers the database directly and melts under load. Design a read path with a load balancer, a cache and a replica, while keeping the client off the database.
- Fan Out Home Timelines Medium Free with account Reading every followed author on demand is collapsing the database. Publish post events and materialize timelines asynchronously.
- Handle Celebrity Fan-out Hard Free with account One celebrity post creates millions of writes. Combine pushed timelines for ordinary authors with a pulled celebrity index at read time.