Debian Codegraph @

mysql-test/suite/multi_source/mdev-9544.result

raw
1 connect server_1,127.0.0.1,root,,,$SERVER_MYPORT_1;
2 connect server_2,127.0.0.1,root,,,$SERVER_MYPORT_2;
3 connect server_3,127.0.0.1,root,,,$SERVER_MYPORT_3;
4 connect server_4,127.0.0.1,root,,,$SERVER_MYPORT_4;
5 connection server_1;
6 create database a;
7 use a;
8 create table t1(a int);
9 insert into t1 values(1);
10 create table t2(a int);
11 insert into t2 values(1);
12 connection server_2;
13 create database b;
14 use b;
15 create table t1(a int);
16 insert into t1 values(1);
17 create table t2(a int);
18 insert into t2 values(1);
19 connection server_3;
20 create database c;
21 use c;
22 create table t1(a int);
23 insert into t1 values(1);
24 create table t2(a int);
25 insert into t2 values(1);
26 connection server_4;
27 change master 'm1' to master_port=MYPORT_1 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
28 change master 'm2' to master_port=MYPORT_2 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
29 change master to master_port=MYPORT_3 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
30 start all slaves;
31 set default_master_connection = 'm1';
32 include/wait_for_slave_to_start.inc
33 set default_master_connection = 'm2';
34 include/wait_for_slave_to_start.inc
35 set default_master_connection = '';
36 include/wait_for_slave_to_start.inc
37 use a;
38 show tables;
39 Tables_in_a
40 t1
41 t2
42 use b;
43 show tables;
44 Tables_in_b
45 t1
46 t2
47 use c;
48 show tables;
49 Tables_in_c
50 t1
51 t2
52 #TEST
53 SET default_master_connection = "m1";
54 SET default_master_connection = "m2";
55 SET default_master_connection = "";
56 flush logs;
57 SET default_master_connection = "m1";
58 #log Rotated
59 mysqld-relay-bin.000002
60 mysqld-relay-bin.000003
61 mysqld-relay-bin.index
62 SET default_master_connection = "m2";
63 #log Rotated
64 mysqld-relay-bin-m1.000002
65 mysqld-relay-bin-m1.000003
66 mysqld-relay-bin-m1.index
67 SET default_master_connection = "";
68 #log Rotated
69 mysqld-relay-bin-m2.000002
70 mysqld-relay-bin-m2.000003
71 mysqld-relay-bin-m2.index
72 #CleanUp
73 connection server_1;
74 drop database a;
75 connection server_2;
76 drop database b;
77 connection server_3;
78 drop database c;
79 connection server_4;
80 stop all slaves;
81 Warnings:
82 Note 1938 SLAVE 'm2' stopped
83 Note 1938 SLAVE '' stopped
84 Note 1938 SLAVE 'm1' stopped
85 SET default_master_connection = "m1";
86 include/wait_for_slave_to_stop.inc
87 SET default_master_connection = "m2";
88 include/wait_for_slave_to_stop.inc
89 SET default_master_connection = "";
90 include/wait_for_slave_to_stop.inc
91 change master to master_use_gtid=slave_pos;
92 change master 'm1' to master_use_gtid=slave_pos;
93 change master 'm2' to master_use_gtid=slave_pos;