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

Ensure consistency of sequence number in Galera GTID Replication

    XMLWordPrintable

Details

    Description

      I created a first Galera node (with MariaDB 10.0.13 Galera). Then, i attached 2 another nodes. After a while, i created another cluster. But the gtid_domain_id was the same within the 2 clusters...
      It has broken a slave which was slave on both cluster (multi-master technology on mariadb 10.0.13 standalone).

      After a while, i found the problem being 2 cluster having the same GTID domain. So i changed online the gtid_domain_id on the first cluster. But as the instruction is not replicated, it was not played at the same time on the 3 nodes. After the change, the sequence number of the couple (domain_id-server_id) for the server_id of the first node was differents on the 3 nodes! All writes comes from the first master... But on each node the sequence number is not the same (domain_id-server_id is the same). Definitively, i think that sequence must depend on the server receiving the writes... And transmit by the Galera framework, to ensure consistency of the sequence number.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              sinfomicien Nicolas BLANC
              Votes:
              4 Vote for this issue
              Watchers:
              8 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.