#!/usr/bin/bash

# @author Jane.Hoo

# @written at://

# @GRANT SELECT, RELOAD, SUPER, LOCK TABLES, SHOW VIEW, EVENT ON *.* TO 'backupuser'@'localhost' IDENTIFIED BY 'xxxxxxxxx'

#

MY_DAY=`date +%A`

MY_TIMESTAMP=`date +%Y%m%d`

MY_DATABASEDIR=/mysql/databackup/

BACKUPWORKSPACE=$MY_DATABASEDIR'BACKUPSPACE'$MY_TIMESTAMP

DUMPFILE=''

USER=backupuser

PASSWORD=backuP_#

MYSQL_CONFIG=/etc/my.cnf

PARALLEL=

DATABASES='"zabbix mysql test"'

TOOL='/usr/local/xtrabackup/bin/innobackupex'

LOGFILE=$MY_DATABASEDIR'LOG'$MY_TIMESTAMP

LSN=

LSN_PATH=$MY_DATABASEDIR'LSN-RECORD.TXT'

echo "">$LOGFILE

if [ ! -d $BACKUPWORKSPACE ];then

    mkdir -p $BACKUPWORKSPACE

else

    echo $BACKUPWORKSPACE" is exits. program exit"|tee -a $LOGFILE

    exit

fi

if [ $MY_DAY = 'Monday' ];then

    echo "today is monday,ALL BACKUP "|tee -a $LOGFILE

    command="$TOOL --defaults-file=$MYSQL_CONFIG --user=$USER --password=$PASSWORD  --parallel=$PARALLEL   --databases=$DATABASES  --no-timestamp  $BACKUPWORKSPACE 2>>$LOGFILE"

    eval $command

    cd $BACKUPWORKSPACE

    LSN=`cat xtrabackup_info |grep innodb_to_lsn|head -n |awk -F ' = ' '{print $2}'`

    echo $LSN>$LSN_PATH

    DUMPFILE='ALL_DUMPFILE'$MY_TIMESTAMP'.tar.gz'

    cd $MY_DATABASEDIR

    tar -zcvf $DUMPFILE 'BACKUPSPACE'$MY_TIMESTAMP >> $LOGFILE

    if [ $? -ne  ];then

            echo "compress fail!."|tee -a $LOGFILE

            exit

    else

            echo "compress ok."|tee -a $LOGFILE

    fi

    rm -rf $BACKUPWORKSPACE

    if [ $? -ne  ];then

                echo "remove workspace fail!."|tee -a $LOGFILE

                exit

        else

                echo "dump compeletly ok."|tee -a $LOGFILE

        fi

else

    echo "today is "$MY_DAY"increment backup ">>$LOGFILE

    cd $MY_DATABASEDIR

    LSN=`cat LSN-RECORD.TXT |head -n `

    command="$TOOL --defaults-file=$MYSQL_CONFIG --user=$USER --password=$PASSWORD  --parallel=$PARALLEL   --databases=$DATABASES  --incremental-lsn=$LSN --incremental --no-timestamp  $BACKUPWORKSPACE 2>>$LOGFILE"

    eval $command

    cd $BACKUPWORKSPACE

    LSN=`cat xtrabackup_info |grep innodb_to_lsn|head -n |awk -F ' = ' '{print $2}'`

    echo $LSN>$LSN_PATH

    DUMPFILE='ICR_DUMPFILE'$MY_TIMESTAMP'.tar.gz'

        cd $MY_DATABASEDIR

        tar -zcvf $DUMPFILE 'BACKUPSPACE'$MY_TIMESTAMP >> $LOGFILE

        if [ $? -ne  ];then

                echo "compress fail!."|tee -a $LOGFILE

                exit

        else

                echo "compress ok."|tee -a $LOGFILE

        fi

        rm -rf $BACKUPWORKSPACE

        if [ $? -ne  ];then

                echo "remove workspace fail!."|tee -a $LOGFILE

                exit

        else

                echo "dump compeletly ok."|tee -a $LOGFILE

        fi

fi

find $MY_DATABASEDIR -name "*.tar.gz" -type f -mtime + -exec rm {} \;>>$LOGFILE >&

find $MY_DATABASEDIR -name "LOG*" -type f -mtime + -exec rm {} \;>>$LOGFILE >&

作者：jane.hoo

出处：jane.hoo的博客 http://www.cnblogs.com/janehoo/

[人生不设限,生命不息，折腾不止]

您的支持是对博主最大的鼓励，感谢您的认真阅读。本文版权归作者所有，欢迎转载，但请保留该声明。