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.
`access_mode`	Gets the access_mode of this UpdateDbSystemDetails. The access mode indicating if the database access will be restricted only to administrators or not: - UNRESTRICTED: the access to the database is not restricted; - RESTRICTED: the access will be allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable `offline_mode`__ to ON.
`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_console`	Gets the database_console of this UpdateDbSystemDetails.
`database_management`	Gets the database_management of this UpdateDbSystemDetails.
`database_mode`	Gets the database_mode of this UpdateDbSystemDetails. The database mode indicating the types of statements that will be allowed to run in the DB system. This mode will apply only to statements run by user connections. Replicated write statements will continue to be allowed regardless of the DatabaseMode. - READ_WRITE: allow running read and write statements on the DB system; - READ_ONLY: only allow running read statements on the DB system.
`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.
`encrypt_data`	Gets the encrypt_data 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.
`ipv6_address_ipv6_subnet_cidr_pair_details`	Gets the ipv6_address_ipv6_subnet_cidr_pair_details of this UpdateDbSystemDetails.
`is_highly_available`	Gets the is_highly_available of this UpdateDbSystemDetails.
`is_ipv6_enabled`	Gets the is_ipv6_enabled of this UpdateDbSystemDetails.
`maintenance`	Gets the maintenance of this UpdateDbSystemDetails.
`mysql_version`	Gets the mysql_version of this UpdateDbSystemDetails.
`nsg_ids`	Gets the nsg_ids of this UpdateDbSystemDetails.
`port`	Gets the port of this UpdateDbSystemDetails.
`port_x`	Gets the port_x of this UpdateDbSystemDetails.
`read_endpoint`	Gets the read_endpoint of this UpdateDbSystemDetails.
`rest`	Gets the rest of this UpdateDbSystemDetails.
`secure_connections`	Gets the secure_connections of this UpdateDbSystemDetails.
`security_attributes`	Gets the security_attributes of this UpdateDbSystemDetails.
`shape_name`	Gets the shape_name of this UpdateDbSystemDetails.
`subnet_id`	Gets the subnet_id of this UpdateDbSystemDetails.
`telemetry_configuration`	Gets the telemetry_configuration 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.
nsg_ids (list[str]) – The value to assign to the nsg_ids property of this UpdateDbSystemDetails.
security_attributes (dict(str, dict(str, object))) – The value to assign to the security_attributes property of this UpdateDbSystemDetails.
database_mode (str) – The value to assign to the database_mode property of this UpdateDbSystemDetails.
access_mode (str) – The value to assign to the access_mode property of this UpdateDbSystemDetails.
rest (oci.mysql.models.UpdateRestDetails) – The value to assign to the rest property of this UpdateDbSystemDetails.
database_console (oci.mysql.models.UpdateDatabaseConsoleDetails) – The value to assign to the database_console 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.
is_ipv6_enabled (bool) – The value to assign to the is_ipv6_enabled property of this UpdateDbSystemDetails.
ipv6_address_ipv6_subnet_cidr_pair_details (oci.mysql.models.Ipv6AddressIpv6SubnetCidrPairDetails) – The value to assign to the ipv6_address_ipv6_subnet_cidr_pair_details 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.
encrypt_data (oci.mysql.models.EncryptDataDetails) – The value to assign to the encrypt_data property of this UpdateDbSystemDetails.
customer_contacts (list[oci.mysql.models.CustomerContact]) – The value to assign to the customer_contacts property of this UpdateDbSystemDetails.
read_endpoint (oci.mysql.models.UpdateReadEndpointDetails) – The value to assign to the read_endpoint property of this UpdateDbSystemDetails.
telemetry_configuration (oci.mysql.models.UpdateTelemetryConfigurationDetails) – The value to assign to the telemetry_configuration property of this UpdateDbSystemDetails.

property access_mode¶

Gets the access_mode of this UpdateDbSystemDetails. The access mode indicating if the database access will be restricted only to administrators or not:

UNRESTRICTED: the access to the database is not restricted;

RESTRICTED: the access will be allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable `offline_mode`__ to ON.

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

property 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

property 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

property 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

property backup_policy¶

Gets the backup_policy of this UpdateDbSystemDetails.

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

property 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

property 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

property 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]

property data_storage¶

Gets the data_storage of this UpdateDbSystemDetails.

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

property 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

property database_console¶

Gets the database_console of this UpdateDbSystemDetails.

Returns: The database_console of this UpdateDbSystemDetails.
Return type: oci.mysql.models.UpdateDatabaseConsoleDetails

property 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

property database_mode¶

Gets the database_mode of this UpdateDbSystemDetails. The database mode indicating the types of statements that will be allowed to run in the DB system. This mode will apply only to statements run by user connections. Replicated write statements will continue to be allowed regardless of the DatabaseMode.

READ_WRITE: allow running read and write statements on the DB system;

READ_ONLY: only allow running read statements on the DB system.

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

property 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))

property deletion_policy¶

Gets the deletion_policy of this UpdateDbSystemDetails.

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

property description¶

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

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

property 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

property encrypt_data¶

Gets the encrypt_data of this UpdateDbSystemDetails.

Returns: The encrypt_data of this UpdateDbSystemDetails.
Return type: oci.mysql.models.EncryptDataDetails

property 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

property 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)

property 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

property 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

property ipv6_address_ipv6_subnet_cidr_pair_details¶

Gets the ipv6_address_ipv6_subnet_cidr_pair_details of this UpdateDbSystemDetails.

Returns: The ipv6_address_ipv6_subnet_cidr_pair_details of this UpdateDbSystemDetails.
Return type: oci.mysql.models.Ipv6AddressIpv6SubnetCidrPairDetails

property 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

property is_ipv6_enabled¶

Gets the is_ipv6_enabled of this UpdateDbSystemDetails. Whether to allocate an IPv6 address for the DB system in an IPv6 enabled subnet. When provided you may optionally provide an IPv6 prefix (ipv6AddressIpv6SubnetCidrPairDetails) of your choice to assign the IPv6 address from. If ipv6AddressIpv6SubnetCidrPairDetails is not provided then an IPv6 prefix is chosen for you.

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

property maintenance¶

Gets the maintenance of this UpdateDbSystemDetails.

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

property mysql_version¶

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

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

property nsg_ids¶

Gets the nsg_ids of this UpdateDbSystemDetails. Network Security Group OCIDs used for the VNIC attachment.

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

property 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

property 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

property read_endpoint¶

Gets the read_endpoint of this UpdateDbSystemDetails.

Returns: The read_endpoint of this UpdateDbSystemDetails.
Return type: oci.mysql.models.UpdateReadEndpointDetails

property rest¶

Gets the rest of this UpdateDbSystemDetails.

Returns: The rest of this UpdateDbSystemDetails.
Return type: oci.mysql.models.UpdateRestDetails

property secure_connections¶

Gets the secure_connections of this UpdateDbSystemDetails.

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

property security_attributes¶

Gets the security_attributes of this UpdateDbSystemDetails. Security Attributes for this resource. Each key is predefined and scoped to a namespace. For more information, see `ZPR Artifacts`__. Example: {“Oracle-ZPR”: {“MaxEgressCount”: {“value”: “42”, “mode”: “audit”}}}

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

property 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

property 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

property telemetry_configuration¶

Gets the telemetry_configuration of this UpdateDbSystemDetails.

Returns: The telemetry_configuration of this UpdateDbSystemDetails.
Return type: oci.mysql.models.UpdateTelemetryConfigurationDetails