Data Guide Data Tools Xtrabackup Xtrabackup_binlog_pos_innodb and Xtrabackup_binlog_info differences

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.