zabbix -mysql数据库监控

参考

https://www.cnblogs.com/laonicc/p/11079249.html

1.禁用安装防护
[root@mysql213 ~]# vi /etc/selinux/config #关闭安装

SELINUX=disabled

2.授权zabbix监控账号

mysql -uroot -p123456
mysql> grant usage on *.* to zabbix@127.0.0.1 identified by '123456';
mysql> grant usage on *.* to zabbix@'%' identified by '123456';#不安全但是暴力
mysql> flush privileges;

3.编辑安装agent客户端

sh zabbix-agent.sh

#!/bin/bash
#clsn
#设置解析
#安装zabbix源、aliyu nYUM源
rpm -ivh http://repo.zabbix.com/zabbix/4.0/rhel/7/x86_64/zabbix-release-4.0-1.el7.noarch.rpm
#安装zabbix客户端
yum install zabbix-agent -y
sed -i.ori 's#Server=127.0.0.1#Server=192.168.100.210#' /etc/zabbix/zabbix_agentd.conf
systemctl start  zabbix-agent.service
#写入开机自启动
systemctl start zabbix-agent.service
systemctl enable zabbix-agent.service

查看确认的信息

vi /etc/zabbix/zabbix_agentd.conf#系统自己配置可以看一下

Include=/etc/zabbix/zabbix_agentd.d/*.conf #

vi /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf #系统自动配置查看一下就可以
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 information_schema.tables$([[ "$1" = "all" || ! "$1" ]] || echo " where table_schema=\"$1\"")$([[ "$2" = "all" || ! "$2" ]] || echo "and table_name=\"$2\"");" | HOME=/var/lib/zabbix mysql -N'


UserParameter=mysql.ping,HOME=/var/lib/zabbix mysqladmin ping | grep -c alive
UserParameter=mysql.version,mysql -V

service zabbix-agent restart
systemctl restart mysqld

[root@mysql213 ~]# vi /etc/my.cnf #配置mysql验证 在最后添加即可

#Zabbix Agent
[mysql]
host=localhost
user=zabbix
password=123456
socket= /var/lib/mysql/mysql.sock
[mysqladmin]
host=localhost
user=zabbix
password=123456
socket= /var/lib/mysql/mysql.sock

4.参数验证

zabbix_agentd -t mysql.version
zabbix_agentd -t mysql.ping

5.添加主机系统自带模板就可以 默认发现数据1分钟

 查询数据