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

              People

              • Assignee:
                vlad.lesin Vladislav Lesin
                Reporter:
                GeoffMontee Geoff Montee
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: