Use XtraBackup to back up and restore the MariaDB Database
Use xtrabackup for backup
Introduction to Xtrabackup
Xtrabackup is a mysql database backup tool provided by percona. According to the official introduction, Xtrabackup is the only open-source tool in the world that can perform hot backup for innodb and xtradb databases. Features:
(1) The backup process is fast and reliable;
(2) The backup process will not interrupt ongoing transactions;
(3) Saving disk space and traffic based on compression and other functions;
(4) automatic backup check;
(5) Fast Restoration;
Official introduction and https://www.percona.com/software/percona-xtrabackup
Install xtrabackup
The official system has rpm package version of the software, you can download the rpm package version of the software for direct installation, because xtrabackup is written using perl scripts, so you need to install perl-DBD-MySQL or else report dependencies.
[Root @ MariaDB ~] # Yum-y install perl-DBD-MySQL
[Root @ MariaDB ~] # Rpm-ivh percona-xtrabackup-2.2.3-4982.el6.x86_64.rpm
Innobackupex: client tool that connects to mysqld using mysql protocol. offline backup is not supported, but offline recovery is supported.
-------------------------------------- Split line --------------------------------------
Install LAMP (Apache with MariaDB and PHP) in CentOS/RHEL/Scientific Linux 6)
Implementation of MariaDB Proxy read/write splitting
How to compile and install the MariaDB database in Linux
Install MariaDB database using yum in CentOS
Install MariaDB and MySQL
MySQL management-using XtraBackup for Hot Backup
MySQL open-source backup tool Xtrabackup backup deployment
MySQL Xtrabackup backup and recovery
Use XtraBackup to implement MySQL master-slave replication and quick deployment [master-slave table lock-free]
Install and use Xtrabackup from Percona to back up MySQL
Install MariaDB on the Ubuntu 14.04 (Trusty) Server