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
- Using the REST API, run the GetChannel operation.
Using the Console
Use the Console to view the state of an inbound replication channel and see more details about it.
- 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.
- 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:
|
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:
|
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:
|
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:
|
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. |