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

Ensure consistency of sequence number in Galera GTID Replication

    Details

    • Type: Task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Galera
    • Labels:
      None

      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.

        Gliffy Diagrams

          Attachments

            Activity

            There are no comments yet on this issue.

              People

              • Assignee:
                nirbhay_c Nirbhay Choubey
                Reporter:
                sinfomicien Nicolas BLANC
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated: