Zabbix monitoring MySQL
1.1 Client Configuration 1.1.1 Install client Package
Yum--IVH zabbix-agent-3.0. 3-1. el6.x86_64.rpm
1.1.2 Editing a configuration file
/etc/zabbix/zabbix_agentd.d/userparameter_mysql.confuserparameter=mysql.version,mysql- Vuserparameter=mysql.status[*],/etc/zabbix/scripts/chk_mysql.sh $1userparameter= mysql.ping,mysqladmin-uzabbix-p123456-p3306-h192. 168.1. the ping | Grep-c Alive
1.1.3 Creating a MySQL monitoring script file
mkdir/etc/zabbix/scripts/Touch/etc/zabbix/scripts/chk_mysql.shchmod u+x/etc/zabbix/scripts/Chk_mysql.shchown-R zabbix.zabbix/etc/zabbix/scripts/chk_mysql.sh Vim/etc/zabbix/scripts/chk_mysql.sh#!/bin/sh#-------------------------------------------------------------------------------Mysql_sock="/tmp/mysql.sock"Mysql_user='Zabbix'mysql_pwd='123456'Mysql_host='127.0.0.1'Mysql_port='3306'ARGS=1if[$#-ne"$ARGS"];then Echo"Please input one arguement:"fi Case$1 inchUptime) Result= '/application/mysql/bin/mysqladmin-u$mysql_user-h$mysql_host-p${mysql_pwd}-S $MYSQL _sock status|cut-F2-D":"|cut-f1-d"T"' echo $result;; Com_update) Result= '/application/mysql/bin/mysqladmin-u$mysql_user-h$mysql_host-p${mysql_pwd}-S $MYSQL _sock extended-Status|grep-w"com_update"|cut-d"|"-F3 ' Echo $result;; Slow_queries) Result= '/application/mysql/bin/mysqladmin-u$mysql_user-h$mysql_host-p${mysql_pwd}-S $MYSQL _sock status |cut-f5-D":"|cut-f1-d"O"`
1.1.4 Modifying the Zabbix client to point to the server IP
' s#serveractive=127.0.0.1#serveractive=192.168.1.72#g ' /etc/zabbix/'s#server=127.0.0.1#server=192.168.1.72#g' /etc /zabbix/zabbix_agentd.conf /etc/init.d/zabbix-agent Restart
1.1.5 web-side operations
Zabbix script monitoring MySQL