Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-827

MySQL GTID metadata not synced upon full SST

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.6.37-26.21
    • Component/s: None
    • Labels:
      None

      Description

      https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1690398

      Tested with Server version: 5.6.35-81.0-56-log Percona XtraDB Cluster (GPL), Release rel81.0, Revision 7f9b6ae, WSREP version 26.20, wsrep_26.20

      When new node is added to a cluster, where all nodes are GTID enabled, after successful full SST, the joiner has unset initial GTID position.

      Test case:

      • bootstrap first node with settings:
        server-id=1
        enforce_gtid_consistency=1
        gtid_mode=on
        log_slave_updates
        log-bin=percona1-bin
      • execute some writes
      • start second node with same settings
      • example result:
        percona1 mysql> show global variables like 'gtid%';
        ----------------------------------------------------------------+
        Variable_name Value

        ----------------------------------------------------------------+

        gtid_deployment_step OFF
        gtid_executed 102cd5f1-0628-ee19-4d29-e8233b126f5f:1-317
        gtid_mode ON
        gtid_owned  
        gtid_purged  

        ----------------------------------------------------------------+
        5 rows in set (0.00 sec)

      percona2 mysql> show global variables like 'gtid%';
      ---------------------------+

      Variable_name Value

      ---------------------------+

      gtid_deployment_step OFF
      gtid_executed  
      gtid_mode ON
      gtid_owned  
      gtid_purged  

      ---------------------------+
      5 rows in set (0.03 sec)

      • execute more writes, and see out of sync positions:
        percona1 mysql> show global variables like 'gtid_e%';
        ---------------------------------------------------------+
        Variable_name Value

        ---------------------------------------------------------+

        gtid_executed 102cd5f1-0628-ee19-4d29-e8233b126f5f:1-448

        ---------------------------------------------------------+
        1 row in set (0.00 sec)

      percona2 mysql> show global variables like 'gtid_e%';
      ---------------------------------------------------------+

      Variable_name Value

      ---------------------------------------------------------+

      gtid_executed 102cd5f1-0628-ee19-4d29-e8233b126f5f:1-131

      ---------------------------------------------------------+
      1 row in set (0.00 sec)

      Quick test on PXC 5.7.16 worked well though, GTID was synced properly.

        Attachments

          Activity

            People

            Assignee:
            kenn.takara Kenn Takara
            Reporter:
            kenn.takara Kenn Takara
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist