yum來源 安裝xtrabackup
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm Retrieving http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm Preparing... ########################################### [100%] 1:percona-release ########################################### [100%]
列出是否有安裝
yum list | grep percona
安裝
yum install percona-xtrabackup-22
tar包安裝方式
yum -y install perl perl-devel libaio libaio-devel yum -y install perl-DBI perl-DBD-MySQL perl-TermReadKey perl-devel perl-Time-HiRes cd /usr/local/src wget -c https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.3.2/ \ binary/tarball/percona-xtrabackup-2.3.2-Linux-x86_64.tar.gz tar -zxf percona-xtrabackup-2.3.2-Linux-x86_64.tar.gz cd percona-xtrabackup-2.3.2-Linux-x86_64/ mkdir /usr/local/xtrabackup mv bin /usr/local/xtrabackup/ ln -s /usr/local/xtrabackup/bin/* /usr/bin/
xtrabackup指令
#備份
innobackupex --user=root --password=xxxx --port=3306 /root/backup/
還原
innobackupex --user=root --copy-back /root/backup/2017-01-11_01-02-51/