Section

10 pages

Database Operations

Running MySQL and PostgreSQL in production: backups, disaster recovery, disk and replica incidents, and the checks that catch them.

A 10 Gb Database Filled a 200 Gb Disk and Du Could Not Find the Space 0 A Billion Row Versions From One Uncommitted Read Stalled a Mysql Replica 0 A Query on a 3 Billion Row Table Took 100 Minutes: One Added Line Made It 40ms 0 Before the Bad Write 0 Death by a Thousand Cuts: The Ai Database Failure You Can't Restore 0 Postgres and Mysql Dr on Ec2: Aws Automates the Snapshot, Not the Restore 0 Postgres, Kafka, Elasticsearch on Ec2: Keep the Data on Ebs, Not the Instance 0 Self Healing Databases With a Health Check and a Watch Script 0 Testing Your Database, Part 1: Why Ai Made It Mandatory 0 Testing Your Database, Part 2: What to Test, and How 0