Oracle Cloud Infrastructure Documentation

Viewing Replication Channel Information

The channel state shows that a replication channel is enabled and active, or else indicates the reason why replication is not currently in progress. The channel details give further information about a replication channel.

Using the Console

Use the Console to view the state of an inbound replication channel and see more details about it.

  1. Open the navigation menu and select Databases. Under MySQL HeatWave, click Channels.
  2. Choose your compartment from the List scope.
  3. In the list of channels, check the icon in the State column to see the state of each channel. The color of the icon and the associated text show the state of the channel. See Channel States.
  4. To see the Channel details page, click the name of the channel you want to view details for. See Channel Details.

Channel States

Check the State column to view the state of the replication channel.

Table 13-2 Channel States

Channel State Description
Deleted The channel has been deleted and is no longer available.
Creating The channel is being created. Provisioning can take several minutes. The channel is not yet replicating data from the source to the target.
Deleting The channel is being deleted.
Inactive The channel is not replicating because the user has disabled it.
Needs Attention This status is displayed for the following reasons:
  • The channel is not replicating due to an error. The Details column on the Channels page explains why the channel needs attention.
  • The target DB system is INACTIVE, that is, the channel is created or updated while the DB system is in INACTIVE state. Pending actions are applied if the DB system is started.
Updating A channel operation is going on.
Active The channel is running and replicating successfully.
The DB system operations affect the channel state. See Overview of Inbound Replication.

Channel Details

You can get to this page by clicking the name of the channel in the list of channels.

Table 13-3 Elements of the Channel Details page

Name Description
Channel Information Basic information on the replication channel and its configuration.
  • OCID: The unique identifier of the Channel.
  • Description: A user-defined description of the channel.
  • Enabled: Displays the status of the channel. Yes for enabled, No for disabled.
  • State : Displays the current lifecycle state of the channel. Select the State Details tooltip to see more detail on the current state of the channel.
  • Source host: The IP address or hostname of the source MySQL server.
  • Target DB system: The display name of the target DB system and a link to it.
  • Compartment: The compartment the channel was created in.
  • Created: The time and date the channel was created.
  • Last Updated: The time and date the channel was last updated.
Source and Target
  • Source:
    • Source host: The IP address or hostname of the source MySQL server.
    • Username: The username of the replication user.
    • SSL Mode: Defines the security state of the connection to the source. Possible values are:
      • Disabled (DISABLED): No encryption required between source and target.
      • Required (REQUIRED): (default) Establishes an encrypted connection if the server supports encrypted connections. The connection attempt fails if an encrypted connection cannot be established.
      • Verify Certificate Authority (VERIFY_CA): Like Required, but additionally verify the CA certificate configured on the source against the Certificate Authority (CA) certificate (X509 PEM file).
      • Verify Identity (VERIFY_IDENTITY): Like Verify Certificate Authority, but additionally verify the source's hostname, defined in the source's SSL certificate, against the hostname defined in the Hostname field.
    • Certificate: Displayed only if either Verify Certificate Authority or Verify Identity SSL Modes were selected. Displays the contents of the uploaded CA X509 certificate.
    • Source can use GTID auto-positioning: Specfies whether the source server can provide the replica with GTID information for auto-positioning. If the option has a value NO, you can see the following:
      • Source of the UUID: Specifies whether the source of the UUID is a manual input or generated.
      • UUID: The UUID of the source.
  • Target:
    • DB System: The display name of the target DB System and a link to it.
    • Applier Username: The username of the replication applier. For more information, see MySQL Reference Manual - REPLICATION_APPLIER
    • Channel Name: The replication channel name. This is the replication channel used by the target MySQL DB System for the communication with the MySQL source.
    • Channel filter: The type and value of the channel filters.