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