Debian Codegraph @

mysql-test/suite/component_keyring_file/r/log_encrypt_4.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 # Run the bootstrap command of datadir1
10 # Start the DB server with datadir1
11 SELECT @@global.innodb_redo_log_encrypt ;
12 @@global.innodb_redo_log_encrypt
13 1
14 USE test;
15 CREATE TABLE tab1(c1 INT, c2 VARCHAR(30));
16 INSERT INTO tab1 VALUES(1, 'Test consistency undo*');
17 SELECT * FROM tab1;
18 c1 c2
19 1 Test consistency undo*
20 CREATE TABLE tab2(c1 INT, c2 VARCHAR(30)) ENCRYPTION="Y";
21 INSERT INTO tab2 VALUES(1, 'Test consistency undo*');
22 SELECT * FROM tab2;
23 c1 c2
24 1 Test consistency undo*
25 DROP TABLE tab1,tab2;
26 # Kill the server
27 # Removing local keyring file for keyring component: component_keyring_file
28 # Taking backup of global manifest file for MySQL server
29 # Run the bootstrap command of datadir2, it should fail since the keyring is not loaded.
30 # Restore global manifest file for MySQL server from backup
31 # Run the bootstrap command of datadir2
32 # Start the DB server with datadir2
33 SELECT @@global.innodb_redo_log_encrypt ;
34 @@global.innodb_redo_log_encrypt
35 1
36 USE test;
37 CREATE TABLE tab1(c1 INT, c2 VARCHAR(30));
38 INSERT INTO tab1 VALUES(1, 'Test consistency undo*');
39 SELECT * FROM tab1;
40 c1 c2
41 1 Test consistency undo*
42 CREATE TABLE tab2(c1 INT, c2 VARCHAR(30)) ENCRYPTION="Y";
43 INSERT INTO tab2 VALUES(1, 'Test consistency undo*');
44 SELECT * FROM tab2;
45 c1 c2
46 1 Test consistency undo*
47 DROP TABLE tab1,tab2;
48 # Kill the server
49 # Removing local keyring file for keyring component: component_keyring_file
50 # Run the bootstrap command of datadir3
51 # Start the DB server with datadir3 and keyring loaded.
52 SELECT @@global.innodb_redo_log_encrypt ;
53 @@global.innodb_redo_log_encrypt
54 0
55 USE test;
56 CREATE TABLE tab1(c1 INT, c2 VARCHAR(30));
57 INSERT INTO tab1 VALUES(1, 'Test consistency undo*');
58 SELECT * FROM tab1;
59 c1 c2
60 1 Test consistency undo*
61 CREATE TABLE tab2(c1 INT, c2 VARCHAR(30)) ENCRYPTION="Y";
62 DROP TABLE tab1;
63 # Kill the server
64 # Removing local keyring file for keyring component: component_keyring_file
65 # ----------------------------------------------------------------------
66 # Teardown
67 # Removing local keyring file for keyring component: component_keyring_file
68 # Removing global configuration file for keyring component: component_keyring_file
69 # Removing global manifest file for MySQL server
70 # Restarting server without the manifest file
71 # ----------------------------------------------------------------------