Mariabackup

mariabackup is a fork of Percona XtraBackup with added support for MariaDB 10.1 compression and data-at-rest encryption. It is included as alpha version with MariaDB 10.1.23 (May 2017) and later.

Support full or incremental backups https://mariadb.com/kb/en/incremental-backup-and-restore-with-mariabackup/

Support for online backups of InnoDB, Aria and MyISAM tables.

apt install mariadb-backup
mariabackup --help

Examples

Full:

mariabackup --backup \
  --target-dir=/var/mariadb/backup/ \
  --user=mariabackup --password=mypassword

Incremental

mariabackup --backup \
  --target-dir=/var/mariadb/inc1/ \
  --incremental-basedir=/var/mariadb/backup/ \
  --user=mariabackup --password=mypassword

parallel=#

--prepare

Related terms

• mysqldump
• show databases
• SST
• brew install mariadb
• MariaDB binary log: mysqlbinlog
• --delete-master-logs

Activities

• Read announcement, May 2017: https://mariadb.com/resources/blog/mariadb-backup-released-with-mariadb-server-10-1-23/

See also

• mariabackup, mariabackup --help, mysqlbinlog, MariaDB binary log, max_binlog_size, PITR
• Database backups: mariabackup, mysqldump, mongodump, mariabackup, pg_dump
• Backups: Data corruption, Business continuity planning, Bacula, Commvault, NetBackup, Veeam, Storage Lifecycle Policy (SLP), TeamCity backup, Backup docker containers, HP Data Protector, Unitrends, Acronis, Veeam Backup & Replication, Disaster Recovery (DR), Point-in-time recovery, RTO, RPO, PITR

https://mariadb.com/kb/en/mariabackup-overview/

https://mariadb.com/kb/en/mariadb-10123-release-notes/