zabbix 从3.0.1 升级到3.2.1

[root@server0 ~]# service zabbix_server stop
Shutting down zabbix_server: [确定]
[root@server0 ~]# service zabbix_agentd stop
Shutting down zabbix_agentd: [确定]
[root@server0 ~]# mv /usr/local/zabbix/ /usr/local/zabbix3.0
[root@server0 ~]# tar zxvf zabbix-3.2.1.tar.gz -C /usr/local/src
[root@server0 zabbix-3.2.1]# ./configure –prefix=/usr/local/zabbix –enable-server –enable-ipv6 –enable-agent –with-mysql –with-net-snmp –with-libcurl –with-libxml2 && make && make install
[root@server0 /]# mv /usr/local/zabbix/etc/zabbix_server.conf /usr/local/zabbix/etc/zabbix_server.conf.bak
[root@server0 /]# cp /usr/local/zabbix3.0/etc/zabbix_server.conf /usr/local/zabbix/etc/zabbix_server.conf
[root@server0 /]# mv /usr/local/zabbix/etc/zabbix_agentd.conf /usr/local/zabbix/etc/zabbix_agentd.conf.bak
[root@server0 /]# cp /usr/local/zabbix3.0/etc/zabbix_agentd.conf /usr/local/zabbix/etc/zabbix_agentd.conf
[root@server0 /]# service zabbix_server start
Starting zabbix_server: [确定]
此时如果不替换前端代码，直接访问zabbix web页面会有以下错误

[root@server0 /]#mv /usr/local/nginx/html/zabbix/ /usr/local/nginx/html/zabbix3.0
[root@server0 /]# cp -r /usr/local/src/zabbix-3.2.1/frontends/php/ /usr/local/nginx/html/zabbix
[root@server0 /]# cp /usr/local/nginx/html/zabbix3.0/conf/zabbix.conf.php /usr/local/nginx/html/zabbix/conf/
之后启动zabbix server，出现故障
[root@localhost html]# service zabbix_server start
Starting zabbix_server: [ OK ]
[root@localhost html]# service zabbix_server status
zabbix_server dead but subsys locked
[root@localhost ~]# ls /var/lock/subsys/
abrt-ccpp atd certmonger haldaemon local mysql nfsd rpc.rquotad xinetd
abrtd auditd cgconfig ksmtuned lvm2-monitor netfs rpcbind rpc.statd zabbix_server
abrt-oops autofs cpuspeed libvirtd mcelogd network rpc.idmapd rsyslog
acpid avahi-daemon cups libvirt-guests messagebus NetworkManager rpc.mountd sshd
查看日志/tmp/zabbix_server.log，提示无法对表problem_tag创建索引，Specified key was too long; max key length is 1000 bytes；
查看数据库zabbix的编码和表problem_tag的结构：
mysql> desc problem_tag;
+————–+———————+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+————–+———————+——+—–+———+——-+
| problemtagid | bigint(20) unsigned | NO | PRI | NULL | |
| eventid | bigint(20) unsigned | NO | MUL | NULL | |
| tag | varchar(255) | NO | | NULL | |
| value | varchar(255) | NO | | NULL | |
+————–+———————+——+—–+———+——-+
4 rows in set (0.00 sec)

mysql> show variables like ‘%char%’;
+————————–+—————————————-+
| Variable_name | Value |
+————————–+—————————————-+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
+————————–+—————————————-+
8 rows in set (0.00 sec)
修改字段长度：
mysql> alter table problem_tag change value value varchar(125) not null;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> alter table problem_tag change tag tag varchar(125) not null;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> desc problem_tag;
+————–+———————+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+————–+———————+——+—–+———+——-+
| problemtagid | bigint(20) unsigned | NO | PRI | NULL | |
| eventid | bigint(20) unsigned | NO | MUL | NULL | |
| tag | varchar(125) | NO | | NULL | |
| value | varchar(125) | NO | | NULL | |
+————–+———————+——+—–+———+——-+
4 rows in set (0.00 sec)

mysql> quit
Bye
成功启动
[root@localhost html]# service zabbix_server stop
Shutting down zabbix_server: [FAILED]
[root@localhost html]# service zabbix_server start
Starting zabbix_server: [ OK ]
[root@localhost html]# service zabbix_server status
zabbix_server (pid 30630 30629 30628 30627 30626 30625 30624 30623 30622 30621 30620 30619 30618 30617 30616 30615 30614 30612 30611 30610 30609 30608 30607 30606 30605 30604 30603 30598) is running…

注意：升级后，mysql数据库内容会自动更新，降级后库内数据不会自动降级，想降级必须提前备份数据库

参考：

http://www.linuxidc.com/Linux/2017-02/140480.htm
http://www.cnblogs.com/unchch/p/7495256.html
http://www.jb51.net/article/24499.htm
http://www.cnblogs.com/jun1019/p/6360452.html

MySQL相关参考
https://www.cnblogs.com/galengao/p/5755788.html
http://blog.51cto.com/zhongyilin/1369361
http://blog.csdn.net/lionhenryzxxy/article/details/58585716