[MDEV-19768] Mariabackup should write warning during backup if server does not have innodb_log_optimize_ddl=OFF set - Jira

XML

Word

Printable

Details

Type: Task
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Fix Version/s: None
Component/s: Backup, Data Definition - Alter Table, mariabackup, Storage Engine - InnoDB
Labels:
- warning

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.

Attachments

Issue Links

relates to

MDEV-19769 Mariabackup should write warning during backup if server does not have innodb_safe_truncate=ON set

Open

MDEV-16791 mariabackup : allow consistent backup, in presence of concurrent DDL, also without --lock-ddl-per-table

Closed

MDEV-19747 Deprecate and ignore innodb_log_optimize_ddl

Closed

Activity

People

Assignee:: Alexander Barkov

Reporter:: Geoff Montee (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2019-06-15 04:28

Updated:: 2024-07-07 22:47

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.