UpdateDbSystemDetails¶

class oci.mysql.models.UpdateDbSystemDetails(**kwargs)¶

Bases: object

Details required to update a DB System.

Attributes

`CRASH_RECOVERY_DISABLED`	A constant which can be used with the crash_recovery property of a UpdateDbSystemDetails.
`CRASH_RECOVERY_ENABLED`	A constant which can be used with the crash_recovery property of a UpdateDbSystemDetails.
`DATABASE_MANAGEMENT_DISABLED`	A constant which can be used with the database_management property of a UpdateDbSystemDetails.
`DATABASE_MANAGEMENT_ENABLED`	A constant which can be used with the database_management property of a UpdateDbSystemDetails.
`admin_password`	Gets the admin_password of this UpdateDbSystemDetails.
`admin_username`	Gets the admin_username of this UpdateDbSystemDetails.
`availability_domain`	Gets the availability_domain of this UpdateDbSystemDetails.
`backup_policy`	Gets the backup_policy of this UpdateDbSystemDetails.
`configuration_id`	Gets the configuration_id of this UpdateDbSystemDetails.
`crash_recovery`	Gets the crash_recovery of this UpdateDbSystemDetails.
`customer_contacts`	Gets the customer_contacts of this UpdateDbSystemDetails.
`data_storage`	Gets the data_storage of this UpdateDbSystemDetails.
`data_storage_size_in_gbs`	Gets the data_storage_size_in_gbs of this UpdateDbSystemDetails.
`database_management`	Gets the database_management of this UpdateDbSystemDetails.
`defined_tags`	Gets the defined_tags of this UpdateDbSystemDetails.
`deletion_policy`	Gets the deletion_policy of this UpdateDbSystemDetails.
`description`	Gets the description of this UpdateDbSystemDetails.
`display_name`	Gets the display_name of this UpdateDbSystemDetails.
`fault_domain`	Gets the fault_domain of this UpdateDbSystemDetails.
`freeform_tags`	Gets the freeform_tags of this UpdateDbSystemDetails.
`hostname_label`	Gets the hostname_label of this UpdateDbSystemDetails.
`ip_address`	Gets the ip_address of this UpdateDbSystemDetails.
`is_highly_available`	Gets the is_highly_available of this UpdateDbSystemDetails.
`maintenance`	Gets the maintenance of this UpdateDbSystemDetails.
`mysql_version`	Gets the mysql_version of this UpdateDbSystemDetails.
`port`	Gets the port of this UpdateDbSystemDetails.
`port_x`	Gets the port_x of this UpdateDbSystemDetails.
`secure_connections`	Gets the secure_connections of this UpdateDbSystemDetails.
`shape_name`	Gets the shape_name of this UpdateDbSystemDetails.
`subnet_id`	Gets the subnet_id of this UpdateDbSystemDetails.

Methods

__init__(**kwargs) Initializes a new UpdateDbSystemDetails object with values from keyword arguments.

CRASH_RECOVERY_DISABLED = 'DISABLED'¶: A constant which can be used with the crash_recovery property of a UpdateDbSystemDetails. This constant has a value of “DISABLED”

CRASH_RECOVERY_ENABLED = 'ENABLED'¶: A constant which can be used with the crash_recovery property of a UpdateDbSystemDetails. This constant has a value of “ENABLED”

DATABASE_MANAGEMENT_DISABLED = 'DISABLED'¶: A constant which can be used with the database_management property of a UpdateDbSystemDetails. This constant has a value of “DISABLED”

DATABASE_MANAGEMENT_ENABLED = 'ENABLED'¶: A constant which can be used with the database_management property of a UpdateDbSystemDetails. This constant has a value of “ENABLED”

__init__(**kwargs)¶

Initializes a new UpdateDbSystemDetails object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

