Databases

Backup & Recovery

Dumps, restores, replication lag and disaster recovery.

2 articles

bench backup Is Not a Backup Strategy: Binlogs and Point-in-Time Recovery for ERPNext

A nightly dump means losing a full day of invoices. Set up mariadb-backup plus binary logs, then walk a real recovery: finding the binlog position of a bad bulk cancel and replaying up to the second before it.

July 6, 2026Read

Databases6 min read

MySQL Replication Lag: Why Seconds_Behind_Master Can Read Zero and Lie

Seconds_Behind_Source measures the relay log, not the primary, so it reads zero while your replica is minutes behind and NULL when it is broken. Here is how to see real lag.

April 9, 2026Read