---
title: "Database WAL and recovery"
description: "How a write-ahead log lets a database keep an acknowledged change after a crash: what reaches storage first, replaying the log, and checkpoints."
canonical_url: "https://fanout.sh/system/archive/database-wal-and-recovery"
md_url: "https://fanout.sh/system/archive/database-wal-and-recovery.md"
access: "pro-preview"
---

# Database WAL and recovery

How a write-ahead log lets a database keep an acknowledged change after a crash: what reaches storage first, replaying the log, and checkpoints.

- Access: Fanout Pro (public preview)

## The core idea

A database acknowledges a change, then stops before every modified table page reaches storage.

How can the change survive?

## In this lesson

- What has to reach storage first?
- Replay a small log
- Checkpoints bound recovery work
- The setting changes the promise

## Continue reading

Pro unlocks video lessons, visual walkthroughs, full notes, diagrams, case studies, and implementations across the System Design archive.

---
This representation contains public Fanout content only. Protected Pro lessons, account data, billing, checkout, and pricing are not included.

Browse the public content map: https://fanout.sh/sitemap.md