display_name (str) – The value to assign to the display_name property of this UpdateDbSystemDetails.
description (str) – The value to assign to the description property of this UpdateDbSystemDetails.
subnet_id (str) – The value to assign to the subnet_id property of this UpdateDbSystemDetails.
is_highly_available (bool) – The value to assign to the is_highly_available property of this UpdateDbSystemDetails.
availability_domain (str) – The value to assign to the availability_domain property of this UpdateDbSystemDetails.
fault_domain (str) – The value to assign to the fault_domain property of this UpdateDbSystemDetails.
shape_name (str) – The value to assign to the shape_name property of this UpdateDbSystemDetails.
mysql_version (str) – The value to assign to the mysql_version property of this UpdateDbSystemDetails.
configuration_id (str) – The value to assign to the configuration_id property of this UpdateDbSystemDetails.
admin_username (str) – The value to assign to the admin_username property of this UpdateDbSystemDetails.
admin_password (str) – The value to assign to the admin_password property of this UpdateDbSystemDetails.
data_storage_size_in_gbs (int) – The value to assign to the data_storage_size_in_gbs property of this UpdateDbSystemDetails.
data_storage (oci.mysql.models.DataStorageDetails) – The value to assign to the data_storage property of this UpdateDbSystemDetails.
hostname_label (str) – The value to assign to the hostname_label property of this UpdateDbSystemDetails.
ip_address (str) – The value to assign to the ip_address property of this UpdateDbSystemDetails.
port (int) – The value to assign to the port property of this UpdateDbSystemDetails.
port_x (int) – The value to assign to the port_x property of this UpdateDbSystemDetails.
backup_policy (oci.mysql.models.UpdateBackupPolicyDetails) – The value to assign to the backup_policy property of this UpdateDbSystemDetails.
maintenance (oci.mysql.models.UpdateMaintenanceDetails) – The value to assign to the maintenance property of this UpdateDbSystemDetails.
freeform_tags (dict(str, str)) – The value to assign to the freeform_tags property of this UpdateDbSystemDetails.
defined_tags (dict(str, dict(str, object))) – The value to assign to the defined_tags property of this UpdateDbSystemDetails.
deletion_policy (oci.mysql.models.UpdateDeletionPolicyDetails) – The value to assign to the deletion_policy property of this UpdateDbSystemDetails.
crash_recovery (str) – The value to assign to the crash_recovery property of this UpdateDbSystemDetails. Allowed values for this property are: “ENABLED”, “DISABLED”
database_management (str) – The value to assign to the database_management property of this UpdateDbSystemDetails. Allowed values for this property are: “ENABLED”, “DISABLED”
secure_connections (oci.mysql.models.SecureConnectionDetails) – The value to assign to the secure_connections property of this UpdateDbSystemDetails.
customer_contacts (list[oci.mysql.models.CustomerContact]) – The value to assign to the customer_contacts property of this UpdateDbSystemDetails.

admin_password¶

Gets the admin_password of this UpdateDbSystemDetails. The password for the administrative user. The password must be between 8 and 32 characters long, and must contain at least 1 numeric character, 1 lowercase character, 1 uppercase character, and 1 special (nonalphanumeric) character.

Returns:	The admin_password of this UpdateDbSystemDetails.
Return type:	str

admin_username¶

Gets the admin_username of this UpdateDbSystemDetails. The username for the administrative user for the MySQL Instance.

Returns:	The admin_username of this UpdateDbSystemDetails.
Return type:	str

availability_domain¶

Gets the availability_domain of this UpdateDbSystemDetails. The availability domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.

In a failover scenario, the Read/Write endpoint is redirected to one of the other availability domains and the MySQL instance in that domain is promoted to the primary instance. This redirection does not affect the IP address of the DB System in any way.

For a standalone DB System, this defines the availability domain in which the DB System is placed.

Returns:	The availability_domain of this UpdateDbSystemDetails.
Return type:	str

backup_policy¶

Gets the backup_policy of this UpdateDbSystemDetails.

Returns:	The backup_policy of this UpdateDbSystemDetails.
Return type:	oci.mysql.models.UpdateBackupPolicyDetails

configuration_id¶

Gets the configuration_id of this UpdateDbSystemDetails. The OCID of the Configuration to be used for Instances in this DB System.

Returns:	The configuration_id of this UpdateDbSystemDetails.
Return type:	str

crash_recovery¶

Gets the crash_recovery of this UpdateDbSystemDetails. Whether to run the DB System with InnoDB Redo Logs and the Double Write Buffer enabled or disabled, and whether to enable or disable syncing of the Binary Logs.

Allowed values for this property are: “ENABLED”, “DISABLED”

Returns:	The crash_recovery of this UpdateDbSystemDetails.
Return type:	str

customer_contacts¶

Gets the customer_contacts of this UpdateDbSystemDetails. The list of customer email addresses that receive information from Oracle about the specified OCI DB System resource. Oracle uses these email addresses to send notifications about planned and unplanned software maintenance updates, information about system hardware, and other information needed by administrators. Up to 10 email addresses can be added to the customer contacts for a DB System.

Returns:	The customer_contacts of this UpdateDbSystemDetails.
Return type:	list[oci.mysql.models.CustomerContact]

data_storage¶

Gets the data_storage of this UpdateDbSystemDetails.

Returns:	The data_storage of this UpdateDbSystemDetails.
Return type:	oci.mysql.models.DataStorageDetails

data_storage_size_in_gbs¶

Gets the data_storage_size_in_gbs of this UpdateDbSystemDetails. Expands the DB System’s storage to the specified value. Only supports values larger than the current DB System’s storage size.

DB Systems with an initial storage size of 400 GB or less can be expanded up to 32 TB. DB Systems with an initial storage size between 401-800 GB can be expanded up to 64 TB. DB Systems with an initial storage size between 801-1200 GB can be expanded up to 96 TB. DB Systems with an initial storage size of 1201 GB or more can be expanded up to 128 TB.

