zabbix3.4 server、proxy安装配置优化、数据库分区

**

持续集成、自动化部署、弹性伸缩教程 http://edu.csdn.net/course/detail/6452

**

1.安装zabbix3.4所需要的依赖包
yum -y install gcc gcc-c++ autoconf httpd php mysql 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 libdi-bdbi-mysql net-snmp-devel curl-devel unixODBC-devel OpenIPMI-devel java-devel openldap openldap-devel libssh2-devel libxml2 libxml2-devel libevent*

2.修改php所需要配置的环境
vi /etc/php.ini
date.timezone = Asia/Chongqing
max_execution_time = 300
post_max_size = 32M
max_input_time = 300
memory_limit = 128M
mbstring.func_overload = off
always_populate_raw_post_data= -1

3.添加zabbix用户
groupadd zabbix -g 201
useradd -g zabbix -u 201 -m zabbix

4.下载安zabbix3.4装包编译安装
wget https://nchc.dl.sourceforge.net/project/zabbix/ZABBIX%20Latest%20Stable/3.4.1/zabbix-3.4.1.tar.gz
./configure –prefix=/usr/local/zabbix –enable-server –enable-agent –enable-ipv6 –with-mysql=/usr/bin/mysql_config –with-net-snmp –with-libcurl –with-libxml2 –with-openipmi –with-unixodbc –with-ldap –with-ssh2 –enable-java &&make install

5.准备mysql数据库 安装分区教程见文档最后
chkconfig mysqld on
service mysqld start
mysql -e “create database zabbix character set utf8;”
mysql -e “grant all privileges on zabbix.* to zabbix@localhost identified by ‘zabbix’;
flush privileges;”
mysql -uroot zabbix < database/mysql/schema.sql
mysql -uroot zabbix < database/mysql/images.sql #如果只是代理可以不用导入这个数据库
mysql -uroot zabbix < database/mysql/data.sql #如果只是代理可以不用导入这个数据库

6.复制service启动脚本
cp misc/init.d/fedora/core/zabbix_* /etc/init.d/
chmod 755 /etc/init.d/zabbix_*
vim /etc/init.d/zabbix_server
BASEDIR=/usr/local/zabbix
vim /etc/init.d/zabbix_agentd
BASEDIR=/usr/local/zabbix

7.配置zabbix_server.conf服务器端文件
vim /usr/local/zabbix/etc/zabbix_server.conf
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix

8.复制zabbix网页文件到apache目录
cp -r frontends/php/ /var/www/html/zabbix
chown -R apache.apache /var/www/html/zabbix/

9.启动zabbix并测试
chkconfig httpd on
chkconfig zabbix_agentd on
chkconfig zabbix_server on
service httpd restart
service zabbix_server start
service zabbix_agentd restart
http://ip/zabbix 配置连接用户，下载文件，默认的登陆用户名admin，密码为zabbix

——————————————zabbix_server配置文件————————————-
[root@ZabbixServer etc]# cat zabbix_server.conf |grep -v ^# |grep -v ^$
LogFile=/tmp/zabbix_server.log
DBHost=192.168.110.5
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix
StartPollers=500
StartPollersUnreachable=50
StartTrappers=10
StartPingers=10
StartDiscoverers=10
StartHTTPPollers=10
StartTimers=10
StartEscalators=10
StartAlerters=6
SNMPTrapperFile=/tmp/zabbix_traps.tmp
StartSNMPTrapper=1
CacheSize=2048M
CacheUpdateFrequency=60
StartDBSyncers=50
HistoryCacheSize=80M
HistoryIndexCacheSize=20M
TrendCacheSize=512M
ValueCacheSize=1024M
Timeout=4
AlertScriptsPath=/usr/local/zabbix/scripts
FpingLocation=/usr/sbin/fping
LogSlowQueries=3000

——————————————proxy安装配置————————————————–
1.安装zabbix3.4所需要的依赖包
yum -y install gcc gcc-c++ autoconf httpd php mysql 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 libdi-bdbi-mysql net-snmp-devel curl-devel unixODBC-devel OpenIPMI-devel java-devel openldap openldap-devel libssh2-devel libxml2 libxml2-devel libevent*

2.添加zabbix用户
groupadd zabbix -g 201
useradd -g zabbix -u 201 -m zabbix

