MySQL Forums
Forum List  »  General

Re: Are they same about binlogs & InnoDB Redo Log Archiving?
Posted by: Guisen Yang
Date: July 15, 2024 02:03AM

No need to enable InnoDB Redo Log Archiving.

Backup utilities that copy redo log records may sometimes fail to keep pace with redo log generation 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 MySQL 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. Backup utilities can copy redo log records from the archive file as necessary, thereby avoiding the potential loss of data.

https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html#innodb-redo-log-archiving

Options: ReplyQuote


Subject
Written By
Posted
Re: Are they same about binlogs & InnoDB Redo Log Archiving?
July 15, 2024 02:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.