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_created
from
  oci_mysql_db_system;

List DB systems that are not active

select
  id,
  display_name,
  lifecycle_state as state,
  time_created
from
  oci_mysql_db_system
where
  lifecycle_state <> 'ACTIVE';

List DB systems with backups not enabled

select
  id,
  display_name,
  lifecycle_state as state,
  time_created
from
  oci_mysql_db_system
where
  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_gbs
from
  oci_mysql_db_system
where
  lifecycle_state = 'ACTIVE';

Query examples

Control examples

.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.

turbot/oci