Debian Codegraph @

mysql-test/suite/x/t/macros/group_replication.macro

raw
1 ################################################################
2 #
3 # This file contains following Group Replication helper macros:
4 #
5 # * Setsession - SESSION_NAME
6 # * Connect_to_instance - SESSION_NAME_PREFIX SERVER_INDEX TCP_PORT
7 # * Connect_to_all_mysqld_instances - SESSION_NAME_PREFIX NUMBER_OF_SERVERS_TO_INITIALIZE
8 # * GR_clear_bootstrap_group - NUMBER_OF_SERVERS_TO_INITIALIZE
9 # * GR_start_and_bootstrap - NUMBER_OF_SERVERS_TO_INITIALIZE GROUP_NAME EXPECTED_STATE
10 # * GR_start - GROUP_NAME EXPECTED_STATE
11 # * GR_stop
12 # * GR_start_applier_sql_thread
13 # * GR_stop_applier_sql_thread
14 # * GR_wait_for_number_of_members - EXPECTED_NUMBER_OF_MEMBERS
15 # * GR_wait_for_member_state - EXPECTED_STATE
16 # * GR_wait_for_uuid_and_member_state - UUID EXPECTED_STATE
17 #
18
19
20 #
21 ## General macros
22 #
23 -->macro Setsession %NAME%
24 quiet;
25 echo [connection %NAME%];
26 setsession %NAME%;
27 noquiet;
28 -->endmacro
29
30
31 -->macro Connect_to_instance %PREFIX% %INSTANCE_ID% %PORT%
32 varlet %OPTION_CLIENT_PORT% %PORT%;
33 newsession %PREFIX%_%INSTANCE_ID% %OPTION_CLIENT_USER%;
34 -->endmacro
35
36
37 -->macro Connect_to_all_mysqld_instances %PREFIX% %NUMBER_OF_SERVERS%
38 repeat %NUMBER_OF_SERVERS% %ITERATION%;
39 varlet %ITERATION_SESSION% %ITERATION%;
40 varinc %ITERATION_SESSION% 1;
41 varlet %PORT_NAME% %SERVER_XPORT_%ITERATION_SESSION%%;
42 callmacro Connect_to_instance %PREFIX% %ITERATION_SESSION% %PORT_NAME%;
43 endrepeat;
44 -->endmacro
45
46
47 #
48 ## Group-replication specific macros
49 #
50 -->macro GR_clear_bootstrap_group %NUMBER_OF_SERVERS%
51 noquery_result;
52 repeat %NUMBER_OF_SERVERS% %ITERATION%;
53 varlet %__SESSION% %NUMBER_OF_SERVERS%;
54 varinc %__SESSION% -%ITERATION%;
55 callmacro Setsession server_%__SESSION%;
56 SET GLOBAL group_replication_bootstrap_group= 0;
57 endrepeat;
58 query_result;
59 -->endmacro
60
61
62 -->macro GR_start_and_bootstrap %NUMBER_OF_SERVERS% %GR_NAME% %EXPECTED_STATE%
63 callmacro Setsession server_1;
64 noquery_result;
65 SET GLOBAL group_replication_bootstrap_group= 1;
66 query_result;
67 callmacro GR_start %GR_NAME% %EXPECTED_STATE%;
68 callmacro GR_clear_bootstrap_group %NUMBER_OF_SERVERS%;
69 -->endmacro
70
71
72 -->macro GR_start %GR_NAME% %EXPECTED_STATE%
73 noquery_result;
74 varsub %GR_NAME%;
75 SET GLOBAL group_replication_group_name='%GR_NAME%';
76 START GROUP_REPLICATION;
77 query_result;
78
79 callmacro GR_wait_for_member_state %EXPECTED_STATE%;
80 -->endmacro
81
82
83 -->macro GR_stop
84 noquery_result;
85 STOP GROUP_REPLICATION;
86 quiet;
87 wait_for 1 SELECT COUNT(*)=1
88 FROM performance_schema.replication_connection_status connection_status
89 WHERE connection_status.channel_name="group_replication_applier"
90 AND connection_status.service_state="OFF";
91 wait_for 1 SELECT @@GLOBAL.super_read_only=1;
92 wait_for 1 SELECT @@GLOBAL.read_only=1;
93 noquiet;
94 SET GLOBAL read_only= FALSE;
95 query_result;
96 -->endmacro
97
98
99 -->macro GR_start_applier_sql_thread
100 noquery_result;
101 START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
102 quiet;
103 wait_for 1 SELECT service_state="ON"
104 FROM performance_schema.replication_applier_status
105 WHERE channel_name="group_replication_applier";
106 noquiet;
107 query_result;
108 -->endmacro
109
110
111 -->macro GR_stop_applier_sql_thread
112 noquery_result;
113 STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
114 quiet;
115 wait_for 1 SELECT service_state="OFF"
116 FROM performance_schema.replication_applier_status
117 WHERE channel_name="group_replication_applier";
118 noquiet;
119 query_result;
120 -->endmacro
121
122
123 -->macro GR_wait_for_number_of_members %EXPECTED_NUMBER_OF_MEMBERS%
124 echo [waiting for '%EXPECTED_NUMBER_OF_MEMBERS%' members];
125 quiet;
126 noquery_result;
127 wait_for %EXPECTED_NUMBER_OF_MEMBERS% SELECT COUNT(*)
128 FROM performance_schema.replication_group_members;
129 noquiet;
130 query_result;
131 -->endmacro
132
133
134 -->macro GR_wait_for_member_state %STATE%
135 echo [waiting for member_state to be equal '%STATE%'];
136 quiet;
137 noquery_result;
138 wait_for 1 SELECT COUNT(*)=1 FROM performance_schema.replication_group_members
139 WHERE member_id=@@SERVER_UUID AND
140 member_state="%STATE%";
141 stmtsql SELECT COUNT(*)=1
142 FROM performance_schema.replication_group_members group_members
143 WHERE group_members.member_id= @@SERVER_UUID
144 AND group_members.member_state="ONLINE"
145 AND group_members.member_role = "PRIMARY"
146 AND group_members.member_version =
147 (SELECT member_version FROM performance_schema.replication_group_members
148 ORDER BY member_version ASC LIMIT 1);
149 recvtovar %IS_PRIMARY%;
150
151 ## Workaround for missing 'if' statement in mysqlxtest syntax.
152 wait_for 1 SELECT @@GLOBAL.read_only = '0' OR !%IS_PRIMARY%;
153 noquiet;
154 query_result;
155 -->endmacro
156
157
158 -->macro GR_wait_for_uuid_and_member_state %UUID% %STATE%
159 echo [waiting for concrete member with member_state to be equal '%STATE%'];
160 quiet;
161 noquery_result;
162 wait_for 1 SELECT COUNT(*)=1 FROM performance_schema.replication_group_members
163 WHERE member_id='%UUID%' AND
164 member_state="%STATE%";
165 stmtsql SELECT COUNT(*)=1
166 FROM performance_schema.replication_group_members group_members
167 WHERE group_members.member_id like '%UUID%'
168 AND group_members.member_state like "%STATE%"
169 AND group_members.member_role = "PRIMARY"
170 AND group_members.member_version =
171 (SELECT member_version FROM performance_schema.replication_group_members
172 ORDER BY member_version ASC LIMIT 1);
173 recvtovar %IS_PRIMARY%;
174
175 ## Workaround for missing 'if' statement in mysqlxtest syntax.
176 wait_for 1 SELECT @@GLOBAL.read_only = '0' OR !%IS_PRIMARY%;
177 noquiet;
178 query_result;
179 -->endmacro
180