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
|
include/group_replication.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 server1]
[connection server1]
# CHANGE MASTER command is blocked for other options than `PRIVILEGE_CHECKS_USER`.
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10 FOR CHANNEL "group_replication_applier";
ERROR HY000: CHANGE REPLICATION SOURCE with the given parameters cannot be performed on channel 'group_replication_applier'.
# CHANGE MASTER command is blocked for other options than `PRIVILEGE_CHECKS_USER`.
CHANGE REPLICATION SOURCE TO SOURCE_CONNECTION_AUTO_FAILOVER=1 FOR CHANNEL "group_replication_applier";
ERROR HY000: CHANGE REPLICATION SOURCE with the given parameters cannot be performed on channel 'group_replication_applier'.
# CHANGE MASTER command is blocked for option `PRIVILEGE_CHECKS_USER` when GR is running
CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER='user' FOR CHANNEL "group_replication_applier";
ERROR HY000: This operation cannot be performed while Group Replication is running; run STOP GROUP_REPLICATION first
# error when executing START SLAVE IO_THREAD FOR CHANNEL
START SLAVE IO_THREAD FOR CHANNEL 'group_replication_applier';
ERROR HY000: START REPLICA IO_THREAD FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
# error when executing STOP SLAVE IO_THREAD FOR CHANNEL
STOP SLAVE IO_THREAD FOR CHANNEL 'group_replication_applier';
ERROR HY000: STOP REPLICA IO_THREAD FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
# error when executing START SLAVE IO_THREAD FOR CHANNEL with UNTIL option
START SLAVE IO_THREAD UNTIL SOURCE_LOG_FILE = 'server-binary-log.000001', SOURCE_LOG_POS = 781 FOR CHANNEL 'group_replication_applier';
ERROR HY000: START REPLICA IO_THREAD FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
# error when executing START SLAVE FOR CHANNEL
START SLAVE FOR CHANNEL 'group_replication_applier';
ERROR HY000: START REPLICA FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
# error when executing STOP SLAVE FOR CHANNEL
STOP SLAVE FOR CHANNEL 'group_replication_applier';
ERROR HY000: STOP REPLICA FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
# error when executing SHOW SLAVE STATUS FOR CHANNEL
SHOW SLAVE STATUS FOR CHANNEL 'group_replication_applier';
ERROR HY000: SHOW REPLICA STATUS cannot be performed on channel 'group_replication_applier'.
# START SLAVE SQL_THREAD command will not work for group_replication_applier
START REPLICA SQL_THREAD FOR CHANNEL "group_replication_applier";
ERROR HY000: START REPLICA FOR CHANNEL while Group Replication is running cannot be performed on channel 'group_replication_applier'.
# STOP SLAVE SQL_THREAD command will not work for group_replication_applier
STOP REPLICA SQL_THREAD FOR CHANNEL "group_replication_applier";
ERROR HY000: STOP REPLICA FOR CHANNEL while Group Replication is running cannot be performed on channel 'group_replication_applier'.
# START SLAVE SQL_THREAD with UNTIL option will not work for group_replication_applier
START SLAVE SQL_THREAD UNTIL SQL_BEFORE_GTIDS='11111111-1111-1111-1111-111111111111:1-23' FOR CHANNEL 'group_replication_applier';
ERROR HY000: START REPLICA FOR CHANNEL while Group Replication is running cannot be performed on channel 'group_replication_applier'.
# START SLAVE SQL_THREAD with UNTIL option will not work for group_replication_applier
START SLAVE SQL_THREAD UNTIL RELAY_LOG_FILE = 'server-relay-log-group_replication_applier.000002', RELAY_LOG_POS = 10000 FOR CHANNEL 'group_replication_applier';
ERROR HY000: START REPLICA FOR CHANNEL while Group Replication is running cannot be performed on channel 'group_replication_applier'.
# SHOW RELAYLOG EVENTS for channel will work for all channels
include/assert.inc [Relay log name should not be empty as the command successfully executed.]
[connection server1]
include/stop_group_replication.inc
# CHANGE MASTER command is blocked for other options than `PRIVILEGE_CHECKS_USER`.
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10 FOR CHANNEL "group_replication_applier";
ERROR HY000: CHANGE REPLICATION SOURCE with the given parameters cannot be performed on channel 'group_replication_applier'.
# CHANGE MASTER command is blocked for other options than `PRIVILEGE_CHECKS_USER`.
CHANGE REPLICATION SOURCE TO SOURCE_CONNECTION_AUTO_FAILOVER=1 FOR CHANNEL "group_replication_applier";
ERROR HY000: CHANGE REPLICATION SOURCE with the given parameters cannot be performed on channel 'group_replication_applier'.
# CHANGE MASTER command allows option `PRIVILEGE_CHECKS_USER` when GR is stopped
SET SESSION sql_log_bin= 0;
CREATE USER gr_applier_slave_user;
SET SESSION sql_log_bin= 1;
CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER='gr_applier_slave_user' FOR CHANNEL "group_replication_applier";
CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER=NULL FOR CHANNEL "group_replication_applier";
SET SESSION sql_log_bin= 0;
DROP USER gr_applier_slave_user;
SET SESSION sql_log_bin= 1;
# error when executing START SLAVE IO_THREAD FOR CHANNEL
START SLAVE IO_THREAD FOR CHANNEL 'group_replication_applier';
ERROR HY000: START REPLICA IO_THREAD FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
# error when executing STOP SLAVE IO_THREAD FOR CHANNEL
STOP SLAVE IO_THREAD FOR CHANNEL 'group_replication_applier';
ERROR HY000: STOP REPLICA IO_THREAD FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
# error when executing START SLAVE FOR CHANNEL
START SLAVE FOR CHANNEL 'group_replication_applier';
ERROR HY000: START REPLICA FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
# error when executing STOP SLAVE FOR CHANNEL
STOP SLAVE FOR CHANNEL 'group_replication_applier';
ERROR HY000: STOP REPLICA FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
# error when executing SHOW SLAVE STATUS FOR CHANNEL
SHOW SLAVE STATUS FOR CHANNEL 'group_replication_applier';
ERROR HY000: SHOW REPLICA STATUS cannot be performed on channel 'group_replication_applier'.
# START SLAVE SQL_THREAD command will work for group_replication_applier
include/gr_start_applier_sql_thread.inc
START REPLICA SQL_THREAD FOR CHANNEL "group_replication_applier";
# STOP SLAVE SQL_THREAD command will work for group_replication_applier
include/gr_stop_applier_sql_thread.inc
STOP REPLICA SQL_THREAD FOR CHANNEL "group_replication_applier";
# SHOW RELAYLOG EVENTS for channel will work for all channels
include/assert.inc [Relay log name should not be empty as the command successfully executed.]
[connection server1]
include/start_group_replication.inc
[connection server2]
# RESET SLAVE [ALL] command is blocked only when channel is running.
RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
ERROR HY000: RESET REPLICA [ALL] FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
RESET SLAVE FOR CHANNEL "group_replication_applier";
ERROR HY000: RESET REPLICA [ALL] FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
# This is command should work without problem.
include/stop_group_replication.inc
RESET SLAVE FOR CHANNEL "group_replication_applier";
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
include/start_group_replication.inc
# This is command should work without problem.
include/stop_group_replication.inc
RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
include/start_group_replication.inc
# RESET SLAVE should not be allowed when GR is ONLINE.
# So this command will fail.
RESET SLAVE FOR CHANNEL "group_replication_applier";
ERROR HY000: RESET REPLICA [ALL] FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
# RESET SLAVE ALL should not be allowed when GR is ONLINE.
# So this command will fail.
RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
ERROR HY000: RESET REPLICA [ALL] FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
# stop the channel and try reset slave for channel again. It should work.
include/stop_group_replication.inc
RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
RESET SLAVE FOR CHANNEL "group_replication_applier";
ERROR HY000: Replica channel 'group_replication_applier' does not exist.
include/group_replication_end.inc
|
