MySQL Enterprise Backup User's Guide (Version 8.0.22)

Chapter 7 Backing up Using Redo Log Archiving

For MySQL Enterprise Backup 8.0.17 and later: mysqlbackup may sometimes fail to keep pace with redo log generation on the backed up server while a backup operation is in progress, resulting in lost redo log records due to those records being overwritten. This issue most often occurs when there is significant server activity during the backup operation, and the redo log file storage media operates at a faster speed than the backup storage media. The redo log archiving feature, introduced in MySQL 8.0.17, addresses this issue by sequentially writing redo log records to an archive file in addition to the redo log files. mysqlbackup can then copy redo log records from the archive file as necessary, thereby avoiding the potential loss of data.

When redo log archiving has been enabled on the server to be backed up, mysqlbackup utilizes the feature by default for backups, as long as the following are true:

Redo log archiving can be skipped using the mysqlbackup option --no-redo-log-archive.

If redo log archiving is skipped by mysqlbackup, disabled on the server, or is simply not working for some reasons, mysqlbackup then reverts to copying the redo log data from the redo log files, as it used to do before the feature was introduced.