oci logo
Oracle Cloud Infrastructure v0.13.0, Mar 28 23

oci.Mysql.getMysqlDbSystem

This data source provides details about a specific Mysql Db System resource in Oracle Cloud Infrastructure MySQL Database service.

Get information about the specified DB System.

Example Usage

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

return await Deployment.RunAsync(() => 
{
    var testMysqlDbSystem = Oci.Mysql.GetMysqlDbSystem.Invoke(new()
    {
        DbSystemId = oci_mysql_mysql_db_system.Test_db_system.Id,
    });

});
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.GetMysqlDbSystem(ctx, &mysql.GetMysqlDbSystemArgs{
			DbSystemId: oci_mysql_mysql_db_system.Test_db_system.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
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.GetMysqlDbSystemArgs;
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 testMysqlDbSystem = MysqlFunctions.getMysqlDbSystem(GetMysqlDbSystemArgs.builder()
            .dbSystemId(oci_mysql_mysql_db_system.test_db_system().id())
            .build());

    }
}
import pulumi
import pulumi_oci as oci

test_mysql_db_system = oci.Mysql.get_mysql_db_system(db_system_id=oci_mysql_mysql_db_system["test_db_system"]["id"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testMysqlDbSystem = oci.Mysql.getMysqlDbSystem({
    dbSystemId: oci_mysql_mysql_db_system.test_db_system.id,
});
variables:
  testMysqlDbSystem:
    fn::invoke:
      Function: oci:Mysql:getMysqlDbSystem
      Arguments:
        dbSystemId: ${oci_mysql_mysql_db_system.test_db_system.id}

Using getMysqlDbSystem

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 getMysqlDbSystem(args: GetMysqlDbSystemArgs, opts?: InvokeOptions): Promise<GetMysqlDbSystemResult>
function getMysqlDbSystemOutput(args: GetMysqlDbSystemOutputArgs, opts?: InvokeOptions): Output<GetMysqlDbSystemResult>
def get_mysql_db_system(db_system_id: Optional[str] = None,
                        opts: Optional[InvokeOptions] = None) -> GetMysqlDbSystemResult
def get_mysql_db_system_output(db_system_id: Optional[pulumi.Input[str]] = None,
                        opts: Optional[InvokeOptions] = None) -> Output[GetMysqlDbSystemResult]
func GetMysqlDbSystem(ctx *Context, args *GetMysqlDbSystemArgs, opts ...InvokeOption) (*GetMysqlDbSystemResult, error)
func GetMysqlDbSystemOutput(ctx *Context, args *GetMysqlDbSystemOutputArgs, opts ...InvokeOption) GetMysqlDbSystemResultOutput

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

public static class GetMysqlDbSystem 
{
    public static Task<GetMysqlDbSystemResult> InvokeAsync(GetMysqlDbSystemArgs args, InvokeOptions? opts = null)
    public static Output<GetMysqlDbSystemResult> Invoke(GetMysqlDbSystemInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetMysqlDbSystemResult> getMysqlDbSystem(GetMysqlDbSystemArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
  function: oci:Mysql/getMysqlDbSystem:getMysqlDbSystem
  arguments:
    # arguments dictionary

The following arguments are supported:

DbSystemId string

The DB System OCID.

DbSystemId string

The DB System OCID.

dbSystemId String

The DB System OCID.

dbSystemId string

The DB System OCID.

db_system_id str

The DB System OCID.

dbSystemId String

The DB System OCID.

getMysqlDbSystem Result

The following output properties are available:

AdminPassword string
AdminUsername string
AnalyticsClusters List<GetMysqlDbSystemAnalyticsCluster>

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

The Backup policy for the DB System.

Channels List<GetMysqlDbSystemChannel>

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

CompartmentId string

The OCID of the compartment the DB System belongs in.

ConfigurationId string

The OCID of the Configuration to be used for Instances in this DB System.

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

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.

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.

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

The Deletion policy for the DB System.

Description string

User-provided data about the DB System.

DisplayName string

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

Endpoints List<GetMysqlDbSystemEndpoint>

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

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 isHeatWaveClusterAttached instead. If the DB System has an Analytics Cluster attached.

IsHeatWaveClusterAttached bool

If the DB System has a HeatWave Cluster attached.

IsHighlyAvailable bool

Specifies if the DB System is highly available.

LifecycleDetails string

Additional information about the current lifecycleState.

Maintenances List<GetMysqlDbSystemMaintenance>

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

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.

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

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

State string

The current state of the DB System.

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

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

The Backup policy for the DB System.

Channels []GetMysqlDbSystemChannel

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

CompartmentId string

The OCID of the compartment the DB System belongs in.

ConfigurationId string

The OCID of the Configuration to be used for Instances in this DB System.

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

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.

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.

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

The Deletion policy for the DB System.

Description string

User-provided data about the DB System.

DisplayName string

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

Endpoints []GetMysqlDbSystemEndpoint

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

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 isHeatWaveClusterAttached instead. If the DB System has an Analytics Cluster attached.

IsHeatWaveClusterAttached bool

If the DB System has a HeatWave Cluster attached.

IsHighlyAvailable bool

Specifies if the DB System is highly available.

LifecycleDetails string

Additional information about the current lifecycleState.

Maintenances []GetMysqlDbSystemMaintenance

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

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.

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

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

State string

The current state of the DB System.

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

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

The Backup policy for the DB System.

channels List<GetDbSystemChannel>

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

compartmentId String

The OCID of the compartment the DB System belongs in.

configurationId String

The OCID of the Configuration to be used for Instances in this DB System.

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

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.

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.

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

The Deletion policy for the DB System.

description String

User-provided data about the DB System.

displayName String

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

endpoints List<GetDbSystemEndpoint>

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

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 isHeatWaveClusterAttached instead. If the DB System has an Analytics Cluster attached.

isHeatWaveClusterAttached Boolean

If the DB System has a HeatWave Cluster attached.

isHighlyAvailable Boolean

Specifies if the DB System is highly available.

lifecycleDetails String

Additional information about the current lifecycleState.

maintenances List<GetDbSystemMaintenance>

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

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.

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

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

state String

The current state of the DB System.

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

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

The Backup policy for the DB System.

channels GetMysqlDbSystemChannel[]

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

compartmentId string

The OCID of the compartment the DB System belongs in.

configurationId string

The OCID of the Configuration to be used for Instances in this DB System.

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

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.

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.

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

The Deletion policy for the DB System.

description string

User-provided data about the DB System.

displayName string

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

endpoints GetMysqlDbSystemEndpoint[]

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

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 isHeatWaveClusterAttached instead. If the DB System has an Analytics Cluster attached.

isHeatWaveClusterAttached boolean

If the DB System has a HeatWave Cluster attached.

isHighlyAvailable boolean

Specifies if the DB System is highly available.

lifecycleDetails string

Additional information about the current lifecycleState.

maintenances GetMysqlDbSystemMaintenance[]

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

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.

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

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

state string

The current state of the DB System.

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

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

The Backup policy for the DB System.

channels GetMysqlDbSystemChannel]

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

compartment_id str

The OCID of the compartment the DB System belongs in.

configuration_id str

The OCID of the Configuration to be used for Instances in this DB System.

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

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.

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.

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

The Deletion policy for the DB System.

description str

User-provided data about the DB System.

display_name str

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

endpoints GetMysqlDbSystemEndpoint]

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

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

Specifies if the DB System is highly available.

lifecycle_details str

Additional information about the current lifecycleState.

maintenances GetMysqlDbSystemMaintenance]

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

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.

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

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

state str

The current state of the DB System.

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 OCID of the compartment the DB System belongs in.

configurationId String

The OCID of the Configuration to be used for Instances in this DB System.

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.

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.

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

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

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 isHeatWaveClusterAttached instead. If the DB System has an Analytics Cluster attached.

isHeatWaveClusterAttached Boolean

If the DB System has a HeatWave Cluster attached.

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.

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

The current state of the DB System.

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.

Supporting Types

GetMysqlDbSystemAnalyticsCluster

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

The current state of the DB System.

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

The current state of the DB System.

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

The current state of the DB System.

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

The current state of the DB System.

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

The current state of the DB System.

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

The current state of the DB System.

timeCreated String

The date and time the DB System was created.

timeUpdated String

The time the DB System was last updated.

GetMysqlDbSystemBackupPolicy

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.

PitrPolicies List<GetMysqlDbSystemBackupPolicyPitrPolicy>

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.

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.

PitrPolicies []GetMysqlDbSystemBackupPolicyPitrPolicy

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.

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.

pitrPolicies List<GetDbSystemBackupPolicyPitrPolicy>

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.

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.

pitrPolicies GetMysqlDbSystemBackupPolicyPitrPolicy[]

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.

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.

pitr_policies GetMysqlDbSystemBackupPolicyPitrPolicy]

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.

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.

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.

GetMysqlDbSystemBackupPolicyPitrPolicy

IsEnabled bool

Whether the Channel has been enabled by the user.

IsEnabled bool

Whether the Channel has been enabled by the user.

isEnabled Boolean

Whether the Channel has been enabled by the user.

isEnabled boolean

Whether the Channel has been enabled by the user.

is_enabled bool

Whether the Channel has been enabled by the user.

isEnabled Boolean

Whether the Channel has been enabled by the user.

GetMysqlDbSystemChannel

CompartmentId string

The OCID of the compartment the DB System belongs in.

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

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

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

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

State string

The current state of the DB System.

Targets List<GetMysqlDbSystemChannelTarget>

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 OCID of the compartment the DB System belongs in.

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

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

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

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

State string

The current state of the DB System.

Targets []GetMysqlDbSystemChannelTarget

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 OCID of the compartment the DB System belongs in.

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

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

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

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

state String

The current state of the DB System.

targets List<GetDbSystemChannelTarget>

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 OCID of the compartment the DB System belongs in.

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

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

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

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

state string

The current state of the DB System.

targets GetMysqlDbSystemChannelTarget[]

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 OCID of the compartment the DB System belongs in.

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

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

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

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

state str

The current state of the DB System.

targets GetMysqlDbSystemChannelTarget]

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 OCID of the compartment the DB System belongs in.

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

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

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

