Zabbix problem with Percona XtraDB Cluster

[zemzema]

Hi,

I'm trying to use latest version of Zabbix with Percona XtraDB Cluster for MySQL 5.7.x.
To my regret, such a combination does not work. Since percona as well as some other cluster systems when working in enforcing mode require that all tables have primary keys, and that is not case with Zabbix.

2021-11-22T12:44:39.893391Z 56545 [ERROR] WSREP: Percona-XtraDB-Cluster prohibits use of DML command on a table (zabbix.history) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER
2021-11-22T12:44:39.894436Z 56546 [ERROR] WSREP: Percona-XtraDB-Cluster prohibits use of DML command on a table (zabbix.history_uint) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER


Would adding artificial primary keys to these tables affect the operation of Zabbix, also does Zabbix have some solution for this?

Something for other software I have found on other forum:
This problem affects any type of MySQL cluster, not only Percona. Galera (default for MariaDB) or MySQLCluster are also affected. Products Like SkySQL or managed DBs like DigitalOcean, Scaleway, etc, all cluster based, are problematic.

So please Zabbix crew add primary keys to all tables.

[zemzema]

Got answer.

There is also the config table that doesn't have primary key. It only contains one row, so feel free to add a primary key there manually if you need to use XtraDB Cluster.
PS, with 6.0, we only support Mysql/Percona 8.0.X

[cyber]

I'd suggest to report the issue directly https://support.zabbix.com/projects/ZBX
It might get more attention...

[zemzema]

Got answer.

There is also the config table that doesn't have primary key. It only contains one row, so feel free to add a primary key there manually if you need to use XtraDB Cluster.
PS, with 6.0, we only support Mysql/Percona 8.0.X