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

    XMLWordPrintable

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

            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.