7.5.4 Resetting a Channel

Resetting a channel removes all replication data on the channel, except the channel configuration. It is equivalent to RESET REPLICA ALL FOR CHANNEL. When there is an unrecoverable issue, the reset operation clears the records associated with replication so that the channel can have a clean start.

The target DB System drops its position in the source binary log, clears the replication metadata repositories, deletes the relay log files, and starts a new relay log file.

You can only reset an Inactive channel. To reset a Channel:

1. In the MySQL HeatWave Console, select the MySQL tab, and then click Channels to open the Channels page.
2. On the Channels page, in the list of channels, find the channel you want to reset, and do one of the following:
   • Click on the row of the channel to highlight it, and choose the Reset action from the Actions menu.
   • Click the name of the channel to open the Channel Details page. Click the Reset button from the Actions menu.

   The Reset MySQL Channel dialog is displayed.

3. Click Reset to reset the channel.

The state of the channel becomes Resetting, and when the reset is complete, the state changes to Inactive. Then, you can enable the channel to restart the replication.

Parent topic: Managing Replication Channels