For all interested, this functionality will deliver huge improvements in usability (almost instant configuration sync) and much better performance for mid and large setups due to dismissal of full configuration sync. At this moment it is planned for Zabbix 6.2, but depending on test results might be postponed to Zabbix 6.4.

One additional note. This will be the first introduction of database triggers for all databases in Zabbix.

I've been wondering if it would be feasable for zabbix frontend send a signal to zabbix server instead of database triggers?

It looks easier because its just two components that already talk to each other, instead of few different databases that change overtime and we do not have any control of.

Hi DevTeam,
I would like to mention that during the Upgrade from 6.2beta2 to 6.2rc1 I have found a problem on MySQL 8.x.
The DB Upgrade failed with this message:

You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

So to Fix it I have add the option: "log_bin_trust_function_creators = 1" on my.cnf config file.

Please update the documentation if this parameters is needed for "immediate configuration sync".

Thanks so much

Best regards

Where is the Zabbix documentation (as requested above) and/or upgrade note for this?

What is the official recommended fix by Zabbix developers?

The error occurs apparently on every MySQL and MariaDB server when installing/upgrading to 6.2 AND have binary logging enabled.

https://mariadb.com/kb/en/replication-and-binary-log-system-variables/#log_bin_trust_function_creators says:

"Functions and triggers can be dangerous when used with replication. Certain types of functions and triggers may have unintended consequences when the statements are applied on a replica. For that reason, there are some restrictions on the creation of functions and triggers when the binary log is enabled by default, such as: [...]"

So, when using database replication, is it safe to use Zabbix 6.2 (after implementing this ZBXNEXT)?

(Duh, apparently I had typoed something when I didn't find it in the documentation earlier, my bad.)

https://www.zabbix.com/documentation/current/en/manual/appendix/install/db_scripts says "This step is not required for MariaDB", which is debatable (= not required if binary logging is disabled).

Thank you for your questions markkul documentation will be improved.

Thank you for your attention and answers!

Very interesting discussion. There is one thing I don't understand: If the setting is not necessary for MariaDB, is the new feature available on MariaDB at all, or only for MySQL?

Based on my testing with MariaDB 10.5.15 (by Debian 11), that change (SUPER privilege or log_bin_trust_function_creators) is required, IF binary logging is enabled.

If binary logging is disabled (= the default in MariaDB 10.5.15 by Debian 11), then no special configurations are required.

(binary logging = log_bin configuration setting in MariaDB)

I suggest, for now, at least, to copy the Database Creation reference to the Upgrade Procedure documentation.

But that doesn't answer my question: Is the new feature available on MariaDB at all, or only for MySQL?

It's available on MySQL, MariaDB, PostgreSQL and Oracle database

okay, thank you very much! As I only just recently moved to 6.0, I wait for the docs to be updated and reviewed, before I upgrade to 6.2, and will then check the documentation again, what I really have to do with Debian 11 (12) and Zabbix 6.2 on MariaDB 10.7 (10.8).

Documentation updated:

•  What's new in 6.2.0
•  Upgrade notes for 6.2.0
• Upgrade from sources in 6.2, 6.4
• Upgrade from packages - RHEL in 6.2, 6.4
• Upgrade from packages - Debian/Ubuntu in 6.2, 6.4
• Database creation in 6.2, 6.4