前提：源端空间不够，可以只把备份文件发送到目标端
脚本1.远程压缩备份：
xtrabackup –defaults-file=/etc/my.cnf \
–user=root –password=xxxx \
–backup –stream=xbstream –slave-info –parallel=8 –compress –compress-threads=8 2> /root/xtrabackup-error.log| \
ssh root@10.1.4.160 ‘cat – > /var/lib/mysql/data/full.xbstream’
脚本2.使用PV限速 远程压缩备份：
xtrabackup –defaults-file=/etc/my.cnf \
–user=root –password=xxxx \
–backup –stream=xbstream –slave-info –parallel=8 –compress –compress-threads=8 | \
pv -q -L80m | ssh root@10.1.4.160 ‘cat – > /var/lib/mysql/data/full.xbstream’
PV安装链接：http://www.ivarch.com/programs/pv.shtml
脚本3.远程备份+解压缩
xtrabackup –defaults-file=/etc/my.cnf \
–user=root –password=xxxx \
–backup –stream=xbstream –slave-info –parallel=8 2> /root/xtrabackup-error.log| \
pv -q -L80m | ssh root@10.1.4.160 ‘cat | xbstream -p10 -x -C /var/lib/mysql/data/’
