MdsMySqlDatabaseInsight

class oci.opsi.models.MdsMySqlDatabaseInsight(**kwargs)

Bases: DatabaseInsight

MySQL support within the OCI Ops Insights service has been deprecated as of January 29, 2026. Database insight resource.

Attributes:

ENTITY_SOURCE_AUTONOMOUS_DATABASE

A constant which can be used with the entity_source property of a DatabaseInsight.

ENTITY_SOURCE_EM_MANAGED_EXTERNAL_DATABASE

A constant which can be used with the entity_source property of a DatabaseInsight.

ENTITY_SOURCE_EXTERNAL_MYSQL_DATABASE_SYSTEM

A constant which can be used with the entity_source property of a DatabaseInsight.

ENTITY_SOURCE_MACS_MANAGED_AUTONOMOUS_DATABASE

A constant which can be used with the entity_source property of a DatabaseInsight.

ENTITY_SOURCE_MACS_MANAGED_CLOUD_DATABASE

A constant which can be used with the entity_source property of a DatabaseInsight.

ENTITY_SOURCE_MACS_MANAGED_EXTERNAL_DATABASE

A constant which can be used with the entity_source property of a DatabaseInsight.

ENTITY_SOURCE_MDS_MYSQL_DATABASE_SYSTEM

A constant which can be used with the entity_source property of a DatabaseInsight.

ENTITY_SOURCE_PE_COMANAGED_DATABASE

A constant which can be used with the entity_source property of a DatabaseInsight.

LIFECYCLE_STATE_ACTIVE

A constant which can be used with the lifecycle_state property of a DatabaseInsight.

LIFECYCLE_STATE_CREATING

A constant which can be used with the lifecycle_state property of a DatabaseInsight.

LIFECYCLE_STATE_DELETED

A constant which can be used with the lifecycle_state property of a DatabaseInsight.

LIFECYCLE_STATE_DELETING

A constant which can be used with the lifecycle_state property of a DatabaseInsight.

LIFECYCLE_STATE_FAILED

A constant which can be used with the lifecycle_state property of a DatabaseInsight.

LIFECYCLE_STATE_NEEDS_ATTENTION

A constant which can be used with the lifecycle_state property of a DatabaseInsight.

LIFECYCLE_STATE_UPDATING

A constant which can be used with the lifecycle_state property of a DatabaseInsight.

STATUS_DISABLED

A constant which can be used with the status property of a DatabaseInsight.

STATUS_ENABLED

A constant which can be used with the status property of a DatabaseInsight.

STATUS_TERMINATED

A constant which can be used with the status property of a DatabaseInsight.

compartment_id

[Required] Gets the compartment_id of this DatabaseInsight.

database_connection_status_details

Gets the database_connection_status_details of this DatabaseInsight.

database_display_name

Gets the database_display_name of this MdsMySqlDatabaseInsight.

database_id

[Required] Gets the database_id of this MdsMySqlDatabaseInsight.

database_name

[Required] Gets the database_name of this MdsMySqlDatabaseInsight.

database_resource_type

[Required] Gets the database_resource_type of this MdsMySqlDatabaseInsight.

database_type

Gets the database_type of this DatabaseInsight.

database_version

Gets the database_version of this DatabaseInsight.

db_additional_details

Gets the db_additional_details of this MdsMySqlDatabaseInsight.

defined_tags

[Required] Gets the defined_tags of this DatabaseInsight.

entity_source

[Required] Gets the entity_source of this DatabaseInsight.

freeform_tags

[Required] Gets the freeform_tags of this DatabaseInsight.

id

[Required] Gets the id of this DatabaseInsight.

is_heat_wave_cluster_attached

Gets the is_heat_wave_cluster_attached of this MdsMySqlDatabaseInsight.

is_highly_available

Gets the is_highly_available of this MdsMySqlDatabaseInsight.

lifecycle_details

Gets the lifecycle_details of this DatabaseInsight.

lifecycle_state

[Required] Gets the lifecycle_state of this DatabaseInsight.

processor_count

Gets the processor_count of this DatabaseInsight.

status

[Required] Gets the status of this DatabaseInsight.

system_tags

Gets the system_tags of this DatabaseInsight.

