oci_adm_knowledge_baseoci_adm_vulnerability_auditoci_ai_anomaly_detection_ai_private_endpointoci_ai_anomaly_detection_data_assetoci_ai_anomaly_detection_modeloci_ai_anomaly_detection_projectoci_analytics_instanceoci_apigateway_apioci_application_migration_migrationoci_application_migration_sourceoci_artifacts_container_imageoci_artifacts_container_image_signatureoci_artifacts_container_repositoryoci_artifacts_generic_artifactoci_artifacts_repositoryoci_autoscaling_auto_scaling_configurationoci_autoscaling_auto_scaling_policyoci_bastion_bastionoci_bastion_sessionoci_bds_bds_instanceoci_budget_alert_ruleoci_budget_budgetoci_certificates_authority_bundleoci_certificates_management_associationoci_certificates_management_ca_bundleoci_certificates_management_certificateoci_certificates_management_certificate_authorityoci_certificates_management_certificate_authority_versionoci_certificates_management_certificate_versionoci_cloud_guard_configurationoci_cloud_guard_detector_recipeoci_cloud_guard_managed_listoci_cloud_guard_responder_recipeoci_cloud_guard_targetoci_container_instances_containeroci_container_instances_container_instanceoci_containerengine_clusteroci_core_block_volume_replicaoci_core_boot_volumeoci_core_boot_volume_attachmentoci_core_boot_volume_backupoci_core_boot_volume_metric_read_opsoci_core_boot_volume_metric_read_ops_dailyoci_core_boot_volume_metric_read_ops_hourlyoci_core_boot_volume_metric_write_opsoci_core_boot_volume_metric_write_ops_dailyoci_core_boot_volume_metric_write_ops_hourlyoci_core_boot_volume_replicaoci_core_cluster_networkoci_core_dhcp_optionsoci_core_drgoci_core_imageoci_core_image_customoci_core_instanceoci_core_instance_configurationoci_core_instance_metric_cpu_utilizationoci_core_instance_metric_cpu_utilization_dailyoci_core_instance_metric_cpu_utilization_hourlyoci_core_internet_gatewayoci_core_load_balanceroci_core_local_peering_gatewayoci_core_nat_gatewayoci_core_network_load_balanceroci_core_network_security_groupoci_core_public_ipoci_core_public_ip_pooloci_core_route_tableoci_core_security_listoci_core_service_gatewayoci_core_subnetoci_core_vcnoci_core_vnic_attachmentoci_core_volumeoci_core_volume_attachmentoci_core_volume_backupoci_core_volume_backup_policyoci_core_volume_default_backup_policyoci_core_volume_groupoci_database_autonomous_databaseoci_database_autonomous_db_metric_cpu_utilizationoci_database_autonomous_db_metric_cpu_utilization_dailyoci_database_autonomous_db_metric_cpu_utilization_hourlyoci_database_autonomous_db_metric_storage_utilizationoci_database_autonomous_db_metric_storage_utilization_dailyoci_database_autonomous_db_metric_storage_utilization_hourlyoci_database_dboci_database_db_homeoci_database_db_systemoci_database_pluggable_databaseoci_database_software_imageoci_devops_projectoci_devops_repositoryoci_dns_rrsetoci_dns_tsig_keyoci_dns_zoneoci_events_ruleoci_file_storage_file_systemoci_file_storage_mount_targetoci_file_storage_snapshotoci_functions_applicationoci_functions_functionoci_identity_api_keyoci_identity_auth_tokenoci_identity_authentication_policyoci_identity_availability_domainoci_identity_compartmentoci_identity_customer_secret_keyoci_identity_dynamic_groupoci_identity_groupoci_identity_network_sourceoci_identity_policyoci_identity_tag_defaultoci_identity_tag_namespaceoci_identity_tenancyoci_identity_useroci_kms_keyoci_kms_key_versionoci_kms_vaultoci_logging_logoci_logging_log_groupoci_logging_searchoci_mysql_backupoci_mysql_channeloci_mysql_configurationoci_mysql_configuration_customoci_mysql_db_systemoci_mysql_db_system_metric_connectionsoci_mysql_db_system_metric_connections_dailyoci_mysql_db_system_metric_connections_hourlyoci_mysql_db_system_metric_cpu_utilizationoci_mysql_db_system_metric_cpu_utilization_dailyoci_mysql_db_system_metric_cpu_utilization_hourlyoci_mysql_db_system_metric_memory_utilizationoci_mysql_db_system_metric_memory_utilization_dailyoci_mysql_heat_wave_clusteroci_network_firewall_firewalloci_network_firewall_policyoci_nosql_tableoci_nosql_table_metric_read_throttle_countoci_nosql_table_metric_read_throttle_count_dailyoci_nosql_table_metric_read_throttle_count_hourlyoci_nosql_table_metric_storage_utilizationoci_nosql_table_metric_storage_utilization_dailyoci_nosql_table_metric_storage_utilization_hourlyoci_nosql_table_metric_write_throttle_countoci_nosql_table_metric_write_throttle_count_dailyoci_nosql_table_metric_write_throttle_count_hourlyoci_objectstorage_bucketoci_objectstorage_objectoci_ons_notification_topicoci_ons_subscriptionoci_queue_queueoci_regionoci_resource_searchoci_resourcemanager_stackoci_streaming_streamoci_vault_secret
Table: oci_mysql_db_system
A DB System is a logical container for the MySQL instance. It provides an interface enabling management of tasks such as provisioning, backup and restore, monitoring, and so on. It also provides a read/write endpoint enabling you to connect to the MySQL instance using the standard protocols.
Examples
Basic info
select id, display_name, lifecycle_state as state, time_createdfrom oci_mysql_db_system;
List DB systems that are not active
select id, display_name, lifecycle_state as state, time_createdfrom oci_mysql_db_systemwhere lifecycle_state <> 'ACTIVE';
List DB systems with backups not enabled
select id, display_name, lifecycle_state as state, time_createdfrom oci_mysql_db_systemwhere lifecycle_state = 'ACTIVE' and backup_policy -> 'isEnabled' <> 'true';
List the CPU and RAM configuration of DB systems
select id, display_name, lifecycle_state as state, cpu_core_count, memory_size_in_gbsfrom oci_mysql_db_systemwhere lifecycle_state = 'ACTIVE';
Query examples
- mysql_configurations_for_mysql_db_system
- mysql_db_system_1_year
- mysql_db_system_24_hrs
- mysql_db_system_30_days
- mysql_db_system_365_days
- mysql_db_system_90_days
- mysql_db_system_age_report
- mysql_db_system_analytics_cluster_attached_count
- mysql_db_system_backup
- mysql_db_system_backup_disabled_count
- mysql_db_system_backup_policy
- mysql_db_system_by_compartment
- mysql_db_system_by_creation_month
- mysql_db_system_by_region
- mysql_db_system_by_tenancy
- mysql_db_system_count
- mysql_db_system_heat_wave_cluster_attached_count
- mysql_db_system_input
- mysql_db_system_mysql_version
- mysql_db_system_overview
- mysql_db_system_storage_by_compartment
- mysql_db_system_storage_by_creation_month
- mysql_db_system_storage_by_region
- mysql_db_system_storage_by_tenancy
- mysql_db_system_storage_total
- mysql_db_system_tag
- vcn_subnets_for_mysql_db_system
- vcn_vcns_for_mysql_db_system
Control examples
- mysql_db_system_age
- mysql_db_system_low_connection_count
- mysql_db_system_low_usage
- mysql_db_system_endpoint
- mysql_db_system_with_backups
.inspect oci_mysql_db_system
OCI MySQL DB System
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
analytics_cluster | jsonb | A summary of an Analytics Cluster. |
availability_domain | text | The Availability Domain where the primary DB System should be located. |
backup_policy | jsonb | BackupPolicy The Backup policy for the DB System. |
channels | jsonb | A list with a summary of all the Channels attached to the DB System. |
compartment_id | text | The OCID of the compartment in Tenant in which the resource is located. |
configuration_id | text | The OCID of the Configuration to be used for Instances in this DB System. |
cpu_core_count | bigint | The number of CPU Cores the Instance provides. These are OCPU's. |
data_storage_size_in_gbs | bigint | Initial size of the data volume in GiBs that will be created and attached. |
defined_tags | jsonb | Defined tags for resource. Defined tags are set up in your tenancy by an administrator. Only users granted permission to work with the defined tags can apply them to resources. |
description | text | User-provided data about the DB System. |
display_name | text | The user-friendly name for the DB System. It does not have to be unique. |
endpoints | jsonb | The network endpoints available for this DB System. |
fault_domain | text | The name of the fault domain the DB System is located in. |
freeform_tags | jsonb | Free-form tags for resource. This tags can be applied by any user with permissions on the resource. |
hostname_label | text | The hostname for the primary endpoint of the DB System. |
id | text | The OCID of the DB System. |
ip_address | inet | The IP address the DB System is configured to listen on. |
is_analytics_cluster_attached | boolean | If the DB System has an Analytics Cluster attached. |
is_heat_wave_cluster_attached | boolean | Whether the DB System has a HeatWave cluster attached. |
lifecycle_details | text | Additional information about the current lifecycleState. |
lifecycle_state | text | The current state of the DB System. |
maintenance | jsonb | The Maintenance Policy for the DB System. |
memory_size_in_gbs | bigint | The amount of RAM the Instance provides. This is an IEC base-2 number. |
mysql_version | text | Name of the MySQL Version in use for the DB System. |
port | bigint | The port for primary endpoint of the DB System to listen on. |
port_x | bigint | The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port. |
region | text | The OCI region in which the resource is located. |
shape_name | text | The shape of the primary instances of the DB System. |
source | jsonb | DbSystemSource Parameters detailing how to provision the initial data of the DB System. |
subnet_id | text | The OCID of the subnet the DB System is associated with. |
tags | jsonb | A map of tags for the resource. |
tenant_id | text | The OCID of the Tenant in which the resource is located. |
tenant_name | text | The name of the Tenant in which the resource is located. |
time_created | timestamp with time zone | The date and time the DB System was created. |
time_updated | timestamp with time zone | The time the DB System was last updated. |
title | text | Title of the resource. |