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
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
|
include/master-slave.inc
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
[connection master]
master_id: 1
stop slave;
Warnings:
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
*** --replicate-same-server-id and change master option can clash ***
CHANGE REPLICATION SOURCE to IGNORE_SERVER_IDS= (2, 1);
ERROR HY000: The requested server id 2 clashes with the replica startup option --replicate-same-server-id
*** must be empty due to the error ***
ignore server id list:
CHANGE REPLICATION SOURCE to IGNORE_SERVER_IDS= (10, 100);
*** must be 10, 100 ***
ignore server id list: 10, 100
reset slave;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
*** must be still (10,100) after reset slave ***
ignore server id list: 10, 100
CHANGE REPLICATION SOURCE to IGNORE_SERVER_IDS= (10, 100);
*** CHANGE MASTER with IGNORE_SERVER_IDS option overrides (does not increment) the previous setup ***
CHANGE REPLICATION SOURCE to IGNORE_SERVER_IDS= (5, 1, 4, 3, 1);
*** must be 1, 3, 4, 5 due to overriding policy ***
ignore server id list: 1, 3, 4, 5
*** ignore master (server 1) queries for a while ***
include/start_slave.inc
include/sync_slave_sql_with_master.inc
create table t1 (n int);
include/wait_for_slave_param.inc [Exec_Master_Log_Pos]
*** must be empty as the event is to be filtered out ***
show tables;
Tables_in_test
*** allowing events from master ***
stop slave;
Warnings:
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
include/wait_for_slave_to_stop.inc
reset slave;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE to IGNORE_SERVER_IDS= (10, 100);
*** the list must remain (10, 100) after reset slave ***
CHANGE REPLICATION SOURCE to IGNORE_SERVER_IDS= ();
*** must be empty due to IGNORE_SERVER_IDS empty list ***
ignore server id list:
*** RESET SLAVE ALL should empty the list ***
CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (10, 100);
ignore server id list: 10, 100
RESET SLAVE ALL;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root';
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
include/start_slave.inc
include/assert.inc [RESET SLAVE ALL must empty the list of server-ids.]
include/sync_slave_sql_with_master.inc
*** must have caught create table ***
show tables;
Tables_in_test
t1
drop table t1;
include/sync_slave_sql_with_master.inc
# === Bug#18192817 IGNORE_SERVER_IDS IS SHOWING DUPLICATE SERVER IDS ===
include/stop_slave.inc
The list should have 0 elements.
Replicate_Ignore_Server_Ids = ''
CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (110,220,330,420);
The list should have 4 elements.
Replicate_Ignore_Server_Ids = '110, 220, 330, 420'
CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (110,220,330,420), IGNORE_SERVER_IDS= (110,220,330,420);
The list should still have only 4 elements.
Replicate_Ignore_Server_Ids = '110, 220, 330, 420'
ISSUE WAS HERE: All server ids should be stored and showed only once, while they are set twice or even more.
The list should have 5 elements.
CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (110,220,330,420), IGNORE_SERVER_IDS= (111,220,330,420);
Replicate_Ignore_Server_Ids = '110, 111, 220, 330, 420'
CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (110,220,330,420), IGNORE_SERVER_IDS= (111,221,330,420);
The list should have 6 elements.
Replicate_Ignore_Server_Ids = '110, 111, 220, 221, 330, 420'
CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (110,220,330,420), IGNORE_SERVER_IDS= (111,221,331,420);
The list should have 7 elements.
Replicate_Ignore_Server_Ids = '110, 111, 220, 221, 330, 331, 420'
CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (110,220,330,420), IGNORE_SERVER_IDS= (111,221,331,421);
The list should have 8 elements.
Replicate_Ignore_Server_Ids = '110, 111, 220, 221, 330, 331, 420, 421'
CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= ();
The list should have NO elements.
Replicate_Ignore_Server_Ids = ''
# === Bug #18593479: ON MASTER_INFO_REPOSITORY CHANGE, ===
# === IGNORE_SERVER_IDS DOUBLES WITH DUP VALUES ===
SET GLOBAL master_info_repository= 'FILE';
Warnings:
Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (5,10,15);
include/start_slave.inc
Expect 3 elements.
Replicate_Ignore_Server_Ids = '5, 10, 15'
include/stop_slave.inc
SET GLOBAL master_info_repository= 'TABLE';
Warnings:
Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
include/start_slave.inc
ISSUE WAS HERE: Due to buggy behaviour, we woule see 6 elements here.
Expect 3 elements ONLY to verify the fix when changing from FILE->TABLE.
Replicate_Ignore_Server_Ids = '5, 10, 15'
include/stop_slave.inc
SET GLOBAL master_info_repository= 'FILE';
Warnings:
Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
include/start_slave.inc
ISSUE WAS HERE TOO: Due to buggy behaviour, we woule see 12 elements here.
Expect 3 elements ONLY to verify the fix when changinf from TABLE->FILE.
Replicate_Ignore_Server_Ids = '5, 10, 15'
include/stop_slave.inc
CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= ();
include/start_slave.inc
include/rpl_end.inc
|