time_created

[Required] Gets the time_created of this DatabaseInsight.

time_updated

Gets the time_updated of this DatabaseInsight.

Methods:

__init__(**kwargs)

Initializes a new MdsMySqlDatabaseInsight 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.

ENTITY_SOURCE_AUTONOMOUS_DATABASE = 'AUTONOMOUS_DATABASE'

A constant which can be used with the entity_source property of a DatabaseInsight. This constant has a value of “AUTONOMOUS_DATABASE”

ENTITY_SOURCE_EM_MANAGED_EXTERNAL_DATABASE = 'EM_MANAGED_EXTERNAL_DATABASE'

A constant which can be used with the entity_source property of a DatabaseInsight. This constant has a value of “EM_MANAGED_EXTERNAL_DATABASE”

ENTITY_SOURCE_EXTERNAL_MYSQL_DATABASE_SYSTEM = 'EXTERNAL_MYSQL_DATABASE_SYSTEM'

A constant which can be used with the entity_source property of a DatabaseInsight. This constant has a value of “EXTERNAL_MYSQL_DATABASE_SYSTEM”

ENTITY_SOURCE_MACS_MANAGED_AUTONOMOUS_DATABASE = 'MACS_MANAGED_AUTONOMOUS_DATABASE'

A constant which can be used with the entity_source property of a DatabaseInsight. This constant has a value of “MACS_MANAGED_AUTONOMOUS_DATABASE”

ENTITY_SOURCE_MACS_MANAGED_CLOUD_DATABASE = 'MACS_MANAGED_CLOUD_DATABASE'

A constant which can be used with the entity_source property of a DatabaseInsight. This constant has a value of “MACS_MANAGED_CLOUD_DATABASE”

ENTITY_SOURCE_MACS_MANAGED_EXTERNAL_DATABASE = 'MACS_MANAGED_EXTERNAL_DATABASE'

A constant which can be used with the entity_source property of a DatabaseInsight. This constant has a value of “MACS_MANAGED_EXTERNAL_DATABASE”

ENTITY_SOURCE_MDS_MYSQL_DATABASE_SYSTEM = 'MDS_MYSQL_DATABASE_SYSTEM'

A constant which can be used with the entity_source property of a DatabaseInsight. This constant has a value of “MDS_MYSQL_DATABASE_SYSTEM”

ENTITY_SOURCE_PE_COMANAGED_DATABASE = 'PE_COMANAGED_DATABASE'

A constant which can be used with the entity_source property of a DatabaseInsight. This constant has a value of “PE_COMANAGED_DATABASE”

LIFECYCLE_STATE_ACTIVE = 'ACTIVE'

A constant which can be used with the lifecycle_state property of a DatabaseInsight. This constant has a value of “ACTIVE”

LIFECYCLE_STATE_CREATING = 'CREATING'

A constant which can be used with the lifecycle_state property of a DatabaseInsight. This constant has a value of “CREATING”

LIFECYCLE_STATE_DELETED = 'DELETED'

A constant which can be used with the lifecycle_state property of a DatabaseInsight. This constant has a value of “DELETED”

LIFECYCLE_STATE_DELETING = 'DELETING'

A constant which can be used with the lifecycle_state property of a DatabaseInsight. This constant has a value of “DELETING”

LIFECYCLE_STATE_FAILED = 'FAILED'

A constant which can be used with the lifecycle_state property of a DatabaseInsight. This constant has a value of “FAILED”

LIFECYCLE_STATE_NEEDS_ATTENTION = 'NEEDS_ATTENTION'

A constant which can be used with the lifecycle_state property of a DatabaseInsight. This constant has a value of “NEEDS_ATTENTION”

LIFECYCLE_STATE_UPDATING = 'UPDATING'

A constant which can be used with the lifecycle_state property of a DatabaseInsight. This constant has a value of “UPDATING”

STATUS_DISABLED = 'DISABLED'

A constant which can be used with the status property of a DatabaseInsight. This constant has a value of “DISABLED”

STATUS_ENABLED = 'ENABLED'

A constant which can be used with the status property of a DatabaseInsight. This constant has a value of “ENABLED”

STATUS_TERMINATED = 'TERMINATED'

