Oracle Cloud Infrastructure v2.33.0, May 1 25

Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi

oci.Mysql.getMysqlDbSystems

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testMysqlDbSystems = oci.Mysql.getMysqlDbSystems({
    compartmentId: compartmentId,
    configurationId: mysqlConfigurationId,
    databaseManagements: mysqlDbSystemDatabaseManagement,
    dbSystemId: testDbSystem.id,
    displayName: mysqlDbSystemDisplayName,
    isHeatWaveClusterAttached: mysqlDbSystemIsHeatWaveClusterAttached,
    isUpToDate: mysqlDbSystemIsUpToDate,
    state: mysqlDbSystemState,
});

import pulumi
import pulumi_oci as oci

test_mysql_db_systems = oci.Mysql.get_mysql_db_systems(compartment_id=compartment_id,
    configuration_id=mysql_configuration_id,
    database_managements=mysql_db_system_database_management,
    db_system_id=test_db_system["id"],
    display_name=mysql_db_system_display_name,
    is_heat_wave_cluster_attached=mysql_db_system_is_heat_wave_cluster_attached,
    is_up_to_date=mysql_db_system_is_up_to_date,
    state=mysql_db_system_state)

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/mysql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := mysql.GetMysqlDbSystems(ctx, &mysql.GetMysqlDbSystemsArgs{
			CompartmentId:             compartmentId,
			ConfigurationId:           pulumi.StringRef(mysqlConfigurationId),
			DatabaseManagements:       mysqlDbSystemDatabaseManagement,
			DbSystemId:                pulumi.StringRef(testDbSystem.Id),
			DisplayName:               pulumi.StringRef(mysqlDbSystemDisplayName),
			IsHeatWaveClusterAttached: pulumi.BoolRef(mysqlDbSystemIsHeatWaveClusterAttached),
			IsUpToDate:                pulumi.BoolRef(mysqlDbSystemIsUpToDate),
			State:                     pulumi.StringRef(mysqlDbSystemState),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testMysqlDbSystems = Oci.Mysql.GetMysqlDbSystems.Invoke(new()
    {
        CompartmentId = compartmentId,
        ConfigurationId = mysqlConfigurationId,
        DatabaseManagements = mysqlDbSystemDatabaseManagement,
        DbSystemId = testDbSystem.Id,
        DisplayName = mysqlDbSystemDisplayName,
        IsHeatWaveClusterAttached = mysqlDbSystemIsHeatWaveClusterAttached,
        IsUpToDate = mysqlDbSystemIsUpToDate,
        State = mysqlDbSystemState,
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Mysql.MysqlFunctions;
import com.pulumi.oci.Mysql.inputs.GetMysqlDbSystemsArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var testMysqlDbSystems = MysqlFunctions.getMysqlDbSystems(GetMysqlDbSystemsArgs.builder()
            .compartmentId(compartmentId)
            .configurationId(mysqlConfigurationId)
            .databaseManagements(mysqlDbSystemDatabaseManagement)
            .dbSystemId(testDbSystem.id())
            .displayName(mysqlDbSystemDisplayName)
            .isHeatWaveClusterAttached(mysqlDbSystemIsHeatWaveClusterAttached)
            .isUpToDate(mysqlDbSystemIsUpToDate)
            .state(mysqlDbSystemState)
            .build());

    }
}

variables:
  testMysqlDbSystems:
    fn::invoke:
      function: oci:Mysql:getMysqlDbSystems
      arguments:
        compartmentId: ${compartmentId}
        configurationId: ${mysqlConfigurationId}
        databaseManagements: ${mysqlDbSystemDatabaseManagement}
        dbSystemId: ${testDbSystem.id}
        displayName: ${mysqlDbSystemDisplayName}
        isHeatWaveClusterAttached: ${mysqlDbSystemIsHeatWaveClusterAttached}
        isUpToDate: ${mysqlDbSystemIsUpToDate}
        state: ${mysqlDbSystemState}

Using getMysqlDbSystems

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getMysqlDbSystems(args: GetMysqlDbSystemsArgs, opts?: InvokeOptions): Promise<GetMysqlDbSystemsResult>
function getMysqlDbSystemsOutput(args: GetMysqlDbSystemsOutputArgs, opts?: InvokeOptions): Output<GetMysqlDbSystemsResult>

def get_mysql_db_systems(compartment_id: Optional[str] = None,
                         configuration_id: Optional[str] = None,
                         database_managements: Optional[Sequence[str]] = None,
                         db_system_id: Optional[str] = None,
                         display_name: Optional[str] = None,
                         filters: Optional[Sequence[GetMysqlDbSystemsFilter]] = None,
                         is_heat_wave_cluster_attached: Optional[bool] = None,
                         is_up_to_date: Optional[bool] = None,
                         state: Optional[str] = None,
                         opts: Optional[InvokeOptions] = None) -> GetMysqlDbSystemsResult
def get_mysql_db_systems_output(compartment_id: Optional[pulumi.Input[str]] = None,
                         configuration_id: Optional[pulumi.Input[str]] = None,
                         database_managements: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                         db_system_id: Optional[pulumi.Input[str]] = None,
                         display_name: Optional[pulumi.Input[str]] = None,
                         filters: Optional[pulumi.Input[Sequence[pulumi.Input[GetMysqlDbSystemsFilterArgs]]]] = None,
                         is_heat_wave_cluster_attached: Optional[pulumi.Input[bool]] = None,
                         is_up_to_date: Optional[pulumi.Input[bool]] = None,
                         state: Optional[pulumi.Input[str]] = None,
                         opts: Optional[InvokeOptions] = None) -> Output[GetMysqlDbSystemsResult]

func GetMysqlDbSystems(ctx *Context, args *GetMysqlDbSystemsArgs, opts ...InvokeOption) (*GetMysqlDbSystemsResult, error)
func GetMysqlDbSystemsOutput(ctx *Context, args *GetMysqlDbSystemsOutputArgs, opts ...InvokeOption) GetMysqlDbSystemsResultOutput

> Note: This function is named GetMysqlDbSystems in the Go SDK.

public static class GetMysqlDbSystems 
{
    public static Task<GetMysqlDbSystemsResult> InvokeAsync(GetMysqlDbSystemsArgs args, InvokeOptions? opts = null)
    public static Output<GetMysqlDbSystemsResult> Invoke(GetMysqlDbSystemsInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetMysqlDbSystemsResult> getMysqlDbSystems(GetMysqlDbSystemsArgs args, InvokeOptions options)
public static Output<GetMysqlDbSystemsResult> getMysqlDbSystems(GetMysqlDbSystemsArgs args, InvokeOptions options)

fn::invoke:
  function: oci:Mysql/getMysqlDbSystems:getMysqlDbSystems
  arguments:
    # arguments dictionary

The following arguments are supported:

CompartmentId string: The compartment OCID.
ConfigurationId string: The requested Configuration instance.
DatabaseManagements List<string>: Filter DB Systems by their Database Management configuration.
DbSystemId string: The DB System OCID.
DisplayName string: A filter to return only the resource matching the given display name exactly.
Filters List<GetMysqlDbSystemsFilter>
IsHeatWaveClusterAttached bool: If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
IsUpToDate bool: Filter instances if they are using the latest revision of the Configuration they are associated with.
State string: DbSystem Lifecycle State

CompartmentId string: The compartment OCID.
ConfigurationId string: The requested Configuration instance.
DatabaseManagements []string: Filter DB Systems by their Database Management configuration.
DbSystemId string: The DB System OCID.
DisplayName string: A filter to return only the resource matching the given display name exactly.
Filters []GetMysqlDbSystemsFilter
IsHeatWaveClusterAttached bool: If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
IsUpToDate bool: Filter instances if they are using the latest revision of the Configuration they are associated with.
State string: DbSystem Lifecycle State

compartmentId String: The compartment OCID.
configurationId String: The requested Configuration instance.
databaseManagements List<String>: Filter DB Systems by their Database Management configuration.
dbSystemId String: The DB System OCID.
displayName String: A filter to return only the resource matching the given display name exactly.
filters List<GetDbSystemsFilter>
isHeatWaveClusterAttached Boolean: If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
isUpToDate Boolean: Filter instances if they are using the latest revision of the Configuration they are associated with.
state String: DbSystem Lifecycle State

compartmentId string: The compartment OCID.
configurationId string: The requested Configuration instance.
databaseManagements string[]: Filter DB Systems by their Database Management configuration.
dbSystemId string: The DB System OCID.
displayName string: A filter to return only the resource matching the given display name exactly.
filters GetMysqlDbSystemsFilter[]
isHeatWaveClusterAttached boolean: If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
isUpToDate boolean: Filter instances if they are using the latest revision of the Configuration they are associated with.
state string: DbSystem Lifecycle State

compartment_id str: The compartment OCID.
configuration_id str: The requested Configuration instance.
database_managements Sequence[str]: Filter DB Systems by their Database Management configuration.
db_system_id str: The DB System OCID.
display_name str: A filter to return only the resource matching the given display name exactly.
filters Sequence[GetMysqlDbSystemsFilter]
is_heat_wave_cluster_attached bool: If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
is_up_to_date bool: Filter instances if they are using the latest revision of the Configuration they are associated with.
state str: DbSystem Lifecycle State

compartmentId String: The compartment OCID.
configurationId String: The requested Configuration instance.
databaseManagements List<String>: Filter DB Systems by their Database Management configuration.
dbSystemId String: The DB System OCID.
displayName String: A filter to return only the resource matching the given display name exactly.
filters List<Property Map>
isHeatWaveClusterAttached Boolean: If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
isUpToDate Boolean: Filter instances if they are using the latest revision of the Configuration they are associated with.
state String: DbSystem Lifecycle State

getMysqlDbSystems Result

The following output properties are available:

CompartmentId string: The OCID of the compartment the DB System belongs in.
DbSystems List<GetMysqlDbSystemsDbSystem>: The list of db_systems.
Id string: The provider-assigned unique ID for this managed resource.
ConfigurationId string: The OCID of the Configuration to be used for Instances in this DB System.
DatabaseManagements List<string>: Whether to enable monitoring via the Database Management service.
DbSystemId string: The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
DisplayName string: The user-friendly name for the DB System. It does not have to be unique.
Filters List<GetMysqlDbSystemsFilter>
IsHeatWaveClusterAttached bool: If the DB System has a HeatWave Cluster attached.
IsUpToDate bool
State string: The current state of the DB System.

CompartmentId string: The OCID of the compartment the DB System belongs in.
DbSystems []GetMysqlDbSystemsDbSystem: The list of db_systems.
Id string: The provider-assigned unique ID for this managed resource.
ConfigurationId string: The OCID of the Configuration to be used for Instances in this DB System.
DatabaseManagements []string: Whether to enable monitoring via the Database Management service.
DbSystemId string: The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
DisplayName string: The user-friendly name for the DB System. It does not have to be unique.
Filters []GetMysqlDbSystemsFilter
IsHeatWaveClusterAttached bool: If the DB System has a HeatWave Cluster attached.
IsUpToDate bool
State string: The current state of the DB System.

compartmentId String: The OCID of the compartment the DB System belongs in.
dbSystems List<GetDbSystemsDbSystem>: The list of db_systems.
id String: The provider-assigned unique ID for this managed resource.
configurationId String: The OCID of the Configuration to be used for Instances in this DB System.
databaseManagements List<String>: Whether to enable monitoring via the Database Management service.
dbSystemId String: The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
displayName String: The user-friendly name for the DB System. It does not have to be unique.
filters List<GetDbSystemsFilter>
isHeatWaveClusterAttached Boolean: If the DB System has a HeatWave Cluster attached.
isUpToDate Boolean
state String: The current state of the DB System.

compartmentId string: The OCID of the compartment the DB System belongs in.
dbSystems GetMysqlDbSystemsDbSystem[]: The list of db_systems.
id string: The provider-assigned unique ID for this managed resource.
configurationId string: The OCID of the Configuration to be used for Instances in this DB System.
databaseManagements string[]: Whether to enable monitoring via the Database Management service.
dbSystemId string: The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
displayName string: The user-friendly name for the DB System. It does not have to be unique.
filters GetMysqlDbSystemsFilter[]
isHeatWaveClusterAttached boolean: If the DB System has a HeatWave Cluster attached.
isUpToDate boolean
state string: The current state of the DB System.

compartment_id str: The OCID of the compartment the DB System belongs in.
db_systems Sequence[GetMysqlDbSystemsDbSystem]: The list of db_systems.
id str: The provider-assigned unique ID for this managed resource.
configuration_id str: The OCID of the Configuration to be used for Instances in this DB System.
database_managements Sequence[str]: Whether to enable monitoring via the Database Management service.
db_system_id str: The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
display_name str: The user-friendly name for the DB System. It does not have to be unique.
filters Sequence[GetMysqlDbSystemsFilter]
is_heat_wave_cluster_attached bool: If the DB System has a HeatWave Cluster attached.
is_up_to_date bool
state str: The current state of the DB System.

compartmentId String: The OCID of the compartment the DB System belongs in.
dbSystems List<Property Map>: The list of db_systems.
id String: The provider-assigned unique ID for this managed resource.
configurationId String: The OCID of the Configuration to be used for Instances in this DB System.
databaseManagements List<String>: Whether to enable monitoring via the Database Management service.
dbSystemId String: The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
displayName String: The user-friendly name for the DB System. It does not have to be unique.
filters List<Property Map>
isHeatWaveClusterAttached Boolean: If the DB System has a HeatWave Cluster attached.
isUpToDate Boolean
state String: The current state of the DB System.

Supporting Types

GetMysqlDbSystemsDbSystem

AccessMode string

The access mode indicating if the database access is unrestricted (to all MySQL user accounts), or restricted (to only certain users with specific privileges):

UNRESTRICTED: the access to the database is not restricted;
RESTRICTED: the access is allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

AdminPassword string

AdminUsername string

AvailabilityDomain string

The availability domain in which the DB System is placed.

BackupPolicies List<GetMysqlDbSystemsDbSystemBackupPolicy>

The Backup policy for the DB System.

Channels List<GetMysqlDbSystemsDbSystemChannel>

A list with a summary of all the Channels attached to the DB System.

CompartmentId string

The compartment OCID.

ConfigurationId string

The requested Configuration instance.

CrashRecovery string

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.

CurrentPlacements List<GetMysqlDbSystemsDbSystemCurrentPlacement>

The availability domain and fault domain a DB System is placed in.

CustomerContacts List<GetMysqlDbSystemsDbSystemCustomerContact>

The list of customer email addresses that receive information from Oracle about the specified Oracle Cloud Infrastructure 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.

DataStorageSizeInGb int

Initial size of the data volume in GiBs that will be created and attached.

DataStorages List<GetMysqlDbSystemsDbSystemDataStorage>

Data Storage information.

DatabaseManagement string

Filter DB Systems by their Database Management configuration.

DatabaseMode string

The database mode indicating the types of statements that are allowed to run in the the DB system. This mode applies only to statements run by user connections. Replicated write statements 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.

DefinedTags Dictionary<string, string>

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

DeletionPolicies List<GetMysqlDbSystemsDbSystemDeletionPolicy>

The Deletion policy for the DB System.

Description string

User-provided data about the DB System.

DisplayName string

A filter to return only the resource matching the given display name exactly.

Endpoints List<GetMysqlDbSystemsDbSystemEndpoint>

The network endpoints available for this DB System.

FaultDomain string

The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.

FreeformTags Dictionary<string, string>

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

HeatWaveClusters List<GetMysqlDbSystemsDbSystemHeatWaveCluster>

A summary of a HeatWave cluster.

HostnameLabel string

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.

Id string

The OCID of the DB System.

IpAddress string

The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.

IsHeatWaveClusterAttached bool

If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.

IsHighlyAvailable bool

Specifies if the DB System is highly available.

LifecycleDetails string

Additional information about the current lifecycleState.

Maintenances List<GetMysqlDbSystemsDbSystemMaintenance>

The Maintenance Policy for the DB System or Read Replica that this model is included in.

MysqlVersion string

Name of the MySQL Version in use for the DB System.

PointInTimeRecoveryDetails List<GetMysqlDbSystemsDbSystemPointInTimeRecoveryDetail>

Point-in-time Recovery details like earliest and latest recovery time point for the DB System.

Port int

The port for primary endpoint of the DB System to listen on.

PortX int

The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.

ReadEndpoints List<GetMysqlDbSystemsDbSystemReadEndpoint>

The read endpoint of a DB System.

SecureConnections List<GetMysqlDbSystemsDbSystemSecureConnection>

Secure connection configuration details.

ShapeName string

The shape of the primary instances of the DB System. The shape determines resources allocated to a 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 ListShapes operation.

ShutdownType string

Sources List<GetMysqlDbSystemsDbSystemSource>

Parameters detailing how to provision the initial data of the DB System.

State string

DbSystem Lifecycle State

SubnetId string

The OCID of the subnet the DB System is associated with.

SystemTags Dictionary<string, string>

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

TimeCreated string

The date and time the DB System was created.

TimeUpdated string

The time the DB System was last updated.

AccessMode string

The access mode indicating if the database access is unrestricted (to all MySQL user accounts), or restricted (to only certain users with specific privileges):

UNRESTRICTED: the access to the database is not restricted;
RESTRICTED: the access is allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

AdminPassword string

AdminUsername string

AvailabilityDomain string

The availability domain in which the DB System is placed.

BackupPolicies []GetMysqlDbSystemsDbSystemBackupPolicy

The Backup policy for the DB System.

Channels []GetMysqlDbSystemsDbSystemChannel

A list with a summary of all the Channels attached to the DB System.

CompartmentId string

The compartment OCID.

ConfigurationId string

The requested Configuration instance.

CrashRecovery string

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.

CurrentPlacements []GetMysqlDbSystemsDbSystemCurrentPlacement

The availability domain and fault domain a DB System is placed in.

CustomerContacts []GetMysqlDbSystemsDbSystemCustomerContact

DataStorageSizeInGb int

Initial size of the data volume in GiBs that will be created and attached.

DataStorages []GetMysqlDbSystemsDbSystemDataStorage

Data Storage information.

DatabaseManagement string

Filter DB Systems by their Database Management configuration.

DatabaseMode string

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

DefinedTags map[string]string

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

DeletionPolicies []GetMysqlDbSystemsDbSystemDeletionPolicy

The Deletion policy for the DB System.

Description string

User-provided data about the DB System.

DisplayName string

A filter to return only the resource matching the given display name exactly.

Endpoints []GetMysqlDbSystemsDbSystemEndpoint

The network endpoints available for this DB System.

FaultDomain string

The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.

FreeformTags map[string]string

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

HeatWaveClusters []GetMysqlDbSystemsDbSystemHeatWaveCluster

A summary of a HeatWave cluster.

HostnameLabel string

Id string

The OCID of the DB System.

IpAddress string

IsHeatWaveClusterAttached bool

If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.

IsHighlyAvailable bool

Specifies if the DB System is highly available.

LifecycleDetails string

Additional information about the current lifecycleState.

Maintenances []GetMysqlDbSystemsDbSystemMaintenance

The Maintenance Policy for the DB System or Read Replica that this model is included in.

MysqlVersion string

Name of the MySQL Version in use for the DB System.

PointInTimeRecoveryDetails []GetMysqlDbSystemsDbSystemPointInTimeRecoveryDetail

Point-in-time Recovery details like earliest and latest recovery time point for the DB System.

Port int

The port for primary endpoint of the DB System to listen on.

PortX int

The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.

ReadEndpoints []GetMysqlDbSystemsDbSystemReadEndpoint

The read endpoint of a DB System.

SecureConnections []GetMysqlDbSystemsDbSystemSecureConnection

Secure connection configuration details.

ShapeName string

ShutdownType string

Sources []GetMysqlDbSystemsDbSystemSource

Parameters detailing how to provision the initial data of the DB System.

State string

DbSystem Lifecycle State

SubnetId string

The OCID of the subnet the DB System is associated with.

SystemTags map[string]string

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

TimeCreated string

The date and time the DB System was created.

TimeUpdated string

The time the DB System was last updated.

accessMode String

The access mode indicating if the database access is unrestricted (to all MySQL user accounts), or restricted (to only certain users with specific privileges):

UNRESTRICTED: the access to the database is not restricted;
RESTRICTED: the access is allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

adminPassword String

adminUsername String

availabilityDomain String

The availability domain in which the DB System is placed.

backupPolicies List<GetDbSystemsDbSystemBackupPolicy>

The Backup policy for the DB System.

channels List<GetDbSystemsDbSystemChannel>

A list with a summary of all the Channels attached to the DB System.

compartmentId String

The compartment OCID.

configurationId String

The requested Configuration instance.

crashRecovery String

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.

currentPlacements List<GetDbSystemsDbSystemCurrentPlacement>

The availability domain and fault domain a DB System is placed in.

customerContacts List<GetDbSystemsDbSystemCustomerContact>

dataStorageSizeInGb Integer

Initial size of the data volume in GiBs that will be created and attached.

dataStorages List<GetDbSystemsDbSystemDataStorage>

Data Storage information.

databaseManagement String

Filter DB Systems by their Database Management configuration.

databaseMode String

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

definedTags Map<String,String>

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

deletionPolicies List<GetDbSystemsDbSystemDeletionPolicy>

The Deletion policy for the DB System.

description String

User-provided data about the DB System.

displayName String

A filter to return only the resource matching the given display name exactly.

endpoints List<GetDbSystemsDbSystemEndpoint>

The network endpoints available for this DB System.

faultDomain String

The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.

freeformTags Map<String,String>

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

heatWaveClusters List<GetDbSystemsDbSystemHeatWaveCluster>

A summary of a HeatWave cluster.

hostnameLabel String

id String

The OCID of the DB System.

ipAddress String

isHeatWaveClusterAttached Boolean

If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.

isHighlyAvailable Boolean

Specifies if the DB System is highly available.

lifecycleDetails String

Additional information about the current lifecycleState.

maintenances List<GetDbSystemsDbSystemMaintenance>

The Maintenance Policy for the DB System or Read Replica that this model is included in.

mysqlVersion String

Name of the MySQL Version in use for the DB System.

pointInTimeRecoveryDetails List<GetDbSystemsDbSystemPointInTimeRecoveryDetail>

Point-in-time Recovery details like earliest and latest recovery time point for the DB System.

port Integer

The port for primary endpoint of the DB System to listen on.

portX Integer

The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.

readEndpoints List<GetDbSystemsDbSystemReadEndpoint>

The read endpoint of a DB System.

secureConnections List<GetDbSystemsDbSystemSecureConnection>

Secure connection configuration details.

shapeName String

shutdownType String

sources List<GetDbSystemsDbSystemSource>

Parameters detailing how to provision the initial data of the DB System.

state String

DbSystem Lifecycle State

subnetId String

The OCID of the subnet the DB System is associated with.

systemTags Map<String,String>

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

timeCreated String

The date and time the DB System was created.

timeUpdated String

The time the DB System was last updated.

accessMode string

The access mode indicating if the database access is unrestricted (to all MySQL user accounts), or restricted (to only certain users with specific privileges):

UNRESTRICTED: the access to the database is not restricted;
RESTRICTED: the access is allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

adminPassword string

adminUsername string

availabilityDomain string

The availability domain in which the DB System is placed.

backupPolicies GetMysqlDbSystemsDbSystemBackupPolicy[]

The Backup policy for the DB System.

channels GetMysqlDbSystemsDbSystemChannel[]

A list with a summary of all the Channels attached to the DB System.

compartmentId string

The compartment OCID.

configurationId string

The requested Configuration instance.

crashRecovery string

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.

currentPlacements GetMysqlDbSystemsDbSystemCurrentPlacement[]

The availability domain and fault domain a DB System is placed in.

customerContacts GetMysqlDbSystemsDbSystemCustomerContact[]

dataStorageSizeInGb number

Initial size of the data volume in GiBs that will be created and attached.

dataStorages GetMysqlDbSystemsDbSystemDataStorage[]

Data Storage information.

databaseManagement string

Filter DB Systems by their Database Management configuration.

databaseMode string

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

definedTags {[key: string]: string}

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

deletionPolicies GetMysqlDbSystemsDbSystemDeletionPolicy[]

The Deletion policy for the DB System.

description string

User-provided data about the DB System.

displayName string

A filter to return only the resource matching the given display name exactly.

endpoints GetMysqlDbSystemsDbSystemEndpoint[]

The network endpoints available for this DB System.

faultDomain string

The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.

freeformTags {[key: string]: string}

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

heatWaveClusters GetMysqlDbSystemsDbSystemHeatWaveCluster[]

A summary of a HeatWave cluster.

hostnameLabel string

id string

The OCID of the DB System.

ipAddress string

isHeatWaveClusterAttached boolean

If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.

isHighlyAvailable boolean

Specifies if the DB System is highly available.

lifecycleDetails string

Additional information about the current lifecycleState.

maintenances GetMysqlDbSystemsDbSystemMaintenance[]

The Maintenance Policy for the DB System or Read Replica that this model is included in.

mysqlVersion string

Name of the MySQL Version in use for the DB System.

pointInTimeRecoveryDetails GetMysqlDbSystemsDbSystemPointInTimeRecoveryDetail[]

Point-in-time Recovery details like earliest and latest recovery time point for the DB System.

port number

The port for primary endpoint of the DB System to listen on.

portX number

The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.

readEndpoints GetMysqlDbSystemsDbSystemReadEndpoint[]

The read endpoint of a DB System.

secureConnections GetMysqlDbSystemsDbSystemSecureConnection[]

Secure connection configuration details.

shapeName string

shutdownType string

sources GetMysqlDbSystemsDbSystemSource[]

Parameters detailing how to provision the initial data of the DB System.

state string

DbSystem Lifecycle State

subnetId string

The OCID of the subnet the DB System is associated with.

systemTags {[key: string]: string}

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

timeCreated string

The date and time the DB System was created.

timeUpdated string

The time the DB System was last updated.

access_mode str

The access mode indicating if the database access is unrestricted (to all MySQL user accounts), or restricted (to only certain users with specific privileges):

UNRESTRICTED: the access to the database is not restricted;
RESTRICTED: the access is allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

admin_password str

admin_username str

availability_domain str

The availability domain in which the DB System is placed.

backup_policies Sequence[GetMysqlDbSystemsDbSystemBackupPolicy]

The Backup policy for the DB System.

channels Sequence[GetMysqlDbSystemsDbSystemChannel]

A list with a summary of all the Channels attached to the DB System.

compartment_id str

The compartment OCID.

configuration_id str

The requested Configuration instance.

crash_recovery str

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.

current_placements Sequence[GetMysqlDbSystemsDbSystemCurrentPlacement]

The availability domain and fault domain a DB System is placed in.

customer_contacts Sequence[GetMysqlDbSystemsDbSystemCustomerContact]

data_storage_size_in_gb int

Initial size of the data volume in GiBs that will be created and attached.

data_storages Sequence[GetMysqlDbSystemsDbSystemDataStorage]

Data Storage information.

database_management str

Filter DB Systems by their Database Management configuration.

database_mode str

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 Mapping[str, str]

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

deletion_policies Sequence[GetMysqlDbSystemsDbSystemDeletionPolicy]

The Deletion policy for the DB System.

description str

User-provided data about the DB System.

display_name str

A filter to return only the resource matching the given display name exactly.

endpoints Sequence[GetMysqlDbSystemsDbSystemEndpoint]

The network endpoints available for this DB System.

fault_domain str

The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.

freeform_tags Mapping[str, str]

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

heat_wave_clusters Sequence[GetMysqlDbSystemsDbSystemHeatWaveCluster]

A summary of a HeatWave cluster.

hostname_label str

id str

The OCID of the DB System.

ip_address str

is_heat_wave_cluster_attached bool

If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.

is_highly_available bool

Specifies if the DB System is highly available.

lifecycle_details str

Additional information about the current lifecycleState.

maintenances Sequence[GetMysqlDbSystemsDbSystemMaintenance]

The Maintenance Policy for the DB System or Read Replica that this model is included in.

mysql_version str

Name of the MySQL Version in use for the DB System.

point_in_time_recovery_details Sequence[GetMysqlDbSystemsDbSystemPointInTimeRecoveryDetail]

Point-in-time Recovery details like earliest and latest recovery time point for the DB System.

port int

The port for primary endpoint of the DB System to listen on.

port_x int

The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.

read_endpoints Sequence[GetMysqlDbSystemsDbSystemReadEndpoint]

The read endpoint of a DB System.

secure_connections Sequence[GetMysqlDbSystemsDbSystemSecureConnection]

Secure connection configuration details.

shape_name str

shutdown_type str

sources Sequence[GetMysqlDbSystemsDbSystemSource]

Parameters detailing how to provision the initial data of the DB System.

state str

DbSystem Lifecycle State

subnet_id str

The OCID of the subnet the DB System is associated with.

system_tags Mapping[str, str]

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

time_created str

The date and time the DB System was created.

time_updated str

The time the DB System was last updated.

accessMode String

The access mode indicating if the database access is unrestricted (to all MySQL user accounts), or restricted (to only certain users with specific privileges):

UNRESTRICTED: the access to the database is not restricted;
RESTRICTED: the access is allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

adminPassword String

adminUsername String

availabilityDomain String

The availability domain in which the DB System is placed.

backupPolicies List<Property Map>

The Backup policy for the DB System.

channels List<Property Map>

A list with a summary of all the Channels attached to the DB System.

compartmentId String

The compartment OCID.

configurationId String

The requested Configuration instance.

crashRecovery String

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.

currentPlacements List<Property Map>

The availability domain and fault domain a DB System is placed in.

customerContacts List<Property Map>

dataStorageSizeInGb Number

Initial size of the data volume in GiBs that will be created and attached.

dataStorages List<Property Map>

Data Storage information.

databaseManagement String

Filter DB Systems by their Database Management configuration.

databaseMode String

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

definedTags Map<String>

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

deletionPolicies List<Property Map>

The Deletion policy for the DB System.

description String

User-provided data about the DB System.

displayName String

A filter to return only the resource matching the given display name exactly.

endpoints List<Property Map>

The network endpoints available for this DB System.

faultDomain String

The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.

freeformTags Map<String>

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

heatWaveClusters List<Property Map>

A summary of a HeatWave cluster.

hostnameLabel String

id String

The OCID of the DB System.

ipAddress String

isHeatWaveClusterAttached Boolean

If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.

isHighlyAvailable Boolean

Specifies if the DB System is highly available.

lifecycleDetails String

Additional information about the current lifecycleState.

maintenances List<Property Map>

The Maintenance Policy for the DB System or Read Replica that this model is included in.

mysqlVersion String

Name of the MySQL Version in use for the DB System.

pointInTimeRecoveryDetails List<Property Map>

Point-in-time Recovery details like earliest and latest recovery time point for the DB System.

port Number

The port for primary endpoint of the DB System to listen on.

portX Number

The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.

readEndpoints List<Property Map>

The read endpoint of a DB System.

secureConnections List<Property Map>

Secure connection configuration details.

shapeName String

shutdownType String

sources List<Property Map>

Parameters detailing how to provision the initial data of the DB System.

state String

DbSystem Lifecycle State

subnetId String

The OCID of the subnet the DB System is associated with.

systemTags Map<String>

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

timeCreated String

The date and time the DB System was created.

timeUpdated String

The time the DB System was last updated.

GetMysqlDbSystemsDbSystemBackupPolicy

CopyPolicies List<GetMysqlDbSystemsDbSystemBackupPolicyCopyPolicy>: List of policies of a DB system to schedule cross-region DB system backup copy.
DefinedTags Dictionary<string, string>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
FreeformTags Dictionary<string, string>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
IsEnabled bool: Specifies if the DB System read endpoint is enabled or not.
PitrPolicies List<GetMysqlDbSystemsDbSystemBackupPolicyPitrPolicy>: The PITR policy for the DB System.
RetentionInDays int: The number of days automated backups are retained.
WindowStartTime string: The start time of the maintenance window.

CopyPolicies []GetMysqlDbSystemsDbSystemBackupPolicyCopyPolicy: List of policies of a DB system to schedule cross-region DB system backup copy.
DefinedTags map[string]string: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
FreeformTags map[string]string: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
IsEnabled bool: Specifies if the DB System read endpoint is enabled or not.
PitrPolicies []GetMysqlDbSystemsDbSystemBackupPolicyPitrPolicy: The PITR policy for the DB System.
RetentionInDays int: The number of days automated backups are retained.
WindowStartTime string: The start time of the maintenance window.

copyPolicies List<GetDbSystemsDbSystemBackupPolicyCopyPolicy>: List of policies of a DB system to schedule cross-region DB system backup copy.
definedTags Map<String,String>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
freeformTags Map<String,String>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
isEnabled Boolean: Specifies if the DB System read endpoint is enabled or not.
pitrPolicies List<GetDbSystemsDbSystemBackupPolicyPitrPolicy>: The PITR policy for the DB System.
retentionInDays Integer: The number of days automated backups are retained.
windowStartTime String: The start time of the maintenance window.

copyPolicies GetMysqlDbSystemsDbSystemBackupPolicyCopyPolicy[]: List of policies of a DB system to schedule cross-region DB system backup copy.
definedTags {[key: string]: string}: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
freeformTags {[key: string]: string}: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
isEnabled boolean: Specifies if the DB System read endpoint is enabled or not.
pitrPolicies GetMysqlDbSystemsDbSystemBackupPolicyPitrPolicy[]: The PITR policy for the DB System.
retentionInDays number: The number of days automated backups are retained.
windowStartTime string: The start time of the maintenance window.

copy_policies Sequence[GetMysqlDbSystemsDbSystemBackupPolicyCopyPolicy]: List of policies of a DB system to schedule cross-region DB system backup copy.
defined_tags Mapping[str, str]: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
freeform_tags Mapping[str, str]: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
is_enabled bool: Specifies if the DB System read endpoint is enabled or not.
pitr_policies Sequence[GetMysqlDbSystemsDbSystemBackupPolicyPitrPolicy]: The PITR policy for the DB System.
retention_in_days int: The number of days automated backups are retained.
window_start_time str: The start time of the maintenance window.

copyPolicies List<Property Map>: List of policies of a DB system to schedule cross-region DB system backup copy.
definedTags Map<String>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
freeformTags Map<String>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
isEnabled Boolean: Specifies if the DB System read endpoint is enabled or not.
pitrPolicies List<Property Map>: The PITR policy for the DB System.
retentionInDays Number: The number of days automated backups are retained.
windowStartTime String: The start time of the maintenance window.

GetMysqlDbSystemsDbSystemBackupPolicyCopyPolicy

BackupCopyRetentionInDays int: Number of days to retain the copied DB system backup.
CopyToRegion string: The destination region name to which the DB system backup will be copied.

BackupCopyRetentionInDays int: Number of days to retain the copied DB system backup.
CopyToRegion string: The destination region name to which the DB system backup will be copied.

backupCopyRetentionInDays Integer: Number of days to retain the copied DB system backup.
copyToRegion String: The destination region name to which the DB system backup will be copied.

backupCopyRetentionInDays number: Number of days to retain the copied DB system backup.
copyToRegion string: The destination region name to which the DB system backup will be copied.

backup_copy_retention_in_days int: Number of days to retain the copied DB system backup.
copy_to_region str: The destination region name to which the DB system backup will be copied.

backupCopyRetentionInDays Number: Number of days to retain the copied DB system backup.
copyToRegion String: The destination region name to which the DB system backup will be copied.

GetMysqlDbSystemsDbSystemBackupPolicyPitrPolicy

IsEnabled bool: Specifies if the DB System read endpoint is enabled or not.

IsEnabled bool: Specifies if the DB System read endpoint is enabled or not.

isEnabled Boolean: Specifies if the DB System read endpoint is enabled or not.

isEnabled boolean: Specifies if the DB System read endpoint is enabled or not.

is_enabled bool: Specifies if the DB System read endpoint is enabled or not.

isEnabled Boolean: Specifies if the DB System read endpoint is enabled or not.

GetMysqlDbSystemsDbSystemChannel

CompartmentId string: The compartment OCID.
DefinedTags Dictionary<string, string>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
DisplayName string: A filter to return only the resource matching the given display name exactly.
FreeformTags Dictionary<string, string>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
Id string: The OCID of the DB System.
IsEnabled bool: Specifies if the DB System read endpoint is enabled or not.
LifecycleDetails string: Additional information about the current lifecycleState.
Sources List<GetMysqlDbSystemsDbSystemChannelSource>: Parameters detailing how to provision the initial data of the DB System.
State string: DbSystem Lifecycle State
SystemTags Dictionary<string, string>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
Targets List<GetMysqlDbSystemsDbSystemChannelTarget>: Details about the Channel target.
TimeCreated string: The date and time the DB System was created.
TimeUpdated string: The time the DB System was last updated.

CompartmentId string: The compartment OCID.
DefinedTags map[string]string: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
DisplayName string: A filter to return only the resource matching the given display name exactly.
FreeformTags map[string]string: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
Id string: The OCID of the DB System.
IsEnabled bool: Specifies if the DB System read endpoint is enabled or not.
LifecycleDetails string: Additional information about the current lifecycleState.
Sources []GetMysqlDbSystemsDbSystemChannelSource: Parameters detailing how to provision the initial data of the DB System.
State string: DbSystem Lifecycle State
SystemTags map[string]string: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
Targets []GetMysqlDbSystemsDbSystemChannelTarget: Details about the Channel target.
TimeCreated string: The date and time the DB System was created.
TimeUpdated string: The time the DB System was last updated.

compartmentId String: The compartment OCID.
definedTags Map<String,String>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
displayName String: A filter to return only the resource matching the given display name exactly.
freeformTags Map<String,String>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id String: The OCID of the DB System.
isEnabled Boolean: Specifies if the DB System read endpoint is enabled or not.
lifecycleDetails String: Additional information about the current lifecycleState.
sources List<GetDbSystemsDbSystemChannelSource>: Parameters detailing how to provision the initial data of the DB System.
state String: DbSystem Lifecycle State
systemTags Map<String,String>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
targets List<GetDbSystemsDbSystemChannelTarget>: Details about the Channel target.
timeCreated String: The date and time the DB System was created.
timeUpdated String: The time the DB System was last updated.

compartmentId string: The compartment OCID.
definedTags {[key: string]: string}: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
displayName string: A filter to return only the resource matching the given display name exactly.
freeformTags {[key: string]: string}: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id string: The OCID of the DB System.
isEnabled boolean: Specifies if the DB System read endpoint is enabled or not.
lifecycleDetails string: Additional information about the current lifecycleState.
sources GetMysqlDbSystemsDbSystemChannelSource[]: Parameters detailing how to provision the initial data of the DB System.
state string: DbSystem Lifecycle State
systemTags {[key: string]: string}: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
targets GetMysqlDbSystemsDbSystemChannelTarget[]: Details about the Channel target.
timeCreated string: The date and time the DB System was created.
timeUpdated string: The time the DB System was last updated.

compartment_id str: The compartment OCID.
defined_tags Mapping[str, str]: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
display_name str: A filter to return only the resource matching the given display name exactly.
freeform_tags Mapping[str, str]: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id str: The OCID of the DB System.
is_enabled bool: Specifies if the DB System read endpoint is enabled or not.
lifecycle_details str: Additional information about the current lifecycleState.
sources Sequence[GetMysqlDbSystemsDbSystemChannelSource]: Parameters detailing how to provision the initial data of the DB System.
state str: DbSystem Lifecycle State
system_tags Mapping[str, str]: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
targets Sequence[GetMysqlDbSystemsDbSystemChannelTarget]: Details about the Channel target.
time_created str: The date and time the DB System was created.
time_updated str: The time the DB System was last updated.

compartmentId String: The compartment OCID.
definedTags Map<String>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
displayName String: A filter to return only the resource matching the given display name exactly.
freeformTags Map<String>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id String: The OCID of the DB System.
isEnabled Boolean: Specifies if the DB System read endpoint is enabled or not.
lifecycleDetails String: Additional information about the current lifecycleState.
sources List<Property Map>: Parameters detailing how to provision the initial data of the DB System.
state String: DbSystem Lifecycle State
systemTags Map<String>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
targets List<Property Map>: Details about the Channel target.
timeCreated String: The date and time the DB System was created.
timeUpdated String: The time the DB System was last updated.

GetMysqlDbSystemsDbSystemChannelSource

AnonymousTransactionsHandlings List<GetMysqlDbSystemsDbSystemChannelSourceAnonymousTransactionsHandling>: Specifies how the replication channel handles replicated transactions without an identifier, enabling replication from a source that does not use transaction-id-based replication to a replica that does.
Hostname string: The network address of the DB System.
Port int: The port for primary endpoint of the DB System to listen on.
SourceType string: The specific source identifier.
SslCaCertificates List<GetMysqlDbSystemsDbSystemChannelSourceSslCaCertificate>: The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
SslMode string: The SSL mode of the Channel.
Username string: The name of the replication user on the source MySQL instance. The username has a maximum length of 96 characters. For more information, please see the MySQL documentation

AnonymousTransactionsHandlings []GetMysqlDbSystemsDbSystemChannelSourceAnonymousTransactionsHandling: Specifies how the replication channel handles replicated transactions without an identifier, enabling replication from a source that does not use transaction-id-based replication to a replica that does.
Hostname string: The network address of the DB System.
Port int: The port for primary endpoint of the DB System to listen on.
SourceType string: The specific source identifier.
SslCaCertificates []GetMysqlDbSystemsDbSystemChannelSourceSslCaCertificate: The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
SslMode string: The SSL mode of the Channel.
Username string: The name of the replication user on the source MySQL instance. The username has a maximum length of 96 characters. For more information, please see the MySQL documentation

anonymousTransactionsHandlings List<GetDbSystemsDbSystemChannelSourceAnonymousTransactionsHandling>: Specifies how the replication channel handles replicated transactions without an identifier, enabling replication from a source that does not use transaction-id-based replication to a replica that does.
hostname String: The network address of the DB System.
port Integer: The port for primary endpoint of the DB System to listen on.
sourceType String: The specific source identifier.
sslCaCertificates List<GetDbSystemsDbSystemChannelSourceSslCaCertificate>: The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
sslMode String: The SSL mode of the Channel.
username String: The name of the replication user on the source MySQL instance. The username has a maximum length of 96 characters. For more information, please see the MySQL documentation

anonymousTransactionsHandlings GetMysqlDbSystemsDbSystemChannelSourceAnonymousTransactionsHandling[]: Specifies how the replication channel handles replicated transactions without an identifier, enabling replication from a source that does not use transaction-id-based replication to a replica that does.
hostname string: The network address of the DB System.
port number: The port for primary endpoint of the DB System to listen on.
sourceType string: The specific source identifier.
sslCaCertificates GetMysqlDbSystemsDbSystemChannelSourceSslCaCertificate[]: The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
sslMode string: The SSL mode of the Channel.
username string: The name of the replication user on the source MySQL instance. The username has a maximum length of 96 characters. For more information, please see the MySQL documentation

anonymous_transactions_handlings Sequence[GetMysqlDbSystemsDbSystemChannelSourceAnonymousTransactionsHandling]: Specifies how the replication channel handles replicated transactions without an identifier, enabling replication from a source that does not use transaction-id-based replication to a replica that does.
hostname str: The network address of the DB System.
port int: The port for primary endpoint of the DB System to listen on.
source_type str: The specific source identifier.
ssl_ca_certificates Sequence[GetMysqlDbSystemsDbSystemChannelSourceSslCaCertificate]: The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
ssl_mode str: The SSL mode of the Channel.
username str: The name of the replication user on the source MySQL instance. The username has a maximum length of 96 characters. For more information, please see the MySQL documentation

anonymousTransactionsHandlings List<Property Map>: Specifies how the replication channel handles replicated transactions without an identifier, enabling replication from a source that does not use transaction-id-based replication to a replica that does.
hostname String: The network address of the DB System.
port Number: The port for primary endpoint of the DB System to listen on.
sourceType String: The specific source identifier.
sslCaCertificates List<Property Map>: The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
sslMode String: The SSL mode of the Channel.
username String: The name of the replication user on the source MySQL instance. The username has a maximum length of 96 characters. For more information, please see the MySQL documentation

GetMysqlDbSystemsDbSystemChannelSourceAnonymousTransactionsHandling

LastConfiguredLogFilename string: Specifies one of the coordinates (file) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
LastConfiguredLogOffset string: Specifies one of the coordinates (offset) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
Policy string: Specifies how the replication channel handles anonymous transactions.
Uuid string: The UUID that is used as a prefix when generating transaction identifiers for anonymous transactions coming from the source. You can change the UUID later.

LastConfiguredLogFilename string: Specifies one of the coordinates (file) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
LastConfiguredLogOffset string: Specifies one of the coordinates (offset) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
Policy string: Specifies how the replication channel handles anonymous transactions.
Uuid string: The UUID that is used as a prefix when generating transaction identifiers for anonymous transactions coming from the source. You can change the UUID later.

lastConfiguredLogFilename String: Specifies one of the coordinates (file) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
lastConfiguredLogOffset String: Specifies one of the coordinates (offset) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
policy String: Specifies how the replication channel handles anonymous transactions.
uuid String: The UUID that is used as a prefix when generating transaction identifiers for anonymous transactions coming from the source. You can change the UUID later.

lastConfiguredLogFilename string: Specifies one of the coordinates (file) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
lastConfiguredLogOffset string: Specifies one of the coordinates (offset) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
policy string: Specifies how the replication channel handles anonymous transactions.
uuid string: The UUID that is used as a prefix when generating transaction identifiers for anonymous transactions coming from the source. You can change the UUID later.

last_configured_log_filename str: Specifies one of the coordinates (file) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
last_configured_log_offset str: Specifies one of the coordinates (offset) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
policy str: Specifies how the replication channel handles anonymous transactions.
uuid str: The UUID that is used as a prefix when generating transaction identifiers for anonymous transactions coming from the source. You can change the UUID later.

lastConfiguredLogFilename String: Specifies one of the coordinates (file) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
lastConfiguredLogOffset String: Specifies one of the coordinates (offset) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
policy String: Specifies how the replication channel handles anonymous transactions.
uuid String: The UUID that is used as a prefix when generating transaction identifiers for anonymous transactions coming from the source. You can change the UUID later.

GetMysqlDbSystemsDbSystemChannelSourceSslCaCertificate

CertificateType string: The type of CA certificate.
Contents string: The string containing the CA certificate in PEM format.

CertificateType string: The type of CA certificate.
Contents string: The string containing the CA certificate in PEM format.

certificateType String: The type of CA certificate.
contents String: The string containing the CA certificate in PEM format.

certificateType string: The type of CA certificate.
contents string: The string containing the CA certificate in PEM format.

certificate_type str: The type of CA certificate.
contents str: The string containing the CA certificate in PEM format.

certificateType String: The type of CA certificate.
contents String: The string containing the CA certificate in PEM format.

GetMysqlDbSystemsDbSystemChannelTarget

ApplierUsername string: The username for the replication applier of the target MySQL DB System.
ChannelName string: The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
DbSystemId string: The DB System OCID.
DelayInSeconds int: Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
Filters List<GetMysqlDbSystemsDbSystemChannelTargetFilter>: Replication filter rules to be applied at the DB System Channel target.
TablesWithoutPrimaryKeyHandling string: Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
TargetType string: The specific target identifier.

ApplierUsername string: The username for the replication applier of the target MySQL DB System.
ChannelName string: The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
DbSystemId string: The DB System OCID.
DelayInSeconds int: Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
Filters []GetMysqlDbSystemsDbSystemChannelTargetFilter: Replication filter rules to be applied at the DB System Channel target.
TablesWithoutPrimaryKeyHandling string: Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
TargetType string: The specific target identifier.

applierUsername String: The username for the replication applier of the target MySQL DB System.
channelName String: The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
dbSystemId String: The DB System OCID.
delayInSeconds Integer: Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
filters List<GetDbSystemsDbSystemChannelTargetFilter>: Replication filter rules to be applied at the DB System Channel target.
tablesWithoutPrimaryKeyHandling String: Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
targetType String: The specific target identifier.

applierUsername string: The username for the replication applier of the target MySQL DB System.
channelName string: The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
dbSystemId string: The DB System OCID.
delayInSeconds number: Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
filters GetMysqlDbSystemsDbSystemChannelTargetFilter[]: Replication filter rules to be applied at the DB System Channel target.
tablesWithoutPrimaryKeyHandling string: Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
targetType string: The specific target identifier.

applier_username str: The username for the replication applier of the target MySQL DB System.
channel_name str: The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
db_system_id str: The DB System OCID.
delay_in_seconds int: Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
filters Sequence[GetMysqlDbSystemsDbSystemChannelTargetFilter]: Replication filter rules to be applied at the DB System Channel target.
tables_without_primary_key_handling str: Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
target_type str: The specific target identifier.

applierUsername String: The username for the replication applier of the target MySQL DB System.
channelName String: The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
dbSystemId String: The DB System OCID.
delayInSeconds Number: Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
filters List<Property Map>: Replication filter rules to be applied at the DB System Channel target.
tablesWithoutPrimaryKeyHandling String: Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
targetType String: The specific target identifier.

GetMysqlDbSystemsDbSystemChannelTargetFilter

Type string: The type of the filter rule.
Value string: The body of the filter rule. This can represent a database, a table, or a database pair (represented as "db1->db2"). For more information, see Replication Filtering Rules.

Type string: The type of the filter rule.
Value string: The body of the filter rule. This can represent a database, a table, or a database pair (represented as "db1->db2"). For more information, see Replication Filtering Rules.

type String: The type of the filter rule.
value String: The body of the filter rule. This can represent a database, a table, or a database pair (represented as "db1->db2"). For more information, see Replication Filtering Rules.

type string: The type of the filter rule.
value string: The body of the filter rule. This can represent a database, a table, or a database pair (represented as "db1->db2"). For more information, see Replication Filtering Rules.

type str: The type of the filter rule.
value str: The body of the filter rule. This can represent a database, a table, or a database pair (represented as "db1->db2"). For more information, see Replication Filtering Rules.

type String: The type of the filter rule.
value String: The body of the filter rule. This can represent a database, a table, or a database pair (represented as "db1->db2"). For more information, see Replication Filtering Rules.

GetMysqlDbSystemsDbSystemCurrentPlacement

AvailabilityDomain string: The availability domain in which the DB System is placed.
FaultDomain string: The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.

AvailabilityDomain string: The availability domain in which the DB System is placed.
FaultDomain string: The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.

availabilityDomain String: The availability domain in which the DB System is placed.
faultDomain String: The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.

availabilityDomain string: The availability domain in which the DB System is placed.
faultDomain string: The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.

availability_domain str: The availability domain in which the DB System is placed.
fault_domain str: The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.

availabilityDomain String: The availability domain in which the DB System is placed.
faultDomain String: The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.

GetMysqlDbSystemsDbSystemCustomerContact

Email string: The email address used by Oracle to send notifications regarding the DB System.

Email string: The email address used by Oracle to send notifications regarding the DB System.

email String: The email address used by Oracle to send notifications regarding the DB System.

email string: The email address used by Oracle to send notifications regarding the DB System.

email str: The email address used by Oracle to send notifications regarding the DB System.

email String: The email address used by Oracle to send notifications regarding the DB System.

GetMysqlDbSystemsDbSystemDataStorage

AllocatedStorageSizeInGbs int: The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
DataStorageSizeInGb int: Initial size of the data volume in GiBs that will be created and attached.
DataStorageSizeLimitInGbs int: The absolute limit the DB System's storage size may ever expand to, either manually or automatically. This limit is based based on the initial dataStorageSizeInGBs when the DB System was first created. Both dataStorageSizeInGBs and maxDataStorageSizeInGBs can not exceed this value.
IsAutoExpandStorageEnabled bool: Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.
MaxStorageSizeInGbs int: Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.

AllocatedStorageSizeInGbs int: The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
DataStorageSizeInGb int: Initial size of the data volume in GiBs that will be created and attached.
DataStorageSizeLimitInGbs int: The absolute limit the DB System's storage size may ever expand to, either manually or automatically. This limit is based based on the initial dataStorageSizeInGBs when the DB System was first created. Both dataStorageSizeInGBs and maxDataStorageSizeInGBs can not exceed this value.
IsAutoExpandStorageEnabled bool: Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.
MaxStorageSizeInGbs int: Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.

allocatedStorageSizeInGbs Integer: The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
dataStorageSizeInGb Integer: Initial size of the data volume in GiBs that will be created and attached.
dataStorageSizeLimitInGbs Integer: The absolute limit the DB System's storage size may ever expand to, either manually or automatically. This limit is based based on the initial dataStorageSizeInGBs when the DB System was first created. Both dataStorageSizeInGBs and maxDataStorageSizeInGBs can not exceed this value.
isAutoExpandStorageEnabled Boolean: Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.
maxStorageSizeInGbs Integer: Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.

allocatedStorageSizeInGbs number: The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
dataStorageSizeInGb number: Initial size of the data volume in GiBs that will be created and attached.
dataStorageSizeLimitInGbs number: The absolute limit the DB System's storage size may ever expand to, either manually or automatically. This limit is based based on the initial dataStorageSizeInGBs when the DB System was first created. Both dataStorageSizeInGBs and maxDataStorageSizeInGBs can not exceed this value.
isAutoExpandStorageEnabled boolean: Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.
maxStorageSizeInGbs number: Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.

allocated_storage_size_in_gbs int: The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
data_storage_size_in_gb int: Initial size of the data volume in GiBs that will be created and attached.
data_storage_size_limit_in_gbs int: The absolute limit the DB System's storage size may ever expand to, either manually or automatically. This limit is based based on the initial dataStorageSizeInGBs when the DB System was first created. Both dataStorageSizeInGBs and maxDataStorageSizeInGBs can not exceed this value.
is_auto_expand_storage_enabled bool: Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.
max_storage_size_in_gbs int: Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.

allocatedStorageSizeInGbs Number: The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
dataStorageSizeInGb Number: Initial size of the data volume in GiBs that will be created and attached.
dataStorageSizeLimitInGbs Number: The absolute limit the DB System's storage size may ever expand to, either manually or automatically. This limit is based based on the initial dataStorageSizeInGBs when the DB System was first created. Both dataStorageSizeInGBs and maxDataStorageSizeInGBs can not exceed this value.
isAutoExpandStorageEnabled Boolean: Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.
maxStorageSizeInGbs Number: Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.

GetMysqlDbSystemsDbSystemDeletionPolicy

AutomaticBackupRetention string: Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
FinalBackup string: Specifies whether or not a backup is taken when the DB System is deleted. REQUIRE_FINAL_BACKUP: a backup is taken if the DB System is deleted. SKIP_FINAL_BACKUP: a backup is not taken if the DB System is deleted.
IsDeleteProtected bool: Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.

AutomaticBackupRetention string: Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
FinalBackup string: Specifies whether or not a backup is taken when the DB System is deleted. REQUIRE_FINAL_BACKUP: a backup is taken if the DB System is deleted. SKIP_FINAL_BACKUP: a backup is not taken if the DB System is deleted.
IsDeleteProtected bool: Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.

automaticBackupRetention String: Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
finalBackup String: Specifies whether or not a backup is taken when the DB System is deleted. REQUIRE_FINAL_BACKUP: a backup is taken if the DB System is deleted. SKIP_FINAL_BACKUP: a backup is not taken if the DB System is deleted.
isDeleteProtected Boolean: Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.

automaticBackupRetention string: Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
finalBackup string: Specifies whether or not a backup is taken when the DB System is deleted. REQUIRE_FINAL_BACKUP: a backup is taken if the DB System is deleted. SKIP_FINAL_BACKUP: a backup is not taken if the DB System is deleted.
isDeleteProtected boolean: Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.

automatic_backup_retention str: Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
final_backup str: Specifies whether or not a backup is taken when the DB System is deleted. REQUIRE_FINAL_BACKUP: a backup is taken if the DB System is deleted. SKIP_FINAL_BACKUP: a backup is not taken if the DB System is deleted.
is_delete_protected bool: Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.

automaticBackupRetention String: Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
finalBackup String: Specifies whether or not a backup is taken when the DB System is deleted. REQUIRE_FINAL_BACKUP: a backup is taken if the DB System is deleted. SKIP_FINAL_BACKUP: a backup is not taken if the DB System is deleted.
isDeleteProtected Boolean: Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.

GetMysqlDbSystemsDbSystemEndpoint

Hostname string: The network address of the DB System.
IpAddress string: The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
Modes List<string>: The access modes from the client that this endpoint supports.
Port int: The port for primary endpoint of the DB System to listen on.
PortX int: The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
ResourceId string: The OCID of the resource that this endpoint is attached to.
ResourceType string: The type of endpoint that clients and connectors can connect to.
Status string: The state of the endpoints, as far as it can seen from the DB System. There may be some inconsistency with the actual state of the MySQL service.
StatusDetails string: Additional information about the current endpoint status.

Hostname string: The network address of the DB System.
IpAddress string: The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
Modes []string: The access modes from the client that this endpoint supports.
Port int: The port for primary endpoint of the DB System to listen on.
PortX int: The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
ResourceId string: The OCID of the resource that this endpoint is attached to.
ResourceType string: The type of endpoint that clients and connectors can connect to.
Status string: The state of the endpoints, as far as it can seen from the DB System. There may be some inconsistency with the actual state of the MySQL service.
StatusDetails string: Additional information about the current endpoint status.

hostname String: The network address of the DB System.
ipAddress String: The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
modes List<String>: The access modes from the client that this endpoint supports.
port Integer: The port for primary endpoint of the DB System to listen on.
portX Integer: The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
resourceId String: The OCID of the resource that this endpoint is attached to.
resourceType String: The type of endpoint that clients and connectors can connect to.
status String: The state of the endpoints, as far as it can seen from the DB System. There may be some inconsistency with the actual state of the MySQL service.
statusDetails String: Additional information about the current endpoint status.

hostname string: The network address of the DB System.
ipAddress string: The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
modes string[]: The access modes from the client that this endpoint supports.
port number: The port for primary endpoint of the DB System to listen on.
portX number: The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
resourceId string: The OCID of the resource that this endpoint is attached to.
resourceType string: The type of endpoint that clients and connectors can connect to.
status string: The state of the endpoints, as far as it can seen from the DB System. There may be some inconsistency with the actual state of the MySQL service.
statusDetails string: Additional information about the current endpoint status.

hostname str: The network address of the DB System.
ip_address str: The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
modes Sequence[str]: The access modes from the client that this endpoint supports.
port int: The port for primary endpoint of the DB System to listen on.
port_x int: The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
resource_id str: The OCID of the resource that this endpoint is attached to.
resource_type str: The type of endpoint that clients and connectors can connect to.
status str: The state of the endpoints, as far as it can seen from the DB System. There may be some inconsistency with the actual state of the MySQL service.
status_details str: Additional information about the current endpoint status.

hostname String: The network address of the DB System.
ipAddress String: The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
modes List<String>: The access modes from the client that this endpoint supports.
port Number: The port for primary endpoint of the DB System to listen on.
portX Number: The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
resourceId String: The OCID of the resource that this endpoint is attached to.
resourceType String: The type of endpoint that clients and connectors can connect to.
status String: The state of the endpoints, as far as it can seen from the DB System. There may be some inconsistency with the actual state of the MySQL service.
statusDetails String: Additional information about the current endpoint status.

GetMysqlDbSystemsDbSystemHeatWaveCluster

ClusterSize int: The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
IsLakehouseEnabled bool: Lakehouse enabled status for the HeatWave cluster.
ShapeName string: The shape of the primary instances of the DB System. The shape determines resources allocated to a 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 ListShapes operation.
State string: DbSystem Lifecycle State
TimeCreated string: The date and time the DB System was created.
TimeUpdated string: The time the DB System was last updated.

ClusterSize int: The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
IsLakehouseEnabled bool: Lakehouse enabled status for the HeatWave cluster.
ShapeName string: The shape of the primary instances of the DB System. The shape determines resources allocated to a 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 ListShapes operation.
State string: DbSystem Lifecycle State
TimeCreated string: The date and time the DB System was created.
TimeUpdated string: The time the DB System was last updated.

clusterSize Integer: The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
isLakehouseEnabled Boolean: Lakehouse enabled status for the HeatWave cluster.
shapeName String: The shape of the primary instances of the DB System. The shape determines resources allocated to a 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 ListShapes operation.
state String: DbSystem Lifecycle State
timeCreated String: The date and time the DB System was created.
timeUpdated String: The time the DB System was last updated.

clusterSize number: The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
isLakehouseEnabled boolean: Lakehouse enabled status for the HeatWave cluster.
shapeName string: The shape of the primary instances of the DB System. The shape determines resources allocated to a 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 ListShapes operation.
state string: DbSystem Lifecycle State
timeCreated string: The date and time the DB System was created.
timeUpdated string: The time the DB System was last updated.

cluster_size int: The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
is_lakehouse_enabled bool: Lakehouse enabled status for the HeatWave cluster.
shape_name str: The shape of the primary instances of the DB System. The shape determines resources allocated to a 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 ListShapes operation.
state str: DbSystem Lifecycle State
time_created str: The date and time the DB System was created.
time_updated str: The time the DB System was last updated.

clusterSize Number: The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
isLakehouseEnabled Boolean: Lakehouse enabled status for the HeatWave cluster.
shapeName String: The shape of the primary instances of the DB System. The shape determines resources allocated to a 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 ListShapes operation.
state String: DbSystem Lifecycle State
timeCreated String: The date and time the DB System was created.
timeUpdated String: The time the DB System was last updated.

GetMysqlDbSystemsDbSystemMaintenance

WindowStartTime string: The start time of the maintenance window.

WindowStartTime string: The start time of the maintenance window.

windowStartTime String: The start time of the maintenance window.

windowStartTime string: The start time of the maintenance window.

window_start_time str: The start time of the maintenance window.

windowStartTime String: The start time of the maintenance window.

GetMysqlDbSystemsDbSystemPointInTimeRecoveryDetail

TimeEarliestRecoveryPoint string: Earliest recovery time point for the DB System, as described by RFC 3339.
TimeLatestRecoveryPoint string: Latest recovery time point for the DB System, as described by RFC 3339.

TimeEarliestRecoveryPoint string: Earliest recovery time point for the DB System, as described by RFC 3339.
TimeLatestRecoveryPoint string: Latest recovery time point for the DB System, as described by RFC 3339.

timeEarliestRecoveryPoint String: Earliest recovery time point for the DB System, as described by RFC 3339.
timeLatestRecoveryPoint String: Latest recovery time point for the DB System, as described by RFC 3339.

timeEarliestRecoveryPoint string: Earliest recovery time point for the DB System, as described by RFC 3339.
timeLatestRecoveryPoint string: Latest recovery time point for the DB System, as described by RFC 3339.

time_earliest_recovery_point str: Earliest recovery time point for the DB System, as described by RFC 3339.
time_latest_recovery_point str: Latest recovery time point for the DB System, as described by RFC 3339.

timeEarliestRecoveryPoint String: Earliest recovery time point for the DB System, as described by RFC 3339.
timeLatestRecoveryPoint String: Latest recovery time point for the DB System, as described by RFC 3339.

GetMysqlDbSystemsDbSystemReadEndpoint

ExcludeIps List<string>: A list of IP addresses of read replicas that are excluded from serving read requests.
IsEnabled bool: Specifies if the DB System read endpoint is enabled or not.
ReadEndpointHostnameLabel string: The hostname for the read endpoint of the DB System. Used for DNS.
ReadEndpointIpAddress string: The IP address the DB System read endpoint is configured to listen on. A private IP address of your choice to assign to the read endpoint of the DB System. Must be an available 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.

ExcludeIps []string: A list of IP addresses of read replicas that are excluded from serving read requests.
IsEnabled bool: Specifies if the DB System read endpoint is enabled or not.
ReadEndpointHostnameLabel string: The hostname for the read endpoint of the DB System. Used for DNS.
ReadEndpointIpAddress string: The IP address the DB System read endpoint is configured to listen on. A private IP address of your choice to assign to the read endpoint of the DB System. Must be an available 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.

excludeIps List<String>: A list of IP addresses of read replicas that are excluded from serving read requests.
isEnabled Boolean: Specifies if the DB System read endpoint is enabled or not.
readEndpointHostnameLabel String: The hostname for the read endpoint of the DB System. Used for DNS.
readEndpointIpAddress String: The IP address the DB System read endpoint is configured to listen on. A private IP address of your choice to assign to the read endpoint of the DB System. Must be an available 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.

excludeIps string[]: A list of IP addresses of read replicas that are excluded from serving read requests.
isEnabled boolean: Specifies if the DB System read endpoint is enabled or not.
readEndpointHostnameLabel string: The hostname for the read endpoint of the DB System. Used for DNS.
readEndpointIpAddress string: The IP address the DB System read endpoint is configured to listen on. A private IP address of your choice to assign to the read endpoint of the DB System. Must be an available 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.

exclude_ips Sequence[str]: A list of IP addresses of read replicas that are excluded from serving read requests.
is_enabled bool: Specifies if the DB System read endpoint is enabled or not.
read_endpoint_hostname_label str: The hostname for the read endpoint of the DB System. Used for DNS.
read_endpoint_ip_address str: The IP address the DB System read endpoint is configured to listen on. A private IP address of your choice to assign to the read endpoint of the DB System. Must be an available 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.

excludeIps List<String>: A list of IP addresses of read replicas that are excluded from serving read requests.
isEnabled Boolean: Specifies if the DB System read endpoint is enabled or not.
readEndpointHostnameLabel String: The hostname for the read endpoint of the DB System. Used for DNS.
readEndpointIpAddress String: The IP address the DB System read endpoint is configured to listen on. A private IP address of your choice to assign to the read endpoint of the DB System. Must be an available 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.

GetMysqlDbSystemsDbSystemSecureConnection

CertificateGenerationType string: Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
CertificateId string: The OCID of the certificate to use.

CertificateGenerationType string: Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
CertificateId string: The OCID of the certificate to use.

certificateGenerationType String: Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
certificateId String: The OCID of the certificate to use.

certificateGenerationType string: Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
certificateId string: The OCID of the certificate to use.

certificate_generation_type str: Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
certificate_id str: The OCID of the certificate to use.

certificateGenerationType String: Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
certificateId String: The OCID of the certificate to use.

GetMysqlDbSystemsDbSystemSource

BackupId string: The OCID of the backup to be used as the source for the new DB System.
DbSystemId string: The DB System OCID.
RecoveryPoint string: The date and time, as per RFC 3339, of the change up to which the new DB System shall be restored to, using a backup and logs from the original DB System. In case no point in time is specified, then this new DB System shall be restored up to the latest change recorded for the original DB System.
SourceType string: The specific source identifier.
SourceUrl string

BackupId string: The OCID of the backup to be used as the source for the new DB System.
DbSystemId string: The DB System OCID.
RecoveryPoint string: The date and time, as per RFC 3339, of the change up to which the new DB System shall be restored to, using a backup and logs from the original DB System. In case no point in time is specified, then this new DB System shall be restored up to the latest change recorded for the original DB System.
SourceType string: The specific source identifier.
SourceUrl string

backupId String: The OCID of the backup to be used as the source for the new DB System.
dbSystemId String: The DB System OCID.
recoveryPoint String: The date and time, as per RFC 3339, of the change up to which the new DB System shall be restored to, using a backup and logs from the original DB System. In case no point in time is specified, then this new DB System shall be restored up to the latest change recorded for the original DB System.
sourceType String: The specific source identifier.
sourceUrl String

backupId string: The OCID of the backup to be used as the source for the new DB System.
dbSystemId string: The DB System OCID.
recoveryPoint string: The date and time, as per RFC 3339, of the change up to which the new DB System shall be restored to, using a backup and logs from the original DB System. In case no point in time is specified, then this new DB System shall be restored up to the latest change recorded for the original DB System.
sourceType string: The specific source identifier.
sourceUrl string

backup_id str: The OCID of the backup to be used as the source for the new DB System.
db_system_id str: The DB System OCID.
recovery_point str: The date and time, as per RFC 3339, of the change up to which the new DB System shall be restored to, using a backup and logs from the original DB System. In case no point in time is specified, then this new DB System shall be restored up to the latest change recorded for the original DB System.
source_type str: The specific source identifier.
source_url str

backupId String: The OCID of the backup to be used as the source for the new DB System.
dbSystemId String: The DB System OCID.
recoveryPoint String: The date and time, as per RFC 3339, of the change up to which the new DB System shall be restored to, using a backup and logs from the original DB System. In case no point in time is specified, then this new DB System shall be restored up to the latest change recorded for the original DB System.
sourceType String: The specific source identifier.
sourceUrl String

GetMysqlDbSystemsFilter

Name string
Values List<string>
Regex bool

Name string
Values []string
Regex bool

name String
values List<String>
regex Boolean

name string
values string[]
regex boolean

name str
values Sequence[str]
regex bool

name String
values List<String>
regex Boolean

Package Details

Repository: oci pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.

Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi

pulumi/pulumi-oci

oci.Mysql.getMysqlDbSystems

On this page

On this page

Example Usage

Using getMysqlDbSystems

getMysqlDbSystems Result

Supporting Types

GetMysqlDbSystemsDbSystem

GetMysqlDbSystemsDbSystemBackupPolicy

GetMysqlDbSystemsDbSystemBackupPolicyCopyPolicy

GetMysqlDbSystemsDbSystemBackupPolicyPitrPolicy

GetMysqlDbSystemsDbSystemChannel

GetMysqlDbSystemsDbSystemChannelSource

GetMysqlDbSystemsDbSystemChannelSourceAnonymousTransactionsHandling

GetMysqlDbSystemsDbSystemChannelSourceSslCaCertificate

GetMysqlDbSystemsDbSystemChannelTarget

GetMysqlDbSystemsDbSystemChannelTargetFilter

GetMysqlDbSystemsDbSystemCurrentPlacement

GetMysqlDbSystemsDbSystemCustomerContact

GetMysqlDbSystemsDbSystemDataStorage

GetMysqlDbSystemsDbSystemDeletionPolicy

GetMysqlDbSystemsDbSystemEndpoint

GetMysqlDbSystemsDbSystemHeatWaveCluster

GetMysqlDbSystemsDbSystemMaintenance

GetMysqlDbSystemsDbSystemPointInTimeRecoveryDetail

GetMysqlDbSystemsDbSystemReadEndpoint

GetMysqlDbSystemsDbSystemSecureConnection

GetMysqlDbSystemsDbSystemSource

GetMysqlDbSystemsFilter

Package Details

On this page

On this page