zabbix監控mysql

標籤：zabbix監控mysql

1.用戶端首先建立MySQL使用者用於zabbix串連資料庫

[[email protected] zabbix]# mysql -uroot -p123456  -e”GRANT USAGE ON *.* TO ‘zabbix’@alhost’ IDENTIFIED BY ‘123456‘”;

2.建立資料庫連接資訊檔

[[email protected] zabbix]# vi /usr/local/zabbix/etc/.my.cnf

650) this.width=650;" src="http://note.youdao.com/yws/res/105/01BD6C64AF2640CC90B0D56C3557AAEE" style="margin-top:8px;height:auto;" alt="01BD6C64AF2640CC90B0D56C3557AAEE" />

3.複製MySQL模板userparameter_mysql.conf需要用到的key，到/usr/local/zabbix/etc/zabbix_agentd.conf.d/目錄下

[[email protected] zabbix]# cp /usr/local/src/zabbix-2.2.6/conf/zabbix_agentd/userparameter_mysql.conf  /usr/local/zabbix/etc/zabbix_agentd.conf.d/

4.修改userparameter_mysql.conf檔案把HOME=/var/lib/zabbix全部改成HOME=/usr/local/zabbix/etc即改成我們建立的.my.cnf位置

[[email protected] ~]# vi /usr/local/zabbix/etc/zabbix_agentd.conf.d/userparameter_mysql.conf

650) this.width=650;" src="http://note.youdao.com/yws/res/110/2ECB8BABC1BC43479B72FDF1DB6B8473" style="margin-top:8px;height:auto;" alt="2ECB8BABC1BC43479B72FDF1DB6B8473" />

5.修改zabbix_agentd.conf檔案

[[email protected] zabbix]# vi etc/zabbix_agentd.conf

本文出自 “Mr.Liang” 部落格，請務必保留此出處http://liangml.blog.51cto.com/10852271/1855785

zabbix監控mysql