On Monday, July 13, 2020, Oracle released MySQL 8.0.21. This release contained a few new changes that cause issues with Percona XtraBackup.
First, this release introduced the ability to temporarily disable InnoDB redo logging (see the work log and documentation). If you love your data, this feature should ONLY be used to speed up an initial logical data import and should never be used under a production workload.
When used, this new feature creates some interesting complications for Percona XtraBackup that you need to be aware of. The core requirement for XtraBackup to be able to make consistent hot backups is to have some form of redo or write ahead log to copy and read from. Disabling the InnoDB redo log will prevent XtraBackup from making a …[Read more]