Shell-Check MySQL Backup Status

# ########################################################################
# Purpose:Check MySQL Backup  status
# Authors:Kin Zhang
# Version:v1.0
# Date:2013-02-18
# ########################################################################

bak_dir=/mysqlbak/
log=`find ${bak_dir} -name xtrabk.log`
chklog=/tmp/kin.log
today=`date +%y%m%d`
bak_time=`date +%H`

function fetch_result()
{
> ${chklog}
for i in ${log}
do
host=`echo ${i}|cut -d '/' -f3`
record=`grep "innobackupex-1.5.1\: completed OK\!" ${i}|tail -n 1|awk '{print $1,$4}'`
echo "${host} ${record}" >> ${chklog}
done
}

function check_logic()
{
bakdate=`cat ${chklog} |awk '{print $2}'`

for x in ${bakdate}
do
if [ ${x} -lt ${today} ];then
str=`grep ${x} ${chklog}`
echo "Critical:please check your ${str}" && exit 2
fi
done
echo "OK:mysql backup is OK!" && exit 0
}

function check_bakfile()
{
if [ ${bak_time} -ge 6 ]; then
check_logic;
fi
}
fetch_result
check_bakfile