Oracle Cloud Infrastructure

Pulumi Official
Package maintained by Pulumi
v0.1.1 published on Tuesday, May 3, 2022 by Pulumi

getMysqlDbSystems

This data source provides the list of Mysql Db Systems in Oracle Cloud Infrastructure MySQL Database service.

Get a list of DB Systems in the specified compartment. The default sort order is by timeUpdated, descending.

Example Usage

using Pulumi;
using Oci = Pulumi.Oci;

class MyStack : Stack
{
    public MyStack()
    {
        var testMysqlDbSystems = Output.Create(Oci.Mysql.GetMysqlDbSystems.InvokeAsync(new Oci.Mysql.GetMysqlDbSystemsArgs
        {
            CompartmentId = @var.Compartment_id,
            ConfigurationId = @var.Mysql_configuration_id,
            DbSystemId = oci_mysql_mysql_db_system.Test_db_system.Id,
            DisplayName = @var.Mysql_db_system_display_name,
            IsAnalyticsClusterAttached = @var.Mysql_db_system_is_analytics_cluster_attached,
            IsHeatWaveClusterAttached = @var.Mysql_db_system_is_heat_wave_cluster_attached,
            IsUpToDate = @var.Mysql_db_system_is_up_to_date,
            State = @var.Mysql_db_system_state,
        }));
    }

}
package main

