xtrabackup 增量备份mysql

#!/bin/sh
inc_back_num=7  # 备份次数周期
BEGINTIME=`date +"%Y-%m-%d %H:%M:%S"`
format_time=`date +"%Y-%m-%d_%H:%M:%S"`
week=`date +%w`
#MySQL数据库端口号
port=3306
#ip地址
ip=localhost
#备份文件存放的路径
basedir=/home/backup
backdir=${basedir}/xbstream_tables
#历史备份路径
backdir_bak=${basedir}/xbstream_tables_bak
#mysql配置文件
file_cnf=/etc/my.cnf
#mysql用户名
user_name=root
#mysql密码
password=Xmlgrg163
#xtrabackup备份日志文件名
out_log=${backdir}/xbstream_log_${format_time}
#备份过程文本名
time_cost=${backdir}/xbstream_time.txt
#备份指定数据库,多个空格隔开，如-–databases="dbname1 dbname2" ，不加备份所有库
#列表中的每个值是以空格区分的，可以用双引号包含空格或单引号的值
DBname_all="tdatabak tdata"

#判断$backdir是否存在 最后一天 备份的文件夹 rec[${inc_back_num} - 2]
if [ -d "${backdir}/rec$[${inc_back_num}-2]" ];then
      rm -rf ${backdir_bak}     
      mv ${backdir}  ${backdir_bak}
      mkdir ${backdir}
fi

#prapare xtrabackup-xbstream
if [ ! -d "${basedir}" ]; then
   mkdir ${basedir}
fi

if [ ! -d "${basedir}/inc-log" ]; then
   mkdir ${basedir}/inc-log
fi

if [ ! -d "${basedir}/inc-log/${format_time}" ]; then
   mkdir ${basedir}/inc-log/${format_time}
fi

if [ ! -d "${basedir}/lsndir" ]; then
   mkdir ${basedir}/lsndir
fi


if [ ! -d "$backdir" ]; then
   mkdir $backdir
fi
#start xtrabackup
#full
if [ ! -d "${backdir}/full" ];then
       mkdir ${backdir}/full

       echo "#####start full backup at ${BEGINTIME} to directory full" >>${time_cost}
       innobackupex --no-timestamp --user=${user_name} --password=${password} --databases="${DBname_all}" --host=${ip} --port=${port} --stream=xbstream --compress --extra-lsndir=${backdir}/full ${backdir}/full 1> ${out_log} 2>&1 >${backdir}/full/full.xbstream
     find_content=$(find ${out_log}|xargs grep -ri ' completed OK!' -l)
     if [ "${find_content}" = "" ];then
        echo "full backup is fail" >>${time_cost}
              rm -rf ${backdir}/*
              # 可配合一个 报警的 命令

              echo "remove fail backup files">>${time_cost}
     else
        echo "full backup is success,start remove history backup." >>${time_cost}
          # 如果全备成功了，就清除上一次 备份的目录，节省服务器空间
        rm -rf ${backdir_bak}
        echo "completed remove history backup." >>${time_cost}
     fi

elif [ ! -d "${backdir}/rec0" ];then
      mkdir ${backdir}/rec0

      echo "#####start 0 incremental backup at ${BEGINTIME} to directory rec0" >>${time_cost}
      innobackupex  --no-timestamp --user=${user_name} --password=${password}  --databases="${DBname_all}" --host=${ip} --port=${port} --stream=xbstream --compress --extra-lsndir=${backdir}/rec0 --incremental --incremental-basedir=${backdir}/full ${backdir}/rec0 1> ${out_log} 2>&1 >${backdir}/rec0/rec0.xbstream
      find_content=$(find ${out_log}|xargs grep -ri ' completed OK!' -l)
    if [ "${find_content}" = "" ];then
        echo "rec0 backup is fail !!!!" >>${time_cost}
              rm -rf ${backdir}/rec0
              echo "remove fail backup files">>${time_cost}
    fi
else
     for ((i=1;i<=$[${inc_back_num}-2];i++))
     do
          if [ ! -d "${backdir}/rec${i}" ]; then
               mkdir ${backdir}/rec${i}

               echo "#####start ${i} incremental backup at ${BEGINTIME} to directory rec${i}" >>${time_cost}
               innobackupex  --no-timestamp --user=${user_name} --password=${password}  --databases="${DBname_all}" --host=${ip} --port=${port} --stream=xbstream --compress --extra-lsndir=${backdir}/rec${i} --incremental --incremental-basedir=${backdir}/rec$[${i}-1] ${backdir}/rec${i} 1> ${out_log} 2>&1 >${backdir}/rec${i}/rec${i}.xbstream
               find_content=$(find ${out_log}|xargs grep -ri ' completed OK!' -l)
             if [ "${find_content}" = "" ];then
              echo "rec${i} backup is fail !!!!" >>${time_cost}
                rm -rf ${backdir}/rec${i}
                echo "remove fail backup files">>${time_cost}             
             fi
               break;
          fi
     done
fi

ENDTIME=`date +"%Y-%m-%d %H:%M:%S"`
begin_data=`date -d "${BEGINTIME}" +%s`
end_data=`date -d "${ENDTIME}" +%s`
spendtime=`expr ${end_data} - ${begin_data}`
echo "it takes ${spendtime} sec for packing the data directory" >>${time_cost}

# 调试可以打开，后边可以注释
tail -f ${time_cost}