概述1、增加備份日志輸出 2、增加備份是否有效判斷 3、定期清理過期備份 01備份腳本內(nèi)容存放位置：/home/scripts/mysql_backup.sh #!/bin/bash#this is mysqldump auto full backup script#Copyright by hwb#date 2019-06-04backup_path='/data/backup'user='root'passwd='fswl@1234'dbname='fsl_prod'host='localhost'dbname2='diaocha_db'today=`date +'%Y%m%d-%H%M%S'`sqlname=$dbname$today.sqlsqlname2=$dbname2$today.sqlif [ -e /home/scripts/log_function.sh ]thensource /home/scripts/log_function.shelseecho -e “\033[41;37m /home/scripts/log_function.sh is not exist. \033[0m”exit 1fibackup(){log_correct '開始執(zhí)行備份腳本,刪除14天過期備份'#backupmysqldump -h$host -u$user -p$passwd $dbname >$backup_path/$sqlnamemysqldump -h$host -u$user -p$passwd $dbname >$backup_path/$sqlname2}delete(){#delete expired 14 daysfind /data/backup -mtime +14 -type f -name '*.sql' -exec rm -f {} \;}size(){cd /data/backupdd=`du -sh $sqlname`dd2=`du -sh $sqlname2`if [ -s ./$sqlname ] ; then log_correct 'fsl_prod備份正常' log_correct $ddelse log_error 'fsl_prod備份失敗'fiif [ -s ./$sqlname2 ] ; then log_correct 'diaocha_db備份正常' log_correct $dd2else log_error 'diaocha_db備份失敗'fi}backupdeletesize 02日志腳本存放位置：/home/scripts/log_function.sh #!/bin/bash#log function#Copyright by hwb#date 2019-06-04####log_correct函數(shù)打印正確的輸出到日志文件function log_correct () {DATE=`date +'%Y%m%d-%H%M%S'` ####顯示打印日志的時(shí)間USER=$(whoami) ####那個(gè)用戶在操作echo “${DATE} ${USER} execute $0 [INFO] $@” >>/home/scripts/log_info.log ######（$0腳本本身，$@將參數(shù)作為整體傳輸調(diào)用）}#log_error打印shell腳本中錯(cuò)誤的輸出到日志文件function log_error (){DATE=`date +'%Y%m%d-%H%M%S'`USER=$(whoami)echo “${DATE} ${USER} execute $0 [INFO] $@” >>/home/scripts/log_error.log ######（$0腳本本身，$@將參數(shù)作為整體傳輸調(diào)用）}####fn_log函數(shù) 通過if判斷執(zhí)行命令的操作是否正確，并打印出相應(yīng)的操作輸出function fn_log (){if [ $? -eq 0 ]thenlog_correct “$@ sucessed!”echo -e “\033[32m $@ sucessed. \033[0m”elselog_error “$@ failed!”echo -e “\033[41;37m $@ failed. \033[0m”exitfi}03備份輸出輸出結(jié)果如下： 備份成功： 備份失敗： 到這里就基本滿足需求，也就不繼續(xù)做優(yōu)化了。 腳本其實(shí)是寫邏輯，只要邏輯通了，一般都可以滿足需求，這個(gè)腳本大家也可以繼續(xù)深入優(yōu)化，時(shí)間比較趕，就不繼續(xù)了。 |
|
|
