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
|
# ==== Purpose ====
#
# Clear XCom configuration.
#
# ==== Usage ====
#
# --source include/gr_clear_configuration.inc
#
--let $_include_silent_group_replication_reset_configuration= $include_silent
--let $include_silent= 1
--let $include_filename= gr_clear_configuration.inc
--source include/begin_include_file.inc
# Save current connection.
--let $_old_connection= $CURRENT_CONNECTION
# Clean Group Replication XCom options on all servers to avoid false
# errors on MTR check testcase.
--let $_rpl_server_max= 10
--let $_rpl_server= 1
while ($_rpl_server <= $_rpl_server_max)
{
--let $_rpl_server_port= \$SERVER_MYPORT_$_rpl_server
if (!$_rpl_server_port)
{
# Break loop.
--let $_rpl_server= $_rpl_server_max
}
if ($_rpl_server_port)
{
--let $rpl_connection_name= server_aux_$_rpl_server
--let $rpl_server_number= $_rpl_server
--source include/rpl_connect.inc
--let $rpl_connection_name= server_aux_$_rpl_server
--source include/rpl_connection.inc
--disable_query_log
SET GLOBAL group_replication_local_address= "";
SET GLOBAL group_replication_group_seeds= "";
SET GLOBAL group_replication_force_members= "";
SET GLOBAL group_replication_bootstrap_group= OFF;
SET GLOBAL read_only= FALSE;
SET GLOBAL group_replication_ip_allowlist= "AUTOMATIC";
# Result-log is enabled.
# RESET PERSIST can be executed by test-case.
# If RESET PERSIST is executed it is the responsibility of test case to restore ip_allowlist.
# If we disable result log, test writer will not come to know ip_allowlist value is changed and needs restoration.
RESET PERSIST IF EXISTS group_replication_ip_allowlist;
if (!$skip_recovery_configuration)
{
# Clean distributed recovery user.
RESET REPLICA ALL FOR CHANNEL "group_replication_recovery";
}
# Clear the configuration of privilege_checks_user account
if ($rpl_privilege_checks_user != '')
{
--source include/rpl_get_instance_priv_checks_user.inc
if ($rpl_instance_privilege_checks_user != '')
{
if ($rpl_instance_privilege_checks_user != NULL)
{
--source include/rpl_clear_priv_checks_user_configuration.inc
}
}
}
# Clear replication asynchronous failover configuration tables
--source include/rpl_clear_asynchronous_failover_configuration.inc
# Clear GR member actions configuration
--disable_result_log ONCE
SELECT group_replication_reset_member_actions();
--enable_query_log
--connection default
--disconnect server_aux_$_rpl_server
}
--inc $_rpl_server
}
# Revert to old connection.
--connection $_old_connection
--let $include_filename= gr_clear_configuration.inc
--source include/end_include_file.inc
--let $include_silent= --let $_include_silent_group_replication_reset_configuration
|
