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

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 2.3.10, 2.4.12, 8.0-2-alpha2
    • 8.0-3-rc1, 2.4.13, 2.3.NEXT
    • None
    • 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

              sergei.glushchenko Sergei Glushchenko (Inactive)
              sergei.glushchenko Sergei Glushchenko (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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

                  Smart Checklist