输入用户admin密码zabbix登录进去；
下面安装agent端我的两台mysql是oracle enterprise linux 5.8 x86_64的； Ip地址:192.168.6.237
http://www.zabbix.com/download.php
下载zabbix_agents_2.4.1.linux2_6.amd64.tar.gz文件
root@rac1:/root-->tar -xzvf zabbix_agents_2.4.1.linux2_6.amd64.tar.gz -C /usr/local/zabbix sbin/zabbix_agent sbin/zabbix_agentd bin/zabbix_get bin/zabbix_sender conf/zabbix_agent.conf
conf/zabbix_agentd.conf
conf/zabbix_agentd/userparameter_examples.conf conf/zabbix_agentd/userparameter_mysql.conf root@rac1:/root-->ls -l /usr/local/zabbix/ total 12
drwxr-xr-x 2 root root 4096 Dec 17 14:53 bin drwxr-xr-x 3 root root 4096 Dec 17 14:53 conf drwxr-xr-x 2 root root 4096 Dec 17 14:53 sbin
##修改参数值Server ServerActive HostnameInclude（包含percona配置的conf文件）
root@rac1:/usr/local/zabbix/conf-->vim zabbix_agentd.conf ##从server端拷贝启动文件
root@ogg1:/root/zabbix-2.4.2/misc/init.d/fedora/core-->scp zabbix_agentd 192.168.6.237:/root/
root@rac1:/root-->mv zabbix_agentd /etc/init.d/ root@rac1:/root-->vim /etc/init.d/zabbix_agentd root@rac1:/root-->chmod +x /etc/init.d/zabbix_agentd
##注意增加如下修改 修改如下：
# Zabbix-Directory
BASEDIR=/usr/local/zabbix
CONFILE=$BASEDIR/conf/zabbix_agentd.conf
action $\
root@rac1:/root-->groupadd zabbix
root@rac1:/root-->useradd -g zabbix -d /home/zabbix zabbix root@rac1:/root-->passwd zabbix
root@rac1:/root-->chown -R zabbix:zabbix /usr/local/zabbix/
root@rac1:/root-->chown -R zabbix:zabbix /etc/init.d/zabbix_agentd root@rac1:/root-->service zabbix_agentd start
Starting zabbix_agentd: [ OK ]
##配置监控mysql,去
http://www.percona.com/doc/percona-monitoring-plugins/1.1/ 网站下载percona开发的mysql监控脚本；
root@rac1:/root-->rpm -ivh percona-zabbix-templates-1.1.4-1.noarch.rpm warning: percona-zabbix-templates-1.1.4-1.noarch.rpm: Header V4 DSA signature: NOKEY, key ID cd2efd2a
Preparing... ########################################### [100%] 1:percona-zabbix-template########################################### [100%]
Scripts are installed to /var/lib/zabbix/percona/scripts Templates are installed to /var/lib/zabbix/percona/templates
root@rac1:/var/lib/zabbix/percona/templates-->cp
userparameter_percona_mysql.conf /usr/local/zabbix/conf/zabbix_agentd/ root@rac1:/usr/local/zabbix/conf/zabbix_agentd-->service zabbix_agentd restart
Shutting down zabbix_agentd: [ OK ] Starting zabbix_agentd: [ OK ]
##修改mysql用户密码
root@rac1:/var/lib/zabbix/percona/scripts-->vim ss_get_mysql_stats.php
官方文档说明：
http://www.percona.com/doc/percona-monitoring-plugins/1.1/zabbix/index.html#installation-instructions
root@rac1:/home/mysql/mysql-5.6.22/lib-->/usr/bin/php -q
/var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php --host 192.168.6.237 --items gg
PHP Warning: PHP Startup: Unable to load dynamic library
'/usr/lib64/php/modules/mysql.so' - /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/lib64/php/modules/mysql.so) in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library
'/usr/lib64/php/modules/mysqli.so' - /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/lib64/php/modules/mysqli.so) in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library
'/usr/lib64/php/modules/pdo_mysql.so' - /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by
/usr/lib64/php/modules/pdo_mysql.so) in Unknown on line 0 PHP MySQLi extension is not loaded
root@rac1:/home/mysql/mysql-5.6.22/lib-->wget
http://files.directadmin.com/services/es_5.0_64/libmysqlclient.so.15
root@rac1:/root-->chmod 755 /usr/lib64/libmysqlclient.so.15 ##使用如下命令测试看能否取到值
root@rac1:/var/lib/zabbix/percona/scripts-->./get_mysql_stats_wrapper.sh gg 2
root@rac1:/var/lib/zabbix/percona/scripts-->
成功鸟
注意事项：
1. 修改get_mysql_stats_wrapper.sh如下红色字体部分
root@rac1:/var/lib/zabbix/percona/scripts-->vim get_mysql_stats_wrapper.sh HOST=127.0.0.1
RES=`HOME=~zabbix /home/mysql/mysql-5.6.22/mysql -uroot -p123456 -e 'SHOW SLAVE STATUS\\G' | egrep '(Slave_IO_Running|Slave_SQL_Running):' | awk -F: '{print $2}' | tr '\\n' ','`
2. 修改127.0.0.1-mysql_cacti_stats.txt属主
root@rac1:/tmp-->chown zabbix:zabbix 127.0.0.1-mysql_cacti_stats.txt
For Oracle
zabbix通过orabbix插件来监控Oracle数据库
可以去如下网址下载http://www.smartmarmot.com/product/orabbix/download/ Orabbix-1.2.3.zip
orabbix是使用java写的工具，需要java环境的支持；安装下最新java，
root@rac1:/opt/orabbix-->yum install java-1.7.0-openjdk.x86_64
在zabbix agent端执行
root@rac1:/root-->mkdir -p /opt/orabbix
root@rac1:/opt/orabbix-->cp /root/orabbix-1.2.3.zip /opt/orabbix/ root@rac1:/root-->cd /opt/orabbix/
root@rac1:/root-->chmod –R a+x /opt/orabbix/ root@rac1:/opt/orabbix-->unzip orabbix-1.2.3.zip ##生成修改配置文件从sample拷贝
root@rac1:/opt/orabbix-->cp conf/config.props.sample conf/config.props root@rac1:/opt/orabbix-->vim conf/config.props root@rac1:/opt/orabbix/conf-->cat config.props #comma separed list of Zabbix servers
ZabbixServerList=ZabbixServer1 ##配置zabbix主机名称
ZabbixServer1.Address=192.168.6.182 ##主机地址 ZabbixServer1.Port=10051 ##主机端口
ZabbixServer2.Address=IP_ADDRESS_OF_ZABBIX_SERVER ZabbixServer2.Port=PORT_OF_ZABBIX_SERVER
#pidFile
OrabbixDaemon.PidFile=./logs/orabbix.pid #frequency of item's refresh OrabbixDaemon.Sleep=300
#MaxThreadNumber should be >= than the number of your databases OrabbixDaemon.MaxThreadNumber=100