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.