Mysql-xtrabackup 备份和恢复

下载xtrabackup工具：

wget https://www.percona.com/redir/downloads/percona-release/redhat/latest/percona-release-0.1-4.noarch.rpm
yum list |grep percona-xt
rpm -ivh percona-release-0.1-4.noarch.rpm
yum list |grep percona-xt
yum install percona-xtrabackup-24 -y

 

innobackupex --defaults-file=/etc/my.cnf --user=pxb --password=123456 --socket=/tmp/mysql.sock /data/pxb

xtrabackup，数据备份（全，增量备份，和恢复）
https://www.cnblogs.com/waynechou/p/xtrabackup_backup.html