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. On the Channels list page, find the channel that you want to work with. If you need help finding the list page or the channel, see Listing Channels - Using the Console.
  2. From the Actions menu for the channel, select View 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 Channel details page

Tab or resource Description
Details Summary information about the channel and its configuration.
Source Information about the source server of the channel.
Target Information about the target DB system of the channel.
Metrics Measurements such as the channel lag and channel failure. See Channel Metrics.
Work requests Activity logs for ongoing and recent operations on the channel. Work requests are retained for 12 hours. See Resource: Work Requests.

Table 13-4 Details tab

Field Description
Channel name The display name of the channel. Select Edit to open the Edit channel panel.
OCID The unique identifier of the channel.
Description A user-defined description of the channel. Select Edit to open the Edit channel panel.
Enabled Displays the status of the channel. Yes for enabled, No for disabled.
Source host The IP address or hostname of the source MySQL server. Select Edit to open the Edit channel panel.
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 date and time the channel was created.
Last updated The date and time the channel was last updated.

Table 13-5 Source tab

Field Description
Source host The IP address or hostname of the source MySQL server. Select Edit to open the Edit channel panel.
Username The username of the replication user. Select Edit to open the Edit channel panel.
SSL Mode Defines the security state of the connection to the source. Select Edit to open the Edit channel panel. 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 Specifies whether the source server can provide the replica with GTID information for auto-positioning. Select Edit to open the Edit channel panel. 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.

Table 13-6 Target tab

Field Description
Target DB System The display name of the target DB System and a link to it.
Applier Username The username of the replication applier. Select Edit to open the Edit channel panel. 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. Select Edit to open the Edit channel panel.
Tables without primary keys How the channel handles a CREATE TABLE or ALTER TABLE statement with no primary key. Select Edit to open the Edit channel panel. Possible values are:
  • RAISE_ERROR: Raise an error when replicating a CREATE TABLE or ALTER TABLE statement with no primary key.
  • ALLOW: (Default) Allow replicating a CREATE TABLE or ALTER TABLE statement with no primary key.
  • GENERATE_IMPLICIT_PRIMARY_KEY: Generate an invisible primary key column when replicating any CREATE TABLE or ALTER TABLE statement on InnoDB tables with no primary key.
Replication delay The number of seconds the channels wait before applying a transaction received from the channel. Select Edit to open the Edit channel panel.
Channel filters The type and value of the channel filters. Select Edit to open the Edit channel panel.