[MySQL] zabbix企业应用之监控mysql 5.6版本

Warning: Using a password on the command line interface can be insecure

mysql_config_editor set --login-path=local --host=localhost --user=zabbix -p

15:35:38 # mysql_config_editor print --all
[local]
user = zabbix
password = *****
host = localhost

15:35:40 # mysql --login-path=local
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 741
Server version: 5.6.19-67.0-log Percona Server (GPL), Release 67.0, Revision 618
Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> quit

UserParameter=mysql_stats
[*],mysql -h localhost -P $1 -uzabbix -pzabbix -e "show global status"|grep "\<$2\>"|cut  -f2
UserParameter=mysql_stats_slave
[*],mysql -h localhost -P $1 -uzabbix -pzabbix  -e "show slave status\G"|grep "\<$2\>"|awk '{if($NF=="Yes") {print 1} else {print 0}}'

UserParameter=mysql_stats_5.6
[*],sudo mysql --login-path=local -P $1  -e "show global status"|grep "\<$2\>"|cut  -f2
UserParameter=mysql_stats_slave_5.6
[*],sudo mysql --login-path=local -P $1  -e "show slave status\G"|grep "\<$2\>"|awk '{if($NF=="Yes") {print 1} else {print 0}}'

zabbix ALL=(root) NOPASSWD:/usr/bin/mysql

ps -ef|grep zabbix|grep -v grep|awk '{print $2}'|xargs kill -9
/usr/local/zabbix/sbin/zabbix_agentd -c /usr/local/zabbix/conf/zabbix_agentd.conf