Zabbix table structure not compatible with InnoDB Group Replication for any version

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Trivial
    • None
    • Affects Version/s: 3.0.30, 3.0.31, 4.0.21, 4.0.22, 5.0.0, 5.0.1
    • Component/s: Server (S)
    • Environment:
      MySQL any version with InnoDB Group Replication plugin

      Missing PRIMARY INDEX in tables:
      'zabbix','dbversion'
      'zabbix','history'
      'zabbix','history_log'
      'zabbix','history_str'
      'zabbix','history_text'
      'zabbix','history_uint'

      don't let using zabbix-server in modern environments.
      Group Replication requires to have PK in every table.

      This is so funny:
      https://assets.zabbix.com/files/zabbix_summit_2019/Vittorio_Cioe-Scaling_Zabbix_with_MySQL_InnoDB_Cluster.pdf

      What's purpose of this presentation if zabbix & innodb cluster 100% incompatible?

            Assignee:
            Zabbix Support Team
            Reporter:
            Yury T
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: