Managing a Replication Channel
Use the Console to enable, disable, resume, reset, or edit an inbound replication channel.
Enabling or Disabling a Channel
Enabling a replication channel that is in the Inactive state starts replication from the source if there are no errors. Disabling a replication channel stops replication and puts the channel into the Inactive state.
Resuming a Channel
When an inbound replication channel is in the Needs Attention state, fix the error then resume the channel to restart replication. The Details column on the Channels page explains why a replication channel needs attention.
The Needs Attention state may also be displayed because the DB system is in
INACTIVE
state. In that case, replication cannot restart until the
DB system is active.
Using the Console
You can restart replication after an error is fixed by resuming the channel.
- Open the navigation menu and select Databases. Under HeatWave MySQL, click Channels.
- Choose your compartment from the List Scope.
- In the list of channels, find the channel you want to resume, and do one of the
following:
- Select the channel and choose Resume from the Actions menu at the top of the page.
- Click the Action menu on the same line as your channel and click Resume.
- Click the name of the channel to open the Channel Details page and click Resume.
Related Topics
Resetting a Channel
Resetting an inbound replication channel removes all 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.
Using the Console
Use the reset operation when there is an unrecoverable error in replication. Only the channel configuration is retained, and the records are removed.
To reset an inbound replication channel, it must be inactive. You cannot reset an active channel.
- Open the navigation menu and select Databases. Under HeatWave MySQL, click Channels.
- Choose your compartment from the List Scope.
- In the list of channels, find the channel you want to enable or disable, and do
one of the following:
- Select the channel and choose Reset from the Actions menu at the top of the page.
- Click the Action menu on the same line as your channel and click Reset.
- Click the name of the channel to open the Channel Details page and click Reset.
Editing a Channel
Edit an inbound replication channel if you need to change configuration items such as the channel name, description, or source connection details after you create it.
Using the Console
Use the Console to edit an inbound replication channel's configuration.
- Open the navigation menu and select Databases. Under HeatWave MySQL, click Channels.
- Choose your compartment from the List Scope.
- In the list of channels, find the channel you want to resume, and do one of the
following:
- Click the Action menu on the same line as your channel and click Edit.
- Click the name of the channel to open the Channel Details page and click Edit.
- In the Edit Channel panel, edit the channel details. You cannot change the compartment and target DB system.
- Click Save Changes.
Deleting a Channel
Deleting an inbound replication channel removes the channel.
Using the Console
Use the delete operation to remove a channel.
You cannot delete a channel that has an active, inactive, or needs attention state.
- Open the navigation menu and select Databases. Under HeatWave MySQL, click Channels.
- Choose your compartment from the List Scope.
- In the list of channels, find the channel you want to delete, and do one of the following:
- Select the channel and choose Delete from the Actions menu at the top of the page.
- Click the Action menu on the same line as your channel and click Delete.
- Click the name of the channel to open the Channel Details page and click More actions and select Delete.
- Click Delete channel in the Delete channel dialog.