Level 8 of 13 · about 2 weeks
Recovery and durability
The kinds of failure a database has to survive, the write-ahead log that makes crash recovery possible, checkpoints that bound how far back recovery looks, the ARIES algorithm in outline, backups and point-in-time recovery, and keeping a remote standby ready to take over.
Modules
Core: everyone needs it. Common: most jobs use it. Specialist: optional depth, safe to skip on a first read.
1
Failure classification
three different ways a database can fail, each demanding a different kind of recovery
Common 5 parts · about 2 hours
2
The write-ahead log
redo and undo, and why the log being durable first is what makes crash recovery possible at all
Core 5 parts · about 2 hours
3
Buffer management and checkpoints
bounding how far back recovery ever needs to look, instead of replaying the whole log every time
Common 5 parts · about 2 hours
4
ARIES in outline
how a real, widely used recovery algorithm organizes redo and undo into three clean phases
Specialist 5 parts · about 2 hours
5
Backups and point-in-time recovery
the separate, offline safety net a damaged disk or a human mistake actually requires
Core 5 parts · about 2 hours
6
High availability with a remote backup
keeping a live, ready standby, and what it costs to keep that standby actually in sync
Common 5 parts · about 2 hours