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

Don't create xtrabackup_binlog_pos_innodb with Mariabackup




      Mariabackup inherited a xtrabackup_binlog_pos_innodb from Percona XtraBackup. However, this file is apparently only safe to use with Percona Server versions that have a special lockless binary log feature:

      Starting with Percona Server for MySQL 5.6.26-74.0 LOCK TABLES FOR BACKUP flushes the current binary log coordinates to InnoDB. Thus, under active LOCK TABLES FOR BACKUP, the binary log coordinates in InnoDB are consistent with its redo log and any non-transactional updates (as the latter are blocked by LOCK TABLES FOR BACKUP). It is planned that this change will enable Percona XtraBackup to avoid issuing the more invasive LOCK BINLOG FOR BACKUP command under some circumstances.


      When the Lockless binary log information feature is available [1] on the server, Percona XtraBackup can trust binary log information stored in the InnoDB system header and avoid executing LOCK BINLOG FOR BACKUP (and thus, blocking commits for the duration of finalizing the REDO log copy) under a number of circumstances:

      • when the server is not a GTID-enabled Galera cluster node
      • when the replication I/O thread information should not be stored as a part of the backup (i.e. when the xtrabackup --slave-info option is not specified)

      If all of the above conditions hold, Percona XtraBackup does not execute the SHOW MASTER STATUS as a part of the backup procedure, does not create the xtrabackup_binlog_info file on backup. Instead, that information is retrieved and the file is created after preparing the backup, along with creating xtrabackup_binlog_pos_innodb, which in this case contains exactly the same information as in xtrabackup_binlog_info and is thus redundant.


      Maybe Mariabackup shouldn't create it at all? It can lead users to make dangerous assumptions. For example, some users seem to think they can use this position when they run Mariabackup with --no-lock.

      For example, if we take a backup with --no-lock:

      $ sudo mariabackup --backup --no-lock \
      >    --target-dir=/home/ec2-user/backup/ \
      >    --user=mariabackup --password=mypassword
      [00] 2019-03-13 18:43:56 Connecting to MySQL server host: localhost, user: mariabackup, password: set, port: not set, socket: not set
      [00] 2019-03-13 18:43:56 Using server version 10.3.13-MariaDB-log
      [00] 2019-03-13 18:43:56 mariabackup based on MariaDB server 10.3.13-MariaDB Linux (x86_64)
      [00] 2019-03-13 18:43:56 uses posix_fadvise().
      [00] 2019-03-13 18:43:56 cd to /var/lib/mysql/
      [00] 2019-03-13 18:43:58 completed OK!

      And then prepare it:

      $ sudo mariabackup --prepare \
      >    --target-dir=/home/ec2-user/backup/
      [00] 2019-03-13 18:44:38 mariabackup based on MariaDB server 10.3.13-MariaDB Linux (x86_64)
      [00] 2019-03-13 18:44:38 cd to /home/ec2-user/backup/
      [00] 2019-03-13 18:44:39 Last binlog file ./mariadb-bin.000007, position 632
      [00] 2019-03-13 18:44:39 completed OK!

      Then this file is present:

      $ ls -l /home/ec2-user/backup/xtrabackup_binlog*
      -rw-r----- 1 root root 38 Mar 13 18:43 /home/ec2-user/backup/xtrabackup_binlog_info
      -rw-r--r-- 1 root root 25 Mar 13 18:44 /home/ec2-user/backup/xtrabackup_binlog_pos_innodb


        Issue Links



              wlad Vladislav Vaintroub
              GeoffMontee Geoff Montee (Inactive)
              0 Vote for this issue
              4 Start watching this issue



                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.