Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2, 1->3, 1->4, 1->5]
2 connection server_1;
3 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
4 CREATE TABLE t4 (a INT, b INT, PRIMARY KEY (a,b)) Engine=InnoDB;
5 CREATE FUNCTION extract_gtid(d VARCHAR(100), s VARCHAR(100))
6 RETURNS VARCHAR(100) DETERMINISTIC
7 BEGIN
8 SET s= CONCAT(",", s, ",");
9 SET s= SUBSTR(s FROM LOCATE(CONCAT(",", d, "-"), s) + 1);
10 SET s= SUBSTR(s FROM 1 FOR LOCATE(",", s) - 1);
11 RETURN s;
12 END|
13 connection server_2;
14 include/stop_slave.inc
15 connection server_3;
16 include/stop_slave.inc
17 connection server_4;
18 include/stop_slave.inc
19 connection server_5;
20 include/stop_slave.inc
21 connection server_1;
22 SET gtid_domain_id= 1;
23 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
24 INSERT INTO t1 VALUES (1);
25 INSERT INTO t1 VALUES (2);
26 INSERT INTO t4 VALUES (1, 1);
27 INSERT INTO t1 VALUES (3);
28 INSERT INTO t1 VALUES (4);
29 INSERT INTO t4 VALUES (1, 3);
30 SET gtid_domain_id= 2;
31 CREATE TABLE t2 (a INT PRIMARY KEY) ENGINE=InnoDB;
32 INSERT INTO t2 VALUES (1);
33 INSERT INTO t2 VALUES (2);
34 INSERT INTO t4 VALUES (2, 1);
35 INSERT INTO t2 VALUES (3);
36 INSERT INTO t2 VALUES (4);
37 INSERT INTO t4 VALUES (2, 3);
38 SET gtid_domain_id= 3;
39 CREATE TABLE t3 (a INT PRIMARY KEY) ENGINE=InnoDB;
40 INSERT INTO t3 VALUES (1);
41 INSERT INTO t3 VALUES (2);
42 INSERT INTO t4 VALUES (3, 1);
43 INSERT INTO t3 VALUES (3);
44 INSERT INTO t3 VALUES (4);
45 INSERT INTO t4 VALUES (3, 3);
46 connection server_2;
47 START SLAVE UNTIL master_gtid_pos= "1-1-4,2-1-4,3-1-4";
48 connection server_3;
49 START SLAVE UNTIL master_gtid_pos= "1-1-1,2-1-4,3-1-7";
50 connection server_4;
51 START SLAVE UNTIL master_gtid_pos= "2-1-1,3-1-4,1-1-7";
52 connection server_5;
53 START SLAVE UNTIL master_gtid_pos= "3-1-1,1-1-4,2-1-7";
54 connection server_2;
55 include/wait_for_slave_to_stop.inc
56 SELECT * FROM t1 ORDER BY a;
57 a
58 1
59 2
60 SELECT * FROM t2 ORDER BY a;
61 a
62 1
63 2
64 SELECT * FROM t3 ORDER BY a;
65 a
66 1
67 2
68 SELECT * FROM t4 ORDER BY a,b;
69 a b
70 1 1
71 2 1
72 3 1
73 connection server_3;
74 include/wait_for_slave_to_stop.inc
75 SELECT * FROM t1 ORDER BY a;
76 a
77 SELECT * FROM t2 ORDER BY a;
78 a
79 1
80 2
81 SELECT * FROM t3 ORDER BY a;
82 a
83 1
84 2
85 3
86 4
87 SELECT * FROM t4 ORDER BY a,b;
88 a b
89 2 1
90 3 1
91 3 3
92 connection server_4;
93 include/wait_for_slave_to_stop.inc
94 SELECT * FROM t1 ORDER BY a;
95 a
96 1
97 2
98 3
99 4
100 SELECT * FROM t2 ORDER BY a;
101 a
102 SELECT * FROM t3 ORDER BY a;
103 a
104 1
105 2
106 SELECT * FROM t4 ORDER BY a,b;
107 a b
108 1 1
109 1 3
110 3 1
111 connection server_5;
112 include/wait_for_slave_to_stop.inc
113 SELECT * FROM t1 ORDER BY a;
114 a
115 1
116 2
117 SELECT * FROM t2 ORDER BY a;
118 a
119 1
120 2
121 3
122 4
123 SELECT * FROM t3 ORDER BY a;
124 a
125 SELECT * FROM t4 ORDER BY a,b;
126 a b
127 1 1
128 2 1
129 2 3
130 *** Now replicate all extra changes from 3,4,5 to 2, in preparation for making 2 the new master. ***
131 connection server_3;
132 connection server_2;
133 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_3;
134 START SLAVE UNTIL master_gtid_pos = "SERVER3_POS";
135 include/wait_for_slave_to_stop.inc
136 SELECT * FROM t1 ORDER BY a;
137 a
138 1
139 2
140 SELECT * FROM t2 ORDER BY a;
141 a
142 1
143 2
144 SELECT * FROM t3 ORDER BY a;
145 a
146 1
147 2
148 3
149 4
150 SELECT * FROM t4 ORDER BY a,b;
151 a b
152 1 1
153 2 1
154 3 1
155 3 3
156 connection server_4;
157 connection server_2;
158 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_4;
159 START SLAVE UNTIL master_gtid_pos = "SERVER4_POS";
160 include/wait_for_slave_to_stop.inc
161 SELECT * FROM t1 ORDER BY a;
162 a
163 1
164 2
165 3
166 4
167 SELECT * FROM t2 ORDER BY a;
168 a
169 1
170 2
171 SELECT * FROM t3 ORDER BY a;
172 a
173 1
174 2
175 3
176 4
177 SELECT * FROM t4 ORDER BY a,b;
178 a b
179 1 1
180 1 3
181 2 1
182 3 1
183 3 3
184 connection server_5;
185 connection server_2;
186 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_5;
187 START SLAVE UNTIL master_gtid_pos = "SERVER5_POS";
188 include/wait_for_slave_to_stop.inc
189 SELECT * FROM t1 ORDER BY a;
190 a
191 1
192 2
193 3
194 4
195 SELECT * FROM t2 ORDER BY a;
196 a
197 1
198 2
199 3
200 4
201 SELECT * FROM t3 ORDER BY a;
202 a
203 1
204 2
205 3
206 4
207 SELECT * FROM t4 ORDER BY a,b;
208 a b
209 1 1
210 1 3
211 2 1
212 2 3
213 3 1
214 3 3
215 *** Now make 2 master and point 3,4,5 to the new master 2
216 connection server_2;
217 SET gtid_domain_id= 1;
218 INSERT INTO t1 values (5);
219 INSERT INTO t4 values (1,5);
220 SET gtid_domain_id= 2;
221 INSERT INTO t2 values (5);
222 INSERT INTO t4 values (2,5);
223 SET gtid_domain_id= 3;
224 INSERT INTO t3 values (5);
225 INSERT INTO t4 values (3,5);
226 connection server_3;
227 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2;
228 include/start_slave.inc
229 connection server_4;
230 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2;
231 include/start_slave.inc
232 connection server_5;
233 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2;
234 include/start_slave.inc
235 connection server_2;
236 connection server_3;
237 SELECT * FROM t1 ORDER BY a;
238 a
239 1
240 2
241 3
242 4
243 5
244 SELECT * FROM t2 ORDER BY a;
245 a
246 1
247 2
248 3
249 4
250 5
251 SELECT * FROM t3 ORDER BY a;
252 a
253 1
254 2
255 3
256 4
257 5
258 SELECT * FROM t4 ORDER BY a,b;
259 a b
260 1 1
261 1 3
262 1 5
263 2 1
264 2 3
265 2 5
266 3 1
267 3 3
268 3 5
269 connection server_5;
270 SELECT * FROM t1 ORDER BY a;
271 a
272 1
273 2
274 3
275 4
276 5
277 SELECT * FROM t2 ORDER BY a;
278 a
279 1
280 2
281 3
282 4
283 5
284 SELECT * FROM t3 ORDER BY a;
285 a
286 1
287 2
288 3
289 4
290 5
291 SELECT * FROM t4 ORDER BY a,b;
292 a b
293 1 1
294 1 3
295 1 5
296 2 1
297 2 3
298 2 5
299 3 1
300 3 3
301 3 5
302 connection server_5;
303 SELECT * FROM t1 ORDER BY a;
304 a
305 1
306 2
307 3
308 4
309 5
310 SELECT * FROM t2 ORDER BY a;
311 a
312 1
313 2
314 3
315 4
316 5
317 SELECT * FROM t3 ORDER BY a;
318 a
319 1
320 2
321 3
322 4
323 5
324 SELECT * FROM t4 ORDER BY a,b;
325 a b
326 1 1
327 1 3
328 1 5
329 2 1
330 2 3
331 2 5
332 3 1
333 3 3
334 3 5
335 *** Now let the old master join up as slave. ***
336 connection server_1;
337 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2,
338 master_user = "root", master_ssl_verify_server_cert=0,
339 master_use_gtid = slave_pos, master_demote_to_slave=1;
340 include/start_slave.inc
341 SELECT * FROM t1 ORDER BY a;
342 a
343 1
344 2
345 3
346 4
347 5
348 SELECT * FROM t2 ORDER BY a;
349 a
350 1
351 2
352 3
353 4
354 5
355 SELECT * FROM t3 ORDER BY a;
356 a
357 1
358 2
359 3
360 4
361 5
362 SELECT * FROM t4 ORDER BY a,b;
363 a b
364 1 1
365 1 3
366 1 5
367 2 1
368 2 3
369 2 5
370 3 1
371 3 3
372 3 5
373 *** Finally move things back and clean up. ***
374 connection server_1;
375 include/stop_slave.inc
376 RESET SLAVE ALL;
377 connection server_2;
378 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_1;
379 include/start_slave.inc
380 connection server_3;
381 include/stop_slave.inc
382 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_1;
383 include/start_slave.inc
384 connection server_4;
385 include/stop_slave.inc
386 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_1;
387 include/start_slave.inc
388 connection server_5;
389 include/stop_slave.inc
390 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_1;
391 include/start_slave.inc
392 connection server_1;
393 SET gtid_domain_id = 0;
394 DROP TABLE t1;
395 DROP TABLE t2;
396 DROP TABLE t3;
397 DROP TABLE t4;
398 DROP FUNCTION extract_gtid;
399 include/rpl_end.inc