Debian Codegraph @

mysql-test/suite/galera/t/galera_gtid_slave_sst_rsync.test

raw
1 #
2 # Test Galera as a slave to a MariaDB master using GTIDs
3 #
4 # suite/galera/galera_2nodes_as_slave.cnf describes the setup of the nodes
5 #
6 # In addition to performing DDL and DML, we check that the gtid of the master is preserved inside the cluster
7 #
8
9 --source include/big_test.inc
10 --source include/have_innodb.inc
11 --source include/galera_cluster.inc
12
13 # As node #3 is not a Galera node, and galera_cluster.inc does not open connetion to it
14 # we open the node_3 connection here
15 --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
16
17 --echo #Connection 2
18 --connection node_2
19 --disable_query_log
20 --eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='root', MASTER_SSL_VERIFY_SERVER_CERT=0, MASTER_PORT=$NODE_MYPORT_3, master_use_gtid=slave_pos;
21 --enable_query_log
22 START SLAVE;
23 --sleep 1
24
25 --echo #Connection 3
26 --connection node_3
27 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY, f2 int unique) ENGINE=InnoDB;
28 INSERT INTO t2 VALUES(1,11);
29 INSERT INTO t2 VALUES(2,22);
30 INSERT INTO t2 VALUES(3,33);
31
32 SELECT @@global.gtid_binlog_state;
33 --source include/save_master_gtid.inc
34
35 --echo #Connection 2
36 --connection node_2
37 --source include/sync_with_master_gtid.inc
38 SELECT @@global.gtid_binlog_state;
39
40 INSERT INTO t2 VALUES(4,44);
41 INSERT INTO t2 VALUES(5,55);
42 INSERT INTO t2 VALUES(6,66);
43 SELECT @@global.gtid_binlog_state;
44
45 --echo #Connection 1
46 --connection node_1
47 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= 't2';
48 --source include/wait_condition.inc
49 --let $wait_condition = SELECT COUNT(*) = 6 FROM t2;
50 --source include/wait_condition.inc
51
52 INSERT INTO t2 VALUES(7,77);
53 INSERT INTO t2 VALUES(8,88);
54 SELECT @@global.gtid_binlog_state;
55
56 #Perform SST
57 --echo #Connection 3
58 --connection node_3
59 CREATE TABLE t1 (f1 CHAR(255)) ENGINE=InnoDB;
60 SET AUTOCOMMIT=OFF;
61 START TRANSACTION;
62 INSERT INTO t1 VALUES ('node1_committed_before');
63 INSERT INTO t1 VALUES ('node1_committed_before');
64 COMMIT;
65 --source include/save_master_gtid.inc
66
67 --echo #Connection 2
68 --connection node_2
69 --source include/sync_with_master_gtid.inc
70 SET AUTOCOMMIT=OFF;
71 START TRANSACTION;
72 INSERT INTO t1 VALUES ('node2_committed_before');
73 INSERT INTO t1 VALUES ('node2_committed_before');
74 COMMIT;
75
76 --echo #Connection 1
77 --connection node_1
78 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= 't1';
79 --source include/wait_condition.inc
80 --let $wait_condition = SELECT COUNT(*) = 4 FROM t1;
81 --source include/wait_condition.inc
82 --let $node_1= node_1
83 --let $node_2= node_2
84 --source include/auto_increment_offset_save.inc
85
86 --echo #Connection 2
87 --connection node_2
88 --echo Shutting down server ...
89 --source include/shutdown_mysqld.inc
90
91 --echo #Connection 1
92 --connection node_1
93 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
94 --source include/wait_condition.inc
95 SET AUTOCOMMIT=OFF;
96 START TRANSACTION;
97 INSERT INTO t1 VALUES ('node1_committed_during');
98 INSERT INTO t1 VALUES ('node1_committed_during');
99 COMMIT;
100
101 --echo #Connection 2
102 --connection node_2
103 --echo Starting server ...
104 --source include/start_mysqld.inc
105
106 --source include/wait_until_ready.inc
107 --source include/auto_increment_offset_restore.inc
108
109 SET AUTOCOMMIT=OFF;
110 START TRANSACTION;
111 INSERT INTO t1 VALUES ('node2_committed_after');
112 INSERT INTO t1 VALUES ('node2_committed_after');
113 COMMIT;
114
115 --echo #Connection 1
116 --connection node_1
117 --let $wait_condition = SELECT COUNT(*) = 8 FROM t1;
118 --source include/wait_condition.inc
119 Select * from t1 order by f1;
120
121 --echo #Connection 2
122 --connection node_2
123 Select * from t1 order by f1;
124
125 #SST Done
126 --sleep 1
127 --echo #Connection 1
128 --connection node_1
129 SELECT @@global.gtid_binlog_state;
130 --echo #Connection 2
131 --connection node_2
132 SELECT @@global.gtid_binlog_state;
133 --echo #Connection 3
134 --connection node_3
135 SET AUTOCOMMIT=ON;
136 #drop table t1;
137 #CREATE TABLE t1 (f1 CHAR(255)) ENGINE=InnoDB;
138 --echo #Connection 2
139 --connection node_2
140 SET AUTOCOMMIT=ON;
141 --echo #Connection 1
142 --connection node_1
143 SET AUTOCOMMIT=ON;
144
145 #
146 #stop slave on node 2
147 --echo #Connection 2
148 --connection node_2
149 STOP slave;
150 --sleep 1
151 INSERT INTO t1 VALUES ('node2_slave_stoped');
152 --echo #Connection 3
153 --connection node_3
154 INSERT INTO t1 VALUES ('node3_normal_entry');
155 --source include/save_master_gtid.inc
156
157 #start slave
158 --echo #Connection 2
159 --connection node_2
160 INSERT INTO t1 VALUES ('node2_slave_stoped_inserted');
161 start slave;
162 --source include/sync_with_master_gtid.inc
163 INSERT INTO t1 VALUES ('node2_slave_started');
164 SELECT count(*) from t1;
165 SELECT @@global.gtid_binlog_state;
166
167 --echo #Connection 1
168 --connection node_1
169 --let $wait_condition = SELECT COUNT(*) = 12 FROM t1;
170 --source include/wait_condition.inc
171 SELECT count(*) from t1;
172 SELECT @@global.gtid_binlog_state;
173
174 --echo #Connection 3
175 --connection node_3
176 DROP TABLE t2,t1;
177
178 # Unfortunately without the sleep below the following statement fails with "query returned no rows", which
179 # is difficult to understand given that it is an aggregate query. A "query execution was interrupted"
180 # warning is also reported by MTR, which is also weird.
181 #
182
183 --sleep 3
184 --echo #Connection 2
185 --connection node_2
186 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2';
187 --source include/wait_condition.inc
188
189 --echo #Connection 1
190 --connection node_1
191 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
192 --source include/wait_condition.inc
193
194 --echo #Connection 2
195 --connection node_2
196 STOP SLAVE;
197 RESET SLAVE ALL;
198 set global wsrep_on=OFF;
199 reset master;
200 set global wsrep_on=ON;
201
202 --disable_warnings
203 set global gtid_slave_pos="";
204 --enable_warnings
205
206 --echo #Connection 1
207 --connection node_1
208 set global wsrep_on=OFF;
209 reset master;
210 set global wsrep_on=ON;
211
212 --echo #Connection 3
213 --connection node_3
214 reset master;
215
216 --connection node_2
217 CALL mtr.add_suppression("Ignoring server id .* for non bootstrap node");