zabbix自带模板监控MySQL服务
1.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;如图:
本文转自898009427 51CTO博客,原文链接:http://blog.51cto.com/moerjinrong/2062927,如需转载请自行联系原作者