Debian Codegraph @

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

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 # Creating local configuration file for keyring component: component_keyring_file
4 # Creating manifest file for current MySQL server instance
5 # Re-starting mysql server with manifest file
6 # ----------------------------------------------------------------------
7 # Kill the server
8 SHOW VARIABLES LIKE "%innodb_redo_log_encrypt%";
9 Variable_name Value
10 innodb_redo_log_encrypt ON
11 DROP TABLE IF EXISTS t1;
12 SET GLOBAL innodb_file_per_table = 1;
13 SELECT @@innodb_file_per_table;
14 @@innodb_file_per_table
15 1
16 CREATE TABLE t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
17 SHOW CREATE TABLE t1;
18 Table Create Table
19 t1 CREATE TABLE `t1` (
20 `c1` int DEFAULT NULL,
21 `c2` char(20) DEFAULT NULL
22 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='Y'
23 INSERT INTO t1 VALUES(0, "aaaaa");
24 INSERT INTO t1 VALUES(1, "bbbbb");
25 INSERT INTO t1 VALUES(2, "ccccc");
26 INSERT INTO t1 VALUES(3, "ddddd");
27 INSERT INTO t1 VALUES(4, "eeeee");
28 INSERT INTO t1 VALUES(5, "fffff");
29 INSERT INTO t1 VALUES(6, "ggggg");
30 INSERT INTO t1 VALUES(7, "hhhhh");
31 INSERT INTO t1 VALUES(8, "iiiii");
32 INSERT INTO t1 VALUES(9, "jjjjj");
33 INSERT INTO t1 select * from t1;
34 INSERT INTO t1 select * from t1;
35 INSERT INTO t1 select * from t1;
36 INSERT INTO t1 select * from t1;
37 INSERT INTO t1 select * from t1;
38 INSERT INTO t1 select * from t1;
39 SELECT * FROM t1 LIMIT 10;
40 c1 c2
41 0 aaaaa
42 1 bbbbb
43 2 ccccc
44 3 ddddd
45 4 eeeee
46 5 fffff
47 6 ggggg
48 7 hhhhh
49 8 iiiii
50 9 jjjjj
51 # Kill the server
52 SHOW VARIABLES LIKE "%innodb_redo_log_encrypt%";
53 Variable_name Value
54 innodb_redo_log_encrypt ON
55 SELECT * FROM t1 LIMIT 10;
56 c1 c2
57 0 aaaaa
58 1 bbbbb
59 2 ccccc
60 3 ddddd
61 4 eeeee
62 5 fffff
63 6 ggggg
64 7 hhhhh
65 8 iiiii
66 9 jjjjj
67 ALTER INSTANCE ROTATE INNODB MASTER KEY;
68 DROP TABLE t1;
69 CREATE TABLE t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
70 INSERT INTO t1 VALUES(0, "aaaaa");
71 INSERT INTO t1 VALUES(1, "bbbbb");
72 INSERT INTO t1 VALUES(2, "ccccc");
73 INSERT INTO t1 VALUES(3, "ddddd");
74 INSERT INTO t1 VALUES(4, "eeeee");
75 INSERT INTO t1 VALUES(5, "fffff");
76 INSERT INTO t1 VALUES(6, "ggggg");
77 INSERT INTO t1 VALUES(7, "hhhhh");
78 INSERT INTO t1 VALUES(8, "iiiii");
79 INSERT INTO t1 VALUES(9, "jjjjj");
80 # Kill the server
81 SHOW VARIABLES LIKE "%innodb_redo_log_encrypt%";
82 Variable_name Value
83 innodb_redo_log_encrypt ON
84 SELECT * FROM t1 LIMIT 10;
85 c1 c2
86 0 aaaaa
87 1 bbbbb
88 2 ccccc
89 3 ddddd
90 4 eeeee
91 5 fffff
92 6 ggggg
93 7 hhhhh
94 8 iiiii
95 9 jjjjj
96 DROP TABLE t1;
97 # Kill the server
98 SHOW VARIABLES LIKE "%innodb_redo_log_encrypt%";
99 Variable_name Value
100 innodb_redo_log_encrypt ON
101 SET block_encryption_mode = 'aes-256-cbc';
102 DROP DATABASE IF EXISTS tde_db;
103 CREATE DATABASE tde_db;
104 CREATE TABLE tde_db.t1(c1 INT PRIMARY KEY, c2 char(50)) ENCRYPTION = 'Y' ENGINE = InnoDB;
105 INSERT INTO tde_db.t1 VALUES(0, 'abc');
106 INSERT INTO tde_db.t1 VALUES(1, 'xyz');
107 INSERT INTO tde_db.t1 VALUES(2, null);
108 INSERT INTO tde_db.t1 VALUES(3, null);
109 SELECT * FROM tde_db.t1 LIMIT 10;
110 c1 c2
111 0 abc
112 1 xyz
113 2 NULL
114 3 NULL
115 ALTER INSTANCE ROTATE INNODB MASTER KEY;
116 SELECT * FROM tde_db.t1 LIMIT 10;
117 c1 c2
118 0 abc
119 1 xyz
120 2 NULL
121 3 NULL
122 # Mysqldump output
123
124 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `tde_db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
125
126 USE `tde_db`;
127 /*!40101 SET @saved_cs_client = @@character_set_client */;
128 /*!50503 SET character_set_client = utf8mb4 */;
129 CREATE TABLE `t1` (
130 `c1` int NOT NULL,
131 `c2` char(50) DEFAULT NULL,
132 PRIMARY KEY (`c1`)
133 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='Y';
134 /*!40101 SET character_set_client = @saved_cs_client */;
135 INSERT INTO `t1` VALUES (0,'abc'),(1,'xyz'),(2,NULL),(3,NULL);
136 # Redirecting mysqlpump output to MYSQL_TMP_DIR/mysqlpump_encrypt.sql
137 DROP DATABASE tde_db;
138 Pattern "ALTER INSTANCE ROTATE INNODB MASTER KEY" found
139 # Loading tables from mysqlpump_encrypt.sql
140 SELECT * FROM tde_db.t1 LIMIT 10;
141 c1 c2
142 0 abc
143 1 xyz
144 2 NULL
145 3 NULL
146 INSERT INTO tde_db.t1 VALUES(4, null);
147 SELECT * FROM tde_db.t1 LIMIT 10;
148 c1 c2
149 0 abc
150 1 xyz
151 2 NULL
152 3 NULL
153 4 NULL
154 DROP DATABASE tde_db;
155 # Kill the server
156 SET GLOBAL innodb_file_per_table=1;
157 # ----------------------------------------------------------------------
158 # Teardown
159 # Removing manifest file for current MySQL server instance
160 # Removing local keyring file for keyring component: component_keyring_file
161 # Removing local configuration file for keyring component: component_keyring_file
162 # Restarting server without the manifest file
163 # ----------------------------------------------------------------------