A constant which can be used with the status property of a DatabaseInsight. This constant has a value of “TERMINATED”

__init__(**kwargs)

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

Parameters
  • entity_source (str) – The value to assign to the entity_source property of this MdsMySqlDatabaseInsight. Allowed values for this property are: “AUTONOMOUS_DATABASE”, “EM_MANAGED_EXTERNAL_DATABASE”, “MACS_MANAGED_EXTERNAL_DATABASE”, “PE_COMANAGED_DATABASE”, “MDS_MYSQL_DATABASE_SYSTEM”, “EXTERNAL_MYSQL_DATABASE_SYSTEM”, “MACS_MANAGED_CLOUD_DATABASE”, “MACS_MANAGED_AUTONOMOUS_DATABASE”

  • id (str) – The value to assign to the id property of this MdsMySqlDatabaseInsight.

  • compartment_id (str) – The value to assign to the compartment_id property of this MdsMySqlDatabaseInsight.

  • status (str) – The value to assign to the status property of this MdsMySqlDatabaseInsight. Allowed values for this property are: “DISABLED”, “ENABLED”, “TERMINATED”

  • database_type (str) – The value to assign to the database_type property of this MdsMySqlDatabaseInsight.

  • database_version (str) – The value to assign to the database_version property of this MdsMySqlDatabaseInsight.

  • processor_count (int) – The value to assign to the processor_count property of this MdsMySqlDatabaseInsight.

  • freeform_tags (dict(str, str)) – The value to assign to the freeform_tags property of this MdsMySqlDatabaseInsight.

  • defined_tags (dict(str, dict(str, object))) – The value to assign to the defined_tags property of this MdsMySqlDatabaseInsight.

  • system_tags (dict(str, dict(str, object))) – The value to assign to the system_tags property of this MdsMySqlDatabaseInsight.

  • time_created (datetime) – The value to assign to the time_created property of this MdsMySqlDatabaseInsight.

  • time_updated (datetime) – The value to assign to the time_updated property of this MdsMySqlDatabaseInsight.

  • lifecycle_state (str) – The value to assign to the lifecycle_state property of this MdsMySqlDatabaseInsight. Allowed values for this property are: “CREATING”, “UPDATING”, “ACTIVE”, “DELETING”, “DELETED”, “FAILED”, “NEEDS_ATTENTION”

  • lifecycle_details (str) – The value to assign to the lifecycle_details property of this MdsMySqlDatabaseInsight.

  • database_connection_status_details (str) – The value to assign to the database_connection_status_details property of this MdsMySqlDatabaseInsight.

  • database_id (str) – The value to assign to the database_id property of this MdsMySqlDatabaseInsight.

  • database_name (str) – The value to assign to the database_name property of this MdsMySqlDatabaseInsight.

  • database_display_name (str) – The value to assign to the database_display_name property of this MdsMySqlDatabaseInsight.

  • database_resource_type (str) – The value to assign to the database_resource_type property of this MdsMySqlDatabaseInsight.

  • is_highly_available (bool) – The value to assign to the is_highly_available property of this MdsMySqlDatabaseInsight.

  • is_heat_wave_cluster_attached (bool) – The value to assign to the is_heat_wave_cluster_attached property of this MdsMySqlDatabaseInsight.

  • db_additional_details (object) – The value to assign to the db_additional_details property of this MdsMySqlDatabaseInsight.

property compartment_id

[Required] Gets the compartment_id of this DatabaseInsight. Compartment identifier of the database

Returns

The compartment_id of this DatabaseInsight.

Return type

str

property database_connection_status_details

Gets the database_connection_status_details of this DatabaseInsight. A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.

Returns

The database_connection_status_details of this DatabaseInsight.

Return type

str

property database_display_name

Gets the database_display_name of this MdsMySqlDatabaseInsight. Display name of database

Returns

The database_display_name of this MdsMySqlDatabaseInsight.

Return type

str

property database_id

[Required] Gets the database_id of this MdsMySqlDatabaseInsight. The OCID of the database.

Returns

The database_id of this MdsMySqlDatabaseInsight.

Return type

str

property database_name

[Required] Gets the database_name of this MdsMySqlDatabaseInsight. Name of database