3.下载安zabbix3.4装包编译安装
wget https://nchc.dl.sourceforge.net/project/zabbix/ZABBIX%20Latest%20Stable/3.4.1/zabbix-3.4.1.tar.gz

./configure –prefix=/usr/local/zabbix –enable-proxy –enable-agent –enable-ipv6 –with-mysql=/usr/bin/mysql_config –with-net-snmp –with-libcurl –with-libxml2 –with-openipmi –with-unixodbc –with-ldap –with-ssh2 –enable-java &&make install

4.准备mysql数据库 安装教程分区见文档最后
chkconfig mysqld on
service mysqld start
mysql -e “create database zabbix character set utf8;”
mysql -e “grant all privileges on zabbix.* to zabbix@localhost identified by ‘zabbix’;
flush privileges;”
mysql -uroot zabbix < database/mysql/schema.sql proxy只需要导入此sql
use zabbix;
source /root/zabbix-3.4.1/database/mysql/schema.sql

5.复制service启动脚本
cp misc/init.d/fedora/core/zabbix_agentd /etc/init.d/
chmod 755 /etc/init.d/zabbix_agentd
vim /etc/init.d/zabbix_agentd
BASEDIR=/usr/local/zabbix

9.启动zabbix agentd proxy 并测试
chown -R zabbix.zabbix /usr/local/zabbix
chkconfig zabbix_agentd on
service zabbix_agentd restart
chmod +x /etc/rc.d/rc.local
echo /usr/local/zabbix/sbin/zabbix_proxy >> /etc/rc.local
/usr/local/zabbix/sbin/zabbix_proxy
——————————————zabbix_proxy配置文件————————————————–
[root@cobbler150 etc]# cat zabbix_proxy.conf
Server=192.168.110.2
Hostname=150-2proxy
LogFile=/tmp/zabbix_proxy.log
DBHost=localhost
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix
DBSocket=/tmp/mysql.sock
ConfigFrequency=60
DataSenderFrequency=10
StartPollers=300
StartPollersUnreachable=10
StartTrappers=10
StartPingers=10
StartDiscoverers=20
StartHTTPPollers=10
CacheSize=2048M
StartDBSyncers=10
HistoryCacheSize=1024M
HistoryIndexCacheSize=256M
Timeout=4
FpingLocation=/usr/sbin/fping
LogSlowQueries=3000

—————————————————mysql5.7安装配置————————- ——
2:下载mysql5.7的二进制包
wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

3:解压二进制包并放在安装目录
tar xf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.17-linux-glibc2.5-x86_64 /usr/local/mysql

4:添加mysql用户
useradd -s /sbin/nologin mysql

5：初始化数据库
rm -rf /etc/my.cnf
yum -y install autoconf
chown -R mysql.mysql /usr/local/mysql/
/usr/local/mysql/bin/mysqld –initialize –user=mysql –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data
注意初始密码
/usr/local/mysql/bin/mysql_ssl_rsa_setup –datadir=/usr/local/mysql/data
数据库ssl证书生成

6:复制配置文件

vim /etc/my.cnf

[client]
port = 3306
default-character-set = utf8
[mysqld]
skip-name-resolve
user = mysql
basedir = /usr/local/mysql/
datadir = /usr/local/mysql/data
port = 3306
server_id = 3306
log-error = /usr/local/mysql/data/error.log
log-bin = /usr/local/mysql/data/bin.log
slow-query-log-file=/usr/local/mysql/data/slow.log
long_query_time = 2000
innodb_buffer_pool_size = 5120M
query_cache_type=1
query_cache_size=64M
log-queries-not-using-indexes=0
character-set-server = utf8

7:设置mysql开机自启动

chown mysql.mysql /etc/my.cnf
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig mysqld on
echo “export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib” >>/etc/profile
source /etc/profile

8:启动mysql
service mysqld start

9:修改mysql的root密码
用初始密码登陆mysql
alter user ‘root’@’localhost’ identified by ‘ww930712’;

10：运行安全脚本设置
/usr/local/mysql/bin/mysql_secure_installation
1：是否需要安装密码插件，输入N ,跳过
2：此处需要输入上一步骤mysql设置的root密码
3：运维此脚本的主要作用：为root用户设置密码，删除匿名用户，取消root用户远程登陆，
删除test库和对test库的访问权限；刷新授权表使修改生效

