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_SQL;            EXECUTE STMT;            DEALLOCATE PREPARE STMT;    END IF;

END$$
DELIMITER ;

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

—————————————只是解释不执行————————————————-
CALL partition_maintenance(‘’, ‘’, , , )

CALL partition_maintenance（’zabbix’，’history’，31，24，32）;
zabbix_db_name：库名
table_name：表名
days_to_keep_data：保存多少天的数据
hourly_interval：每隔多久生成一个分区
num_future_intervals_to_create：本次一共生成多少个分区

这个例子就是history表最多保存31天的数据，每隔24小时生成一个分区，这次一共生成32个分区

下面是改进过的存储过程，可以
《———————zabbix数据库导入以后，登陆mysql 复制下面所有语句，直接执行即可———————————–》
DELIMITER

CREATEPROCEDURE‘partitionmaintenanceall‘(SCHEMANAMEVARCHAR(32))BEGINCALLpartitionmaintenance(SCHEMANAME,′history′,31,24,32);CALLpartitionmaintenance(SCHEMANAME,′historylog′,31,24,32);CALLpartitionmaintenance(SCHEMANAME,′historystr′,31,24,32);CALLpartitionmaintenance(SCHEMANAME,′historytext′,31,24,32);CALLpartitionmaintenance(SCHEMANAME,′historyuint′,31,24,32);CALLpartitionmaintenance(SCHEMANAME,′trends′,730,24,14);CALLpartitionmaintenance(SCHEMANAME,′trendsuint′,730,24,32);END

DELIMITER ;
CALL partition_maintenance_all(‘zabbix’);

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

分区现在都在数据库中设置，生活现在全都是热衷的。只需要记住一件事，我强调，你不能忘记这一点：不要让你的数据库用尽分区。记住提供的示例创建32天的额外分区？这意味着Zabbix可以运行长达32天而没有任何问题。在第33天，数据库将无法粘贴历史/趋势数据，因此数据丢失将发生。您必须记住，经常（通过cron或其他方法）重新运行这些存储过程（只是“partition_maintenance_all”）。通过这样做，将始终存在可以插入数据的分区。

添加定时任务：
1 5 1 * * mysql -uzabbix -pzabbix zabbix -e “CALL partition_maintenance_all(‘zabbix’);”

zabbix_web修改 一般—–》管家