All Products
Search

This Product

    PolarDB:START SLAVE

    Document Center

    PolarDB:START SLAVE

    Last Updated:Dec 10, 2024

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

    Syntax

    START 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 enable all the primary/secondary replication links that are created by executing the CHANGE MASTER TO statement: 

    START SLAVE;

    Example 2

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

    START SLAVE for channel 'TEST';