# 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).
import 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.config.from_file()
# Initialize service client with default config file
mysql_client = oci.mysql.ChannelsClient(config)
# Send the request to service, some parameters are not required, see API
# doc for more info
create_channel_response = mysql_client.create_channel(
create_channel_details=oci.mysql.models.CreateChannelDetails(
source=oci.mysql.models.CreateChannelSourceFromMysqlDetails(
source_type="MYSQL",
hostname="EXAMPLE-hostname-Value",
username="EXAMPLE-username-Value",
password="EXAMPLE-password-Value",
ssl_mode="VERIFY_IDENTITY",
port=36647,
ssl_ca_certificate=oci.mysql.models.PemCaCertificate(
certificate_type="PEM",
contents="EXAMPLE-contents-Value"),
anonymous_transactions_handling=oci.mysql.models.AssignManualUuidHandling(
policy="ASSIGN_MANUAL_UUID",
last_configured_log_filename="EXAMPLE-lastConfiguredLogFilename-Value",
last_configured_log_offset=2199381186,
uuid="25e0fb24-e9b7-401b-8375-e6c36fb06f21")),
target=oci.mysql.models.CreateChannelTargetFromDbSystemDetails(
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(
type="REPLICATE_WILD_IGNORE_TABLE",
value="EXAMPLE-value-Value")],
tables_without_primary_key_handling="ALLOW",
delay_in_seconds=41532530),
compartment_id="ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value",
display_name="EXAMPLE-displayName-Value",
is_enabled=True,
description="EXAMPLE-description-Value",
freeform_tags={
'EXAMPLE_KEY_1EU0c': 'EXAMPLE_VALUE_Ri9vanv5GrdFcQm2OTiD'},
defined_tags={
'EXAMPLE_KEY_aw4Fu': {
'EXAMPLE_KEY_ragvf': 'EXAMPLE--Value'}}),
opc_request_id="BG3JKFNLKODBUVD3LI3E<unique_ID>",
opc_retry_token="EXAMPLE-opcRetryToken-Value")
# Get the data from response
print(create_channel_response.data)