Mariabackup: too rarely used
summary
Mariabackup is a physical backup tool (mariadb-backup) that copies the data directory, requires a separate prepare step to make backups consistent, and supports point‑in‑time recovery when binary logging is enabled using the xtrabackup_binlog_info file and mariadb-binlog. On a 30 GB test set it takes ~180s to backup and ~90s to prepare, with restore ~180s; mysqldump/mariadb-dump took ~230s to dump and ~40 minutes to restore, dumps were 17 GB vs a 29 GB physical copy. Commands: --backup --prepare --copy-back. Feature requests: combine backup+prepare and preserve file ownership. Works with Galera clusters.
AI-written summary · about
chapters (14)
- 0:00Intro
- 0:18About FromDual LLC
- 0:56Table of Contents
- 1:31Why do we need backups?
- 3:21Terminology
- 4:01Types of Backups
- 5:32Restore/Recovery Metrics
- 7:31Granularity of Backups
- 9:12Steps to do a Mariabackup
- 14:12Mariabackup steps
- 14:54Performance differences
- 17:06Point-in-Time-Recovery
- 19:31Where has the time gone?
- 22:35What is left?
related talks
31mHighly Efficient backups with Percona Xtrabackup
39mPhysical Backups with Percona Backup for MongoDB
58mDatabase High Availability
26mCurrent state of MongoDB Backup options
52mPBM - The Backup Open Source Tool for MongoDB
54mPercona XtraBackup Advanced Features
46mLock, Stock and Backup: Data Guaranteed
40mMySQL at Scale: Booking MariaDB to MySQL Migration