Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19768

Mariabackup should write warning during backup if server does not have innodb_log_optimize_ddl=OFF set

Details

    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

          Activity

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

            marko Marko Mäkelä added a comment - I do not think that implementing the requested warning requires any specific InnoDB knowledge.

            People

              bar Alexander Barkov
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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