Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20511

Galera replication of events is not consistent

    XMLWordPrintable

Details

    Description

      Refs: https://bugs.launchpad.net/codership-mysql/+bug/1312618 https://jira.percona.com/browse/PXC-999

      MariaDB Galera has following problems based on mtr testing:

      • After SST from master node (the one where event is ENABLED) - you will end up with the event enabled on two nodes, hence it's now being executed twice. It can be solved by comparing event's originator with server_id. if not equal, then change its status to 'SLAVESIDE_DISABLED'
      • If event owner node is re-created using SST, all the nodes have the event now in "SLAVESIDE_DISABLED" state, hence manual action is needed to re-enable the event on one of the nodes. This requirement of the manual action will be documented.

      Attachments

        Issue Links

          Activity

            People

              jplindst Jan Lindström (Inactive)
              jplindst Jan Lindström (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.