Returns

The database_name of this MdsMySqlDatabaseInsight.

Return type

str

property database_resource_type

[Required] Gets the database_resource_type of this MdsMySqlDatabaseInsight. OCI database resource type

Returns

The database_resource_type of this MdsMySqlDatabaseInsight.

Return type

str

property database_type

Gets the database_type of this DatabaseInsight. Ops Insights internal representation of the database type.

Returns

The database_type of this DatabaseInsight.

Return type

str

property database_version

Gets the database_version of this DatabaseInsight. The version of the database.

Returns

The database_version of this DatabaseInsight.

Return type

str

property db_additional_details

Gets the db_additional_details of this MdsMySqlDatabaseInsight. Additional details of a db system in JSON format. For MySQL DB System, this is the DbSystem object serialized as a JSON string as defined in https://docs.oracle.com/en-us/iaas/api/#/en/mysql/20190415/DbSystem/.

Returns

The db_additional_details of this MdsMySqlDatabaseInsight.

Return type

object

property defined_tags

[Required] Gets the defined_tags of this DatabaseInsight. Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {“foo-namespace”: {“bar-key”: “value”}}

Returns

The defined_tags of this DatabaseInsight.

Return type

dict(str, dict(str, object))

property entity_source

[Required] Gets the entity_source of this DatabaseInsight. Source of the database entity.

Allowed values for this property are: “AUTONOMOUS_DATABASE”, “EM_MANAGED_EXTERNAL_DATABASE”, “MACS_MANAGED_EXTERNAL_DATABASE”, “PE_COMANAGED_DATABASE”, “MDS_MYSQL_DATABASE_SYSTEM”, “EXTERNAL_MYSQL_DATABASE_SYSTEM”, “MACS_MANAGED_CLOUD_DATABASE”, “MACS_MANAGED_AUTONOMOUS_DATABASE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The entity_source of this DatabaseInsight.

Return type

str

property freeform_tags

[Required] Gets the freeform_tags of this DatabaseInsight. 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 DatabaseInsight.

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.

property id

[Required] Gets the id of this DatabaseInsight. Database insight identifier

Returns

The id of this DatabaseInsight.

Return type

str

property is_heat_wave_cluster_attached

Gets the is_heat_wave_cluster_attached of this MdsMySqlDatabaseInsight. Specifies if MYSQL DB System has heatwave cluster attached.

Returns

The is_heat_wave_cluster_attached of this MdsMySqlDatabaseInsight.

Return type

bool

property is_highly_available

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

Returns

The is_highly_available of this MdsMySqlDatabaseInsight.

Return type

bool

property lifecycle_details

Gets the lifecycle_details of this DatabaseInsight. A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.

Returns

The lifecycle_details of this DatabaseInsight.

Return type

str

property lifecycle_state

[Required] Gets the lifecycle_state of this DatabaseInsight. The current state of the database.

Allowed values for this property are: “CREATING”, “UPDATING”, “ACTIVE”, “DELETING”, “DELETED”, “FAILED”, “NEEDS_ATTENTION”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The lifecycle_state of this DatabaseInsight.

Return type

str

property processor_count

Gets the processor_count of this DatabaseInsight. Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.

Returns

The processor_count of this DatabaseInsight.

Return type

int

property status

[Required] Gets the status of this DatabaseInsight. Indicates the status of a database insight in Operations Insights

Allowed values for this property are: “DISABLED”, “ENABLED”, “TERMINATED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The status of this DatabaseInsight.

Return type

str

property system_tags

Gets the system_tags of this DatabaseInsight. System tags for this resource. Each key is predefined and scoped to a namespace. Example: {“orcl-cloud”: {“free-tier-retained”: “true”}}

Returns

The system_tags of this DatabaseInsight.

Return type

dict(str, dict(str, object))

property time_created

[Required] Gets the time_created of this DatabaseInsight. The time the the database insight was first enabled. An RFC3339 formatted datetime string

Returns

The time_created of this DatabaseInsight.

Return type

datetime

property time_updated

Gets the time_updated of this DatabaseInsight. The time the database insight was updated. An RFC3339 formatted datetime string

Returns

The time_updated of this DatabaseInsight.

Return type

datetime