The current state of the DB System.

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.

GetMysqlDbSystemChannelSource

AnonymousTransactionsHandlings List<GetMysqlDbSystemChannelSourceAnonymousTransactionsHandling>

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

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

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

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

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

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

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

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

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

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

GetMysqlDbSystemChannelSourceAnonymousTransactionsHandling

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.

GetMysqlDbSystemChannelSourceSslCaCertificate

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.

GetMysqlDbSystemChannelTarget

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.

Filters List<GetMysqlDbSystemChannelTargetFilter>

Replication filter rules to be applied at the DB System Channel target.

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.

Filters []GetMysqlDbSystemChannelTargetFilter

Replication filter rules to be applied at the DB System Channel target.

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.

filters List<GetDbSystemChannelTargetFilter>

Replication filter rules to be applied at the DB System Channel target.

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.

filters GetMysqlDbSystemChannelTargetFilter[]

Replication filter rules to be applied at the DB System Channel target.

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.

filters GetMysqlDbSystemChannelTargetFilter]

Replication filter rules to be applied at the DB System Channel target.

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.

filters List<Property Map>

Replication filter rules to be applied at the DB System Channel target.

targetType String

The specific target identifier.

GetMysqlDbSystemChannelTargetFilter

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.

GetMysqlDbSystemCurrentPlacement

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.

GetMysqlDbSystemDeletionPolicy

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.

GetMysqlDbSystemEndpoint

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.

GetMysqlDbSystemHeatWaveCluster

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

The current state of the DB System.

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

The current state of the DB System.

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

The current state of the DB System.

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

The current state of the DB System.

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

The current state of the DB System.

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

The current state of the DB System.

timeCreated String

The date and time the DB System was created.

timeUpdated String

The time the DB System was last updated.

GetMysqlDbSystemMaintenance

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.

GetMysqlDbSystemPointInTimeRecoveryDetail

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.

GetMysqlDbSystemSource

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

Package Details

Repository
oci pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.