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

event may non stop replicate in circular semisync setup

    XMLWordPrintable

Details

    Description

      MDEV-21117 had to relax own events acceptance condition for a case when
      a former semisync master server recovers after crash as the semisync slave.
      That however admits a possibility for endless event "orbiting" in the semisync circular setup
      where the master is also a slave.

      As a work-around CHANGE MASTER TO ... ignore_domain_ids=(`own_domain_id`) can do,
      where own_domain_id is the value of this_server@@global.gtid_domain_id. The command should be invoked
      on every server node of the circle configuration.

      Also @@global.gtid_strict_mode = ON blocks any attempt to execute own event; the event circulation would stop, but the slave errors out.

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              Elkin Andrei Elkin
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.