Debian Codegraph @

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

raw
1 #
2 #
3 #
4 -- source include/have_innodb.inc
5 -- source include/have_example_key_management_plugin.inc
6 -- source include/innodb_undo_tablespaces.inc
7
8 # embedded does not support restart
9 -- source include/not_embedded.inc
10
11 SET @start_global_value = @@global.innodb_encryption_threads;
12
13 SHOW VARIABLES LIKE 'innodb_encrypt%';
14
15 SET GLOBAL innodb_encrypt_tables = ON;
16
17 --let $tables_count= `select count(*) + @@global.innodb_undo_tablespaces + 1 from information_schema.tables where engine = 'InnoDB'`
18
19 --echo # Wait max 10 min for key encryption threads to encrypt all spaces
20 --let $wait_timeout= 600
21 --let $wait_condition=SELECT COUNT(*) >= $tables_count FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
22 --source include/wait_condition.inc
23
24 --sorted_result
25 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0
26 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
27 --sorted_result
28 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0
29 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
30
31 --echo # Success!
32
33 --echo # Now turn off encryption and wait for threads to decrypt everything
34 SET GLOBAL innodb_encrypt_tables = off;
35
36 --echo # Wait max 10 min for key encryption threads to decrypt all spaces
37 --let $wait_timeout= 600
38 --let $wait_condition=SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
39 --source include/wait_condition.inc
40
41 --sorted_result
42 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0
43 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
44 --sorted_result
45 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0
46 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
47
48 --echo # Success!
49
50 --echo # Shutdown innodb_encryption_threads
51 SET GLOBAL innodb_encryption_threads=0;
52
53 --echo # Turn on encryption
54 --echo # since threads are off tables should remain unencrypted
55 SET GLOBAL innodb_encrypt_tables = on;
56
57 --echo # Wait 15s to check that nothing gets encrypted
58 --let $wait_timeout= 15
59 --let $wait_condition=SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
60 --source include/wait_condition.inc
61
62 --sorted_result
63 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0
64 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
65 --sorted_result
66 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0
67 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
68
69 --echo # Success!
70
71 --echo # Startup innodb_encryption_threads
72 SET GLOBAL innodb_encryption_threads=@start_global_value;
73
74 --echo # Wait max 10 min for key encryption threads to encrypt all spaces
75 --let $wait_timeout= 600
76 --let $wait_condition=SELECT COUNT(*) >= $tables_count FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
77 --source include/wait_condition.inc
78
79 --sorted_result
80 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0
81 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
82 --sorted_result
83 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0
84 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
85
86 --echo # Success!
87 --echo # Restart mysqld --innodb_encrypt_tables=0 --innodb_encryption_threads=0
88 -- let $restart_parameters=--innodb_encrypt_tables=0 --innodb_encryption_threads=0
89 -- source include/restart_mysqld.inc
90
91 SHOW VARIABLES LIKE 'innodb_encrypt%';
92
93 --sorted_result
94 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0
95 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
96 --sorted_result
97 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0
98 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';