# ---------------------------------------------------------------------- # Setup # Creating custom global manifest file for MySQL server # Creating custom global configuration file for keyring component: component_keyring_file # Re-starting mysql server with manifest file # ---------------------------------------------------------------------- # # Bug #29492911 : ENABLING UNDO-TABLESPACE ENCRYPTION DOESN'T MARK TABLESPACE ENCRYPTION FLAG # SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%"; Variable_name Value innodb_undo_log_encrypt OFF # Taking backup of global manifest file for MySQL server ############################################################################### # With keyring and innodb_undo_log_encrypt=ON ############################################################################### # Restore global manifest file for MySQL server from backup SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%"; Variable_name Value innodb_undo_log_encrypt ON # Create a new UNDO tablespace. Should be created as ENCRYPTED. CREATE UNDO TABLESPACE undo_3 ADD DATAFILE 'undo_3.ibu'; SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo'; NAME SPACE_TYPE ENCRYPTION STATE innodb_undo_001 Undo Y active innodb_undo_002 Undo Y active undo_3 Undo Y active SET GLOBAL innodb_undo_log_encrypt=OFF; SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%"; Variable_name Value innodb_undo_log_encrypt OFF SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo'; NAME SPACE_TYPE ENCRYPTION STATE innodb_undo_001 Undo N active innodb_undo_002 Undo N active undo_3 Undo N active # Create a new UNDO tablespace. Should be created as UNENCRYPTED. CREATE UNDO TABLESPACE undo_4 ADD DATAFILE 'undo_4.ibu'; SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo'; NAME SPACE_TYPE ENCRYPTION STATE innodb_undo_001 Undo N active innodb_undo_002 Undo N active undo_3 Undo N active undo_4 Undo N active SET GLOBAL innodb_undo_log_encrypt=ON; SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%"; Variable_name Value innodb_undo_log_encrypt ON SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo'; NAME SPACE_TYPE ENCRYPTION STATE innodb_undo_001 Undo Y active innodb_undo_002 Undo Y active undo_3 Undo Y active undo_4 Undo Y active ############################################################################### # With keyring and innodb_undo_log_encrypt=OFF ############################################################################### ALTER UNDO TABLESPACE undo_3 set INACTIVE; SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo'; NAME SPACE_TYPE ENCRYPTION STATE innodb_undo_001 Undo N active innodb_undo_002 Undo N active undo_3 Undo N inactive undo_4 Undo N active DROP UNDO TABLESPACE undo_3; ALTER UNDO TABLESPACE undo_4 set INACTIVE; SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo'; NAME SPACE_TYPE ENCRYPTION STATE innodb_undo_001 Undo N active innodb_undo_002 Undo N active undo_4 Undo N inactive DROP UNDO TABLESPACE undo_4; SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo'; NAME SPACE_TYPE ENCRYPTION STATE innodb_undo_001 Undo N active innodb_undo_002 Undo N active # ---------------------------------------------------------------------- # Teardown # Removing local keyring file for keyring component: component_keyring_file # Removing global configuration file for keyring component: component_keyring_file # Removing global manifest file for MySQL server # Restarting server without the manifest file # ----------------------------------------------------------------------