Shulou(Shulou.com)06/01 Report--

MariaDB-Mariabackup Hot backup tool

Since MariaDB10.2.7 (included) and above, online physical hot backup using Percona XtraBackup tool is no longer supported.

MariaDB 10.1 introduces features unique to MariaDB, such as InnoDB page compression and data at rest encryption. These exclusive features are very popular among MariaDB users. "however, existing backup solutions from the MySQL ecosystem, such as Percona XtraBackup, do not support full backup capabilities for these features."

In order to meet the needs of users, MariaDB officially decided to develop a backup solution that fully supports the unique features of MariaDB. It rewrites the extension based on Percona XtraBackup version 2.3.8.

Use of the mariabackup tool (included in the binary tar package bin directory)

1. Backup

Shell > mariabackup-defaults-file=/etc/my.cnf-S / tmp/mysql3306.sock-backup-target-dir=/data/bak/-user=root-password=123456

2. Restore incremental data during backup (this step is similar to innobackupex-apply-log)

Shell > mariabackup-- prepare-- target-dir=/data/bak/

Note: / data/bak/xtrabackup_binlog_pos_innodb file, record the POS point of the main library show master status.

3. Restore

Steps

1. Close the mysqld process

Make sure the datadir directory is empty. You can change the name of the original directory and create a new one.

3. Restore

Shell > mariabackup-defaults-file=/etc/my.cnf-copy-back-target-dir=/data/bak/

4. Change directory properties

Shell > chown-R mysql:mysql / var/lib/mysql/

If you want to back up on the slave library and want to record the POS point of the show slave status of the slave library, so that you can pick up another slave library later

Then you can do it like this:

Shell > mariabackup-defaults-file=/etc/my.cnf-S / tmp/mysql3306.sock-backup-slave-info-safe-slave-backup-target-dir=/data/bak/-user=root-password=123456

Note: / data/bak/xtrabackup_slave_info file, record the POS point of show slave status from the library.

Reference: https://mariadb.com/kb/en/library/mariabackup/

# decompression of xbstream streams

/ usr/local/mariadb/bin/mbstream-x-C. / <. / backup.xbstream

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.