All Products
Search

This Product

    PolarDB:STOP SLAVE

    Document Center

    PolarDB:STOP SLAVE

    Last Updated:Dec 10, 2024

    This topic describes how to execute the STOP SLAVE statement to disable the primary/secondary replication links that are created by executing the CHANGE MASTER TO statement.

    Syntax

    STOP SLAVE [ channel_option ]

channel_option:
    FOR CHANNEL channel

    Usage notes

    • You must use a privileged account of the current instance to execute this SQL statement.

    • If the channel_option parameter is specified, this statement takes effect only on the specified primary/secondary replication link. If the channel_option parameter is not specified, this statement takes effect on all primary/secondary replication links of the current instance.

    • You can replace SLAVE with REPLICA in this statement. The semantics remain unchanged.

    Example 1

    Execute the following statement to disable all the primary/secondary replication links that are created by executing the CHANGE MASTER TO statement: 

    STOP SLAVE;

    Example 2

    Execute the following statement to disable the primary/secondary replication link whose name is TEST: 

    STOP SLAVE for channel 'TEST';