Shulou(Shulou.com)06/01 Report--

MySQL master-slave replication status monitoring and Wechat alarm

Shell script enables Wechat alarm to be triggered when the master-slave state of MySQL is abnormal.

1. Set up master-slave monitoring script

Vi / opt/scripts/mysql/check_repl_status.sh

#! / bin/bash

Host='' # Slave machine

User='' # mysql account (can execute show slave status without too much permission)

Passwd='' # mysql password

_ msgBodys ()

{

Local int AppID=0

Local UserID=$1

Local Msg= "$2"

Cat / dev/null 2 > & 1

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.