xtrabackup 远程流备份脚本

1、xbstream 流，本地文件夹可以自己创建，异地文件夹必须存在

 innobackupex --host=127.0.0.1  --post=3306 --stream=xbstream  --compress /root/backup/ | ssh root@192.168.56.15 "xbstream -x -C /tmp/"

2、xbstream 流，对端机器需要解压并清理压缩文件

192.168.56.15xtrabackup --decompress --target-dir=/tmp/find /tmp/ -name "*.qp" |xargs  rm -f

3、xbstream 流对端需要安装软件

3.1 xtrabackup

3.2 qpress-11-linux-x64.tar

4、脚本，周一全备，其它都是增备

[root@es1 chkpoint]# cat backup.sh#!/bin/bashLOCALDIR=/data/backupCHECKPIONTDIR=$LOCALDIR/chkpointREMOTEDIR=/tmp/WEEKDAY=`date +%u`INTERVARNUM=`expr $WEEKDAY - 1`TISHWEEKFULL=`date -d "$INTERVARNUM day ago" +%F`TODAY=`date +%F`ssh root@192.168.56.19 "mkdir -p /$REMOTEDIR/$TISHWEEKFULL"ssh root@192.168.56.19 "mkdir -p /$REMOTEDIR/$TISHWEEKFULL/$TODAY"if [ ! -f $CHECKPIONTDIR/xtrabackup_checkpoints ] ;thenecho "没有lsn信息，开始一次全备"innobackupex --host=127.0.0.1 --history  --post=3306 --stream=xbstream   --compress --extra-lsndir=$CHECKPIONTDIR  $LOCALDIR |ssh root@192.168.56.19 "xbstream -x -C /$REMOTEDIR/$TISHWEEKFULL/"exit 1ficase $WEEKDAY in#判断变量WEEKDAY的值    "1")    innobackupex --host=127.0.0.1 --history  --post=3306 --stream=xbstream   --compress --extra-lsndir=$CHECKPIONTDIR  $LOCALDIR |ssh root@192.168.56.19 "xbstream -x -C /$REMOTEDIR/$TISHWEEKFULL/"        ;;    "2")       innobackupex --host=127.0.0.1  --post=3306 --stream=xbstream  --history     --incremental --extra-lsndir=$CHECKPIONTDIR  --incremental-basedir=$CHECKPIONTDIR   --compress $LOCALDIR | ssh root@192.168.56.19 "xbstream -x -C /$REMOTEDIR/$TISHWEEKFULL/$TODAY"        ;;        "3")       innobackupex --host=127.0.0.1  --post=3306 --stream=xbstream  --history     --incremental --extra-lsndir=$CHECKPIONTDIR  --incremental-basedir=$CHECKPIONTDIR   --compress $LOCALDIR | ssh root@192.168.56.19 "xbstream -x -C /$REMOTEDIR/$TISHWEEKFULL/$TODAY"        ;;    "4")       innobackupex --host=127.0.0.1  --post=3306 --stream=xbstream  --history     --incremental --extra-lsndir=$CHECKPIONTDIR  --incremental-basedir=$CHECKPIONTDIR   --compress $LOCALDIR | ssh root@192.168.56.19 "xbstream -x -C /$REMOTEDIR/$TISHWEEKFULL/$TODAY"        ;;        "5")       innobackupex --host=127.0.0.1  --post=3306 --stream=xbstream  --history     --incremental --extra-lsndir=$CHECKPIONTDIR  --incremental-basedir=$CHECKPIONTDIR   --compress $LOCALDIR | ssh root@192.168.56.19 "xbstream -x -C /$REMOTEDIR/$TISHWEEKFULL/$TODAY"        ;;        "3")       innobackupex --host=127.0.0.1  --post=3306 --stream=xbstream  --history     --incremental --extra-lsndir=$CHECKPIONTDIR  --incremental-basedir=$CHECKPIONTDIR   --compress $LOCALDIR | ssh root@192.168.56.19 "xbstream -x -C /$REMOTEDIR/$TISHWEEKFULL/$TODAY"        ;;    "4")       innobackupex --host=127.0.0.1  --post=3306 --stream=xbstream  --history     --incremental --extra-lsndir=$CHECKPIONTDIR  --incremental-basedir=$CHECKPIONTDIR   --compress $LOCALDIR | ssh root@192.168.56.19 "xbstream -x -C /$REMOTEDIR/$TISHWEEKFULL/$TODAY"        ;;esac

5、tar 目前不支持增备，压缩解压需要注意，需要tar -xizvf *.tar.gz