| 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 |
|