Use XtraBackup to back up and restore the MariaDB Database

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

1 2 Next Page