Mysql 서비스 감시 체크 예시

1. Mysql replication 체크

 

1.1. Cron 등록

*/15 * * * * /root/script/repmon.sh

 

1.2. repmon.sh (shell 예시)

 #!/bin/bash

 

export PATH=/usr/local/proftpd/bin:/usr/local/proftpd/sbin:/usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

 

SERVER=$(hostname)

LAST_ERRNO=$(mysql -urepmon -p"qwe123" -e "show slave status\G" | grep "Last_Errno" | awk '{print $2;}')

ERROR=0

 

if [ "$LAST_ERRNO" != 0 ]

then

    ERRORS=("${ERRORS[@]}" "Error when processing relay log (Last_Errno)")

fi

 

if [ "${#ERRORS[@]}" != 0 ]

then

    MESSAGES="An error has been detected on ${SERVER} involving the mysql replication. Below is a list of the reported errors:\n\n

    $(for i in $(seq 0 ${#ERRORS[@]}); do echo "\t${ERRORS[$i]}\n";done)Please correct this ASAP"

    echo -e $MESSAGES | mail -s "MySQL Replication for $SERVER is reporting Error" user3@test.com user@test.com user2@test.com

else

echo 1 >> /root/1.txt

fi