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

              • Assignee:
                Unassigned
                Reporter:
                sinfomicien Nicolas BLANC
              • Votes:
                4 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: