1, installing Phpyum install PHP php-mysql 2, specify Mysql.sock file vim/etc/php.inimysql_default_socket=/data/mysql/3306/var/ Run/mysql.sockmysqli_default_socket=/data/mysql/3306/var/run/mysql.sock 3, installing Percona Pluginwget https ://www.percona.com/downloads/percona-monitoring-plugins/1.1.5/percona-zabbix-templates-1.1.5-1.noarch.rpmrpm- IVH percona-zabbix-templates-1.1.5-1.noarch.rpmcopy template to server import, link template 3, modify PHP script vim Ss_get_mysql_ Stats.php$mysql_user = ' root '; $mysql _pass = ' root '; $mysql _port = 3306; 4, modify the shell script vim Get_mysql_stats_ Wrapper.shhost=******res= ' echo ' SHOW SLAVE status\g ' |mysql--defaults-file=/etc/.my.cnf | Egrep ' (slave_io_running| slave_sql_running): ' | Awk-f: ' {print $} ' | Tr ' \ n ', ' vim/etc/.my.cnf[mysql]user=zabbixpassword=zabbixhost=localhostsocket= /data/mysql/3306/ Var/run/mysql.sock [mysqladmin]user=zabbixpassword=zabbix 7, configure MySQL account zabbix/passwordselect MySQL permissions 8, restart Zabbix 9, test php-q ss_get_mysql_stats.php--host LocalhOST--items gg./get_mysql_stats_wrapper.sh gg chown Zabbix:zabbix /tmp/*-mysql_stats.txt
ZABBIX MySQL Monitor