Zabbix custom key monitoring MySQL master-slave synchronization Super simple!

1. In the Zabbix client configuration file, add:

First to provide MySQL with a query master-slave status account! (You can use root, of course.) )

Userparameter=mysql.replicate_error,if test ' mysql-uxxx-pxxx-h127.0.0.1-e ' show slave status\g ' | Awk-f: ' {if ($1~/slave_io_running/) print$2} ' = "Yes"-a ' mysql-uxxx-pxxx-h127.0.0.1-e ' show Slave status\g ' | Awk-f: ' {if ($1~/slave_sql_running/) print$2} ' = ' yes '; then echo 0; else Echo 1;fi

2. Create a template in the Web interface:

Create a project

Add triggers;

Add action slightly.

4. Share the key for other services:

USERPARAMETER=NGINX.STATUS,NETSTAT-TUNLP | grep 80 | grep Nginx | WC | awk ' {print '} '

USERPARAMETER=MEMCACHED.STATS,NETSTAT-TUNLP | grep 11211 | grep memcache | WC | awk ' {print '} '

Zabbix custom key monitoring MySQL master-slave synchronization Super simple!