UpdateMysqlConnectionDetails

class oci.golden_gate.models.UpdateMysqlConnectionDetails(**kwargs)

Bases: oci.golden_gate.models.update_connection_details.UpdateConnectionDetails

The information to update a MySQL Connection.

Attributes

CONNECTION_TYPE_AMAZON_KINESIS str(object=’’) -> str
CONNECTION_TYPE_AMAZON_REDSHIFT str(object=’’) -> str
CONNECTION_TYPE_AMAZON_S3 str(object=’’) -> str
CONNECTION_TYPE_AZURE_DATA_LAKE_STORAGE str(object=’’) -> str
CONNECTION_TYPE_AZURE_SYNAPSE_ANALYTICS str(object=’’) -> str
CONNECTION_TYPE_DB2 str(object=’’) -> str
CONNECTION_TYPE_ELASTICSEARCH str(object=’’) -> str
CONNECTION_TYPE_GENERIC str(object=’’) -> str
CONNECTION_TYPE_GOLDENGATE str(object=’’) -> str
CONNECTION_TYPE_GOOGLE_BIGQUERY str(object=’’) -> str
CONNECTION_TYPE_GOOGLE_CLOUD_STORAGE str(object=’’) -> str
CONNECTION_TYPE_HDFS str(object=’’) -> str
CONNECTION_TYPE_JAVA_MESSAGE_SERVICE str(object=’’) -> str
CONNECTION_TYPE_KAFKA str(object=’’) -> str
CONNECTION_TYPE_KAFKA_SCHEMA_REGISTRY str(object=’’) -> str
CONNECTION_TYPE_MICROSOFT_SQLSERVER str(object=’’) -> str
CONNECTION_TYPE_MONGODB str(object=’’) -> str
CONNECTION_TYPE_MYSQL str(object=’’) -> str
CONNECTION_TYPE_OCI_OBJECT_STORAGE str(object=’’) -> str
CONNECTION_TYPE_ORACLE str(object=’’) -> str
CONNECTION_TYPE_ORACLE_NOSQL str(object=’’) -> str
CONNECTION_TYPE_POSTGRESQL str(object=’’) -> str
CONNECTION_TYPE_REDIS str(object=’’) -> str
CONNECTION_TYPE_SNOWFLAKE str(object=’’) -> str
ROUTING_METHOD_DEDICATED_ENDPOINT str(object=’’) -> str
ROUTING_METHOD_SHARED_DEPLOYMENT_ENDPOINT str(object=’’) -> str
ROUTING_METHOD_SHARED_SERVICE_ENDPOINT str(object=’’) -> str
additional_attributes Gets the additional_attributes of this UpdateMysqlConnectionDetails.
connection_type Gets the connection_type of this UpdateConnectionDetails.
database_name Gets the database_name of this UpdateMysqlConnectionDetails.
db_system_id Gets the db_system_id of this UpdateMysqlConnectionDetails.
defined_tags Gets the defined_tags of this UpdateConnectionDetails.
description Gets the description of this UpdateConnectionDetails.
display_name Gets the display_name of this UpdateConnectionDetails.
freeform_tags Gets the freeform_tags of this UpdateConnectionDetails.
host Gets the host of this UpdateMysqlConnectionDetails.
key_id Gets the key_id of this UpdateConnectionDetails.
nsg_ids Gets the nsg_ids of this UpdateConnectionDetails.
password Gets the password of this UpdateMysqlConnectionDetails.
port Gets the port of this UpdateMysqlConnectionDetails.
private_ip Gets the private_ip of this UpdateMysqlConnectionDetails.
routing_method Gets the routing_method of this UpdateConnectionDetails.
security_protocol Gets the security_protocol of this UpdateMysqlConnectionDetails.
ssl_ca Gets the ssl_ca of this UpdateMysqlConnectionDetails.
ssl_cert Gets the ssl_cert of this UpdateMysqlConnectionDetails.
ssl_crl Gets the ssl_crl of this UpdateMysqlConnectionDetails.
ssl_key Gets the ssl_key of this UpdateMysqlConnectionDetails.
ssl_mode Gets the ssl_mode of this UpdateMysqlConnectionDetails.
subnet_id Gets the subnet_id of this UpdateConnectionDetails.
username Gets the username of this UpdateMysqlConnectionDetails.
vault_id Gets the vault_id of this UpdateConnectionDetails.

Methods

