1.安装依赖包:
yum install cmake gcc gcc-c++ libaio libaio-devel automake autoconf bison libtool ncurses-devel libgcrypt-devel libev-devel libcurl-devel vim-common libevdev-devel -y
2.yum 安装方法:
yum install https://www.percona.com/redir/downloads/percona-release/redhat/latest/percona-release-0.1-6.noarch.rpm –y
安装 percona-xtrabackup
yum install percona-xtrabackup-24 percona-toolkit.noarch –y
3.二进制包安装方法:
下载二进制包:
https://www.percona.com/downloads/XtraBackup/LATEST/
4.备份到远程,前提做好ssh互信:
#非压缩方式:
innobackupex --stream=tar /tmp | ssh root@192.168.56.100 \ "cat - > /backup/bak.tar"
#压缩方式:
innobackupex --stream=tar /tmp | ssh root@192.168.56.100 \ "gzip >/backup/bak.tar.gz"
上一篇:SQL获取字段字符串中文首字母