——————————–zabbix 数据库分区 ，zabbix server proxy 都需要做分区——————-
参考文档： https://www.zabbix.org/wiki/Docs/howto/mysql_partition#Index_changes_.282.x.2C_3.0_only.29
3.2以上包括3.2安装如下分区 ：

《———————zabbix数据库导入以后，登陆mysql 复制一下所有语句，直接执行即可———————————–》

DELIMITER $$
CREATE PROCEDURE partition_create(SCHEMANAME varchar(64), TABLENAME varchar(64), PARTITIONNAME varchar(64), CLOCK int)
BEGIN
/*
SCHEMANAME = The DB schema in which to make changes
TABLENAME = The table with partitions to potentially delete
PARTITIONNAME = The name of the partition to create
*/
/*
Verify that the partition does not already exist
*/

    DECLARE RETROWS INT;
    SELECT COUNT(1) INTO RETROWS
    FROM information_schema.partitions
    WHERE table_schema = SCHEMANAME AND table_name = TABLENAME AND partition_description >= CLOCK;

    IF RETROWS = 0 THEN
            /*
               1. Print a message indicating that a partition was created.
               2. Create the SQL to create the partition.
               3. Execute the SQL from #2.
            */
            SELECT CONCAT( "partition_create(", SCHEMANAME, ",", TABLENAME, ",", PARTITIONNAME, ",", CLOCK, ")" ) AS msg;
            SET @sql = CONCAT( 'ALTER TABLE ', SCHEMANAME, '.', TABLENAME, ' ADD PARTITION (PARTITION ', PARTITIONNAME, ' VALUES LESS THAN (', CLOCK, '));' );
            PREPARE STMT FROM @sql;
            EXECUTE STMT;
            DEALLOCATE PREPARE STMT;
    END IF;

END$$
DELIMITER ;

DELIMITER $$
CREATE PROCEDURE partition_drop(SCHEMANAME VARCHAR(64), TABLENAME VARCHAR(64), DELETE_BELOW_PARTITION_DATE BIGINT)
BEGIN
/*
SCHEMANAME = The DB schema in which to make changes
TABLENAME = The table with partitions to potentially delete
DELETE_BELOW_PARTITION_DATE = Delete any partitions with names that are dates older than this one (yyyy-mm-dd)
*/
DECLARE done INT DEFAULT FALSE;
DECLARE drop_part_name VARCHAR(16);

    /*
       Get a list of all the partitions that are older than the date
       in DELETE_BELOW_PARTITION_DATE.  All partitions are prefixed with
       a "p", so use SUBSTRING TO get rid of that character.
    */
    DECLARE myCursor CURSOR FOR
            SELECT partition_name
            FROM information_schema.partitions
            WHERE table_schema = SCHEMANAME AND table_name = TABLENAME AND CAST(SUBSTRING(partition_name FROM 2) AS UNSIGNED) < DELETE_BELOW_PARTITION_DATE;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    /*
       Create the basics for when we need to drop the partition.  Also, create
       @drop_partitions to hold a comma-delimited list of all partitions that
       should be deleted.
    */
    SET @alter_header = CONCAT("ALTER TABLE ", SCHEMANAME, ".", TABLENAME, " DROP PARTITION ");
    SET @drop_partitions = "";

    /*
       Start looping through all the partitions that are too old.
    */
    OPEN myCursor;
    read_loop: LOOP
            FETCH myCursor INTO drop_part_name;
            IF done THEN
                    LEAVE read_loop;
            END IF;
            SET @drop_partitions = IF(@drop_partitions = "", drop_part_name, CONCAT(@drop_partitions, ",", drop_part_name));
    END LOOP;
    IF @drop_partitions != "" THEN
            /*
               1. Build the SQL to drop all the necessary partitions.
               2. Run the SQL to drop the partitions.
               3. Print out the table partitions that were deleted.
            */
            SET @full_sql = CONCAT(@alter_header, @drop_partitions, ";");
            PREPARE STMT FROM @full_sql;
            EXECUTE STMT;
            DEALLOCATE PREPARE STMT;

            SELECT CONCAT(SCHEMANAME, ".", TABLENAME) AS `table`, @drop_partitions AS `partitions_deleted`;
    ELSE
            /*
               No partitions are being deleted, so print out "N/A" (Not applicable) to indicate
               that no changes were made.
            */
            SELECT CONCAT(SCHEMANAME, ".", TABLENAME) AS `table`, "N/A" AS `partitions_deleted`;
    END IF;

