Embedded Files
Transparent Data Encryption (TDE)
Transparent Data Encryption (TDE)
This is a MySQL Enterprise Edition feature
Check
Check
SELECT PLUGIN_NAME,
PLUGIN_STATUS
FROM information_schema.plugins
WHERE PLUGIN_NAME LIKE 'keyring%';
If no keyring plugin is active then TDE cannot be enabled.SHOW VARIABLES LIKE 'innodb_encrypt%';
If innodb_encrypt_tables is ON or FORCE then new InnoDB tables are encryptedIf innodb_encrypt_log is ON then redo/undo logs are encryptedSELECT TABLE_SCHEMA,
TABLE_NAME,
CREATE_OPTIONS
FROM information_schema.tables
WHERE CREATE_OPTIONS LIKE '%ENCRYPTION%';
SELECT SPACE,
NAME,
ENCRYPTION
FROM information_schema.innodb_tablespace
WHERE ENCRYPTION = 'Y';
Bibliography
Bibliography
https://www.mysql.com/products/enterprise/tde.htmlhttps://www.percona.com/blog/mysql-data-at-rest-encryption/https://www.percona.com/blog/comparing-data-at-rest-encryption-features-for-mariadb-mysql-and-percona-server-for-mysql/https://info.townsendsecurity.com/how-mysql-enterprise-transparent-data-encryption-works
Page updated
Google Sites
Report abuse