Debian Codegraph @

mysql-test/suite/encryption/t/innodb_encryption_filekeys.test

raw
1 -- source include/have_innodb.inc
2 -- source include/have_file_key_management_plugin.inc
3
4 --disable_query_log
5 let $encrypt_tables = `SELECT @@innodb_encrypt_tables`;
6 let $threads = `SELECT @@innodb_encryption_threads`;
7 let $key_id = `SELECT @@innodb_default_encryption_key_id`;
8 --enable_query_log
9
10 SET GLOBAL innodb_encrypt_tables = OFF;
11 SET GLOBAL innodb_encryption_threads = 4;
12
13 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT, c VARCHAR(256)) ENGINE=INNODB;
14 SHOW CREATE TABLE t1;
15 CREATE TABLE t2 (pk INT PRIMARY KEY AUTO_INCREMENT, c VARCHAR(256)) ENGINE=INNODB ENCRYPTED=YES;
16 CREATE TABLE t3 (pk INT PRIMARY KEY AUTO_INCREMENT, c VARCHAR(256)) ENGINE=INNODB ENCRYPTED=NO;
17 CREATE TABLE t4 (pk INT PRIMARY KEY AUTO_INCREMENT, c VARCHAR(256)) ENGINE=INNODB ENCRYPTED=YES ENCRYPTION_KEY_ID=4;
18
19 --disable_warnings
20 --disable_query_log
21 begin;
22 let $i = 10;
23 while ($i)
24 {
25 INSERT INTO t1 values(NULL, substring(MD5(RAND()), -128));
26 dec $i;
27 }
28
29 INSERT INTO t2 select * from t1;
30 INSERT INTO t3 select * from t1;
31 INSERT INTO t4 select * from t1;
32 commit;
33 --enable_warnings
34 --enable_query_log
35
36 SET GLOBAL innodb_encrypt_tables = on;
37
38 --echo # Wait max 10 min for key encryption threads to encrypt required all spaces
39 let $cnt=600;
40 while ($cnt)
41 {
42 let $success=`SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0`;
43 if ($success)
44 {
45 let $cnt=0;
46 }
47 if (!$success)
48 {
49 real_sleep 1;
50 dec $cnt;
51 }
52 }
53 if (!$success)
54 {
55 SELECT NAME,ENCRYPTION_SCHEME,MIN_KEY_VERSION, ROTATING_OR_FLUSHING FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION;
56 SHOW STATUS LIKE 'innodb_encryption%';
57 -- die Timeout waiting for encryption threads
58 }
59 --echo # Success!
60
61 SELECT COUNT(1) FROM t1;
62 SELECT COUNT(1) FROM t2;
63 SELECT COUNT(1) FROM t3;
64 SELECT COUNT(1) FROM t4;
65
66 SET GLOBAL innodb_encrypt_tables = off;
67
68 --echo # Wait max 10 min for key encryption threads to decrypt all required spaces
69 let $cnt=600;
70 while ($cnt)
71 {
72 let $success=`SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0`;
73 if ($success)
74 {
75 let $cnt=0;
76 }
77 if (!$success)
78 {
79 real_sleep 1;
80 dec $cnt;
81 }
82 }
83 if (!$success)
84 {
85 SELECT NAME,ENCRYPTION_SCHEME,MIN_KEY_VERSION, ROTATING_OR_FLUSHING FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION;
86 SHOW STATUS LIKE 'innodb_encryption%';
87 -- die Timeout waiting for encryption threads
88 }
89 --echo # Success!
90
91 SET GLOBAL innodb_encrypt_tables = ON;
92 set GLOBAL innodb_default_encryption_key_id=4;
93 CREATE TABLE t5 (pk INT PRIMARY KEY AUTO_INCREMENT, c VARCHAR(256)) ENGINE=INNODB;
94 SHOW CREATE TABLE t5;
95 INSERT INTO t5 select * from t1;
96
97 --echo # Wait max 10 min for key encryption threads to encrypt required all spaces
98 let $cnt=600;
99 while ($cnt)
100 {
101 let $success=`SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0`;
102 if ($success)
103 {
104 let $cnt=0;
105 }
106 if (!$success)
107 {
108 real_sleep 1;
109 dec $cnt;
110 }
111 }
112 if (!$success)
113 {
114 SELECT NAME,ENCRYPTION_SCHEME,MIN_KEY_VERSION, ROTATING_OR_FLUSHING FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION;
115 SHOW STATUS LIKE 'innodb_encryption%';
116 -- die Timeout waiting for encryption threads
117 }
118 --echo # Success!
119
120 SELECT COUNT(1) FROM t1;
121 SELECT COUNT(1) FROM t2;
122 SELECT COUNT(1) FROM t3;
123 SELECT COUNT(1) FROM t4;
124 SELECT COUNT(1) FROM t5;
125
126 drop table t1,t2,t3,t4, t5;
127
128 # reset system
129 --disable_query_log
130 EVAL SET GLOBAL innodb_encrypt_tables = $encrypt_tables;
131 EVAL SET GLOBAL innodb_encryption_threads = $threads;
132 EVAL set GLOBAL innodb_default_encryption_key_id = $key_id;
133 --enable_query_log