It is not possible to decrease data storage size.

Returns:	The data_storage_size_in_gbs of this UpdateDbSystemDetails.
Return type:	int

database_management¶

Gets the database_management of this UpdateDbSystemDetails. Whether to enable monitoring via the Database Management service.

Allowed values for this property are: “ENABLED”, “DISABLED”

Returns:	The database_management of this UpdateDbSystemDetails.
Return type:	str

defined_tags¶

Gets the defined_tags of this UpdateDbSystemDetails. Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {“foo-namespace”: {“bar-key”: “value”}}

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

deletion_policy¶

Gets the deletion_policy of this UpdateDbSystemDetails.

Returns:	The deletion_policy of this UpdateDbSystemDetails.
Return type:	oci.mysql.models.UpdateDeletionPolicyDetails

description¶

Gets the description of this UpdateDbSystemDetails. User-provided data about the DB System.

Returns:	The description of this UpdateDbSystemDetails.
Return type:	str

display_name¶

Gets the display_name of this UpdateDbSystemDetails. The user-friendly name for the DB System. It does not have to be unique.

Returns:	The display_name of this UpdateDbSystemDetails.
Return type:	str

fault_domain¶

Gets the fault_domain of this UpdateDbSystemDetails. The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.

In a failover scenario, the Read/Write endpoint is redirected to one of the other fault domains and the MySQL instance in that domain is promoted to the primary instance. This redirection does not affect the IP address of the DB System in any way.

For a standalone DB System, this defines the fault domain in which the DB System is placed.

Returns:	The fault_domain of this UpdateDbSystemDetails.
Return type:	str

freeform_tags¶

Gets the freeform_tags of this UpdateDbSystemDetails. Simple key-value pair applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {“bar-key”: “value”}

Returns:	The freeform_tags of this UpdateDbSystemDetails.
Return type:	dict(str, str)

hostname_label¶

Gets the hostname_label of this UpdateDbSystemDetails. The hostname for the primary endpoint of the DB System. Used for DNS. The value is the hostname portion of the primary private IP’s fully qualified domain name (FQDN) (for example, “dbsystem-1” in FQDN “dbsystem-1.subnet123.vcn1.oraclevcn.com”). Must be unique across all VNICs in the subnet and comply with RFC 952 and RFC 1123.

Returns:	The hostname_label of this UpdateDbSystemDetails.
Return type:	str

ip_address¶

Gets the ip_address of this UpdateDbSystemDetails. The IP address the DB System should be configured to listen on the provided subnet. It must be a free private IP address within the subnet’s CIDR. If you don’t specify a value, Oracle automatically assigns a private IP address from the subnet. This should be a “dotted-quad” style IPv4 address.

Returns:	The ip_address of this UpdateDbSystemDetails.
Return type:	str

is_highly_available¶

Gets the is_highly_available of this UpdateDbSystemDetails. Specifies if the DB System is highly available.

Set to true to enable high availability. Two secondary MySQL instances are created and placed in the unused availability or fault domains, depending on your region and subnet type. Set to false to disable high availability. The secondary MySQL instances are removed and the MySQL instance in the preferred location is used.

Returns:	The is_highly_available of this UpdateDbSystemDetails.
Return type:	bool

maintenance¶

Gets the maintenance of this UpdateDbSystemDetails.

Returns:	The maintenance of this UpdateDbSystemDetails.
Return type:	oci.mysql.models.UpdateMaintenanceDetails

mysql_version¶

Gets the mysql_version of this UpdateDbSystemDetails. The specific MySQL version identifier.

Returns:	The mysql_version of this UpdateDbSystemDetails.
Return type:	str

port¶

Gets the port of this UpdateDbSystemDetails. The port for primary endpoint of the DB System to listen on.

Returns:	The port of this UpdateDbSystemDetails.
Return type:	int

port_x¶

Gets the port_x of this UpdateDbSystemDetails. The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.

Returns:	The port_x of this UpdateDbSystemDetails.
Return type:	int

secure_connections¶

Gets the secure_connections of this UpdateDbSystemDetails.

Returns:	The secure_connections of this UpdateDbSystemDetails.
Return type:	oci.mysql.models.SecureConnectionDetails

shape_name¶

Gets the shape_name of this UpdateDbSystemDetails. The shape of the DB System. The shape determines resources allocated to the DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use the list_shapes() operation.

Changes in Shape will result in a downtime as the MySQL DB System is migrated to the new Compute instance.

Returns:	The shape_name of this UpdateDbSystemDetails.
Return type:	str

subnet_id¶

Gets the subnet_id of this UpdateDbSystemDetails. The OCID of the subnet the DB System is associated with.

Returns:	The subnet_id of this UpdateDbSystemDetails.
Return type:	str