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

            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: