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

Make information_schema table that shows which Aria tables are encrypted

    XMLWordPrintable

Details

    Description

      You can query information_schema.INNODB_TABLESPACES_ENCRYPTION to determine which InnoDB tables are encrypted:

      https://mariadb.com/kb/en/library/innodb-encryption-overview/#finding-encrypted-tables

      https://mariadb.com/kb/en/library/information-schema-innodb_tablespaces_encryption-table/

      Aria tables can also be encrypted if aria_encrypt_tables is enabled:

      https://mariadb.com/kb/en/library/aria-system-variables/#aria_encrypt_tables

      However, there does not seem to be any information_schema table that shows which Aria tables are encrypted. Wouldn't it make sense to make this information available?

      https://mariadb.com/kb/en/library/information-schema-tables/

      Currently, you have to use the very user-unfriendly method shown here:

      https://mariadb.com/kb/en/library/aria-encryption-overview/#determining-whether-a-table-is-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-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

          Task - A task that needs to be done. MDEV-17266 Document how to determine which Aria tables are encrypted

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-17268 Document how to safely decrypt Aria tables

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-18049 Support ENCRYPTED and ENCRYPTION_KEY_ID table options for Aria

          • Major - Major loss of function.
          • Open

          Activity

            People

              ralf.gebhardt Ralf Gebhardt
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              8 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.