About MySQL master and slave is normal judgment

Develop a daemon script that monitors MySQL master-slave replication anomalies (including unsynchronized and delayed) every 30 seconds

#!/bin/bashfile=/root/mysql.txt #mysql > Show slave status\g; This command can view status information and save it to a file. Aa= ($ (Cat $file | grep-e ' Running| Behind ' | Cut-d ': '-f2)) for ((i=0;i<${#aa [*]};i++)) do count=0 if [${aa[i]}! = "Yes"-a ${aa[i]}! = "0"]; Then echo ' bad ' let count+=1 else echo ' good ' fidone

For a delay of 30 seconds, put the above script inside the function, using the while true null value, plus sleep 30

About MySQL master and slave is normal judgment