Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-1672

Allow MTS slave without GTID to be backed up with --safe-slave-backup

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Pending Release
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 2.3.10, 2.4.12, 8.0-2-alpha2
    • Fix Version/s: 2.4.NEXT, 2.3.NEXT, 8.0-3-rc1
    • Component/s: None
    • Labels:
      None

      Description

      Currently there is implicit check in xtrabackup to disallow --slave-info with MTS and GTID mode OFF, as it can lead to inconsistent binary log position as described in https://dev.mysql.com/doc/refman/5.7/en/replication-features-transaction-inconsistencies.html. There is a workaround for it - to stop slave sql thread before querying the Exec_master_log_pos.

      After issuing STOP SLAVE, the slave waits for any gaps to be filled and then updates Exec_master_log_pos. This ensures it never leaves gaps or gap-free low-watermark positions, unless any of the cases above applies (in other words, before STOP SLAVE completes, either an error happens, or another thread issues KILL, or the server restarts. In these cases, STOP SLAVE returns successfully.) 

      Thus, using -slave-info with -safe-slave-backup should be fine.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sergei.glushchenko Sergei Glushchenko
                Reporter:
                sergei.glushchenko Sergei Glushchenko
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day
                  1d