MariaDB Backup

You are viewing an old version of this article. View the current version here.

About MariaDB Backup

MariaDB Backup is the open source tool provided by MariaDB for performing physical online backups of InnoDB, Aria and MyISAM tables. For InnoDB, “hot online” backups are possible. MariaDB Backup is provided as part of MariaDB Server starting with MariaDB Server 10.1.23. The tool is available on Linux and Windows.

MariaDB Backup as part of MariaDB 10.1.23 is of Alpha maturity.

MariaDB Server 10.1 introduced MariaDB Compression and Data-at-Rest Encryption. For both we have seen high interest from the users of MariaDB Server. However, existing backup solution from our ecosystem like XtraBackup and others did not support full backup capability for these features.

To address our customers and community users concerns, we decided to provide a backup solution that would support full backup capability for MariaDB Server that include encrypted and compressed data. The most obvious way to do this was to create a solution based on the well known and used backup tool Percona XtraBackup. We extended it and named our solution MariaDB Backup.

MariaDB Backup Releases

You will not find MariaDB Backup as a separate downloadable product at this time. MariaDB Backup will be provided as a separate package included in new releases of MariaDB Server 10.1, and in the near future also with MariaDB Server 10.2. MariaDB Backup is tightly connected to XtraDB/InnoDB, and maintaining MariaDB Backup as part of the Server enables us to test it against changes in the Server and storage engines.

Using MariaDB Backup

MariaDB Backup is currently based on XtraBackup 2.3.8 and therefore provides the same functionality XtraBackup offers, plus

  • Backup/Restore of Data-at-Rest encrypted XtraDB/InnoDB tables
  • Backup/Restore when XtraDB/InnoDB Compression is used
  • Backup/Restore of Data-at-Rest encrypted Aria tables
  • Using MariaDB Backup for a SST with Galera Cluster, when Data-at-Rest encryption is used
  • Support of Microsoft Windows

Limitations compared to XtraBackup

  • Support of MySQL Data-at-Rest Encryption
  • Backup tool based encryption (gcrypt) is not supported
  • No symlink to innobackupex - use the parameter “--innobackupex” instead

The command to use MariaDB Backup is

mariabackup <params>

To use MariaDB Backup for Galera Cluster SST, the script wsrep_sst_mariabackup.sh is provided and the Galera configuration setting is used:

wsrep_sst_method = mariabackup-sst

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.