68 lines
1.7 KiB
PHP
68 lines
1.7 KiB
PHP
# ==== 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;
|
|
|
|
if (!$skip_recovery_configuration)
|
|
{
|
|
# Clean distributed recovery user.
|
|
RESET SLAVE ALL FOR CHANNEL "group_replication_recovery";
|
|
}
|
|
|
|
--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
|