__init__(**kwargs) Initializes a new UpdateMysqlConnectionDetails object with values from keyword arguments.
get_subtype(object_dictionary) Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.
CONNECTION_TYPE_AMAZON_KINESIS = 'AMAZON_KINESIS'
CONNECTION_TYPE_AMAZON_REDSHIFT = 'AMAZON_REDSHIFT'
CONNECTION_TYPE_AMAZON_S3 = 'AMAZON_S3'
CONNECTION_TYPE_AZURE_DATA_LAKE_STORAGE = 'AZURE_DATA_LAKE_STORAGE'
CONNECTION_TYPE_AZURE_SYNAPSE_ANALYTICS = 'AZURE_SYNAPSE_ANALYTICS'
CONNECTION_TYPE_DB2 = 'DB2'
CONNECTION_TYPE_ELASTICSEARCH = 'ELASTICSEARCH'
CONNECTION_TYPE_GENERIC = 'GENERIC'
CONNECTION_TYPE_GOLDENGATE = 'GOLDENGATE'
CONNECTION_TYPE_GOOGLE_BIGQUERY = 'GOOGLE_BIGQUERY'
CONNECTION_TYPE_GOOGLE_CLOUD_STORAGE = 'GOOGLE_CLOUD_STORAGE'
CONNECTION_TYPE_HDFS = 'HDFS'
CONNECTION_TYPE_JAVA_MESSAGE_SERVICE = 'JAVA_MESSAGE_SERVICE'
CONNECTION_TYPE_KAFKA = 'KAFKA'
CONNECTION_TYPE_KAFKA_SCHEMA_REGISTRY = 'KAFKA_SCHEMA_REGISTRY'
CONNECTION_TYPE_MICROSOFT_SQLSERVER = 'MICROSOFT_SQLSERVER'
CONNECTION_TYPE_MONGODB = 'MONGODB'
CONNECTION_TYPE_MYSQL = 'MYSQL'
CONNECTION_TYPE_OCI_OBJECT_STORAGE = 'OCI_OBJECT_STORAGE'
CONNECTION_TYPE_ORACLE = 'ORACLE'
CONNECTION_TYPE_ORACLE_NOSQL = 'ORACLE_NOSQL'
CONNECTION_TYPE_POSTGRESQL = 'POSTGRESQL'
CONNECTION_TYPE_REDIS = 'REDIS'
CONNECTION_TYPE_SNOWFLAKE = 'SNOWFLAKE'
ROUTING_METHOD_DEDICATED_ENDPOINT = 'DEDICATED_ENDPOINT'
ROUTING_METHOD_SHARED_DEPLOYMENT_ENDPOINT = 'SHARED_DEPLOYMENT_ENDPOINT'
ROUTING_METHOD_SHARED_SERVICE_ENDPOINT = 'SHARED_SERVICE_ENDPOINT'
__init__(**kwargs)

Initializes a new UpdateMysqlConnectionDetails object with values from keyword arguments. The default value of the connection_type attribute of this class is MYSQL and it should not be changed. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:
  • connection_type (str) – The value to assign to the connection_type property of this UpdateMysqlConnectionDetails. Allowed values for this property are: “GOLDENGATE”, “KAFKA”, “KAFKA_SCHEMA_REGISTRY”, “MYSQL”, “JAVA_MESSAGE_SERVICE”, “MICROSOFT_SQLSERVER”, “OCI_OBJECT_STORAGE”, “ORACLE”, “AZURE_DATA_LAKE_STORAGE”, “POSTGRESQL”, “AZURE_SYNAPSE_ANALYTICS”, “SNOWFLAKE”, “AMAZON_S3”, “HDFS”, “ORACLE_NOSQL”, “MONGODB”, “AMAZON_KINESIS”, “AMAZON_REDSHIFT”, “DB2”, “REDIS”, “ELASTICSEARCH”, “GENERIC”, “GOOGLE_CLOUD_STORAGE”, “GOOGLE_BIGQUERY”
  • display_name (str) – The value to assign to the display_name property of this UpdateMysqlConnectionDetails.
  • description (str) – The value to assign to the description property of this UpdateMysqlConnectionDetails.
  • freeform_tags (dict(str, str)) – The value to assign to the freeform_tags property of this UpdateMysqlConnectionDetails.
  • defined_tags (dict(str, dict(str, object))) – The value to assign to the defined_tags property of this UpdateMysqlConnectionDetails.
  • vault_id (str) – The value to assign to the vault_id property of this UpdateMysqlConnectionDetails.
  • key_id (str) – The value to assign to the key_id property of this UpdateMysqlConnectionDetails.
  • nsg_ids (list[str]) – The value to assign to the nsg_ids property of this UpdateMysqlConnectionDetails.
  • subnet_id (str) – The value to assign to the subnet_id property of this UpdateMysqlConnectionDetails.
  • routing_method (str) – The value to assign to the routing_method property of this UpdateMysqlConnectionDetails. Allowed values for this property are: “SHARED_SERVICE_ENDPOINT”, “SHARED_DEPLOYMENT_ENDPOINT”, “DEDICATED_ENDPOINT”
  • username (str) – The value to assign to the username property of this UpdateMysqlConnectionDetails.
  • password (str) – The value to assign to the password property of this UpdateMysqlConnectionDetails.
  • host (str) – The value to assign to the host property of this UpdateMysqlConnectionDetails.
  • port (int) – The value to assign to the port property of this UpdateMysqlConnectionDetails.
  • database_name (str) – The value to assign to the database_name property of this UpdateMysqlConnectionDetails.
  • security_protocol (str) – The value to assign to the security_protocol property of this UpdateMysqlConnectionDetails.
  • ssl_mode (str) – The value to assign to the ssl_mode property of this UpdateMysqlConnectionDetails.
  • ssl_ca (str) – The value to assign to the ssl_ca property of this UpdateMysqlConnectionDetails.
  • ssl_crl (str) – The value to assign to the ssl_crl property of this UpdateMysqlConnectionDetails.
  • ssl_cert (str) – The value to assign to the ssl_cert property of this UpdateMysqlConnectionDetails.
  • ssl_key (str) – The value to assign to the ssl_key property of this UpdateMysqlConnectionDetails.
  • private_ip (str) – The value to assign to the private_ip property of this UpdateMysqlConnectionDetails.
  • additional_attributes (list[oci.golden_gate.models.NameValuePair]) – The value to assign to the additional_attributes property of this UpdateMysqlConnectionDetails.
  • db_system_id (str) – The value to assign to the db_system_id property of this UpdateMysqlConnectionDetails.
additional_attributes

Gets the additional_attributes of this UpdateMysqlConnectionDetails. An array of name-value pair attribute entries. Used as additional parameters in connection string.

Returns:The additional_attributes of this UpdateMysqlConnectionDetails.
Return type:list[oci.golden_gate.models.NameValuePair]
connection_type

Gets the connection_type of this UpdateConnectionDetails. The connection type.

Allowed values for this property are: “GOLDENGATE”, “KAFKA”, “KAFKA_SCHEMA_REGISTRY”, “MYSQL”, “JAVA_MESSAGE_SERVICE”, “MICROSOFT_SQLSERVER”, “OCI_OBJECT_STORAGE”, “ORACLE”, “AZURE_DATA_LAKE_STORAGE”, “POSTGRESQL”, “AZURE_SYNAPSE_ANALYTICS”, “SNOWFLAKE”, “AMAZON_S3”, “HDFS”, “ORACLE_NOSQL”, “MONGODB”, “AMAZON_KINESIS”, “AMAZON_REDSHIFT”, “DB2”, “REDIS”, “ELASTICSEARCH”, “GENERIC”, “GOOGLE_CLOUD_STORAGE”, “GOOGLE_BIGQUERY”

Returns:The connection_type of this UpdateConnectionDetails.
Return type:str
database_name

Gets the database_name of this UpdateMysqlConnectionDetails. The name of the database.

Returns:The database_name of this UpdateMysqlConnectionDetails.
Return type:str
db_system_id

Gets the db_system_id of this UpdateMysqlConnectionDetails. The OCID of the database system being referenced.

Returns:The db_system_id of this UpdateMysqlConnectionDetails.
Return type:str
defined_tags

Gets the defined_tags of this UpdateConnectionDetails. Tags defined for this resource. Each key is predefined and scoped to a namespace.

Example: {“foo-namespace”: {“bar-key”: “value”}}

Returns:The defined_tags of this UpdateConnectionDetails.
Return type:dict(str, dict(str, object))
description

Gets the description of this UpdateConnectionDetails. Metadata about this specific object.

Returns:The description of this UpdateConnectionDetails.
Return type:str
display_name

Gets the display_name of this UpdateConnectionDetails. An object’s Display Name.

Returns:The display_name of this UpdateConnectionDetails.
Return type:str
freeform_tags

Gets the freeform_tags of this UpdateConnectionDetails. A simple key-value pair that is applied without any predefined name, type, or scope. Exists for cross-compatibility only.

Example: {“bar-key”: “value”}

Returns:The freeform_tags of this UpdateConnectionDetails.
Return type:dict(str, str)
static get_subtype(object_dictionary)

Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

host

Gets the host of this UpdateMysqlConnectionDetails. The name or address of a host.

Returns:The host of this UpdateMysqlConnectionDetails.
Return type:str
key_id

Gets the key_id of this UpdateConnectionDetails. Refers to the customer’s master key OCID. If provided, it references a key to manage secrets. Customers must add policies to permit GoldenGate to use this key.

Returns:The key_id of this UpdateConnectionDetails.
Return type:str
nsg_ids

Gets the nsg_ids of this UpdateConnectionDetails. An array of Network Security Group OCIDs used to define network access for either Deployments or Connections.

Returns:The nsg_ids of this UpdateConnectionDetails.
Return type:list[str]
password

Gets the password of this UpdateMysqlConnectionDetails. The password Oracle GoldenGate uses to connect the associated system of the given technology. It must conform to the specific security requirements including length, case sensitivity, and so on.

Returns:The password of this UpdateMysqlConnectionDetails.
Return type:str
port

Gets the port of this UpdateMysqlConnectionDetails. The port of an endpoint usually specified for a connection.

Returns:The port of this UpdateMysqlConnectionDetails.
Return type:int
private_ip

Gets the private_ip of this UpdateMysqlConnectionDetails. Deprecated: this field will be removed in future versions. Either specify the private IP in the connectionString or host field, or make sure the host name is resolvable in the target VCN.

The private IP address of the connection’s endpoint in the customer’s VCN, typically a database endpoint or a big data endpoint (e.g. Kafka bootstrap server). In case the privateIp is provided, the subnetId must also be provided. In case the privateIp (and the subnetId) is not provided it is assumed the datasource is publicly accessible. In case the connection is accessible only privately, the lack of privateIp will result in not being able to access the connection.

Returns:The private_ip of this UpdateMysqlConnectionDetails.
Return type:str
routing_method

Gets the routing_method of this UpdateConnectionDetails. Controls the network traffic direction to the target: SHARED_SERVICE_ENDPOINT: Traffic flows through the Goldengate Service’s network to public hosts. Cannot be used for private targets. SHARED_DEPLOYMENT_ENDPOINT: Network traffic flows from the assigned deployment’s private endpoint through the deployment’s subnet. DEDICATED_ENDPOINT: A dedicated private endpoint is created in the target VCN subnet for the connection. The subnetId is required when DEDICATED_ENDPOINT networking is selected.

Allowed values for this property are: “SHARED_SERVICE_ENDPOINT”, “SHARED_DEPLOYMENT_ENDPOINT”, “DEDICATED_ENDPOINT”

Returns:The routing_method of this UpdateConnectionDetails.
Return type:str
security_protocol

Gets the security_protocol of this UpdateMysqlConnectionDetails. Security Type for MySQL.

Returns:The security_protocol of this UpdateMysqlConnectionDetails.
Return type:str
ssl_ca

Gets the ssl_ca of this UpdateMysqlConnectionDetails. Database Certificate - The base64 encoded content of a .pem or .crt file. containing the server public key (for 1 and 2-way SSL).

Returns:The ssl_ca of this UpdateMysqlConnectionDetails.
Return type:str
ssl_cert

Gets the ssl_cert of this UpdateMysqlConnectionDetails. Client Certificate - The base64 encoded content of a .pem or .crt file. containing the client public key (for 2-way SSL).

Returns:The ssl_cert of this UpdateMysqlConnectionDetails.
Return type:str
ssl_crl

Gets the ssl_crl of this UpdateMysqlConnectionDetails. The base64 encoded list of certificates revoked by the trusted certificate authorities (Trusted CA). Note: This is an optional property and only applicable if TLS/MTLS option is selected.

Returns:The ssl_crl of this UpdateMysqlConnectionDetails.
Return type:str
ssl_key

Gets the ssl_key of this UpdateMysqlConnectionDetails. Client Key – The base64 encoded content of a .pem or .crt file containing the client private key (for 2-way SSL).

Returns:The ssl_key of this UpdateMysqlConnectionDetails.
Return type:str
ssl_mode

Gets the ssl_mode of this UpdateMysqlConnectionDetails. SSL modes for MySQL.

Returns:The ssl_mode of this UpdateMysqlConnectionDetails.
Return type:str
subnet_id

Gets the subnet_id of this UpdateConnectionDetails. The OCID of the target subnet of the dedicated connection.

Returns:The subnet_id of this UpdateConnectionDetails.
Return type:str
username

Gets the username of this UpdateMysqlConnectionDetails. The username Oracle GoldenGate uses to connect the associated system of the given technology. This username must already exist and be available by the system/application to be connected to and must conform to the case sensitivty requirments defined in it.

Returns:The username of this UpdateMysqlConnectionDetails.
Return type:str
vault_id

Gets the vault_id of this UpdateConnectionDetails. Refers to the customer’s vault OCID. If provided, it references a vault where GoldenGate can manage secrets. Customers must add policies to permit GoldenGate to manage secrets contained within this vault.

Returns:The vault_id of this UpdateConnectionDetails.
Return type:str