MYSQL日常管理脚本

下面是编程之家 jb51.cc 通过网络收集整理的代码片段。

编程之家小编现在分享给大家，也给大家做个参考。

#!/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,%s\n",$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

以上是编程之家(jb51.cc)为你收集整理的全部代码内容，希望文章能够帮你解决所遇到的程序开发问题。

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

MYSQL日常管理脚本

猜你在找的Shell相关文章