Debian Codegraph @

mysql-test/suite/group_replication/t/gr_perfschema_group_members_number.test

raw
1 ################################################################################
2 # WL#7331: Check that member status are properly updated when members join
3 # and leave group.
4 #
5 # Test:
6 # 0. The test requires three servers: M1, M2 and M3.
7 # 1. Initially, check no members on the group.
8 # 2. Bootstrap start M1. Check one member on the group.
9 # 3. Start M2. Check two members on the group.
10 # 4. Start M3. Check three members on the group.
11 # 5. Stop M1. Check two members on the group.
12 # 6. Stop M2. Check one member on the group.
13 # 7. Stop M3. Check no members on the group.
14 ################################################################################
15 --source include/big_test.inc
16 --let $group_replication_group_name= 8a94f357-aab4-11df-86ab-c80aa9429500
17 --source include/have_group_replication_plugin.inc
18 --let $rpl_skip_group_replication_start= 1
19 --let $rpl_server_count= 3
20 --source include/group_replication.inc
21
22 --echo
23 --echo ###########################################################
24 --echo # 1. No members on group.
25 --connection server1
26 --let $group_replication_number_of_members= 0
27 --source include/gr_wait_for_number_of_members.inc
28
29 --connection server2
30 --let $group_replication_number_of_members= 0
31 --source include/gr_wait_for_number_of_members.inc
32
33 --connection server3
34 --let $group_replication_number_of_members= 0
35 --source include/gr_wait_for_number_of_members.inc
36
37
38 --echo
39 --echo ###########################################################
40 --echo # 2. One member on group.
41 --connection server1
42 --source include/start_and_bootstrap_group_replication.inc
43
44 --connection server1
45 --let $group_replication_number_of_members= 1
46 --source include/gr_wait_for_number_of_members.inc
47
48 --connection server2
49 --let $group_replication_number_of_members= 0
50 --source include/gr_wait_for_number_of_members.inc
51
52 --connection server3
53 --let $group_replication_number_of_members= 0
54 --source include/gr_wait_for_number_of_members.inc
55
56
57 --echo
58 --echo ###########################################################
59 --echo # 3. Two members on group.
60 --connection server2
61 --source include/start_group_replication.inc
62
63 --connection server1
64 --let $group_replication_number_of_members= 2
65 --source include/gr_wait_for_number_of_members.inc
66
67 --connection server2
68 --let $group_replication_number_of_members= 2
69 --source include/gr_wait_for_number_of_members.inc
70
71 --connection server3
72 --let $group_replication_number_of_members= 0
73 --source include/gr_wait_for_number_of_members.inc
74
75
76 --echo
77 --echo ###########################################################
78 --echo # 4. Three members on group.
79 --connection server3
80 --source include/start_group_replication.inc
81
82 --connection server1
83 --let $group_replication_number_of_members= 3
84 --source include/gr_wait_for_number_of_members.inc
85
86 --connection server2
87 --let $group_replication_number_of_members= 3
88 --source include/gr_wait_for_number_of_members.inc
89
90 --connection server3
91 --let $group_replication_number_of_members= 3
92 --source include/gr_wait_for_number_of_members.inc
93
94 --replace_column 2 MEMBER_ID 3 MEMBER_HOST 4 MEMBER_PORT
95 SELECT CHANNEL_NAME, MEMBER_ID, MEMBER_HOST, MEMBER_PORT, MEMBER_STATE FROM performance_schema.replication_group_members;
96
97
98 --echo
99 --echo ###########################################################
100 --echo # 5. Two members on group.
101 --connection server1
102 --source include/stop_group_replication.inc
103
104 --connection server1
105 --let $group_replication_number_of_members= 0
106 --source include/gr_wait_for_number_of_members.inc
107
108 --connection server2
109 --let $group_replication_number_of_members= 2
110 --source include/gr_wait_for_number_of_members.inc
111
112 --connection server3
113 --let $group_replication_number_of_members= 2
114 --source include/gr_wait_for_number_of_members.inc
115
116
117 --echo
118 --echo ###########################################################
119 --echo # 6. One member on group.
120 --connection server2
121 --source include/stop_group_replication.inc
122
123 --connection server1
124 --let $group_replication_number_of_members= 0
125 --source include/gr_wait_for_number_of_members.inc
126
127 --connection server2
128 --let $group_replication_number_of_members= 0
129 --source include/gr_wait_for_number_of_members.inc
130
131 --connection server3
132 --let $group_replication_number_of_members= 1
133 --source include/gr_wait_for_number_of_members.inc
134
135
136 --echo
137 --echo ###########################################################
138 --echo # 7. No members on group.
139 --connection server3
140 --source include/stop_group_replication.inc
141
142 --let $group_replication_number_of_members= 0
143 --connection server1
144 --source include/gr_wait_for_number_of_members.inc
145
146 --connection server2
147 --let $group_replication_number_of_members= 0
148 --source include/gr_wait_for_number_of_members.inc
149
150 --connection server3
151 --let $group_replication_number_of_members= 0
152 --source include/gr_wait_for_number_of_members.inc
153
154 --source include/group_replication_end.inc