END$$
DELIMITER ;

DELIMITER $$
CREATE PROCEDURE partition_maintenance(SCHEMA_NAME VARCHAR(32), TABLE_NAME VARCHAR(32), KEEP_DATA_DAYS INT, HOURLY_INTERVAL INT, CREATE_NEXT_INTERVALS INT)
BEGIN
DECLARE OLDER_THAN_PARTITION_DATE VARCHAR(16);
DECLARE PARTITION_NAME VARCHAR(16);
DECLARE OLD_PARTITION_NAME VARCHAR(16);
DECLARE LESS_THAN_TIMESTAMP INT;
DECLARE CUR_TIME INT;

    CALL partition_verify(SCHEMA_NAME, TABLE_NAME, HOURLY_INTERVAL);
    SET CUR_TIME = UNIX_TIMESTAMP(DATE_FORMAT(NOW(), '%Y-%m-%d 00:00:00'));

    SET @__interval = 1;
    create_loop: LOOP
            IF @__interval > CREATE_NEXT_INTERVALS THEN
                    LEAVE create_loop;
            END IF;

            SET LESS_THAN_TIMESTAMP = CUR_TIME + (HOURLY_INTERVAL * @__interval * 3600);
            SET PARTITION_NAME = FROM_UNIXTIME(CUR_TIME + HOURLY_INTERVAL * (@__interval - 1) * 3600, 'p%Y%m%d%H00');
            IF(PARTITION_NAME != OLD_PARTITION_NAME) THEN
                    CALL partition_create(SCHEMA_NAME, TABLE_NAME, PARTITION_NAME, LESS_THAN_TIMESTAMP);
            END IF;
            SET @__interval=@__interval+1;
            SET OLD_PARTITION_NAME = PARTITION_NAME;
    END LOOP;

    SET OLDER_THAN_PARTITION_DATE=DATE_FORMAT(DATE_SUB(NOW(), INTERVAL KEEP_DATA_DAYS DAY), '%Y%m%d0000');
    CALL partition_drop(SCHEMA_NAME, TABLE_NAME, OLDER_THAN_PARTITION_DATE);

END$$
DELIMITER ;

DELIMITER $$
CREATE PROCEDURE partition_verify(SCHEMANAME VARCHAR(64), TABLENAME VARCHAR(64), HOURLYINTERVAL INT(11))
BEGIN
DECLARE PARTITION_NAME VARCHAR(16);
DECLARE RETROWS INT(11);
DECLARE FUTURE_TIMESTAMP TIMESTAMP;

    /*
     * Check if any partitions exist for the given SCHEMANAME.TABLENAME.
     */
    SELECT COUNT(1) INTO RETROWS
    FROM information_schema.partitions
    WHERE table_schema = SCHEMANAME AND table_name = TABLENAME AND partition_name IS NULL;

    /*
     * If partitions do not exist, go ahead and partition the table
     */
    IF RETROWS = 1 THEN
            /*
             * Take the current date at 00:00:00 and add HOURLYINTERVAL to it.  This is the timestamp below which we will store values.
             * We begin partitioning based on the beginning of a day.  This is because we don't want to generate a random partition
             * that won't necessarily fall in line with the desired partition naming (ie: if the hour interval is 24 hours, we could
             * end up creating a partition now named "p201403270600" when all other partitions will be like "p201403280000").
             */
            SET FUTURE_TIMESTAMP = TIMESTAMPADD(HOUR, HOURLYINTERVAL, CONCAT(CURDATE(), " ", '00:00:00'));
            SET PARTITION_NAME = DATE_FORMAT(CURDATE(), 'p%Y%m%d%H00');

            -- Create the partitioning query
            SET @__PARTITION_SQL = CONCAT("ALTER TABLE ", SCHEMANAME, ".", TABLENAME, " PARTITION BY RANGE(`clock`)");
            SET @__PARTITION_SQL = CONCAT(@__PARTITION_SQL, "(PARTITION ", PARTITION_NAME, " VALUES LESS THAN (", UNIX_TIMESTAMP(FUTURE_TIMESTAMP), "));");

            -- Run the partitioning query
            PREPARE STMT FROM @__PARTITION_SQ