import (
	"github.com/pulumi/pulumi-oci/sdk/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:              _var.Compartment_id,
			ConfigurationId:            pulumi.StringRef(_var.Mysql_configuration_id),
			DbSystemId:                 pulumi.StringRef(oci_mysql_mysql_db_system.Test_db_system.Id),
			DisplayName:                pulumi.StringRef(_var.Mysql_db_system_display_name),
			IsAnalyticsClusterAttached: pulumi.BoolRef(_var.Mysql_db_system_is_analytics_cluster_attached),
			IsHeatWaveClusterAttached:  pulumi.BoolRef(_var.Mysql_db_system_is_heat_wave_cluster_attached),
			IsUpToDate:                 pulumi.BoolRef(_var.Mysql_db_system_is_up_to_date),
			State:                      pulumi.StringRef(_var.Mysql_db_system_state),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

Coming soon!

import pulumi
import pulumi_oci as oci

test_mysql_db_systems = oci.Mysql.get_mysql_db_systems(compartment_id=var["compartment_id"],
    configuration_id=var["mysql_configuration_id"],
    db_system_id=oci_mysql_mysql_db_system["test_db_system"]["id"],
    display_name=var["mysql_db_system_display_name"],
    is_analytics_cluster_attached=var["mysql_db_system_is_analytics_cluster_attached"],
    is_heat_wave_cluster_attached=var["mysql_db_system_is_heat_wave_cluster_attached"],
    is_up_to_date=var["mysql_db_system_is_up_to_date"],
    state=var["mysql_db_system_state"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testMysqlDbSystems = oci.Mysql.getMysqlDbSystems({
    compartmentId: _var.compartment_id,
    configurationId: _var.mysql_configuration_id,
    dbSystemId: oci_mysql_mysql_db_system.test_db_system.id,
    displayName: _var.mysql_db_system_display_name,
    isAnalyticsClusterAttached: _var.mysql_db_system_is_analytics_cluster_attached,
    isHeatWaveClusterAttached: _var.mysql_db_system_is_heat_wave_cluster_attached,
    isUpToDate: _var.mysql_db_system_is_up_to_date,
    state: _var.mysql_db_system_state,
});

Coming soon!

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,
                         db_system_id: Optional[str] = None,
                         display_name: Optional[str] = None,
                         filters: Optional[Sequence[_mysql.GetMysqlDbSystemsFilter]] = None,
                         is_analytics_cluster_attached: Optional[bool] = 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,
                         db_system_id: Optional[pulumi.Input[str]] = None,
                         display_name: Optional[pulumi.Input[str]] = None,
                         filters: Optional[pulumi.Input[Sequence[pulumi.Input[_mysql.GetMysqlDbSystemsFilterArgs]]]] = None,
                         is_analytics_cluster_attached: Optional[pulumi.Input[bool]] = 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)
// Output-based functions aren't available in Java yet
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.

DbSystemId string

The DB System OCID.

DisplayName string

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

Filters List<GetMysqlDbSystemsFilter>
IsAnalyticsClusterAttached bool

DEPRECATED -- please use HeatWave API instead. If true, return only DB Systems with an Analytics Cluster attached, if false return only DB Systems with no Analytics Cluster attached. If not present, return all DB Systems.

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.

DbSystemId string

The DB System OCID.

DisplayName string

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

Filters []GetMysqlDbSystemsFilter
IsAnalyticsClusterAttached bool

DEPRECATED -- please use HeatWave API instead. If true, return only DB Systems with an Analytics Cluster attached, if false return only DB Systems with no Analytics Cluster attached. If not present, return all DB Systems.

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.

dbSystemId String

The DB System OCID.

displayName String

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

filters List<GetDbSystemsFilter>
isAnalyticsClusterAttached Boolean

DEPRECATED -- please use HeatWave API instead. If true, return only DB Systems with an Analytics Cluster attached, if false return only DB Systems with no Analytics Cluster attached. If not present, return all DB Systems.

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.

dbSystemId string

The DB System OCID.

displayName string

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

filters GetMysqlDbSystemsFilter[]
isAnalyticsClusterAttached boolean

DEPRECATED -- please use HeatWave API instead. If true, return only DB Systems with an Analytics Cluster attached, if false return only DB Systems with no Analytics Cluster attached. If not present, return all DB Systems.

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.

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 GetMysqlDbSystemsFilter]
is_analytics_cluster_attached bool

DEPRECATED -- please use HeatWave API instead. If true, return only DB Systems with an Analytics Cluster attached, if false return only DB Systems with no Analytics Cluster attached. If not present, return all DB Systems.

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.

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>
isAnalyticsClusterAttached Boolean

DEPRECATED -- please use HeatWave API instead. If true, return only DB Systems with an Analytics Cluster attached, if false return only DB Systems with no Analytics Cluster attached. If not present, return all DB Systems.

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.

DbSystemId string

The OCID of the source DB System.

DisplayName string

The user-friendly name for the DB System. It does not have to be unique.

Filters List<GetMysqlDbSystemsFilter>
IsAnalyticsClusterAttached bool

DEPRECATED -- please use isHeatWaveClusterAttached instead. If the DB System has an Analytics Cluster attached.

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.

DbSystemId string

The OCID of the source DB System.

DisplayName string

The user-friendly name for the DB System. It does not have to be unique.

Filters []GetMysqlDbSystemsFilter
IsAnalyticsClusterAttached bool

DEPRECATED -- please use isHeatWaveClusterAttached instead. If the DB System has an Analytics Cluster attached.

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.

dbSystemId String

The OCID of the source DB System.

displayName String

The user-friendly name for the DB System. It does not have to be unique.

filters List<GetDbSystemsFilter>
isAnalyticsClusterAttached Boolean

DEPRECATED -- please use isHeatWaveClusterAttached instead. If the DB System has an Analytics Cluster attached.

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.

dbSystemId string

The OCID of the source DB System.

displayName string

The user-friendly name for the DB System. It does not have to be unique.

filters GetMysqlDbSystemsFilter[]
isAnalyticsClusterAttached boolean

DEPRECATED -- please use isHeatWaveClusterAttached instead. If the DB System has an Analytics Cluster attached.

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

db_system_id str

The OCID of the source DB System.

display_name str

The user-friendly name for the DB System. It does not have to be unique.

filters GetMysqlDbSystemsFilter]
is_analytics_cluster_attached bool

DEPRECATED -- please use isHeatWaveClusterAttached instead. If the DB System has an Analytics Cluster attached.

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.

dbSystemId String

The OCID of the source DB System.

displayName String

The user-friendly name for the DB System. It does not have to be unique.

filters List<Property Map>
isAnalyticsClusterAttached Boolean

DEPRECATED -- please use isHeatWaveClusterAttached instead. If the DB System has an Analytics Cluster attached.

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

AdminPassword string
AdminUsername string
AnalyticsClusters List<GetMysqlDbSystemsDbSystemAnalyticsCluster>

DEPRECATED -- please use HeatWave API instead. A summary of an Analytics Cluster.

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.

DataStorageSizeInGb int

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

DefinedTags Dictionary<string, object>

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, object>

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.

IsAnalyticsClusterAttached bool

DEPRECATED -- please use HeatWave API instead. If true, return only DB Systems with an Analytics Cluster attached, if false return only DB Systems with no Analytics Cluster attached. If not present, return all DB Systems.

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

If the policy is to enable high availability of the instance, by maintaining secondary/failover capacity as necessary.

LifecycleDetails string

Additional information about the current lifecycleState.

Maintenances List<GetMysqlDbSystemsDbSystemMaintenance>

The Maintenance Policy for the DB System.

MysqlVersion string

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

Deprecated:

