Shulou(Shulou.com)05/31 Report--

This article is to share with you about the principle of XtraBackup backup and its advantages and disadvantages. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Innobackupex keeps tracking InnoDB's log files in the background thread, and then copies InnoDB's data files. After the data file is copied, the log replication thread also ends. This results in a copy of the data that is not at the same point in time and the transaction log after the backup starts. After completing the above steps, you can use the InnoDB crash recovery code to perform transaction logs (redo log) to achieve data consistency.

Backup is mainly divided into two processes:

1. Backup, backup phase, tracking transaction logs and copying data files (physical backup).

2. Preparing, replay the transaction log so that all data are at the same point in time and reach a consistent state.

Advantages of XtraBackup:

Can quickly and reliably complete data backup (copy data files and track transaction logs)

Transaction processing will not be interrupted during data backup (hot backup)

Save disk space and network bandwidth

Automatic completion of backup identification

Increased online time due to faster recovery time

File-based physical backup

Recovery will be faster (no mysql statements need to be executed, no indexes need to be built, and innoDB tables do not need to be fully cached in memory)

Disadvantages of XtraBackup:

1. The file is large

2. Cross-platform, operating system and MySQL versions are not always available

These are the principles and advantages and disadvantages of XtraBackup backup. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.