How to Estimate the Size of the InnoDB Redo Logs Required to Make Incremental Backups Using the --incremental-with-redo-log-only Option?

(Doc ID 2310092.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

MySQL Enterprise Backup - Version 3.11 and later
MySQL Server - Version 5.5 and later
Information in this document applies to any platform.

Goal

Use the --incremental-with-redo-log-only option to create incremental backups in MySQL Enterprise Backup and ensure the InnoDB redo logs are large enough to hold all changes between the backups to avoid the issue described in <Note 2310074.1> where the backup fails due to the redo logs being overwritten.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms