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

Fix mysqldump SST method to transfer binlog state to the joiner

Details

    Description

      In mysqldump galera SST method, if nodes are started with log-bin and log-
      slave-updates, the GTID on the joiner shoots as the dump for all databases
      in donor is replayed on the joiner node.

      As a result of which - after the SST completes and the joiner in synced - the
      donor and joiner nodes end up in different binlog states and hence same
      transactions may get different GTIDs.

      The GTIDs on both the nodes should be consistent after the SST.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-6490 mysqldump unknown option --galera-sst-mode

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            nirbhay_c Nirbhay Choubey (Inactive) created issue -
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Field Original Value New Value
            Description In mysqldump galera SST method, if nodes are started with log-bin and log-
            slave-updates, the GTID on the joiner shoots as the dump for all databases in donor is replayed on the joiner node.

            As a result of which - after the SST completes and the joiner in synced - the donor and joiner nodes end up in different binlog states and hence same transactions may get different GTIDs.

            The GTIDs on both the nodes should be consistent after the SST.
            		 In mysqldump galera SST method, if nodes are started with log-bin and log-
            slave-updates, the GTID on the joiner shoots as the dump for all databases
            in donor is replayed on the joiner node.

            As a result of which - after the SST completes and the joiner in synced - the
            donor and joiner nodes end up in different binlog states and hence same
            transactions may get different GTIDs.

            The GTIDs on both the nodes should be consistent after the SST.
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Labels galera gtid galera gtid sst
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Comment [ Fix pushed to maria-10.0-galera.
            http://bazaar.launchpad.net/~maria-captains/maria/maria-10.0-galera/revision/3842 ]
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 42213 ] MariaDB v2 [ 44733 ]
            Status Reopened [ 4 ] Stalled [ 10000 ]
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            nirbhay_c Nirbhay Choubey (Inactive) added a comment -

            Fix pushed in maria-10.0-galera.
            http://bazaar.launchpad.net/~maria-captains/maria/maria-10.0-galera/revision/3845

            nirbhay_c Nirbhay Choubey (Inactive) added a comment - Fix pushed in maria-10.0-galera. http://bazaar.launchpad.net/~maria-captains/maria/maria-10.0-galera/revision/3845
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Fix Version/s 10.0.12-galera [ 16303 ]
            zeth Michael Both made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 44733 ] MariaDB v3 [ 64114 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 64114 ] MariaDB v4 [ 147942 ]

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              nirbhay_c Nirbhay Choubey (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.