Mysql Master/Slave monitoring script includes automatic configuration of sending Gmail Mail Client

Common script backup

 
 

  
  
Automatically configure msmtp and use mail to send emails
  
  
#! /Bin/bash
  
  
SRC =/usr/local/src
  
  
Cd $ SRC
  
  
# Install msmtp client
  
  
# If your want support TLS/SSL, install openssl-devel
  
  
# Yum install-y openssl-devel //
  
  
Wget http://nchc.dl.sourceforge.net/project/msmtp/msmtp/1.4.28/msmtp-1.4.28.tar.bz2
  
  
Tar xjf msmtp-1.4.28.tar.bz2
  
  
Cd msmtp-1.4.28
  
  
./Configure -- prefix =/usr/local/msmtp & make install
  
  
Cd/usr/local/msmtp/
  
  
Mkdir etc
  
  
Echo 'account gmail
  
  
Host smtp.gmail.com
  
  
From reportonline@gmail.com
  
  
Auth on
  
  
Tls on
  
  
Tls_starttls on
  
  
Tls_force_sslv3 on
  
  
Tls_trust_file/usr/local/msmtp/etc/gmail. crt
  
  
User reportonline@gmail.com
  
  
Password 1234567890

  
  
Port 587
  
  
Syslog off
  
  
Logfile/tmp/msmtp. log
  
  
Account default: gmail '>/usr/local/msmtp/etc/msmtprc
  
  
Wget-O/usr/local/msmtp/etc/gmail. crt http://www.geotrust.com/resources/extended-validation-ssl/certs/Equifax%20Secure%20Certificate%20Authority.crt
  
  
Ln-s/usr/local/msmtp/bin/msmtp/usr/bin/
  
  
Echo "set sendmail =/usr/bin/msmtp">/etc/mail. rc
  
  
 
  
  
Script 2 <monitoring mysql Server Master/Slave, from fuqin liquor cooking>
  
  
#! /Bin/bash
  
  
# Check MySQL_Slave Status
  
  
# Crontab time every 10 min

  
  
Test-e/data0/mysql/check_mysql_slave.log | touch/data0/mysql/check_mysql_slave.log
  
  
Chown mysql. mysql/data0/mysql/check_mysql_slave.log
  
  
 
  
  
MYSQLPORT = 'netstat-na | grep "LISTEN" | grep "3306" | awk-F [: ""] + '{print $5 }''
  
  
MYSQLIP = 'ifconfig eth0 | grep "inet addr" | awk-F [: ""] + '{print $4 }''
  
  
STATUS = $ (/usr/local/mysql/bin/mysql-uadmin-ppassword-S/tmp/mysql. sock-e "show slave status \ G" | grep-I "running ")
  
  
IO_env = 'echo $ STATUS | grep IO | awk '{print $2 }''
  
  
SQL _env = 'echo $ STATUS | grep SQL | awk '{print $2 }''
  
  
DATA = 'date + "% y-% m-% d % H: % M: % S "'
  
  
 
  
  
If ["$ MYSQLPORT" = "3306"]
  
  
Then
  
  
Echo "mysql is running"
  
  
Else
  
  
Mail-s "ERROR! Server: $ MYSQLIP mysql is down "start@gmail.com-c user1@gmail.com-c user2@gmail.com-c user3@gmail.com
  
  
Fi
  
  
 
  
  
If ["$ IO_env" = "Yes"-a "$ SQL _env" = "Yes"]
  
  
Then
  
  
Echo "Slave is running! "
  
  
Else
  
  
Echo "######## $ DATA ########">/data0/mysql/check_mysql_slave.log
  
  
Echo "Slave is not running! ">/Data0/mysql/check_mysql_slave.log
  
  
Echo "Slave is not running! "| Mail-s" ERROR! $ MYSQLIP MySQL Slave is not running "start@gmail.com-c user1@gmail.com-c user2@gmail.com-c user3@gmail.com
  
  
Fi
 
 

Recently, due to actual needs, the following changes have been made to the script and DNS monitoring has been added. The difference from the previous one is that an email is sent. Instead of sending an email when there is an error.

 
 

  
  
#!/bin/bash  -x 
  
  
#check MySQL_Slave Status and check dns status 
  
  
#crontab time 00:10 
  
  
test -e /data0/mysql/check_mysql_slave.log || touch /data0/mysql/check_mysql_slave.log  
  
  
chown mysql.mysql /data0/mysql/check_mysql_slave.log  
  
  
 
  
  
MYSQLPORT=`netstat -na|grep "LISTEN"|grep "3306"|awk -F[:" "]+ '{print $5}'` 
  
  
MYSQLIP=`ifconfig eth0|grep "inet addr" | awk -F[:" "]+ '{print $4}'` 
  
  
STATUS=$(/usr/local/mysql/bin/mysql -uadmin -ppassword -S /tmp/mysql.sock -e "show slave status\G" | grep -i "running") 
  
  
IO_env=`echo $STATUS | grep IO | awk  ' {print $2}'` 
  
  
SQL_env=`echo $STATUS | grep SQL | awk  '{print $2}'` 
  
  
DATA=`date +"%y-%m-%d %H:%M:%S"` 
  
  
 
  
  
 > /data0/mysql/check_mysql_slave.log  
  
  
 
  
  
if [ "$MYSQLPORT" == "3306" ] 
  
  
then 
  
  
    echo "mysql is running" 
  
  
else 
  
  
    echo "Mysql Server is not running!" >>  /data0/mysql/check_mysql_slave.log 
  
  
fi 
  
  
 
  
  
if [ "$IO_env" = "Yes" -a "$SQL_env" = "Yes" ];then 
  
  
    echo "Slave is running"  
  
  
    ps aux | grep bind | grep -v grep > /dev/null  
  
  
    if [ "$?" == "0" ];then 
  
  
        echo "Bind9 is running" 
  
  
    else 
  
  
        echo "####### $DATA #########">> /data0/mysql/check_mysql_slave.log 
  
  
        echo "Bind9 is not running!" >>  /data0/mysql/check_mysql_slave.log 
  
  
    fi 
  
  
else 
  
  
    echo "####### $DATA #########">> /data0/mysql/check_mysql_slave.log 
  
  
    echo "Slave is not running!" >>  /data0/mysql/check_mysql_slave.log 
  
  
fi 
  
  
 
  
  
LINE=`wc -l /data0/mysql/check_mysql_slave.log | awk '{print $1}' ` 
  
  
if [ "$LINE" -gt "0" ];then 
  
  
    cat /data0/mysql/check_mysql_slave.log | mail -s "PLOBLEAM: DNS SERVER $MYSQLIP ERROR INFORMATION" baoch8@163.com 
  
  
fi 
 
 

Online machine running

 
 

  
  
+ test -e /data0/mysql/check_mysql_slave.log 
  
  
+ chown mysql.mysql /data0/mysql/check_mysql_slave.log 
  
  
++ netstat -na 
  
  
++ grep LISTEN 
  
  
++ grep 3306 
  
  
++ awk '-F[: ]+' '{print $5}' 
  
  
+ MYSQLPORT=3306 
  
  
++ ifconfig eth0 
  
  
++ grep 'inet addr' 
  
  
++ awk '-F[: ]+' '{print $4}' 
  
  
+ MYSQLIP=118.X.X.X 
  
  
++ /usr/local/mysql/bin/mysql -uadmin -ppassword -S /tmp/mysql.sock -e 'show slave status\G' 
  
  
++ grep -i running 
  
  
+ STATUS='             Slave_IO_Running: Yes 
  
  
            Slave_SQL_Running: Yes' 
  
  
++ echo Slave_IO_Running: Yes Slave_SQL_Running: Yes 
  
  
++ grep IO 
  
  
++ awk ' {print $2}' 
  
  
+ IO_env=Yes 
  
  
++ echo Slave_IO_Running: Yes Slave_SQL_Running: Yes 
  
  
++ grep SQL 
  
  
++ awk '{print $2}' 
  
  
+ SQL_env=Yes 
  
  
++ date '+%y-%m-%d %H:%M:%S' 
  
  
+ DATA='12-12-28 18:44:14' 
  
  
+ '[' 3306 == 3306 ']' 
  
  
+ echo 'mysql is running' 
  
  
mysql is running 
  
  
+ '[' YesYes = Yes -a YesYes = Yes ']' 
  
  
+ echo 'Slave is running' 
  
  
Slave is running 
  
  
+ ps aux 
  
  
+ grep bind 
  
  
+ grep -v grep 
  
  
+ '[' 0 == 0 ']' 
  
  
+ echo 'Bind9 is running' 
  
  
Bind9 is running 
  
  
++ wc -l /data0/mysql/check_mysql_slave.log 
  
  
++ awk '{print $1}' 
  
  
+ LINE=5 
  
  
+ '[' 5 -ne 0 ']' 
  
  
+ cat /data0/mysql/check_mysql_slave.log 
  
  
+ mail -s 'PLOBLEAM: DNS SERVER 118.X.X.X ERROR INFORMATION' baoch8@163.com 

 
 

 

This article from the "diving into the ocean of technology" blog, please be sure to keep this source http://myhat.blog.51cto.com/391263/1102487