backups

The article discusses the importance of backups, sharing a personal story of data loss and explaining technical concepts like Recovery Point Objective (RPO) to emphasize backup strategies.

PlanetScale describes how it performs massively parallel backups for sharded Postgres databases by spinning up per-shard EC2 instances, restoring prior backups from object storage, and replaying WAL, achieving petabyte-scale backup speeds over 50 GB/s.

The author recounts the failure of their Raspberry Pi home server's SD card and their process of rebuilding with a focus on minimizing writes and improving redundancy using NixOS, zram, and external backups.

ClickHouse Cloud announces WAL-RUS, an open-source Rust rewrite of WAL-G for PostgreSQL backups, focusing on predictable memory usage and WAL-G compatibility.