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