Debian Codegraph @

mysql-test/suite/rpl/t/rpl_key_rotation.test

raw
1 # WL#8821
2 # Testing ALTER INSTANCE ROTATE INNODB MASTER KEY with replication
3 # and keyring installing/uninstalling scenarios on master/slave.
4
5 --source include/master-slave.inc
6 call mtr.add_suppression("\\[Error\\] .*MY-\\d+.* Function 'keyring_file' already exists");
7 call mtr.add_suppression("\\[Error\\] .*MY-\\d+.* Couldn't load plugin named 'keyring_file' with soname 'keyring_file.so'.");
8 call mtr.add_suppression("\\[Error\\] .*MY-\\d+.* Can't generate new master key, please check the keyring is loaded.");
9 call mtr.add_suppression("\\[Error\\] .*MY-\\d+.* Encryption can't find master key, please check the keyring is loaded.");
10 call mtr.add_suppression("Error 'Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.");
11 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Replica: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.");
12 call mtr.add_suppression("\\[Error\\] .*MY-\\d+.* Can't generate new master key for tablespace encryption, please check the keyring is loaded.");
13 call mtr.add_suppression("The replica coordinator and worker threads are stopped");
14
15 --connection master
16 --echo [On Master]
17 --echo
18 # Roating master key when keyring file is empty.
19 # It should genereate new master key.
20 ALTER INSTANCE ROTATE INNODB MASTER KEY;
21
22 # Creating table with encryption.
23 CREATE TABLE t1(c1 INT PRIMARY KEY, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
24 INSERT INTO t1 VALUES(0, "aaaaa");
25 INSERT INTO t1 VALUES(1, "bbbbb");
26 INSERT INTO t1 VALUES(2, "ccccc");
27 SELECT * FROM t1;
28
29 ALTER INSTANCE ROTATE INNODB MASTER KEY;
30
31 CREATE TABLE t2(c1 INT PRIMARY KEY, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
32 INSERT INTO t2 SELECT * FROM t1;
33 SELECT COUNT(*) FROM t2;
34
35 --echo
36 --echo # Check for keyring file on master.
37 --list_files $MYSQL_TMP_DIR/keyring_master/
38 --echo
39
40 # ALTER INSTANCE ROTATE cmd will create keyring file
41 # if it is not exists and new master key in it.
42 ALTER INSTANCE ROTATE INNODB MASTER KEY;
43
44 --echo # Check for keyring file on master.
45 --list_files $MYSQL_TMP_DIR/keyring_master/
46 --file_exists $MYSQL_TMP_DIR/keyring_master/keyring_master
47 --echo
48 SELECT * FROM t1;
49
50 --source include/sync_slave_sql_with_master.inc
51 --echo [On Slave]
52
53 --echo # Check for keyring file on slave.
54 --list_files $MYSQL_TMP_DIR/keyring_slave/
55 --file_exists $MYSQL_TMP_DIR/keyring_slave/keyring_slave
56 SELECT COUNT(*) FROM t2;
57 SELECT * FROM t1;
58
59 --echo # Check for keyring file on slave.
60 --list_files $MYSQL_TMP_DIR/keyring_slave/
61
62 --connection master
63 --echo [On Master]
64 --echo #
65 CREATE TABLE t3(c1 INT PRIMARY KEY, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
66 INSERT INTO t3 VALUES(0, "aaaaa");
67
68 --echo
69 --source include/sync_slave_sql_with_master.inc
70 --echo [On Slave]
71 SELECT * FROM t3;
72 SELECT COUNT(*) FROM t2;
73 SELECT * FROM t1;
74 --echo # Check for keyring file on slave.
75 --list_files $MYSQL_TMP_DIR/keyring_slave/
76
77 ALTER INSTANCE ROTATE INNODB MASTER KEY;
78 --echo # Check for keyring file on slave.
79 --list_files $MYSQL_TMP_DIR/keyring_slave/
80 --file_exists $MYSQL_TMP_DIR/keyring_slave/keyring_slave
81
82 # Uninstalling keyring_file plugin on slave.
83 UNINSTALL PLUGIN keyring_file;
84 --echo # Checking keyring plugin after uninstall.
85 query_vertical SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
86 FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
87 --source include/stop_slave_sql.inc
88
89 --connection master
90 --echo [On Master]
91 CREATE TABLE t4(c1 INT PRIMARY KEY, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
92 INSERT INTO t4 VALUES(1, "rpltest");
93
94 --connection slave
95 --echo [On Slave]
96 START SLAVE SQL_THREAD;
97 --let $slave_sql_errno= convert_error(ER_CANNOT_FIND_KEY_IN_KEYRING)
98 --source include/wait_for_slave_sql_error.inc
99
100 --replace_regex /\.dll/.so/
101 eval INSTALL PLUGIN keyring_file SONAME '$KEYRING_PLUGIN';
102 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
103 eval SET @@global.keyring_file_data='$MYSQL_TMP_DIR/keyring_slave/keyring_slave';
104 query_vertical SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
105 FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
106 --source include/start_slave_sql.inc
107 --connection master
108 --source include/sync_slave_sql_with_master.inc
109 SELECT * FROM t4;
110
111 --connection master
112 --echo [On Master]
113 --echo # Uninstalling keyring_file plugin on master.
114 UNINSTALL PLUGIN keyring_file;
115 --echo # Checking keyring plugin after uninstall.
116 query_vertical SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
117 FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
118 SELECT * FROM t1;
119 --echo
120 # Try to rotate master key when keyring_file plugin uninstalled.
121 --error ER_CANNOT_FIND_KEY_IN_KEYRING
122 ALTER INSTANCE ROTATE INNODB MASTER KEY;
123
124 --echo # Installing keyring_file plugin on master.
125 --replace_regex /\.dll/.so/
126 eval INSTALL PLUGIN keyring_file SONAME '$KEYRING_PLUGIN';
127
128 --echo # Cleanup
129 DROP TABLE t1,t2,t3,t4;
130
131 --connection slave
132
133 --connection master
134 --source include/sync_slave_sql_with_master.inc
135 --source include/rpl_end.inc
136 # End:
137 # Restart
138 --source include/force_restart.inc