Setting up MySQL partitioning for your Zabbix database

When working with a MySQL database, the biggest issue we face is how MySQL stores its data by default. There is no real order to the data that we can use if we want to drop large chunks of data. MySQL partitioning solves this issue; let’s see how we can configure it to use for our Zabbix database.

Important note

Here at Opensource ICT Solutions, we have fixed the script to work with MySQL 8. The script should work for any MySQL setup once more. Check out the link for more information: https://github.com/OpensourceICTSolutions/zabbix-mysql-partitioning-perl.

Getting ready

For this recipe, we are going to need a running Zabbix server with a MySQL database. I’ll be using MariaDB in my example, but any MySQL flavor should be about the same. The Linux host I’ll be using is called lar-book-mysql-mgmt, which already meets the requirements.

If you are running these steps in a production environment,...