Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.6Mb
PDF (A4) - 40.7Mb
PDF (RPM) - 40.2Mb
HTML Download (TGZ) - 10.7Mb
HTML Download (Zip) - 10.7Mb
HTML Download (RPM) - 9.3Mb
Man Pages (TGZ) - 241.8Kb
Man Pages (Zip) - 346.8Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  Resetting Multi-Source Replicas

17.1.5.7 Resetting Multi-Source Replicas

The RESET REPLICA | SLAVE statement can be used to reset a multi-source replica. By default, if you use the RESET REPLICA | SLAVE statement on a multi-source replica all channels are reset. Optionally, use the FOR CHANNEL channel clause to reset only a specific channel.

  • To reset all currently configured replication channels:

    mysql> RESET SLAVE;
    Or from MySQL 8.0.22:
    mysql> RESET REPLICA;
  • To reset only a named channel, use a FOR CHANNEL channel clause:

    mysql> RESET SLAVE FOR CHANNEL "source_1";
    Or from MySQL 8.0.22:
    mysql> RESET REPLICA FOR CHANNEL "source_1";

For GTID-based replication, note that RESET REPLICA | SLAVE has no effect on the replica's GTID execution history. If you want to clear this, issue RESET MASTER on the replica.

RESET REPLICA | SLAVE makes the replica forget its replication position, and clears the relay log, but it does not change any replication connection parameters (such as the source host name) or replication filters. If you want to remove these for a channel, issue RESET REPLICA | SLAVE ALL.

For the full syntax of the RESET REPLICA | SLAVE command and other available options, see Section 13.4.2.4, “RESET REPLICA | SLAVE Statement”.