Page MenuHomeMiraheze

Revise MariaDB backup strategy
Open, NormalPublic


(todo: fill in with more information)

Our current backup strategy is directly copying /srv/mariadb to Bacula. However, that is guaranteed to provide corruption, since no table locks are acquired during the backup. On top of that, retrieving specific databases or tables is a pain.

See, and in particular. While we can't compare our wiki sizes to Wikimedia's, their backups are generated using commonly used tools: mariabackup (which we're already using for creating replicas) and mydumper (alternative for mysqldump).