Overview
Percona XTRABACKUP provides online(hot) backup functionality for InnoDB database and is the 2nd tool, apart from the Oracle mysqlbackup, which offers online(hot) backup for InnoDB.
Installation
Installation of the percona: XtraBackup is done via 3 packages:
[root@mysqlmaster ~]# ls -lart -rw-rw-r-- 1 root root 7704656 Nov 23 04:15 percona-xtrabackup-24-2.4.9-1.el7.x86_64.rpm -rw-rw-r-- 1 root root 37655180 Nov 23 04:15 percona-xtrabackup-24-debuginfo-2.4.9-1.el7.x86_64.rpm -rw-rw-r-- 1 root root 13576972 Nov 23 04:15 percona-xtrabackup-test-24-2.4.9-1.el7.x86_64.rpm [root@mysqlmaster ~]#
Which can be downloaded from: here
These packages require 4 additional packages:
[root@mysqlmaster ~]# rpm -Uvh percona-xtrabackup-* warning: percona-xtrabackup-24-2.4.9-1.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY error: Failed dependencies: libev.so.4()(64bit) is needed by percona-xtrabackup-24-2.4.9-1.el7.x86_64 perl(DBD::mysql) is needed by percona-xtrabackup-24-2.4.9-1.el7.x86_64 perl(Digest::MD5) is needed by percona-xtrabackup-24-2.4.9-1.el7.x86_64 rsync is needed by percona-xtrabackup-24-2.4.9-1.el7.x86_64 [root@mysqlmaster ~]#
All of these packages can be downloaded with installing:
- Percona-Server-shared-compat
Or by simply installing all the packages yourself:
[root@mysqlmaster ~]# yum -y install libev.* rsync perl-DBD-MySQL perl-Digest-MD5