33 lines
972 B
Plaintext
33 lines
972 B
Plaintext
# 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
|