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

Support ENCRYPTED and ENCRYPTION_KEY_ID table options for Aria

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

          relates to

          Task - A task that needs to be done. MDEV-8587 Aria log encryption

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-17324 Make information_schema table that shows which Aria tables are encrypted

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-18971 Add background encryption threads for Aria

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-20099 Implement key rotation for Aria

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            GeoffMontee Geoff Montee (Inactive) created issue -
            GeoffMontee Geoff Montee (Inactive) made changes -
            Field Original Value New Value
            Description InnoDB supports manually encrypting tables with the ENCRYPTED and ENCRYPTION_KEY_ID table options:

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

            Aria does support data-at-rest encryption:

            https://mariadb.com/kb/en/library/encrypting-data-for-aria/

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

            {noformat}
            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'
            {noformat}             		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:

            {noformat}
            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'
            {noformat}
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            Fix Version/s 10.5 [ 23123 ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            Assignee Michael Widenius [ monty ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.5 [ 23123 ]
            Assignee Michael Widenius [ monty ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 91342 ] MariaDB v4 [ 130961 ]
            AirFocus AirFocus made changes -
            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:

            {noformat}
            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'
            {noformat}             		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:

            {noformat}
            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'
            {noformat}
            julien.fritsch Julien Fritsch made changes -
            Labels synchronization
            julien.fritsch Julien Fritsch made changes -
            Labels synchronization
            julien.fritsch Julien Fritsch made changes -
            Issue Type Task [ 3 ] New Feature [ 2 ]

            People

              Unassigned Unassigned
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.