binglog日志异地上传脚本

#!/bin/bash

BACK_DIR=/usr/local/mysql


#ftp define
ftpuser=xxx
ftppwd=xxx
ftpserver=ftp://xxx.xxx.xxx.xxx
cur_ip=$(/sbin/ifconfig eth0 |grep "inet addr" |cut -d: -f2 |cut -d" " -f1)
bin_dir=$(echo $cur_ip|awk -F . '{print $4}')
ftp_dir=binlog/bak_$bin_dir

#bin-log
BINLOG=$BACK_DIR/binlog


# mysql
MYSQL_DIR=/usr/local/mysql

# mysql  data
DATA_DIR=$MYSQL_DIR/binlog

LOG_DIR=/home/mysql/logs

#md5
#sshuser=root
#sship=192.168.99.98

#log
LOG=$LOG_DIR/binlog.log


backup_binlog(){

        if [ ! -f $LOG_DIR/mysql-bin.index ];then

                head -n -1 $DATA_DIR/mysql-bin.index > $LOG_DIR/mysql-bin.index


        else


                BINSID=`tail -1 $LOG_DIR/mysql-bin.index | sed 's#/usr/local/mysql/binlog/##'`


                newfile=`cat $DATA_DIR/mysql-bin.index | sed -n "/$BINSID/,//p" | sed "/$BINSID/d" | head -n -1 | sed 's#/usr/local/mysql/binlog/##'`


                for i in $newfile
                do
                        cd $DATA_DIR
                        md5sum $i > $LOG_DIR/logmd5/${i}.md5
                        curl -T $DATA_DIR/$i -u $ftpuser:$ftppwd $ftpserver/$ftp_dir/
                        curl -T $LOG_DIR/logmd5/${i}.md5 -u $ftpuser:$ftppwd $ftpserver/$ftp_dir/
                        if [ $? -eq 0 ];then
                                echo `date +'%Y%m%d %H:%M:%S'` ftpsucess $?>>$LOG
                                echo "/usr/local/mysql/binlog/${i}" >> $LOG_DIR/mysql-bin.index
                        else
                                echo `date +'%Y%m%d %H:%M:%S'` ftpfail $?>>$LOG
#                curl ""
                        fi

                done
                failsum=$(tail -6 $LOG |grep ftpfail|wc -l)
                if [ $failsum = 6 ];then
                curl ""
                fi
        fi
}



DTTERM=`pgrep curl`
if [ -n "$DTTERM" ]
then  exit
else
backup_binlog
fi