Топ-100
 

STOP SLAVE

База данных: MySQL
Текст

Syntax:
STOP SLAVE [thread_types] [channel_option]

thread_types:
[thread_type [, thread_type] ... ]

thread_type: IO_THREAD | SQL_THREAD

channel_option:
FOR CHANNEL channel

Stops the replication threads. STOP SLAVE requires the
REPLICATION_SLAVE_ADMIN privilege (or the deprecated SUPER privilege).
Recommended best practice is to execute STOP SLAVE on the replica
before stopping the replica server (see
https://dev.mysql.com/doc/refman/8.0/en/server-shutdown.html, for more
information).

When using the row-based logging format: You should execute STOP SLAVE
or STOP SLAVE SQL_THREAD on the replica prior to shutting down the
replica server if you are replicating any tables that use a
nontransactional storage engine (see the Note later in this section).

Like START SLAVE, this statement may be used with the IO_THREAD and
SQL_THREAD options to name the thread or threads to be stopped. Note
that the Group Replication applier channel (group_replication_applier)
has no I/O thread, only a SQL thread. Using the SQL_THREAD option
therefore stops this channel completely.

STOP SLAVE causes an implicit commit of an ongoing transaction. See
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html.

gtid_next must be set to AUTOMATIC before issuing this statement.

You can control how long STOP SLAVE waits before timing out by setting
the rpl_stop_slave_timeout system variable. This can be used to avoid
deadlocks between STOP SLAVE and other SQL statements using different
client connections to the replica. When the timeout value is reached,
the issuing client returns an error message and stops waiting, but the
STOP SLAVE instruction remains in effect. Once the replication threads
are no longer busy, the STOP SLAVE statement is executed and the
replica stops.

Some CHANGE MASTER TO statements are allowed while the replica is
running, depending on the states of the replication threads. However,
using STOP SLAVE prior to executing CHANGE MASTER TO in such cases is
still supported. See [HELP CHANGE MASTER TO], and
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-switch.ht
ml, for more information.

The optional FOR CHANNEL channel clause enables you to name which
replication channel the statement applies to. Providing a FOR CHANNEL
channel clause applies the STOP SLAVE statement to a specific
replication channel. If no channel is named and no extra channels
exist, the statement applies to the default channel. If a STOP SLAVE
statement does not name a channel when using multiple channels, this
statement stops the specified threads for all channels. This statement
cannot be used with the group_replication_recovery channel. See
https://dev.mysql.com/doc/refman/8.0/en/replication-channels.html for
more information.

When using statement-based replication: changing the source while it
has open temporary tables is potentially unsafe. This is one of the
reasons why statement-based replication of temporary tables is not
recommended. You can find out whether there are any temporary tables on
the replica by checking the value of Slave_open_temp_tables; when using
statement-based replication, this value should be 0 before executing
CHANGE MASTER TO. If there are any temporary tables open on the
replica, issuing a CHANGE MASTER TO statement after issuing a STOP
SLAVE causes an ER_WARN_OPEN_TEMP_TABLES_MUST_BE_ZERO
(https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.h
tml#error_er_warn_open_temp_tables_must_be_zero) warning.

When using a multithreaded replica (slave_parallel_workers is a nonzero
value), any gaps in the sequence of transactions executed from the
relay log are closed as part of stopping the worker threads. If the
replica is stopped unexpectedly (for example due to an error in a
worker thread, or another thread issuing KILL) while a STOP SLAVE
statement is executing, the sequence of executed transactions from the
relay log may become inconsistent. See
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transactio
n-inconsistencies.html, for more information.

If the current replication event group has modified one or more
nontransactional tables, STOP SLAVE waits for up to 60 seconds for the
event group to complete, unless you issue a KILL QUERY or KILL
CONNECTION statement for the replication SQL thread. If the event group
remains incomplete after the timeout, an error message is logged.

URL: https://dev.mysql.com/doc/refman/8.0/en/stop-slave.html

Пример