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

MariaDB Galera cluster gtid's falling out of sync inspite of setting wsrep_gtid_mode=ON

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.11, 10.1.13, 10.1.14
    • 10.1.31
    • Galera, Replication
    • 2.6.32-504.8.1.el6.x86_64

    Description

      I have asynchronous replication between 2 clusters (calling master cluster, slave cluster). As expected a node in the slave cluster receives async replication and galera transmits to the rest of the nodes of the slave cluster. When the gtid counter is being incremented on the nodes of this slave cluster, the node acting as the slave node is keeping track of master server id and incrementing the gtid by wsrep_domain_id, server_id, galera counter+1. However the other nodes of the slave cluster are not keeping track of the server id variable and increment gtid by wsrep_domain_id, galera counter+1. See below

      Slave node of the slave cluster

      show variables like '%gtid%'; 
      +------------------------+-------------------------+
      Variable_nameValue
      +------------------------+-------------------------+
      gtid_binlog_pos2-100-36261
      gtid_binlog_state2-200-36263,2-100-36261
      gtid_current_pos1-100-36261
      gtid_domain_id22
      gtid_ignore_duplicatesOFF
      gtid_seq_no0
      gtid_slave_pos1-100-36261
      gtid_strict_modeOFF
      last_gtid2-200-36263
      wsrep_gtid_domain_id2
      wsrep_gtid_modeON
      +------------------------+-------------------------+ 
      11 rows in set (0.00 sec)
      

      Another node in the slave cluster

      show variables like '%gtid%'; 
      +------------------------+-------------------------+
      Variable_nameValue
      +------------------------+-------------------------+
      gtid_binlog_pos2-100-36265
      gtid_binlog_state2-200-36264,2-100-36265
      gtid_current_pos1-100-36259
      gtid_domain_id22
      gtid_ignore_duplicatesOFF
      gtid_seq_no0
      gtid_slave_pos1-100-36259
      gtid_strict_modeOFF
      last_gtid
      wsrep_gtid_domain_id2
      wsrep_gtid_modeON
      +------------------------+-------------------------+ 
      11 rows in set (0.00 sec)
      

      Please review and let me know if this is expected behavior or bug.

      Attachments

        Issue Links

          Activity

            People

              sachin.setiya.007 Sachin Setiya (Inactive)
              kk1674@att.com Kasturi Kalagara
              Votes:
              3 Vote for this issue
              Watchers:
              9 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.