Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-18043

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

    XMLWordPrintable

    Details

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

      Description

      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?

        Attachments

          Activity

            People

            Assignee:
            zabbix.support Zabbix Support Team
            Reporter:
            aero Yury T
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: