# ---------------------------------------------------------------------- # 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 # ---------------------------------------------------------------------- # create bootstrap file # Stop the MTR default DB server # Taking backup of global manifest file for MySQL server # Run the bootstrap command with no keyring # Restore global manifest file for MySQL server from backup # Run the bootstrap command with keyring # Search for particular string of encryption metadata, should success since it's encrypted. Pattern "lCC" found # Taking backup of global manifest file for MySQL server # Start the DB server with undo log encryption disabled and keyring loaded. It should success. # Restore global manifest file for MySQL server from backup SET GLOBAL innodb_undo_log_encrypt = ON; CREATE TABLE tab1(c1 INT, c2 VARCHAR(30)); START TRANSACTION; INSERT INTO tab1 VALUES (100,REPEAT('a',5)),(200,REPEAT('b',5)); SELECT * FROM tab1; c1 c2 100 aaaaa 200 bbbbb COMMIT; SET GLOBAL innodb_undo_log_encrypt = OFF; START TRANSACTION; INSERT INTO tab1 VALUES (300,REPEAT('a',5)),(400,REPEAT('b',5)); COMMIT; SELECT * FROM tab1; c1 c2 100 aaaaa 200 bbbbb 300 aaaaa 400 bbbbb DROP TABLE tab1; Pattern "lCC" found Pattern "lCC" found # ---------------------------------------------------------------------- # 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 # ----------------------------------------------------------------------