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

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

Activities

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

See also

• MariaDB: mariadbcheck, mariabackup, mysqldump, MyRocks, show (MariaDB) MariaDB Changelog, 50-server.cnf, MariaDB engines, .ibd, .myd, .myi, /var/log/mysql/error.log, MariaDB files: .frm, .ibd, /etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries, show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306
• 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/