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
95
96
97
98
99
100
101
102
103
|
# ==== Purpose ====
#
# Issues STOP REPLICA on the current connection. Then waits until both
# the IO and SQL threads have stopped, or until a timeout is reached.
#
# Please use this instead of 'STOP REPLICA', to reduce the risk of races
# in test cases.
#
# This will fail if the slave IO or SQL thread has an error. If you
# expect an error in the IO thread, use
# include/wait_for_slave_io_error.inc and include/stop_slave_sql.inc.
#
#
# ==== Usage ====
#
# [--let $rpl_only_running_threads= 1]
# [--let $rpl_channel_name= 'NAME']
# [--let $slave_timeout= NUMBER]
# [--let $rpl_debug= 1]
# --source include/stop_slave.inc
#
# Parameters:
# $rpl_only_running_threads
# By default, this script executes STOP REPLICA unconditionally.
# This generates a warnings if one or both slave threads are
# already stopped. If $rpl_only_running_threads is set, this
# script checks which slave threads are running, and issues either
# STOP REPLICA, STOP REPLICA SQL_THREAD, STOP REPLICA IO_THREAD, or
# nothing.
#
# $rpl_channel_name
# If set, a FOR CHANNEL $rpl_channel_name is added.
#
# $slave_timeout
# See include/wait_for_slave_param.inc
#
# $rpl_debug
# See include/rpl_init.inc
--let $include_filename= stop_slave.inc
--let $_for_channel_clause=
if ($rpl_channel_name)
{
--let $_for_channel_clause= FOR CHANNEL $rpl_channel_name
--let $include_filename= $include_filename [FOR CHANNEL $rpl_channel_name]
}
--source include/begin_include_file.inc
if (!$rpl_debug)
{
--disable_query_log
}
--let $_for_channel_clause=
if ($rpl_channel_name)
{
--let $_for_channel_clause= FOR CHANNEL $rpl_channel_name
}
if ($rpl_only_running_threads)
{
--let $_slave_sql_running= query_get_value(SHOW SLAVE STATUS $_for_channel_clause, Slave_SQL_Running, 1)
--let $_slave_io_running= query_get_value(SHOW SLAVE STATUS $_for_channel_clause, Slave_IO_Running, 1)
if ($rpl_debug)
{
--echo Stop SQL: $_slave_sql_running; Stop IO: $_slave_io_running
}
--let $_slave_running_bits= `SELECT IF('$_slave_io_running' = 'Yes', 1, 0) + IF('$_slave_sql_running' = 'Yes', 2, 0)`
if ($_slave_running_bits)
{
--dec $_slave_running_bits
# $_slave_running_bits=1: io thread running
if (!$_slave_running_bits)
{
--source include/stop_slave_io.inc
}
--dec $_slave_running_bits
# $_slave_running_bits=2: sql thread running
if (!$_slave_running_bits)
{
--source include/stop_slave_sql.inc
}
--dec $_slave_running_bits
# $_slave_running_bits=2: both threads running
if (!$_slave_running_bits)
{
eval STOP REPLICA $_for_channel_clause;
--source include/wait_for_slave_to_stop.inc
}
}
}
if (!$rpl_only_running_threads)
{
eval STOP REPLICA $_for_channel_clause;
--source include/wait_for_slave_to_stop.inc
}
--let $include_filename= stop_slave.inc
--source include/end_include_file.inc
|
