Oracle Cloud Infrastructure Documentation

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.

  • Using the Console
  • Using the REST API, run the UpdateChannel operation:
    • Specify a TRUE value in the isEnabled attribute to enable the channel.
    • Specify a FALSE value in the isEnabled attribute to disable the channel.

Using the Console

Enable or disable an inbound replication channel using console actions.

  1. Open the navigation menu and select Databases. Under HeatWave MySQL, click Channels.
  2. Choose your compartment from the List Scope.
  3. In the list of channels, find the channel you want to enable or disable.
  4. To disable an active channel, do one of the following:
    • Select the channel and choose Disable from the Actions menu at the top of the page.
    • Click the Action menu on the same line as your channel and click Disable.
    • Click the name of the channel to open the Channel Details page and click Disable.
    The state of the channel changes to Updating and then to Inactive.
  5. To enable an inactive channel, do the following:
    • Select the channel and choose Enable from the Actions menu at the top of the page.
    • Click the Action menu on the same line as your channel and click Enable.
    • Click the name of the channel to open the Channel Details page and click Enable.
    The state of the channel changes to Updating and then to Active.

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.

Do the following to resume a channel:
  1. Open the navigation menu and select Databases. Under HeatWave MySQL, click Channels.
  2. Choose your compartment from the List Scope.
  3. 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.
The state of the channel changes to Updating, and if the error is resolved, changes to Active.

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.

Do the following to reset a channel:
  1. Open the navigation menu and select Databases. Under HeatWave MySQL, click Channels.
  2. Choose your compartment from the List Scope.
  3. 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.
You can now enable the replication channel.

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.

Do the following to edit a channel:
  1. Open the navigation menu and select Databases. Under HeatWave MySQL, click Channels.
  2. Choose your compartment from the List Scope.
  3. 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.
  4. In the Edit Channel panel, edit the channel details. You cannot change the compartment and target DB system.
  5. 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.

Do the following to delete a channel:
  1. Open the navigation menu and select Databases. Under HeatWave MySQL, click Channels.
  2. Choose your compartment from the List Scope.
  3. 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.
  4. Click Delete channel in the Delete channel dialog.
The state of the channel changes to Deleting and then to Deleted.