Zabbix 4 Network Monitoring - Third Edition

Database versioning

With all of this talk about the database version and schema changes, let's take a closer look at how version information is stored and how we can check the upgrade status. Examine the dbversion table in your Zabbix database:

 mysql> select * from dbversion;
 +-----------+----------+
 | mandatory | optional |
 +-----------+----------+
 |   4000000 |  4000003 |
 +-----------+----------+
 1 row in set (0.00 sec) 

This table is the way Zabbix components determine which version of the database schema they're dealing with. There're two numbers in there: the mandatory and optional versions. The following rules are important regarding version numbers:

• Inside one major version, the mandatory version number is always the same
• If a more ...