Debian Codegraph @

mysql-test/suite/component_keyring_file/r/undo_encrypt_bootstrap.result

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 # Creating custom global manifest file for MySQL server
4 # Creating custom global configuration file for keyring component: component_keyring_file
5 # Re-starting mysql server with manifest file
6 # ----------------------------------------------------------------------
7 # create bootstrap file
8 # Stop the MTR default DB server
9 # Taking backup of global manifest file for MySQL server
10 # Run the bootstrap command with no keyring
11 # Restore global manifest file for MySQL server from backup
12 # Run the bootstrap command with keyring
13 # Search for particular string of encryption metadata, should success since it's encrypted.
14 Pattern "lCC" found
15 # Taking backup of global manifest file for MySQL server
16 # Start the DB server with undo log encryption disabled and keyring loaded. It should success.
17 # Restore global manifest file for MySQL server from backup
18 SET GLOBAL innodb_undo_log_encrypt = ON;
19 CREATE TABLE tab1(c1 INT, c2 VARCHAR(30));
20 START TRANSACTION;
21 INSERT INTO tab1 VALUES (100,REPEAT('a',5)),(200,REPEAT('b',5));
22 SELECT * FROM tab1;
23 c1 c2
24 100 aaaaa
25 200 bbbbb
26 COMMIT;
27 SET GLOBAL innodb_undo_log_encrypt = OFF;
28 START TRANSACTION;
29 INSERT INTO tab1 VALUES (300,REPEAT('a',5)),(400,REPEAT('b',5));
30 COMMIT;
31 SELECT * FROM tab1;
32 c1 c2
33 100 aaaaa
34 200 bbbbb
35 300 aaaaa
36 400 bbbbb
37 DROP TABLE tab1;
38 Pattern "lCC" found
39 Pattern "lCC" found
40 # ----------------------------------------------------------------------
41 # Teardown
42 # Removing local keyring file for keyring component: component_keyring_file
43 # Removing global configuration file for keyring component: component_keyring_file
44 # Removing global manifest file for MySQL server
45 # Restarting server without the manifest file
46 # ----------------------------------------------------------------------