Debian Codegraph @

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

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