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，如需转载请自行联系原作者