The 'mysql_version' field has been deprecated and may be removed in a future version. Do not use this field.

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.

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.

TimeCreated string

The date and time the DB System was created.

TimeUpdated string

The time the DB System was last updated.

AdminPassword string
AdminUsername string
AnalyticsClusters []GetMysqlDbSystemsDbSystemAnalyticsCluster

DEPRECATED -- please use HeatWave API instead. A summary of an Analytics Cluster.

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.

DataStorageSizeInGb int

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

DefinedTags map[string]interface{}

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]interface{}

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

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.

IsAnalyticsClusterAttached bool

DEPRECATED -- please use HeatWave API instead. If true, return only DB Systems with an Analytics Cluster attached, if false return only DB Systems with no Analytics Cluster attached. If not present, return all DB Systems.

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

If the policy is to enable high availability of the instance, by maintaining secondary/failover capacity as necessary.

LifecycleDetails string

Additional information about the current lifecycleState.

Maintenances []GetMysqlDbSystemsDbSystemMaintenance

The Maintenance Policy for the DB System.

MysqlVersion string

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

Deprecated:

The 'mysql_version' field has been deprecated and may be removed in a future version. Do not use this field.

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.

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

TimeCreated string

The date and time the DB System was created.

TimeUpdated string

The time the DB System was last updated.

adminPassword String
adminUsername String
analyticsClusters List<GetDbSystemsDbSystemAnalyticsCluster>

DEPRECATED -- please use HeatWave API instead. A summary of an Analytics Cluster.

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.

dataStorageSizeInGb Integer

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

definedTags Map<String,Object>

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,Object>

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

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.

isAnalyticsClusterAttached Boolean

DEPRECATED -- please use HeatWave API instead. If true, return only DB Systems with an Analytics Cluster attached, if false return only DB Systems with no Analytics Cluster attached. If not present, return all DB Systems.

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

If the policy is to enable high availability of the instance, by maintaining secondary/failover capacity as necessary.

lifecycleDetails String

Additional information about the current lifecycleState.

maintenances List<GetDbSystemsDbSystemMaintenance>

The Maintenance Policy for the DB System.

mysqlVersion String

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

Deprecated:

The 'mysql_version' field has been deprecated and may be removed in a future version. Do not use this field.

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.

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

timeCreated String

The date and time the DB System was created.

timeUpdated String

The time the DB System was last updated.

adminPassword string
adminUsername string
analyticsClusters GetMysqlDbSystemsDbSystemAnalyticsCluster[]

DEPRECATED -- please use HeatWave API instead. A summary of an Analytics Cluster.

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.

dataStorageSizeInGb number

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

definedTags {[key: string]: any}

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]: any}

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

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.

isAnalyticsClusterAttached boolean

DEPRECATED -- please use HeatWave API instead. If true, return only DB Systems with an Analytics Cluster attached, if false return only DB Systems with no Analytics Cluster attached. If not present, return all DB Systems.

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

If the policy is to enable high availability of the instance, by maintaining secondary/failover capacity as necessary.

lifecycleDetails string

Additional information about the current lifecycleState.

maintenances GetMysqlDbSystemsDbSystemMaintenance[]

The Maintenance Policy for the DB System.

mysqlVersion string

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

Deprecated:

The 'mysql_version' field has been deprecated and may be removed in a future version. Do not use this field.

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.

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

timeCreated string

The date and time the DB System was created.

timeUpdated string

The time the DB System was last updated.

admin_password str
admin_username str
analytics_clusters GetMysqlDbSystemsDbSystemAnalyticsCluster]

DEPRECATED -- please use HeatWave API instead. A summary of an Analytics Cluster.

availability_domain str

The availability domain in which the DB System is placed.

backup_policies GetMysqlDbSystemsDbSystemBackupPolicy]

The Backup policy for the DB System.

channels 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 GetMysqlDbSystemsDbSystemCurrentPlacement]

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

data_storage_size_in_gb int

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

defined_tags Mapping[str, Any]

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

deletion_policies 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 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, Any]

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

A summary of a HeatWave cluster.

hostname_label str

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 str

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

is_analytics_cluster_attached bool

DEPRECATED -- please use HeatWave API instead. If true, return only DB Systems with an Analytics Cluster attached, if false return only DB Systems with no Analytics Cluster attached. If not present, return all DB Systems.

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

If the policy is to enable high availability of the instance, by maintaining secondary/failover capacity as necessary.

lifecycle_details str

Additional information about the current lifecycleState.

maintenances GetMysqlDbSystemsDbSystemMaintenance]

