Debian Codegraph @

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

raw
1 -- source include/have_innodb.inc
2 -- source include/not_embedded.inc
3 -- source include/have_example_key_management_plugin.inc
4 -- source include/innodb_undo_tablespaces.inc
5
6 CREATE TABLE t1 (f1 INT, f2 VARCHAR(256))engine=innodb;
7 INSERT INTO t1 VALUES(1, 'MariaDB'), (2, 'Robot'), (3, 'Science');
8 INSERT INTO t1 SELECT * FROM t1;
9
10 CREATE TABLE t2(f1 INT, f2 VARCHAR(256))engine=innodb;
11 INSERT INTO t2 SELECT * FROM t1;
12
13 CREATE TABLE t3(f1 INT, f2 VARCHAR(256))engine=innodb encrypted=yes;
14 INSERT INTO t3 SELECT * FROM t1;
15
16 --echo # Restart the server with encryption
17
18 let $restart_noprint=2;
19 let $restart_parameters= --innodb_encryption_threads=5 --innodb_encryption_rotate_key_age=16384;
20 --source include/restart_mysqld.inc
21
22 --echo # Wait until encryption threads have encrypted all tablespaces
23
24 --let $tables_count= `select count(*) + 1 + @@global.innodb_undo_tablespaces from information_schema.tables where engine = 'InnoDB'`
25 --let $wait_timeout= 600
26 --let $wait_condition=SELECT COUNT(*) >= $tables_count FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
27 --source include/wait_condition.inc
28
29 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
30 --sorted_result
31 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
32
33 --echo # Restart the server with innodb_encryption_rotate_key_age= 0
34
35 let $restart_parameters= --innodb_encryption_threads=1 --innodb_encryption_rotate_key_age=0;
36
37 --source include/restart_mysqld.inc
38
39 create table t4 (f1 int not null)engine=innodb encrypted=NO;
40
41 --echo # Wait until encryption threads have encrypted all tablespaces
42
43 --let $tables_count= `select count(*) + @@global.innodb_undo_tablespaces from information_schema.tables where engine = 'InnoDB'`
44 --let $wait_timeout= 600
45 --let $wait_condition=SELECT COUNT(*) >= $tables_count FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
46 --source include/wait_condition.inc
47
48 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
49
50 --sorted_result
51 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
52
53 --echo # Disable encryption when innodb_encryption_rotate_key_age is 0
54 set global innodb_encrypt_tables = OFF;
55
56 --echo # Wait until encryption threads to decrypt all unencrypted tablespaces
57
58 --let $tables_count= `select count(*) + @@global.innodb_undo_tablespaces from information_schema.tables where engine = 'InnoDB'`
59 --let $wait_timeout= 600
60 --let $wait_condition=SELECT COUNT(*) >= $tables_count FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0 AND ROTATING_OR_FLUSHING = 0;
61 --source include/wait_condition.inc
62
63 --sorted_result
64 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
65 --echo # Display only encrypted create tables (t3)
66 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
67
68 --echo # Enable encryption when innodb_encryption_rotate_key_age is 0
69 set global innodb_encrypt_tables = ON;
70
71 --echo # Wait until encryption threads to encrypt all unencrypted tablespaces
72
73 --let $tables_count= `select count(*) + @@global.innodb_undo_tablespaces from information_schema.tables where engine = 'InnoDB'`
74 --let $wait_timeout= 600
75 --let $wait_condition=SELECT COUNT(*) >= $tables_count FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
76 --source include/wait_condition.inc
77
78 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
79 --echo # Display only unencrypted create tables (t4)
80 --sorted_result
81 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
82
83 --let $restart_parameters=
84 -- source include/restart_mysqld.inc
85
86 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
87 --sorted_result
88 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
89 DROP TABLE t4, t3, t2, t1;