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

Conflicting value definitions for innodb_encrypt_tables

    XMLWordPrintable

    Details

      Description

      When reading Encrypting Data for InnoDB / XtraDB you may be lead to believe that if you are using innodb_encrypt_tables=FORCE then you would be unable to access any InnoDB tables that are storing data in plaintext.

      Option Description
      OFF Disables table encryption
      ON Enables table encryption, but allows unencrypted tables
      FORCE Enables table encryption, but doesn't allow unencrypted tables

      The variable documentation states it differently:

      Description: Encrypt all tables in the storage engine. See Table and Tablespace Encryption. The FORCE option (from 10.1.4) means that XtraDB/InnoDB will refuse to create unencrypted tables (CREATE TABLE ... ENCRYPTED=NO will fail).

      This could lead to someone having the wrong impression about using FORCE

        Attachments

          Issue Links

          relates to

          Task - A task that needs to be done. MDEV-16998 Allow logging of plaintext InnoDB tables during startup

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

            Activity

              People

              Assignee:
              greenman Ian Gilfillan
              Reporter:
              cezmunsta Ceri Williams
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

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