mirror of
https://github.com/MariaDB/server.git
synced 2025-09-22 09:05:29 +02:00
c45a34b2fb
When master-retry-count equals 0, it means the slave will try to reconnect to the master continuously. But, when the number of tries err_count overflows to 0, the connection will abort. So, when an overflow occurs, we still need to check master-retry-cout value. If master-retry-count equals 0, reconnection should continue. Reviewed-by: ParadoxV5 <paradox.ver5@gmail.com>
88 lines
2.3 KiB
PHP
88 lines
2.3 KiB
PHP
# ==== Purpose ====
|
|
#
|
|
# During shutdown of the master, check Slave_IO_Running status
|
|
# after reconnecting a specified number of times.
|
|
#
|
|
# ==== Usage ====
|
|
#
|
|
# --let $overflow= 0
|
|
# --let $retry_count= 3
|
|
# --let $expected_Slave_IO_Running_status= Connecting
|
|
# --source rpl_mdev36002.inc
|
|
#
|
|
# Parameters:
|
|
# $overflow
|
|
# If overflow equals 1, the DEBUG flag 'set_slave_err_count_near_overflow'
|
|
# will be activated, and the number of tries made will be initialized to
|
|
# ULONG_MAX - 2.
|
|
#
|
|
# $retry_count
|
|
# The number of reconnections the slave will do during shutdown of the master.
|
|
#
|
|
# $expected_Slave_IO_Running_status
|
|
# Whether Slave_IO_Running should be Connecting/No
|
|
# after reconnecting $retry_count times.
|
|
#
|
|
|
|
|
|
--source include/have_debug.inc
|
|
--source include/have_debug_sync.inc
|
|
|
|
# Set MASTER_CONNECT_RETRY as 1 second
|
|
--let $rpl_skip_start_slave= 1
|
|
--source include/master-slave.inc
|
|
|
|
--connection slave
|
|
CHANGE MASTER TO MASTER_CONNECT_RETRY= 1;
|
|
--source include/start_slave.inc
|
|
|
|
|
|
# Set err_count as ULONG_MAX if necessary and starts up sync points
|
|
SET @saved_dbug= @@GLOBAL.debug_dbug;
|
|
|
|
if ($overflow)
|
|
{
|
|
SET @@GLOBAL.debug_dbug= '+d,set_slave_err_count_near_overflow';
|
|
}
|
|
SET @@GLOBAL.debug_dbug= '+d,sync_master_retry';
|
|
|
|
|
|
# stop the master
|
|
--let $rpl_server_number= 1
|
|
--source include/rpl_stop_server.inc
|
|
|
|
# Everytime the reconnection is done, check the status of Slave_IO_Running
|
|
while ($retry_count)
|
|
{
|
|
SET @@SESSION.debug_sync= 'now WAIT_FOR master_retry_sleep';
|
|
--let $slave_param= Slave_IO_Running
|
|
--let $slave_param_value= Connecting
|
|
--source include/wait_for_slave_param.inc
|
|
|
|
SET @@SESSION.debug_sync= 'now SIGNAL master_retry_continue';
|
|
--dec $retry_count
|
|
}
|
|
|
|
# after exhausting exactly that many number of tries,
|
|
# the Slave_IO_Running status should be expected.
|
|
|
|
--echo Slave_IO_Running status should be $expected_Slave_IO_Running_status
|
|
--let $slave_param= Slave_IO_Running
|
|
--let $slave_param_value= $expected_Slave_IO_Running_status
|
|
--source include/wait_for_slave_param.inc
|
|
|
|
SET @@GLOBAL.debug_dbug= @saved_dbug;
|
|
|
|
|
|
# Restart the master to reestablish a successful slave connection for clean-up
|
|
--let $rpl_server_number= 1
|
|
--source include/rpl_start_server.inc
|
|
|
|
--connection slave
|
|
--disable_warnings
|
|
START SLAVE;
|
|
--enable_warnings
|
|
--let $rpl_allow_error= 1
|
|
--source include/wait_for_slave_io_to_start.inc
|
|
|
|
--source include/rpl_end.inc
|