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.13, 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.

        Smart Checklist

          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