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

Support ENCRYPTED and ENCRYPTION_KEY_ID table options for Aria

    XMLWordPrintable

    Details

      Description

      InnoDB supports manually encrypting tables with the ENCRYPTED and ENCRYPTION_KEY_ID table options:

      https://mariadb.com/kb/en/library/innodb-enabling-encryption/#enabling-encryption-for-manually-encrypted-tablespaces

      Aria does support data-at-rest encryption:

      https://mariadb.com/kb/en/library/aria-encryption-overview/

      But Aria does not currently support manual encryption using these table options:

      https://mariadb.com/kb/en/library/aria-enabling-encryption/#manually-encrypting-tables

      See the following:

      MariaDB [db1]> CREATE TABLE aria_tab (
          ->    id int primary key,
          ->    str varchar(50)
          -> )
          -> ENGINE = Aria
          -> ROW_FORMAT=PAGE
          -> ENCRYPTED = YES
          -> ENCRYPTION_KEY_ID = 1;
      ERROR 1911 (HY000): Unknown option 'ENCRYPTED'
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: