# create bootstrap file # Stop the MTR default DB server # Run the bootstrap command with no keyring # Run the bootstrap command with keyring # Search for particular string of encryption metadata, should success since it's encrypted. Pattern "lCC" found # Start the DB server with undo log encryption disabled and keyring plugin loaded. It should success. INSTALL PLUGIN keyring_file SONAME 'keyring_file.so'; ERROR HY000: Function 'keyring_file' already exists 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 UNINSTALL PLUGIN keyring_file; DROP TABLE tab1; Pattern "lCC" found Pattern "lCC" found