监控mysql
zabbix自带mysql模板监控mariadb,更全面的监控可以自行编写脚本或才通过第三方模板,如http://www.fromdual.com/mpm-installation-guide
在要监控的mysql主机上
1.安装zabbix客户端
2.创建具有监控权限的数据库用户
GRANT USAGE ON *.* TO
'zabbix'@'localhost' IDENTIFIED BY 'zabbix';
FLUSH PRIVILEGES;
3.创建数据库连接配置文件
root@jlive:~#cat
>/usr/local/zabbix/etc/.my.cnf <
[mysql]
host = localhost
user = zabbix
password = zabbix
socket =
/tmp/mysql.sock
[mysqladmin]
host = localhost
user = zabbix
password = zabbix
socket =
/tmp/mysql.sock
HERE
可根据环境不同作相应调整
4.使用zabbix
mysql模板配置文件userparameter_mysql.conf
cp
/usr/local/src/zabbix-3.0.2/conf/zabbix_agentd/userparameter_mysql.conf
/usr/local/za