Upgrading a Zabbix database from older MariaDB versions to MariaDB 10.5

For a Zabbix 5 installation we are going to need MariaDB 10.0.37 or later, so, it is a good idea to keep your database version up to date. MariaDB regularly makes improvements to how MySQL handles certain aspects of performance.

In this recipe, I will show you how to upgrade MariaDB to the now-latest version 10.5.

Getting ready

For this recipe, we will need our server called lar-book-zbx4. At this point, the server installed with CentOS 7 will be running Zabbix server 4.0 with MariaDB version 5.5.

Another option is that you have a server running Ubuntu 16.04, which already includes MariaDB version 10.0 by default. We will be upgrading the MariaDB instance on this server to version 10.5.

If you've followed the Upgrading the Zabbix backend from older PHP versions to PHP 7.2 or higher recipe, your server will now be running PHP version 7.2. If not, it's wise to follow that recipe first.

...