#!/bin/bash

#日期转为天数

function date2days {

    echo "$*" | awk '{

        z=int((-$)/); y=$+-z; m=$+*z-;

        j=int((*m+)/)+$+y*+int(y/)-int(y/)+int(y/)-;

        print j

    }'

}

#说明：脚本执行策略为每天执行一次，执行前需要先建立config文件，并在config文件

#中添加

#backup_full=

#backup_pre_name=

#即可，注意路径。

#备份策略，每七天一个循环，第一天为全备份，第二天至第六天为增量备份。

#后续会增加已备份文件压缩转移定期删除部分 

#######################

db_user="xtrabackup"

db_passwd="mysQlbackup"

db_defaults_file="/home/backup/config/3306.cnf"

db_socket="/var/lib/mysql/mysql_3306.sock"

db_backup="/home/backup/"

db_backup_fulldir="/home/backup/full/"

db_backup_incrementaldir="/home/backup/incremental/"

db_backup_gzfull="/home/backup/gzip/"

db_backup_tarfull="/home/backup/tar.gzdb/"

rm_num=

#用于压缩并转移源文件

move_and_tar (){

if [ $# !=  ]; then

        echo "参数不正确"

        exit

fi

time_rm=`date -d "$1 days ago" +"back_%d-%m-%Y"`

if [ $ -eq  ]; then

        if [ -d ${db_backup_fulldir}${time_rm} ]; then

                su - root -c  "tar -czPvf ${db_backup_tarfull}${time_rm}_full.tar.gz ${db_backup_fulldir}${time_rm}"

                su - root -c  "rm -rf ${db_backup_fulldir}${time_rm}"

                echo "压缩目录rm $db_backup_fulldir${time_rm}" >>/home/backup/config/tar.log

        fi

fi

if [ $ -gt  -a $ -lt  ]; then

        if [ -d $db_backup_incrementaldir${time_rm} ]; then

                su - root -c  "tar -czPvf ${db_backup_tarfull}${time_rm}_increment.tar.gz ${db_backup_incrementaldir}${time_rm}"

                su - root -c  "rm -rf ${db_backup_incrementaldir}${time_rm}"

                echo "压缩目录rm $db_backup_incrementaldir${time_rm}" >>/home/backup/config/tar.log

        fi

fi

}

#得到当前时间和配置文件

time="$(date +"back_%d-%m-%Y")"

source /home/backup/config/config

#计算今天到上次全备份相隔天数

_Day=$(date2days `echo ${backup_full::}|awk 'BEGIN{FS="-"}{print $3,$2,$1}'`)

Day=$(date2days `date +"%Y %m %d"`)

echo $_Day

echo $Day

let result=$Day-$_Day

echo "相差$result天"

if [ -z ${backup_full} ] || [ $result -ge   ] ; then

#todo

echo '全备份'

backup_full=${time}

innobackupex --defaults-file=$db_defaults_file --no-timestamp --user=${db_user} --password=${db_passwd} --no-lock  --socket=$db_socket ${db_backup_fulldir}${backup_full}/

if [ $? -eq  ]; then

        echo "${time} 备份成功!!!" >> /home/backup/config/results.log

    else

        echo "${time} 备份失败???" >> /home/backup/config/results.log

    fi

#更新配置文件

echo "backup_full=${backup_full}" >/home/backup/config/config

echo "backup_pre_name=full/${backup_full}" >>/home/backup/config/config

#自动删除两周以前的备份文件

while [ ${rm_num} -lt  -a ${rm_num} -gt  ]

do

move_and_tar ${rm_num}

rm_num=`expr ${rm_num} - `

done

echo '全备份'

else

#todo

echo '增量备份'

innobackupex  --defaults-file=$db_defaults_file --socket=$db_socket --no-timestamp --user=${db_user} --password=${db_passwd} --no-lock  --incremental ${db_backup_incrementaldir}${time}/ --incremental-basedir=${db_backup}${backup_pre_name}

if [ $? -eq  ]; then

                echo "${time} 增量备份成功!!!" >> /home/backup/config/results.log

        else

                echo "${time} 增量备份失败???" >> /home/backup/config/results.log

        fi

#更新配置文件

echo "backup_full=${backup_full}" >/home/backup/config/config

echo "backup_pre_name=incremental/${time}" >>/home/backup/config/config

echo '增量备份'

fi