通过自带的mysql模板监控数据库
1.新建一个专门用在zabbix监控的用户
GRANT ALL PRIVILEGES ON *.* TO 'zabbix'@'localhost' IDENTIFIED BY 'abc123';
FLUSH PRIVILEGES;
2.添加一个.my.cnf文件(这个文件不要放/etc/要放在/etc/zabbix下)
vim /etc/zabbix/.my.cnf
[mysql]
host=localhost
user=zabbix
password=abc123
socket=/tmp/mysql.sock
[mysqladmin]
host=localhost
user=zabbix
password=abc123
socket=/tmp/mysql.sock
#需要注意的是/tmp/mysql.sock这个要根据你实际的情况去修改,有的不一定在/tmp/。可以通过数据库配置去看
3.添加一个配置文件在zabbix
vim /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/etc/zabbix mysql -N | awk '{print $$
2}'
UserParameter=mysql.size[*],bash -c 'echo "select sum($(case "$3" in both|"") echo "data_length+index_length";; data|index) ec
ho "$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=/etc/zabbix mysql -N'
UserParameter=mysql.ping,HOME=/etc/zabbix mysqladmin ping | grep -c alive
UserParameter=mysql.version,mysql -V
#这里文件路径根据自己实际情况去修改配置里面的HOME=/etc/zabbix这个路径就是你自己新建的.my.cnf的文件路径
4.重启zabbix_agent客户端
5.配置界面模板