共计 5564 个字符，预计需要花费 14 分钟才能阅读完成。
这篇文章将为大家详细讲解有关如何使用 zabbix 监控 MySQL，丸趣 TV 小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。
概要：
如果你想搭建一套 mysql 监控
如果你想学习 zabbix
那么此篇文章适合你
MySQL 监控 –zabbix
– 刘春雷修改 vi /etc/services，添加下面几行
zabbix-agent 10050/tcp #zabbix agent
zabbix-agent 10050/udp #zabbix agent
zabbix-trapper 10051/tcp #zabbix trapper
zabbix-trapper 10051/udp #zabbix trapper
8、修改 zabbix 的配置：[[email protected] zabbix-2.4.4]# vi /usr/local/zabbix/etc/zabbix_server.conf
[[email protected] zabbix-2.4.4]# cat /usr/local/zabbix/etc/zabbix_server.conf|grep -v ^# | grep -v ^$
LogFile=/data/zabbix/zabbix_server.log
PidFile=/data/zabbix/zabbix_server.pid
DBHost=192.168.94.78
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix
DBSocket=/tmp/mysql.sock
DBPort=6001
StartPollers=20
StartTrappers=15
StartPingers=10
User=zabbix
[root@localhost ~]# vi /etc/init.d/zabbix_server
BASEDIR=/usr/local/zabbix ########## 修改这行
[root@localhost ~]# vi /etc/init.d/zabbix_agentd
BASEDIR=/usr/local/zabbix ########## 修改这行
9、修改 httpd 配置[[email protected] zabbix-2.4.4]# vi /etc/httpd/conf/httpd.conf
ServerName 127.0.0.1
VirtualHost *:80
DocumentRoot /var/www/html
ServerName 192.168.94.78
/VirtualHost
10、开启 httpd[[email protected] core]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: httpd: Could not reliably determine the server s fully qualified domain name, using 127.0.0.1 for ServerName
[ OK ][[email protected] core]# lsof -i:80
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
httpd 23923 root 4u IPv4 2582967064 0t0 TCP *:80(LISTEN)
httpd 23925 apache 4u IPv4 2582967064 0t0 TCP *:80 (LISTEN)
httpd 23926 apache 4u IPv4 2582967064 0t0 TCP *:80 (LISTEN)
httpd 23927 apache 4u IPv4 2582967064 0t0 TCP *:80 (LISTEN)
httpd 23928 apache 4u IPv4 2582967064 0t0 TCP *:80 (LISTEN)
httpd 23929 apache 4u IPv4 2582967064 0t0 TCP *:80 (LISTEN)
httpd 23930 apache 4u IPv4 2582967064 0t0 TCP *:80 (LISTEN)
httpd 23931 apache 4u IPv4 2582967064 0t0 TCP *:80 (LISTEN)
httpd 23932 apache 4u IPv4 2582967064 0t0 TCP *:80 (LISTEN)
10、做几个软连接[root@localhost ~]# ln -s /usr/local/zabbix/bin/* /usr/bin/
[root@localhost ~]# ln -s /usr/local/zabbix/sbin/* /usr/sbin/
[root@localhost ~]# cd /data/zabbix/zabbix-2.4.4/misc/init.d/fedora/core
[root@localhost ~]# cp * /etc/init.d/
11. 开启 zabbix server 端：
[[email protected] subsys]# chown zabbix.zabbix /var/lock/subsys/ -R
[[email protected] subsys]# chown zabbix.zabbix /usr/local/zabbix -R
[[email protected] subsys]# chown zabbix.zabbix /data/zabbix/ -R
[[email protected] core]#[[email protected] zabbix]# scp zabbix-2.4.4.tar.gz 192.168.94.144:/data/zabbix_agent/
[[email protected] zabbix_agent]# groupadd -g 201 zabbix
[[email protected] zabbix_agent]# useradd -g zabbix -u 201 -m zabbix
[[email protected] zabbix_agent]# passwd zabbix
Changing password for user zabbix.
New password:
BAD PASSWORD: it is based on a dictionary word
BAD PASSWORD: is too simple
Retype new password:
passwd: all authentication tokens updated successfully.
[[email protected] zabbix-2.4.4]# cd /data/zabbix_agent/zabbix-2.4.4
[[email protected] zabbix-2.4.4]# ./configure –prefix=/usr/local/zabbix –enable-agent –enable-proxy –with-mysql=/usr/local/mysql5.5/bin/mysql_config
[[email protected] zabbix-2.4.4]# make make install
2、拷贝 / 创建快捷
[[email protected] zabbix-2.4.4]# pwd
/data/zabbix_agent/zabbix-2.4.4
[[email protected] zabbix-2.4.4]# cp misc/init.d/tru64/zabbix_agentd /etc/init.d/
[[email protected] zabbix-2.4.4]# chmod +x /etc/init.d/zabbix_agentd
3、修改配置文件
[[email protected] zabbix-2.4.4]# vi /usr/local/zabbix/etc/zabbix_agentd.conf
[[email protected] zabbix-2.4.4]# cat /usr/local/zabbix/etc/zabbix_agentd.conf | grep -v ^# | grep -v ^$
LogFile=/data/zabbix_agent/zabbix_agentd.log
UnsafeUserParameters=1
Include= /usr/local/zabbix/etc/zabbix_agentd.conf.d/
Server=192.168.94.78 #server 端 IP
ServerActive=192.168.94.78 #server 端 IP
Hostname=192.168.94.144 #客户端 IP
4、开启 zabbix 的 agent
[[email protected] zabbix-2.4.4]# chown zabbix.zabbix /data/zabbix_agent/ -R
[[email protected] zabbix-2.4.4]# chown zabbix.zabbix /usr/local/zabbix/ -R
[[email protected] zabbix-2.4.4]# chown zabbix.zabbix /soft/mysqlmonitor/port_6190 -R
[[email protected] tmp]#5、界面添加 host
此时可以在界面上面添加 host 进行监控测试了，因后面添加自定义监控，此处忽略
三、自定义监控配置 1、准备检查脚本
准备检查 mysql 状态的脚本
[[email protected] ~]# cd /soft/port_6190/
[[email protected] port_6190]# ./mysql_status.pl|grep com_writes
com_writes=0
[[email protected] port_6190]# /soft/port_6190/mysql_status.pl |grep com_writes|awk -F = {print $2}
0
注：此处可以自定义脚本，返回 key=value 即可，或者使用 percona 的模板，此处以自定义监控脚本为例来进行配置监控
2、修改 agent 的配置文件
[[email protected] port_6190]# vi /usr/local/zabbix/etc/zabbix_agentd.conf
[[email protected] port_6190]# cat /usr/local/zabbix/etc/zabbix_agentd.conf|grep -v ^# |grep -v ^$
LogFile=/data/zabbix_agent/zabbix_agentd.log
UnsafeUserParameters=1
Include= /usr/local/zabbix/etc/zabbix_agentd.conf.d/
Server=192.168.94.78
ServerActive=192.168.94.78
Hostname=test
UserParameter=com_writes,/soft/port_6190/mysql_status.pl |grep com_writes|awk -F = {print $2}
UserParameter=com_reads,/soft/port_6190/mysql_status.pl |grep com_reads |awk -F = {print $2}
UserParameter=com_update,/soft/port_6190/mysql_status.pl |grep com_update|awk -F = {print $2}
UserParameter=com_insert,/soft/port_6190/mysql_status.pl |grep com_insert|awk -F = {print $2}
UserParameter=com_delete,/soft/port_6190/mysql_status.pl |grep com_delete|awk -F = {print $2}
注：com_delet 为键值名，后面为键值的值
重启 agent
/etc/init.d/zabbix_agentd stop
/usr/local/zabbix/sbin/zabbix_agentd -c /usr/local/zabbix/etc/zabbix_agentd.conf
3、server 端检查
检查
[[email protected] bin]# pwd
/usr/local/zabbix/bin
[[email protected] 添加 host
4.2 添加模版
4.3 创建应用集
4.4 创建项目
4.5 创建图形
5、查看监控图
6、其他过程
关于“如何使用 zabbix 监控 MySQL”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，使各位可以学到更多知识，如果觉得文章不错，请把它分享出去让更多的人看到。
