CSE Roadmap

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. 1

    Failure classification

    three different ways a database can fail, each demanding a different kind of recovery

    Common 5 parts · about 2 hours

  2. 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. 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. 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. 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. 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