zabbix监控mysql

rpm -ivh https://www.percona.com/downloads/percona-monitoring-plugins/percona-monitoring-plugins-1.1.8/binary/redhat/7/x86_64/percona-zabbix-templates-1.1.8-1.noarch.rpm
cp /var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf /etc/zabbix/zabbix_agentd.d/
vim /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh
修改19行内容：RES=HOME=~zabbix mysql -uzabbix -p123456 -e 'SHOW SLAVE STATUS\G' | egrep '(Slave_IO_Running|Slave_SQL_Running):' | awk -F: '{print $2}' | tr '\n' ','
vim /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php
$mysql_user = ‘zabbix’; # MySQL用户名
$mysql_pass = ‘123456’; # MySQL密码
$mysql_port = 3306; # MySQL服务端口
$mysql_socket = ‘/var/lib/mysql/mysql.sock’; # 默认为NULL，若需要指定socket文件需修改该参数值
systemctl restart zabbix-server zabbix-agent httpd
systemctl enable zabbix-server zabbix-agent httpd
/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh gg
sudo -u zabbix -H /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh running-slave

zabbix_get -s 127.0.0.1 -p 10050 -k “mysql.status[Com_begin]”