zabbix自带模板监控MySQL服务

322ggg

.GUI界面添加Mysql模板Configuration --> Hosts --> 点击要添加的主机 --> Templates


添加新的模板，点击Select -->选择”Template DB MySQL“
点击“add”添加，最后点击Update更新；


2.登陆MySQL服务，创建只读账户；

1 2	mysql> grant select on *.* to "zabbix"@"localhost" identified by “123456”;    #赋权 mysql> flush privileges;    #刷新权限

3.修改mysql服务器的agent配置

1 2 3 4 5 6 7 8 9 10

# cd /etc/zabbix/zabbix_agentd.d # cp userparameter_mysql.conf{,.bak} # vim userparameter_mysql.conf   5 UserParameter=mysql.status ,echo "show global status where Variable_name='$1';" | HOME=/var/lib/zabbix /data/mysql/bin/mysql -N | awk '{print $$2}' 15 UserParameter=mysql.size ,bash -c 'echo "select sum($(case "$3" in both|"") echo "data_length+index_length";; data|index) echo "$3_length";; free) echo "data_free";; esac)) from informat ion_schema.tables$([[ "$1" = "all" || ! "$1" ]] || echo " where table_schema=\"$1\"")$([[ "$2" = "all" || ! "$2" ]] || echo "and table_name=\"$2\"");" | HOME=/var/lib/zabbix /data/mysql/bi n/mysql -N' 16 17 UserParameter=mysql.ping,HOME=/var/lib/zabbix /data/mysql/bin/mysqladmin ping | grep -c alive 18 UserParameter=mysql.version,/data/mysql/bin/mysql -V

注：1.mysql和mysqladmin配上绝对路径；
       2./var/lib/zabbix改为/usr/local/zabbix/etc；作为存放.my.cnf文件的位置；

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

# mkdir -pv /usr/local/zabbix/etc # vim /usr/local/zabbix/etc/.my.cnf \# mysql_agent        #文件内容 [mysql] host=localhost user=zabbix password=123456 socket=/data/mysql/mysql.sock [mysqladmin] host=localhost user=zabbix password=123456 socket=/data/mysql/mysql.sock # service zabbix-agent restart # ss -tnl | grep 10050

4.GUI 界面
查看MySQL模板监控是否生效：
Configuration --> Hosts --> 点击要监控服务器的Items选项 -->
Application选择MySQL，点击Apply过滤掉其它监控项；查看mysql模板监控是否生效；如图：


Monitoring --> Latest data -->
Hosts选择要监控的那台MySQL服务器；Application选择MySQL；点击Allly；如图：


查看监控图像：
Monitoring --> Graphs -->
Host选择要监控的那台MySQL服务器；Graph选择MySQL operations；如图：