# This is an automatically generated code sample.
# To make this code sample work in your Oracle Cloud tenancy,
# please replace the values for any parameters whose current values do not fit
# your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
# boolean, number, and enum parameters with values not fitting your use case).
require 'oci'
# Create a default config using DEFAULT profile in default location
# Refer to https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File for more info
config = OCI::ConfigFileLoader.load_config
# Initialize service client with default config file
mysql_client = OCI::Mysql::ChannelsClient.new(config: config)
# Send the request to service, some parameters are not required, see API doc for more info
create_channel_response =
mysql_client.create_channel(
OCI::Mysql::Models::CreateChannelDetails.new(
source:
OCI::Mysql::Models::CreateChannelSourceFromMysqlDetails.new(
source_type: 'MYSQL',
hostname: 'EXAMPLE-hostname-Value',
username: 'EXAMPLE-username-Value',
password: 'EXAMPLE-password-Value',
ssl_mode: 'DISABLED',
port: 62_785,
ssl_ca_certificate:
OCI::Mysql::Models::PemCaCertificate.new(
certificate_type: 'PEM', contents: 'EXAMPLE-contents-Value'
),
anonymous_transactions_handling:
OCI::Mysql::Models::AssignTargetUuidHandling.new(
policy: 'ASSIGN_TARGET_UUID',
last_configured_log_filename:
'EXAMPLE-lastConfiguredLogFilename-Value',
last_configured_log_offset: 1_519_362_398
)
),
target:
OCI::Mysql::Models::CreateChannelTargetFromDbSystemDetails.new(
target_type: 'DBSYSTEM',
db_system_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-dbSystemId-Value',
channel_name: 'EXAMPLE-channelName-Value',
applier_username: 'EXAMPLE-applierUsername-Value',
filters: [
OCI::Mysql::Models::ChannelFilter.new(
type: 'REPLICATE_IGNORE_DB', value: 'EXAMPLE-value-Value'
)
],
tables_without_primary_key_handling: 'ALLOW',
delay_in_seconds: 2_055_604_004
),
compartment_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value',
display_name: 'EXAMPLE-displayName-Value',
is_enabled: false,
description: 'EXAMPLE-description-Value',
freeform_tags: {
'EXAMPLE_KEY_JrAbK' => 'EXAMPLE_VALUE_B9WpIBG6kGTUSE36xxKs'
},
defined_tags: {
'EXAMPLE_KEY_5rVwk' => { 'EXAMPLE_KEY_GlWPR' => 'EXAMPLE--Value' }
}
)
)
# Get the data from response
puts "#{create_channel_response.data}"