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
|
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 server2]
SET SESSION sql_log_bin= 0;
call mtr.add_suppression("Member is not ONLINE, it is not possible to force a new group membership.");
call mtr.add_suppression("group_replication_force_members must be empty on group start. Current value: '127.0.0.1:10000'");
call mtr.add_suppression("Unable to start Group Replication on boot");
call mtr.add_suppression("force_members can only be updated when Group Replication is running*");
call mtr.add_suppression("The member lost contact with a majority of the members in the group. Until the network is restored.*");
call mtr.add_suppression("\\[GCS\\] Peer address .* is not valid.");
call mtr.add_suppression("\\[GCS\\] The peers list contains invalid addresses.Please provide a list with only valid addresses.");
call mtr.add_suppression("Error setting group_replication_force_members value .* on group communication interfaces");
call mtr.add_suppression("The member resumed contact with a majority of the members in the group.*");
call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': ... The replica coordinator and worker threads are stopped.*");
call mtr.add_suppression(".*Only alive members in the current configuration should be present in a forced configuration list.*");
call mtr.add_suppression("\\[GCS\\] Error reconfiguring group.");
SET SESSION sql_log_bin= 1;
[connection server1]
SET SESSION sql_log_bin= 0;
call mtr.add_suppression("Member is OFFLINE, it is not possible to force a new group membership");
call mtr.add_suppression("force_members can only be updated when Group Replication is running*");
SET SESSION sql_log_bin= 1;
############################################################
# 1. Set empty string value to
# group_replication_force_members on a OFFLINE
# member.
SET GLOBAL group_replication_force_members= "";
include/assert.inc [group_replication_force_members is empty]
############################################################
# 2. Set group_replication_force_members on a OFFLINE
# member.
SET GLOBAL group_replication_force_members= "127.0.0.1:10000";
ERROR HY000: The 'SET GLOBAL group_replication_force_members=127.0.0.1:10000' command encountered a failure. Member is not ONLINE, it is not possible to force a new group membership.
include/assert.inc [group_replication_force_members is empty]
############################################################
# 3. Set empty string value to
# group_replication_force_members on a ONLINE
# member.
include/start_and_bootstrap_group_replication.inc
SET GLOBAL group_replication_force_members= "";
include/assert.inc [group_replication_force_members is empty]
############################################################
# 4. Set valid IP string value to
# group_replication_force_members on a ONLINE member and
# majority of group members are reachable
SET GLOBAL group_replication_force_members= "127.0.0.1:10001";
ERROR HY000: The 'SET GLOBAL group_replication_force_members=127.0.0.1:10001' command encountered a failure. The group_replication_force_members can only be updated when Group Replication is running and majority of the members are unreachable.
include/assert.inc [group_replication_force_members is empty]
############################################################
# 5. Set empty string value to
# group_replication_force_members on a RECOVERING
# member.
[connection server2]
SET @@GLOBAL.DEBUG='+d,recovery_thread_wait_before_finish';
include/start_group_replication.inc
SET GLOBAL group_replication_force_members= "";
include/assert.inc [group_replication_force_members is empty]
############################################################
# 6. Set group_replication_force_members on a RECOVERING
# member.
include/gr_wait_for_member_state.inc
SET GLOBAL group_replication_force_members= "127.0.0.1:10000";
ERROR HY000: The 'SET GLOBAL group_replication_force_members=127.0.0.1:10000' command encountered a failure. The group_replication_force_members can only be updated when Group Replication is running and majority of the members are unreachable.
SET DEBUG_SYNC= "now WAIT_FOR signal.recovery_thread_wait_before_finish_reached";
SET @@GLOBAL.DEBUG='-d,recovery_thread_wait_before_finish';
SET DEBUG_SYNC= "now SIGNAL signal.recovery_end";
[connection server2]
include/gr_wait_for_member_state.inc
SET DEBUG_SYNC= 'RESET';
############################################################
# 7. Restart member with group_replication_force_members
# set. Group Replication start will error out.
# 2 members.
[connection server2]
# restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_start_on_boot=1 --group-replication-group-name=GROUP_REPLICATION_GROUP_NAME --group_replication_force_members=127.0.0.1:10000
include/rpl_reconnect.inc
include/assert.inc [Member 2 is OFFLINE]
############################################################
# 8. Start Group Replication while
# group_replication_force_members is set. Start
# will error out.
include/assert.inc [group_replication_force_members must be 127.0.0.1:10000]
START GROUP_REPLICATION;
ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
include/assert.inc [Member 2 is OFFLINE]
############################################################
# 9. Clear group_replication_force_members and start
# Group Replication. Group will have the 2 members.
SET GLOBAL group_replication_force_members= "";
include/assert.inc [group_replication_force_members is empty]
include/start_group_replication.inc
[connection server1]
include/rpl_gr_wait_for_number_of_members.inc
include/assert.inc [Server 1 must be present on group members]
include/assert.inc [Server 2 must be present on group members]
[connection server2]
include/rpl_gr_wait_for_number_of_members.inc
include/assert.inc [Server 1 must be present on group members]
include/assert.inc [Server 2 must be present on group members]
include/assert.inc [group_replication_force_members must be empty]
############################################################
# 10. Kill and restart a member to group loose majority.
[connection server1]
# Kill and restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS1 --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_group_name=GROUP_REPLICATION_GROUP_NAME
include/rpl_reconnect.inc
[connection server2]
include/gr_wait_for_member_state.inc
############################################################
# 11. Set invalid IP string value to
# group_replication_force_members on a ONLINE member and
# majority of group members are unreachable.
SET GLOBAL group_replication_force_members= "256.256.256.777:1234";
ERROR HY000: The 'SET GLOBAL group_replication_force_members=256.256.256.777:1234' command encountered a failure. Error setting group_replication_force_members value '256.256.256.777:1234'. Please check error log for additional details.
include/assert.inc [group_replication_force_members is empty]
############################################################
# 12. Set IP of an UNREACHABLE member to
# group_replication_force_members on a ONLINE member .
SET GLOBAL group_replication_force_members= "GROUP_REPLICATION_LOCAL_ADDRESS1";;
ERROR HY000: The 'SET GLOBAL group_replication_force_members=GROUP_REPLICATION_LOCAL_ADDRESS1' command encountered a failure. Error setting group_replication_force_members value 'GROUP_REPLICATION_LOCAL_ADDRESS1'. Please check error log for additional details.
include/assert.inc [group_replication_force_members is empty]
############################################################
# 13. Set valid IP string value to
# group_replication_force_members on a ONLINE member and
# majority of group members are unreachable
SET GLOBAL group_replication_force_members= "GROUP_REPLICATION_LOCAL_ADDRESS1";
include/assert.inc [group_replication_force_members has member2 local address]
############################################################
# 14. Clean up.
[connection server1]
include/start_group_replication.inc
include/group_replication_end.inc
|
