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

event may non stop replicate in circular semisync setup

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

            Transition Time In Source Status Execution Times
            Sergei Golubchik made transition -
            Open Confirmed
            19h 16m 1
            Andrei Elkin made transition -
            Confirmed In Progress
            21m 18s 1
            Andrei Elkin made transition -
            In Progress In Review
            3d 5h 48m 1
            Andrei Elkin made transition -
            Stalled In Review
            3d 22h 11m 1
            Sergei Golubchik made transition -
            In Review Stalled
            14d 3h 1m 2
            Andrei Elkin made transition -
            Stalled In Progress
            13d 13h 51m 1
            Andrei Elkin made transition -
            In Progress Closed
            7d 9h 20m 1

            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.