[MDEV-19768] Mariabackup should write warning during backup if server does not have innodb_log_optimize_ddl=OFF set Created: 2019-06-15  Updated: 2023-04-24

Status: Open
Project: MariaDB Server
Component/s: Backup, Data Definition - Alter Table, mariabackup, Storage Engine - InnoDB
Fix Version/s: None

Type: Task Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: warning

Issue Links:
Relates
relates to MDEV-19769 Mariabackup should write warning duri... Open
relates to MDEV-16791 mariabackup : allow consistent backup... Closed
relates to MDEV-19747 Deprecate and ignore innodb_log_optim... Closed

 Description   

Some DDL statements can lead to inconsistent backups unless the server has innodb_log_optimize_ddl=OFF set. See MDEV-16791 for more information.

https://mariadb.com/kb/en/library/mariabackup-overview/#concurrent-ddl-and-backup-issues

https://mariadb.com/kb/en/library/innodb-system-variables/#innodb_log_optimize_ddl

Maybe Mariabackup should write a warning if a backup is taken when innodb_log_optimize_ddl=OFF is not set? i.e. something like this?:

[Warning] The server does not have innodb_log_optimize_ddl set to OFF. If certain DDL statements are executed during the backup, then the backup can be inconsistent.

 Comments   
Comment by Marko Mäkelä [ 2022-03-09 ]

I do not think that implementing the requested warning requires any specific InnoDB knowledge.

Generated at Thu Feb 08 08:54:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.