Nightly restore drill · 02:23 UTC

Reading the log…

A backup only counts once it has been restored. Every night a fresh MariaDB is launched, last night's encrypted backup is brought back into it and every table is checked against the fingerprint taken at backup time. Only then does the next backup go out.

Restore time · RTO
-
Backup interval · RPO
24 h
Drills passed in a row
-
Backups aboard
-
Rows protected
-
Log · 01

Last night, step by step

    Voyage history

      Log · 02

      Backups aboard

      GitHub Release "backups", AES-256-GCM. The manifests are public on purpose.

      BackupTakenSizeRowsSHA-256Kept as

      Retention: the newest of each of the last 7 days, 4 weeks and 6 months. The drill deletes the rest.

      Drill · 03

      Man overboard

      A real SQLite shop runs in your browser. Take a backup, sink the data, then run the same drill as the nightly job: decrypt, restore into an empty database, verify every table.

      Database shop

      loading

      Latest orders

      #customerstatusCHF

      Cause a disaster

      Backups

      • No backup yet. Take one first.

      Drill log

      Waiting for you…