Details

    • Type: Enhancement
    • Status: Triage (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.0.2
    • Fix Version/s: None
    • Component/s: Database
    • Labels:
      None
    • Docs QE Status:
      NEW
    • QE Status:
      NEW

      Description

      Hi, we are trying to setup Keycloak on our environment which is running on a MySQL Enterprise server with Group Replication enabled, but we receive an error from the DB server during database provisioning:

      Plugin group_replication reported: 'Table DATABASECHANGELOG does not have any PRIMARY KEY. This is not compatible with Group Replication.'
      

      The Group Replication feature in MySQL Enterprise imposes some constraints on the database schema and usage (i.e. https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html , https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html ), but if all that it complains about are missing primary keys on some tables it looks like it could be fixed with little effort.
      Does anybody have any previous research on that?

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                l.scorcia Luca Leonardo Scorcia
              • Votes:
                2 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: