该脚本为Innobackupex全备脚本
Xtrabackup版本:2.4.3
#/bin/bash
#set variables
conf=/XXX/my.cnf #my.cnf的路径
user=
password=
socket=
backupdir=
name=fullback_`date +"%Y%m%d-%H:%M:%S"`
innobackupexlog=${backupdir}/log/innobackupexlog_`date +"%Y%m%d-%H:%M:%S"`
expire=7 #备份的数据保留的时间
#begin full backup
innobackupex --defaults-file=${conf} \
--user=${user} \
--password=${password} \
--socket=${socket} \
--slave-info \
--no-timestamp ${backupdir}/${name}&>>${innobackupexlog}
backupflag1=`tail -n 10 ${innobackupexlog} | grep "completed OK" | grep -v prints | wc -l`
if [ ${backupflag1} -eq 0 ]
then
echo "==============================================================="
echo "`date +"%Y-%m-%d %H:%M:%S"` backup failed!">> ${innobackupexlog}
echo "==============================================================="
exit 1
elif [ ${backupflag1} -eq 1 ]
then
echo "============================================================" >> ${innobackupexlog}
echo "backup success" >>${innobackupexlog}
echo "============================================================" >> ${innobackupexlog}
#begin recover redolog
echo "============================================================" >> ${innobackupexlog}
echo "`date +"%Y%m%d-%H:%M:%S"` Begin to Recover ..." >> ${innobackupexlog}
echo "============================================================" >> ${innobackupexlog}
innobackupex --defaults-file=${conf} --apply-log ${backupdir}/${name} &>>${innobackupexlog}
backupflag2=`tail -n 10 ${innobackupexlog} | grep "completed OK" | grep -v prints | wc -l`
if [ ${backupflag2} -gt 0 ]
then
echo "===============================================================" >>${innobackupexlog}
echo "`date +"%Y%m%d-%H:%M:%S"` Recover is success!" >>${innobackupexlog}
echo "===============================================================" >>${innobackupexlog}
else
echo "===============================================================" >>${innobackupexlog}
echo "Recover is failed!" >>${innobackupexlog}
echo "===============================================================" >>${innobackupexlog}
exit 1
fi
fi
#clean expired backup
find ${backupdir} -type d -name "fullback*" -mtime +${expire} | xargs /bin/rm -rf
find ${backupdir}/log -type f -name "innobackupexlog*" -mtime +${expire} | xargs /bin/rm -rf
Xtrabackup版本:2.4.3
#/bin/bash
#set variables
conf=/XXX/my.cnf #my.cnf的路径
user=
password=
socket=
backupdir=
name=fullback_`date +"%Y%m%d-%H:%M:%S"`
innobackupexlog=${backupdir}/log/innobackupexlog_`date +"%Y%m%d-%H:%M:%S"`
expire=7 #备份的数据保留的时间
#begin full backup
innobackupex --defaults-file=${conf} \
--user=${user} \
--password=${password} \
--socket=${socket} \
--slave-info \
--no-timestamp ${backupdir}/${name}&>>${innobackupexlog}
backupflag1=`tail -n 10 ${innobackupexlog} | grep "completed OK" | grep -v prints | wc -l`
if [ ${backupflag1} -eq 0 ]
then
echo "==============================================================="
echo "`date +"%Y-%m-%d %H:%M:%S"` backup failed!">> ${innobackupexlog}
echo "==============================================================="
exit 1
elif [ ${backupflag1} -eq 1 ]
then
echo "============================================================" >> ${innobackupexlog}
echo "backup success" >>${innobackupexlog}
echo "============================================================" >> ${innobackupexlog}
#begin recover redolog
echo "============================================================" >> ${innobackupexlog}
echo "`date +"%Y%m%d-%H:%M:%S"` Begin to Recover ..." >> ${innobackupexlog}
echo "============================================================" >> ${innobackupexlog}
innobackupex --defaults-file=${conf} --apply-log ${backupdir}/${name} &>>${innobackupexlog}
backupflag2=`tail -n 10 ${innobackupexlog} | grep "completed OK" | grep -v prints | wc -l`
if [ ${backupflag2} -gt 0 ]
then
echo "===============================================================" >>${innobackupexlog}
echo "`date +"%Y%m%d-%H:%M:%S"` Recover is success!" >>${innobackupexlog}
echo "===============================================================" >>${innobackupexlog}
else
echo "===============================================================" >>${innobackupexlog}
echo "Recover is failed!" >>${innobackupexlog}
echo "===============================================================" >>${innobackupexlog}
exit 1
fi
fi
#clean expired backup
find ${backupdir} -type d -name "fullback*" -mtime +${expire} | xargs /bin/rm -rf
find ${backupdir}/log -type f -name "innobackupexlog*" -mtime +${expire} | xargs /bin/rm -rf
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31003153/viewspace-2108736/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31003153/viewspace-2108736/