Debian Codegraph @

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

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 # Creating custom global manifest file for MySQL server
4 # Creating custom global configuration file for keyring component: component_keyring_file
5 # Re-starting mysql server with manifest file
6 # ----------------------------------------------------------------------
7 #
8 # Bug #29492911 : ENABLING UNDO-TABLESPACE ENCRYPTION DOESN'T MARK TABLESPACE ENCRYPTION FLAG
9 #
10 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
11 Variable_name Value
12 innodb_undo_log_encrypt OFF
13 # Taking backup of global manifest file for MySQL server
14 ###############################################################################
15 # With keyring and innodb_undo_log_encrypt=ON
16 ###############################################################################
17 # Restore global manifest file for MySQL server from backup
18 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
19 Variable_name Value
20 innodb_undo_log_encrypt ON
21 # Create a new UNDO tablespace. Should be created as ENCRYPTED.
22 CREATE UNDO TABLESPACE undo_3 ADD DATAFILE 'undo_3.ibu';
23 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
24 NAME SPACE_TYPE ENCRYPTION STATE
25 innodb_undo_001 Undo Y active
26 innodb_undo_002 Undo Y active
27 undo_3 Undo Y active
28 SET GLOBAL innodb_undo_log_encrypt=OFF;
29 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
30 Variable_name Value
31 innodb_undo_log_encrypt OFF
32 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
33 NAME SPACE_TYPE ENCRYPTION STATE
34 innodb_undo_001 Undo N active
35 innodb_undo_002 Undo N active
36 undo_3 Undo N active
37 # Create a new UNDO tablespace. Should be created as UNENCRYPTED.
38 CREATE UNDO TABLESPACE undo_4 ADD DATAFILE 'undo_4.ibu';
39 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
40 NAME SPACE_TYPE ENCRYPTION STATE
41 innodb_undo_001 Undo N active
42 innodb_undo_002 Undo N active
43 undo_3 Undo N active
44 undo_4 Undo N active
45 SET GLOBAL innodb_undo_log_encrypt=ON;
46 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
47 Variable_name Value
48 innodb_undo_log_encrypt ON
49 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
50 NAME SPACE_TYPE ENCRYPTION STATE
51 innodb_undo_001 Undo Y active
52 innodb_undo_002 Undo Y active
53 undo_3 Undo Y active
54 undo_4 Undo Y active
55 ###############################################################################
56 # With keyring and innodb_undo_log_encrypt=OFF
57 ###############################################################################
58 ALTER UNDO TABLESPACE undo_3 set INACTIVE;
59 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
60 NAME SPACE_TYPE ENCRYPTION STATE
61 innodb_undo_001 Undo N active
62 innodb_undo_002 Undo N active
63 undo_3 Undo N inactive
64 undo_4 Undo N active
65 DROP UNDO TABLESPACE undo_3;
66 ALTER UNDO TABLESPACE undo_4 set INACTIVE;
67 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
68 NAME SPACE_TYPE ENCRYPTION STATE
69 innodb_undo_001 Undo N active
70 innodb_undo_002 Undo N active
71 undo_4 Undo N inactive
72 DROP UNDO TABLESPACE undo_4;
73 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
74 NAME SPACE_TYPE ENCRYPTION STATE
75 innodb_undo_001 Undo N active
76 innodb_undo_002 Undo N active
77 # ----------------------------------------------------------------------
78 # Teardown
79 # Removing local keyring file for keyring component: component_keyring_file
80 # Removing global configuration file for keyring component: component_keyring_file
81 # Removing global manifest file for MySQL server
82 # Restarting server without the manifest file
83 # ----------------------------------------------------------------------