Upgrading a Zabbix database from older MariaDB versions to MariaDB 10.6

For our Zabbix 6 installation, we are going to need MariaDB 10.5 or a newer supported version, 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.

This recipe details how to upgrade MariaDB to the latest stable version, which is MariaDB 10.6 at the time of writing.

Getting ready

For this recipe, we will need our server which we called lar-book-zbx5. At this point, the server is running a RHEL8-based distribution.

Another option is that you have a server running a Debian-based distribution like Ubuntu 18.04, Debian 10, or a newer version of those Linux distributions. We will be upgrading the MariaDB instance on this server to version 10.6.

If you've followed the Optionally upgrading the Zabbix backend from PHP 7.2 to PHP 7.4 recipe, your server will now be running PHP version 7.4. If not, it...