用Zabbix监控MySQL,无须自己定义脚本

添加Mysql监控

1. 安装MySQL

yum install mysql-server -y

2. 开始MySQL服务

service mysqld start

3. 初始化MySQL数据库的root用户密码及其它设置

mysql_secure_installation

4. 创建一个帐号用于agent获取MySQL状态

grant all privileges on zabbix.* to zabbix[@localhost](http://my.oschina.net/u/570656) identified by 'zabbix_password';flush privileges;

5. 在agent端设置连接MySQL的配置文件/etc/zabbix/.my.cnf

# Zabbix Agent[mysql]host     = localhostuser     = rootpassword = rootpasswordsocket   = /var/lib/mysql/mysql.sock[mysqladmin]host     = localhostuser     = rootpassword = rootpasswordsocket   = /var/lib/mysql/mysql.sock

6. 调整获取MySQL数据的文件,將默认/var/lib/zabbix路径改为/etc/zabbix指向.my.cnf所在的路径

sed -i "s/HOME\=\/var\/lib\/zabbix/HOME\=\/etc\/zabbix/g" /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf

6. 选择MySQL模板

7. 添加选择的模板

7. MySQL监控采集数据绘制的效果图