mysql优化三板斧
http://www.woqutech.com/?p=1200
zabbix的数据存到mysql中，后期会有IO瓶颈，提前做好规划。
zabbix官网
http://www.zabbix.com/
https://github.com/leonanu/moss/
（lamp等环境自动部署）
安装依赖（配置好网络yum源）
yum -y install gcc gcc-c++ autoconf httpd php mysql mysql-server php-mysql httpd-manual mod_ssl
mod_perl mod_auth_mysql php-gd php-xml php-mbstring php-ldap php-pear php-xmlrpc php-bcmath
mysql-connector-odbc mysql-devel libdbi-dbd-mysql net-snmp-devel curl-devel unixODBC-devel
OpenIPMI-devel java-devel libssh2-devel openldap
修改php
sed -i "s/;date.timezone =/date.timezone = Asia\/Shanghai/g" /etc/php.ini
sed -i "s#max_execution_time = 30#max_execution_time = 300#g" /etc/php.ini
sed -i "s#post_max_size = 8M#post_max_size = 32M#g" /etc/php.ini
sed -i "s#max_input_time = 60#max_input_time = 300#g" /etc/php.ini
sed -i "s#memory_limit = 128M#memory_limit = 128M#g" /etc/php.ini
#sed -i "/;mbstring.func_overload = 0/ambstring.func_overload = 2\n" /etc/php.ini
开启mysql，apache
chkconfig mysqld on
chkconfig httpd on
service mysqld start
service httpd start
安装（也可以直接yum安装）
groupadd zabbix -g 201
useradd -g zabbix -u 201 -m zabbix
cd /usr/local/src/zabbix-2.4.6
./configure --prefix=/usr/local/zabbix --sysconfdir=/etc/zabbix --enable-server --enable-proxy
--enable-agent --enable-ipv6 --with-mysql=/usr/bin/mysql_config --with-net-snmp --with-libcurl
--with-openipmi --with-unixodbc --with-ldap --with-ssh2 --enable-java（某些功能不需要可以不写）
make && make install
创建mysql库导入数据
mysql -uroot -e "create database zabbix character set utf8;"
mysql -uroot -e "grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbix';"
mysql -uroot -e "flush privileges;"
mysql -uzabbix -pzabbix zabbix < ./database/mysql/schema.sql
mysql -uzabbix -pzabbix zabbix < ./database/mysql/images.sql
mysql -uzabbix -pzabbix zabbix < ./database/mysql/data.sql
zabbix的web界面和log目录
cp -r ./frontends/php/ /var/www/html/zabbix
chown -R apache.apache /var/www/html/zabbix
mkdir /var/log/zabbix
chown zabbix.zabbix /var/log/zabbix
启动脚本
cp misc/init.d/fedora/core/zabbix_* /etc/init.d/
chmod 755 /etc/init.d/zabbix_*
配置
sed -i "s#BASEDIR=/usr/local#BASEDIR=/usr/local/zabbix#g" /etc/init.d/zabbix_server
sed -i "s#BASEDIR=/usr/local#BASEDIR=/usr/local/zabbix#g" /etc/init.d/zabbix_agentd
sed -i "s#tmp/zabbix_server.log#var/log/zabbix/zabbix_server.log#g" /etc/zabbix/zabbix_server.conf
sed -i "s/ServerActive\=127.0.0.1/ServerActive\=127.0.0.1:10051/g" /etc/zabbix/zabbix_agentd.conf
sed -i "s#tmp/zabbix_agentd.log#var/log/zabbix/zabbix_agentd.log#g" /etc/zabbix/zabbix_agentd.conf
sed -i "#UnsafeUserParameters=0#aUnsafeUserParameters=1\n" /etc/zabbix/zabbix_agentd.conf
chkconfig zabbix_server on
chkconfig zabbix_agentd on
service zabbix_server start
service zabbix_agentd start
----------------------------------------------------------------------------
yum安装
rpm -ivh http://repo.zabbix.com/zabbix/2.4/rhel/6/x86_64/zabbix-release-2.4-1.el6.noarch.rpm
yum install zabbix-server-mysql zabbix-web-mysql zabbix-server
# cd /usr/share/doc/zabbix-server-mysql-2.4.0/create
# mysql -uroot zabbix < schema.sql
# mysql -uroot zabbix < images.sql
# mysql -uroot zabbix < data.sql
# vi /etc/zabbix/zabbix_server.conf
DBHost=localhost
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix
StartPollers=10
StartPollersUnreachable=80
StartTrappers=15
StartPingers=4
StartDiscoverers=0
HousekeepingFrequency=1
CacheSize=384M
CacheUpdateFrequency=300
StartDBSyncers=8
HistoryCacheSize=512M
TrendCacheSize=384M
HistoryTextCacheSize=512M
Timeout=30
LogSlowQueries=1000
Include=/usr/local/zabbix/etc/zabbix_server.conf.d/
#AlertScriptsPath=/usr/local/zabbix/alertscripts
#ExternalScripts=/usr/local/zabbix/externalscripts
#FpingLocation=/usr/local/sbin/fping
# service zabbix-server start