Difference between revisions of "Mariabackup"
Jump to navigation
Jump to search
↑ https://mariadb.com/kb/en/mariabackup-overview/
↑ https://mariadb.com/kb/en/mariadb-10123-release-notes/
Tags: Mobile web edit, Mobile edit |
|||
| (14 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{lc}} | |
| + | <code>mariabackup</code><ref>https://mariadb.com/kb/en/mariabackup-overview/</ref> 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]]<ref>https://mariadb.com/kb/en/mariadb-10123-release-notes/</ref> (May 2017) and later. | ||
Support full or [[incremental backups]] | Support full or [[incremental backups]] | ||
| Line 6: | Line 7: | ||
Support for online backups of [[InnoDB]], [[Aria]] and [[MyISAM]] tables. | Support for online backups of [[InnoDB]], [[Aria]] and [[MyISAM]] tables. | ||
| + | [[apt install mariadb-backup]] | ||
| + | [[mariabackup --help]] | ||
| + | |||
| + | == Examples == | ||
Full: | Full: | ||
mariabackup --backup \ | mariabackup --backup \ | ||
| Line 11: | Line 16: | ||
--user=mariabackup --password=mypassword | --user=mariabackup --password=mypassword | ||
| − | Incremental | + | [[Incremental]] |
mariabackup --backup \ | mariabackup --backup \ | ||
--target-dir=/var/mariadb/inc1/ \ | --target-dir=/var/mariadb/inc1/ \ | ||
| Line 27: | Line 32: | ||
* <code>[[mysqldump]]</code> | * <code>[[mysqldump]]</code> | ||
* <code>[[show databases]]</code> | * <code>[[show databases]]</code> | ||
| + | * [[SST]] | ||
| + | * <code>[[brew install mariadb]]</code> | ||
| + | * [[MariaDB binary log]]: <code>[[mysqlbinlog]]</code> | ||
| + | * [[--delete-master-logs]] | ||
== Activities == | == Activities == | ||
| − | * Read announcement: https://mariadb.com/resources/blog/mariadb-backup-released-with-mariadb-server-10-1-23/ | + | * Read announcement, May 2017: https://mariadb.com/resources/blog/mariadb-backup-released-with-mariadb-server-10-1-23/ |
| − | ==See also== | + | == See also == |
| − | *{{ | + | * {{mariabackup}} |
| + | * {{DB backup}} | ||
* {{Backups}} | * {{Backups}} | ||
| − | |||
[[Category:MariaDB]] | [[Category:MariaDB]] | ||
Latest revision as of 12:55, 19 February 2023
mariabackup[1] 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[2] (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
Contents
Examples[edit]
Full:
mariabackup --backup \ --target-dir=/var/mariadb/backup/ \ --user=mariabackup --password=mypassword
mariabackup --backup \ --target-dir=/var/mariadb/inc1/ \ --incremental-basedir=/var/mariadb/backup/ \ --user=mariabackup --password=mypassword
parallel=#
--prepare
Related terms[edit]
mysqldumpshow databases- SST
brew install mariadb- MariaDB binary log:
mysqlbinlog - --delete-master-logs
Activities[edit]
- Read announcement, May 2017: https://mariadb.com/resources/blog/mariadb-backup-released-with-mariadb-server-10-1-23/
See also[edit]
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
Advertising:
