Class MysqlConnection

Represents the metadata of a MySQL Connection.

Inheritance
object
Connection
MysqlConnection
Inherited Members
Namespace: Oci.GoldengateService.Models
Assembly: OCI.DotNetSDK.Goldengate.dll
Syntax
public class MysqlConnection : Connection

Properties

AdditionalAttributes

Declaration
[JsonProperty(PropertyName = "additionalAttributes")]
public List<NameValuePair> AdditionalAttributes { get; set; }
Property Value
Type Description
List<NameValuePair>

An array of name-value pair attribute entries. Used as additional parameters in connection string.

DatabaseName

Declaration
[JsonProperty(PropertyName = "databaseName")]
public string DatabaseName { get; set; }
Property Value
Type Description
string

The name of the database.

DbSystemId

Declaration
[JsonProperty(PropertyName = "dbSystemId")]
public string DbSystemId { get; set; }
Property Value
Type Description
string

The OCID of the database system being referenced.

Host

Declaration
[JsonProperty(PropertyName = "host")]
public string Host { get; set; }
Property Value
Type Description
string

The name or address of a host.

PasswordSecretId

Declaration
[JsonProperty(PropertyName = "passwordSecretId")]
public string PasswordSecretId { get; set; }
Property Value
Type Description
string

The OCID of the Secret where the password is stored. 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. If secretId is used plaintext field must not be provided. Note: When provided, 'password' field must not be provided.

Port

Declaration
[JsonProperty(PropertyName = "port")]
public int? Port { get; set; }
Property Value
Type Description
int?

The port of an endpoint usually specified for a connection.

PrivateIp

Declaration
[JsonProperty(PropertyName = "privateIp")]
public string PrivateIp { get; set; }
Property Value
Type Description
string

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.

SecurityProtocol

Declaration
[Required(ErrorMessage = "SecurityProtocol is required.")]
[JsonProperty(PropertyName = "securityProtocol")]
[JsonConverter(typeof(ResponseEnumConverter))]
public MysqlConnection.SecurityProtocolEnum? SecurityProtocol { get; set; }
Property Value
Type Description
MysqlConnection.SecurityProtocolEnum?

Security Protocol for MySQL.
Remarks

Required

SslCa

Declaration
[JsonProperty(PropertyName = "sslCa")]
public string SslCa { get; set; }
Property Value
Type Description
string

Database Certificate - The base64 encoded content of a .pem or .crt file containing the server public key (for 1 and 2-way SSL). It is not included in GET responses if the view=COMPACT query parameter is specified.

SslCert

Declaration
[JsonProperty(PropertyName = "sslCert")]
public string SslCert { get; set; }
Property Value
Type Description
string

Client Certificate - The base64 encoded content of a .pem or .crt file containing the client public key (for 2-way SSL). It is not included in GET responses if the view=COMPACT query parameter is specified.

SslCrl

Declaration
[JsonProperty(PropertyName = "sslCrl")]
public string SslCrl { get; set; }
Property Value
Type Description
string

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. It is not included in GET responses if the view=COMPACT query parameter is specified.

SslKeySecretId

Declaration
[JsonProperty(PropertyName = "sslKeySecretId")]
public string SslKeySecretId { get; set; }
Property Value
Type Description
string

The OCID of the Secret that stores the Client Key

  • The content of a .pem or .crt file containing the client private key (for 2-way SSL). Note: When provided, 'sslKey' field must not be provided.

SslMode

Declaration
[JsonProperty(PropertyName = "sslMode")]
[JsonConverter(typeof(ResponseEnumConverter))]
public MysqlConnection.SslModeEnum? SslMode { get; set; }
Property Value
Type Description
MysqlConnection.SslModeEnum?

SSL modes for MySQL.

TechnologyType

Declaration
[Required(ErrorMessage = "TechnologyType is required.")]
[JsonProperty(PropertyName = "technologyType")]
[JsonConverter(typeof(ResponseEnumConverter))]
public MysqlConnection.TechnologyTypeEnum? TechnologyType { get; set; }
Property Value
Type Description
MysqlConnection.TechnologyTypeEnum?

The MySQL technology type.
Remarks

Required

Username

Declaration
[Required(ErrorMessage = "Username is required.")]
[JsonProperty(PropertyName = "username")]
public string Username { get; set; }
Property Value
Type Description
string

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.
Remarks

Required