backups

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.