MYSQL日常管理脚本
发布时间:2020-12-15 07:10:11 所属栏目:安全 来源:网络整理
导读:今天PHP站长网 52php.cn把收集自互联网的代码分享给大家,仅供参考。 #!/bin/env bash############################################################################### NOTE:# The test system is Ubuntu12.04# This S
以下代码由PHP站长网 52php.cn收集自互联网 现在PHP站长网小编把它分享给大家,仅供参考 #!/bin/env bash ############################################################################## # NOTE: # The test system is Ubuntu12.04 # This Scripts all rights reserved deserved by MickeyZZC # Copyright 2013 # ############################################################################## PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:~/bin export PATH clear ######全局变量配置####### username= passwd= mysqlhost="" backuppath= ######################### #MYSQL存活状态检测 mysqllive(){ num=0 while [[ `pidof mysqld` == "" ]] ; do echo "$(date +%Y%m%d%H%M),MYSQL IS DOWN" >> /var/log/mysqlstat.log service mysql start num=`expr $num + 1` if [ $num -gt 11 ] ; then echo "$(date +%Y%m%d%H%M),MYSQL NO UP" >> /var/log/mysqlstat.log exit 1 fi sleep 10 done #把生产线上的数据库赋值给数组变量 mysqldata=`mysql -h$mysqlhost -u$username -p$passwd -e"show databases"|grep -vE "mysql|information_schema|performance_schema|Database"` if [ $num -gt 0 ] ; then mysqlsamchk fi } #MYSQL表检测和修复 mysqlsamchk(){ #MYSQL存活状态检测 mysqllive if [[ `which mysqlcheck` == "" ]] ;then for i in ${mysqldata[@]} ; do mytables=`mysql -h$mysqlhost -u$username -p$passwd -e"use $i;show tables;"|grep -vE "Tables_in_"` for j in ${mytables[@]} ; do table_status=`mysql -h$mysqlhost -u$username -p$passwd -e"check table $i.$j"|awk 'BEGIN{IFS='t'}{print $3}'|grep "error"` if [[ ! "$table_status" == "" ]] ; then mysql -h$mysqlhost -u$username -p$passwd -e"repair table $i.$j" echo "$(date +%Y%m%d%H%M),$i.$j be repair" >> /var/log/mysqlstat.log fi done done else mysqlcheck --all-databases --auto-repair -u$username -p$passwd |awk '!/OK/ {printf "datetime,%sn",$1}'|sed "s/datetime/$(date +%Y%m%d%H%M)/g" >> /var/log/mysqlstat.log fi } #备份数据库 mysqlbackup() { #MYSQL存活状态检测 mysqllive [ ! -d $backuppath ] && mkdir $backuppath for i in ${mysqldata[@]} do #先清理空间后在备份会比较稳当一点 find $backuppath -name $i_*.zip -type f -mtime +7 -exec rm {} ; #备份后压缩保存 mysqldump --opt -h$mysqlhost -u$username -p$passwd $i |gzip > $backuppath/$i_$(date +%Y%m%d%H%M).zip done } #FTP上传数据备份 dataftp() { ######变量配置####### ftphost='' ftpusr='' ftpd='' ftpcmd='' ################### #生成备份数据包的MD5文件排错 tmp="/tmp/$(date +%Y%m%d)" [ ! -f $tmp ] && touch $tmp for j in $(ls $backuppath/*$(date +%Y%m%d)* ); do cd $backuppath ; md5sum `basename $j` >> $tmp #调用PYTHON写的FTP脚本上传数据,代码地址:http://www.oschina.net/code/snippet_217347_25497 python $ftpcmd -t upload -H $ftphost -u $ftpusr -p $ftpd -l $j -r "/${j##*/}" done python $ftpcmd -t upload -H $ftphost -u $ftpusr -p $ftpd -l $tmp -r $(date +%Y%m%d) rm $tmp } case $1 in 'check') mysqlsamchk ;; 'backup') mysqlbackup dataftp ;; *) mysqllive ;; esac 以上内容由PHP站长网【52php.cn】收集整理供大家参考研究 如果以上内容对您有帮助,欢迎收藏、点赞、推荐、分享。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |