There is nethserver-rh-mariadb105 to install rh-mariadb10.5 alongside other mariadb versions (not to replace the main/default one). It is used, for instance, by NethServer’s Nextcloud and GLPI implementations. Surely some tweaks to zabbix config would be required to point it to the right mariadb version (do not know the specifics, though).
There is a community maintanined zabbix module but not yet for zabbix 6. There is some work to port from zabbix 5 to zabbix 6 but with docker containers.