Hello,
I made a Python version of the Perl script project by OpenSource ICT Solutions detailed in the Zabbix Blog on partitioning MySQL 8, mostly because my perl skills are non-existent and I wanted something I could extend if I needed to. The project can be found here:
https://gitlab.com/jhboricua/zabbix-mysql-partitioning/
The script can be run on directly on a server or as in a Docker/Podman container. Both can be scheduled via cron or systemd-timers. There's also a separate Python script to generate the queries needed to do the initial partitioning of the database. I've tested it on Zabbix 6 and 7 running MySQL 8.x and MariaDB 10.x backends. The README file has all the details. Hopefully this helps anyone looking to partition their MySQL/MariaDB Zabbix database.
I made a Python version of the Perl script project by OpenSource ICT Solutions detailed in the Zabbix Blog on partitioning MySQL 8, mostly because my perl skills are non-existent and I wanted something I could extend if I needed to. The project can be found here:
https://gitlab.com/jhboricua/zabbix-mysql-partitioning/
The script can be run on directly on a server or as in a Docker/Podman container. Both can be scheduled via cron or systemd-timers. There's also a separate Python script to generate the queries needed to do the initial partitioning of the database. I've tested it on Zabbix 6 and 7 running MySQL 8.x and MariaDB 10.x backends. The README file has all the details. Hopefully this helps anyone looking to partition their MySQL/MariaDB Zabbix database.