#!/bin/bash
mysql_user='root'
mysql_pass='123.com'
mail="it-arch"
data=$(date +%Y-%m-%d-%H:%M)
netstat -lntup|egrep ":3306"|grep -v grep>/dev/null0
if [ $? -eq 0 ];then
	Slave_IO=`mysql -u${mysql_user} -pCHANGE_ME -e "show slave status\G"|grep "Slave_IO_Running:"|awk -F": " '{print $2}'`
	Slave_SQL=`mysql -u${mysql_user} -pCHANGE_ME -e "show slave status\G"|grep "Slave_SQL_Running:"|awk -F": " '{print $2}'`
		if [ "$Slave_IO" == "Yes" ] && [ "$Slave_SQL" == "Yes" ];then
			STAT=1 && echo "$data mysql-status is ok">>/var/log/mysql-status.log
		else
			STAT=0 && echo "$data mysql-status is error">>/var/log/mysql-status.log
		fi
else
	STAT=0 && echo "$data mysql-status is error">>/var/log/mysql-status.log
fi
zabbix_sender -z xxx.xxx.xxx.xx -s "MySQL-master-slave" -k mysql -o $STAT