Data Guide Data Tools Xtrabackup Xtrabackup_binlog_pos_innodb and Xtrabackup_binlog_info differences

When backing up data using the Xtrabackup tool's Innobackupex script, prepare the backup--apply-log

Innobackupex--apply-log/datapath command after execution

There will be two files in the backup data indicating the file name and location of the binlog corresponding to the backup data, Xtrabackup_binlog_pos_innodb and Xtrabackup_binlog_info, specific differences:

1. For pure InnoDB operations, the contents of the above two files in the backed up data are consistent

2. For InnoDB and non-transactional storage engine blending operations, theposition shown in Xtrabackup_binlog_info should be larger than the value shown in Xtrabackup_pos_innodb. The xtrabackup_binlog_info shall prevail at this time, and the contents shown in the recovery log of the latter and Apply-log are consistent and only for the InnoDB data

In addition, today found Innobase/mysql/oracle company produced by the MySQL Enterprise Backup (original InnoDB hot backup) innobackup script back up the data also has a similar problem. This is actually due to the time difference between the InnoDB table and the non-transactional table when the hot copy is copied.

Data Guide Data Tools Xtrabackup Xtrabackup_binlog_pos_innodb and Xtrabackup_binlog_info differences