使用zabbix自带模板监控MySQL数据库

最新推荐文章于 2024-07-14 16:31:29 发布

cpseh68048

最新推荐文章于 2024-07-14 16:31:29 发布

阅读量138

点赞数

授权zabbix连接MySQL数据库

zabbix客户端程序会以该用户的身份启动 
mysql> GRANT USAGE ON *.* TO 'zabbix'@'localhost' IDENTIFIED BY '123@qwe';
mysql> flush privileges;

修改监控模板

将监控模板加入配置文件中
shell> cp conf/zabbix_agentd/userparameter_mysql.conf /usr/local/zabbix/etc/zabbix_agentd.conf.d/

修改配置文件HOME
shell> grep -v ^# /usr/local/zabbix/etc/zabbix_agentd.conf.d/userparameter_mysql.conf
=================================================================================================
UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | 
HOME=/usr/local/zabbix/etc mysql -N | awk '{print $$2}'

UserParameter=mysql.size[*],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=/usr/local/zabbix/etc mysql -N

UserParameter=mysql.ping,HOME=/usr/local/zabbix/etc mysqladmin ping | grep -c alive
UserParameter=mysql.version,mysql -V
=================================================================================================

建立数据库连接信息

shell> cat /usr/local/zabbix/etc/.my.cnf
=================================================================================================
# Zabbix Agent
[mysql]
host=localhost
user=zabbix
password=123@qwe
socket=/tmp/mysql.sock
[mysqladmin]
host=localhost
user=zabbix
password=123@qwe
socket=/tmp/mysql.sock
=================================================================================================