The Maintenance Policy for the DB System.

mysql_version str

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

Deprecated:

The 'mysql_version' field has been deprecated and may be removed in a future version. Do not use this field.

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.

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.

shutdown_type str
sources 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.

time_created str

The date and time the DB System was created.

time_updated str

The time the DB System was last updated.

adminPassword String
adminUsername String
analyticsClusters List<Property Map>

DEPRECATED -- please use HeatWave API instead. A summary of an Analytics Cluster.

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.

dataStorageSizeInGb Number

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

definedTags Map<Any>

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

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

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.

isAnalyticsClusterAttached Boolean

DEPRECATED -- please use HeatWave API instead. If true, return only DB Systems with an Analytics Cluster attached, if false return only DB Systems with no Analytics Cluster attached. If not present, return all DB Systems.

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

If the policy is to enable high availability of the instance, by maintaining secondary/failover capacity as necessary.

lifecycleDetails String

Additional information about the current lifecycleState.

maintenances List<Property Map>

The Maintenance Policy for the DB System.

mysqlVersion String

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

Deprecated:

The 'mysql_version' field has been deprecated and may be removed in a future version. Do not use this field.

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.

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

timeCreated String

The date and time the DB System was created.

timeUpdated String

The time the DB System was last updated.

GetMysqlDbSystemsDbSystemAnalyticsCluster

ClusterSize int

The number of analytics-processing compute instances, of the specified shape, in 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.

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.

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.

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.

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.

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.

GetMysqlDbSystemsDbSystemBackupPolicy

DefinedTags Dictionary<string, object>

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

FreeformTags Dictionary<string, object>

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

Whether the Channel has been enabled by the user.

RetentionInDays int

The number of days automated backups are retained.

WindowStartTime string

The start time of the maintenance window.

DefinedTags map[string]interface{}

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

FreeformTags map[string]interface{}

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

Whether the Channel has been enabled by the user.

RetentionInDays int

The number of days automated backups are retained.

WindowStartTime string

The start time of the maintenance window.

definedTags Map<String,Object>

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

freeformTags Map<String,Object>

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

Whether the Channel has been enabled by the user.

retentionInDays Integer

The number of days automated backups are retained.

windowStartTime String

The start time of the maintenance window.

definedTags {[key: string]: any}

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

freeformTags {[key: string]: any}

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

Whether the Channel has been enabled by the user.

retentionInDays number

The number of days automated backups are retained.

windowStartTime string

The start time of the maintenance window.

defined_tags Mapping[str, Any]

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

freeform_tags Mapping[str, Any]

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

Whether the Channel has been enabled by the user.

retention_in_days int

The number of days automated backups are retained.

window_start_time str

The start time of the maintenance window.

definedTags Map<Any>

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

freeformTags Map<Any>

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

Whether the Channel has been enabled by the user.

retentionInDays Number

The number of days automated backups are retained.

windowStartTime String

The start time of the maintenance window.

GetMysqlDbSystemsDbSystemChannel

CompartmentId string

The compartment OCID.

DefinedTags Dictionary<string, object>

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, object>

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

Whether the Channel has been enabled by the user.

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

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]interface{}

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]interface{}

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

Whether the Channel has been enabled by the user.

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

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,Object>

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,Object>

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

Whether the Channel has been enabled by the user.

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

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]: any}

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]: any}

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

Whether the Channel has been enabled by the user.

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

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, Any]

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, Any]

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

Whether the Channel has been enabled by the user.

lifecycle_details str

Additional information about the current lifecycleState.

sources GetMysqlDbSystemsDbSystemChannelSource]

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

state str

DbSystem Lifecycle State

targets 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<Any>

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

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

Whether the Channel has been enabled by the user.

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

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

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

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

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

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

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

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

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.

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.

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.

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.

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.

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.

targetType String

The specific target identifier.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

GetMysqlDbSystemsDbSystemSource

BackupId string

The OCID of the backup to be used as the source for the new DB System.

SourceType string

The specific source identifier.

BackupId string

The OCID of the backup to be used as the source for the new DB System.

SourceType string

The specific source identifier.

backupId String

The OCID of the backup to be used as the source for the new DB System.

sourceType String

The specific source identifier.

backupId string

The OCID of the backup to be used as the source for the new DB System.

sourceType string

The specific source identifier.

backup_id str

The OCID of the backup to be used as the source for the new DB System.

source_type str

The specific source identifier.

backupId String

The OCID of the backup to be used as the source for the new DB System.

sourceType String

The specific source identifier.

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
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.