Debian Codegraph @

mysql-test/suite/multi_source/gtid.result

raw
1 connect slave1,127.0.0.1,root,,,$SERVER_MYPORT_3;
2 connect slave2,127.0.0.1,root,,,$SERVER_MYPORT_4;
3 connect master1,127.0.0.1,root,,,$SERVER_MYPORT_1;
4 connect master2,127.0.0.1,root,,,$SERVER_MYPORT_2;
5 connection slave1;
6 CHANGE MASTER 'slave1' TO master_port=MYPORT_1, master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0;
7 CHANGE MASTER 'slave2' TO master_port=MYPORT_2, master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0;
8 set default_master_connection = 'slave1';
9 START SLAVE;
10 include/wait_for_slave_to_start.inc
11 set default_master_connection = 'slave2';
12 START SLAVE;
13 include/wait_for_slave_to_start.inc
14 set default_master_connection = '';
15 connection slave2;
16 CHANGE MASTER TO master_port=MYPORT_3, master_host='127.0.0.1', master_ssl_verify_server_cert=0, master_user='root';
17 start all slaves;
18 Warnings:
19 Note 1937 SLAVE '' started
20 include/wait_for_slave_to_start.inc
21 connection master1;
22 SET GLOBAL gtid_domain_id= 1;
23 SET SESSION gtid_domain_id= 1;
24 CREATE TABLE t3 (a INT PRIMARY KEY, b VARCHAR(10)) ENGINE=InnoDB;
25 CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10));
26 INSERT INTO t1 VALUES (1, "initial");
27 INSERT INTO t3 VALUES (101, "initial 1");
28 connection slave1;
29 connection master2;
30 SET GLOBAL gtid_domain_id= 2;
31 SET SESSION gtid_domain_id= 2;
32 CREATE TABLE t2 (a INT PRIMARY KEY, b VARCHAR(10)) ENGINE=InnoDB;
33 INSERT INTO t2 VALUES (1, "initial");
34 SET SQL_LOG_BIN=0;
35 CREATE TABLE t3 (a INT PRIMARY KEY, b VARCHAR(10));
36 SET SQL_LOG_BIN=1;
37 INSERT INTO t3 VALUES (201, "initial 2");
38 connection slave2;
39 *** Now move slave2 to replicate from both master1 and master2 instead of just slave1 ***
40 STOP ALL SLAVES;
41 Warnings:
42 Note 1938 SLAVE '' stopped
43 connection master1;
44 INSERT INTO t1 VALUES (2, "switch1");
45 INSERT INTO t3 VALUES (102, "switch1 a");
46 connection master2;
47 INSERT INTO t2 VALUES (2, "switch1");
48 INSERT INTO t3 VALUES (202, "switch1 b");
49 connection slave2;
50 CHANGE MASTER 'slave1' TO master_port=MYPORT_1, master_host='127.0.0.1', master_ssl_verify_server_cert=0, master_user='root';
51 CHANGE MASTER 'slave2' TO master_port=MYPORT_2, master_host='127.0.0.1', master_ssl_verify_server_cert=0, master_user='root';
52 SET default_master_connection = 'slave1';
53 START SLAVE;
54 include/wait_for_slave_to_start.inc
55 SET default_master_connection = 'slave2';
56 START SLAVE;
57 include/wait_for_slave_to_start.inc
58 set default_master_connection = '';
59 *** Move slave1 to replicate from slave2 instead of from master1 and master2 ***
60 connection slave1;
61 STOP SLAVE 'slave1';
62 connection master1;
63 INSERT INTO t1 VALUES (3, "switch 2");
64 INSERT INTO t3 VALUES (103, "switch 2 a");
65 connection slave2;
66 connection master2;
67 INSERT INTO t2 VALUES (3, "switch 2");
68 INSERT INTO t3 VALUES (203, "switch 2 b");
69 include/save_master_gtid.inc
70 connection slave1;
71 STOP SLAVE 'slave2';
72 connection master2;
73 INSERT INTO t2 VALUES (4, "switch 3");
74 INSERT INTO t3 VALUES (204, "switch 3 b");
75 connection slave2;
76 include/sync_with_master_gtid.inc
77 connection slave1;
78 CHANGE MASTER TO master_port=MYPORT_4, master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0;
79 START SLAVE;
80 SELECT * FROM t1 ORDER BY a;
81 a b
82 1 initial
83 2 switch1
84 3 switch 2
85 SELECT * FROM t2 ORDER BY a;
86 a b
87 1 initial
88 2 switch1
89 3 switch 2
90 4 switch 3
91 SELECT * FROM t3 ORDER BY a;
92 a b
93 101 initial 1
94 102 switch1 a
95 103 switch 2 a
96 201 initial 2
97 202 switch1 b
98 203 switch 2 b
99 204 switch 3 b
100 connection master1;
101 DROP TABLE t1;
102 SET SQL_LOG_BIN=0;
103 DROP TABLE t3;
104 SET SQL_LOG_BIN=1;
105 connection master2;
106 DROP TABLE t2;
107 DROP TABLE t3;
108 connection slave1;
109 SET GLOBAL gtid_domain_id=0;
110 STOP ALL SLAVES;
111 Warnings:
112 Note 1938 SLAVE '' stopped
113 include/reset_master_slave.inc
114 disconnect slave1;
115 connection slave2;
116 SET GLOBAL gtid_domain_id=0;
117 STOP ALL SLAVES;
118 Warnings:
119 Note 1938 SLAVE 'slave1' stopped
120 Note 1938 SLAVE 'slave2' stopped
121 include/reset_master_slave.inc
122 disconnect slave2;
123 connection master1;
124 SET GLOBAL gtid_domain_id=0;
125 include/reset_master_slave.inc
126 disconnect master1;
127 connection master2;
128 SET GLOBAL gtid_domain_id=0;
129 include/reset_master_slave.inc
130 disconnect master2;