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
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
|
include/master-slave.inc [rpl_server_count=3]
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]
call mtr.add_suppression("Replica I/O thread .* register on source");
call mtr.add_suppression("Replica I/O: Source command COM_REGISTER_REPLICA failed: .*");
CALL mtr.add_suppression(".*source and replica have equal MySQL server UUIDs.*");
CALL mtr.add_suppression("Source's UUID has changed, although this should not happen unless you have changed it manually");
CALL mtr.add_suppression("Replica I/O: SET @master_heartbeat_period to source failed with error: Lost connection to MySQL server during query");
CALL mtr.add_suppression("Notifying source by SET @master_binlog_checksum= @@global.binlog_checksum failed with error");
CALL mtr.add_suppression("A replica with the same server_uuid/server_id as this replica has connected to the source");
SET @@GLOBAL.LOG_ERROR_VERBOSITY= 3;
include/sync_slave_sql_with_master.inc
# Case 1:
# Master's UUID appears in the result of 'SHOW SLAVE STATUS'.
# Slave's UUID appears in the result of 'SHOW SLAVE HOSTS'.
-----------------------------------------------------------------------------
include/assert.inc ["Slave's SHOW SLAVE HOST should contain the correct value for master's server_uuid]
include/assert.inc [Master's SHOW SLAVE HOSTS should contain the correct value for slave's server_uuid]
# Case 2:
# After executing 'STOP SLAVE [IO_THREAD|SQL_THREAD]' successfully, Master's UUID
# is still kept into Slave status.
-----------------------------------------------------------------------------
include/stop_slave_io.inc
include/check_slave_param.inc [Slave_IO_Running]
include/stop_slave_sql.inc
include/check_slave_param.inc [Slave_SQL_Running]
include/start_slave.inc
include/stop_slave.inc
include/check_slave_param.inc [Slave_IO_Running]
# Case 3:
# Slave generates an error and aborts, if master's UUID is
# equal to slave's UUID unless --replicate-same-server-id
# option is set.
-----------------------------------------------------------------------------
include/rpl_restart_server.inc [server_number=1]
START SLAVE IO_THREAD;
Warnings:
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
include/wait_for_slave_io_error.inc [errno=13117]
include/rpl_restart_server.inc [server_number=1]
# server_3 is running with --replicate-same-server-id option
CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1',
SOURCE_PORT= MASTER_PORT,
SOURCE_USER= 'root',
SOURCE_LOG_FILE='master-bin.000001';
Warnings:
Warning #### CHANGE REPLICATION SOURCE TO with a SOURCE_LOG_FILE clause but no SOURCE_LOG_POS clause may not be safe. The old position value may not be valid for the new binary log file.
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/check_slave_no_error.inc
include/sync_slave_sql_with_master.inc
include/stop_slave.inc
include/rpl_restart_server.inc [server_number=1]
# Case 4:
# When executing 'CHANGE MASTER ...', master's UUID and server_id will be
# cleared if master_host or/and master_port are changed.
# Master's UUID and server_id will not be cleared if both master_port
# and master_host are not changed.
-----------------------------------------------------------------------------
include/start_slave_io.inc
include/wait_for_slave_param.inc [Master_UUID]
include/stop_slave.inc
# Only change MASTER_PORT
CHANGE REPLICATION SOURCE TO SOURCE_PORT= 1111;
include/check_slave_param.inc [Master_UUID]
include/check_slave_param.inc [Master_Server_Id]
CHANGE REPLICATION SOURCE TO SOURCE_PORT= MASTER_PORT,
SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_POS;
include/start_slave_io.inc
include/wait_for_slave_param.inc [Master_UUID]
# Only change MASTER_HOST
STOP SLAVE IO_THREAD;
Warnings:
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
include/wait_for_slave_io_to_stop.inc
CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'localhost';
include/check_slave_param.inc [Master_UUID]
include/check_slave_param.inc [Master_Server_Id]
CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1',
SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_POS;
include/start_slave_io.inc
include/wait_for_slave_param.inc [Master_UUID]
# Both MASTER_HOST and MASTER_PORT are changed
STOP SLAVE IO_THREAD;
Warnings:
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
include/wait_for_slave_io_to_stop.inc
CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1', SOURCE_PORT= 1111;
include/check_slave_param.inc [Master_UUID]
include/check_slave_param.inc [Master_Server_Id]
CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1', SOURCE_PORT= MASTER_PORT,
SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_POS;
include/start_slave_io.inc
include/wait_for_slave_param.inc [Master_UUID]
# Both MASTER_HOST and MASTER_PORT are NOT changed
STOP SLAVE IO_THREAD;
Warnings:
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
include/wait_for_slave_io_to_stop.inc
CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1', SOURCE_PORT= MASTER_PORT;
include/check_slave_param.inc [Slave_IO_Running]
CHANGE REPLICATION SOURCE TO
SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_POS;
include/check_slave_param.inc [Slave_IO_Running]
# Case 5:
# After executing 'RESET SLAVE' successfully, Master's UUID is still kept
# into Slave status.
-----------------------------------------------------------------------------
RESET SLAVE;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
include/check_slave_param.inc [Slave_IO_Running]
CHANGE REPLICATION SOURCE TO
SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_POS;
include/start_slave.inc
# Case 6:
# In an existing master-slave replication forum (M->S1), if another
# slave (S2) with the same UUID as S1 joins the forum and connects
# to Master(M), the master will throw an error to the first slave
# connection that will not try to reconnect.
-----------------------------------------------------------------------------
include/rpl_restart_server.inc [server_number=3]
[connection server_2]
include/wait_for_slave_io_error.inc [errno=13114]
include/assert_grep.inc [Found the expected line in master's error log for server 2 disconnection]
include/start_slave_io.inc
[connection server_3]
include/wait_for_slave_io_error.inc [errno=13114]
include/assert_grep.inc [Found the expected line in master's error log for server 3 disconnection]
include/assert_grep.inc [Found the expected line in server 2 error log]
include/assert_grep.inc [Found the expected line in server 3 error log]
include/rpl_restart_server.inc [server_number=3]
include/stop_slave.inc
[connection master]
SET @@GLOBAL.log_error_verbosity= OLD_LOG_ERROR_VERBOSITY;
include/rpl_end.inc
|
