Debian Codegraph @

mysql-test/suite/rpl/r/rpl_key_rotation.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
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 [On Master]
15
16 ALTER INSTANCE ROTATE INNODB MASTER KEY;
17 CREATE TABLE t1(c1 INT PRIMARY KEY, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
18 INSERT INTO t1 VALUES(0, "aaaaa");
19 INSERT INTO t1 VALUES(1, "bbbbb");
20 INSERT INTO t1 VALUES(2, "ccccc");
21 SELECT * FROM t1;
22 c1 c2
23 0 aaaaa
24 1 bbbbb
25 2 ccccc
26 ALTER INSTANCE ROTATE INNODB MASTER KEY;
27 CREATE TABLE t2(c1 INT PRIMARY KEY, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
28 INSERT INTO t2 SELECT * FROM t1;
29 SELECT COUNT(*) FROM t2;
30 COUNT(*)
31 3
32
33 # Check for keyring file on master.
34 keyring_master
35
36 ALTER INSTANCE ROTATE INNODB MASTER KEY;
37 # Check for keyring file on master.
38 keyring_master
39
40 SELECT * FROM t1;
41 c1 c2
42 0 aaaaa
43 1 bbbbb
44 2 ccccc
45 include/sync_slave_sql_with_master.inc
46 [On Slave]
47 # Check for keyring file on slave.
48 keyring_slave
49 SELECT COUNT(*) FROM t2;
50 COUNT(*)
51 3
52 SELECT * FROM t1;
53 c1 c2
54 0 aaaaa
55 1 bbbbb
56 2 ccccc
57 # Check for keyring file on slave.
58 keyring_slave
59 [On Master]
60 #
61 CREATE TABLE t3(c1 INT PRIMARY KEY, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
62 INSERT INTO t3 VALUES(0, "aaaaa");
63
64 include/sync_slave_sql_with_master.inc
65 [On Slave]
66 SELECT * FROM t3;
67 c1 c2
68 0 aaaaa
69 SELECT COUNT(*) FROM t2;
70 COUNT(*)
71 3
72 SELECT * FROM t1;
73 c1 c2
74 0 aaaaa
75 1 bbbbb
76 2 ccccc
77 # Check for keyring file on slave.
78 keyring_slave
79 ALTER INSTANCE ROTATE INNODB MASTER KEY;
80 # Check for keyring file on slave.
81 keyring_slave
82 UNINSTALL PLUGIN keyring_file;
83 # Checking keyring plugin after uninstall.
84 SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
85 FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
86 include/stop_slave_sql.inc
87 [On Master]
88 CREATE TABLE t4(c1 INT PRIMARY KEY, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
89 INSERT INTO t4 VALUES(1, "rpltest");
90 [On Slave]
91 START SLAVE SQL_THREAD;
92 Warnings:
93 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
94 include/wait_for_slave_sql_error.inc [errno=3185]
95 INSTALL PLUGIN keyring_file SONAME 'keyring_file.so';
96 SET @@global.keyring_file_data='MYSQL_TMP_DIR/keyring_slave/keyring_slave';
97 SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
98 FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
99 PLUGIN_NAME keyring_file
100 PLUGIN_VERSION 1.0
101 PLUGIN_STATUS ACTIVE
102 include/start_slave_sql.inc
103 include/sync_slave_sql_with_master.inc
104 SELECT * FROM t4;
105 c1 c2
106 1 rpltest
107 [On Master]
108 # Uninstalling keyring_file plugin on master.
109 UNINSTALL PLUGIN keyring_file;
110 # Checking keyring plugin after uninstall.
111 SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
112 FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
113 SELECT * FROM t1;
114 c1 c2
115 0 aaaaa
116 1 bbbbb
117 2 ccccc
118
119 ALTER INSTANCE ROTATE INNODB MASTER KEY;
120 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
121 # Installing keyring_file plugin on master.
122 INSTALL PLUGIN keyring_file SONAME 'keyring_file.so';
123 # Cleanup
124 DROP TABLE t1,t2,t3,t4;
125 include/sync_slave_sql_with_master.inc
126 include/rpl_end.inc