Docs Packages
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Mysql
  5. getMysqlDbSystem
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi
pulumi/pulumi-oci

oci.Mysql.getMysqlDbSystem

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi
pulumi/pulumi-oci

    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

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

const testMysqlDbSystem = oci.Mysql.getMysqlDbSystem({
    dbSystemId: testDbSystem.id,
});

    import pulumi
import pulumi_oci as oci

test_mysql_db_system = oci.Mysql.get_mysql_db_system(db_system_id=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: testDbSystem.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

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

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

});

    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(testDbSystem.id())
            .build());

    }
}

    variables:
  testMysqlDbSystem:
    fn::invoke:
      Function: oci:Mysql:getMysqlDbSystem
      Arguments:
        dbSystemId: ${testDbSystem.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
    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.
    DatabaseManagement string
    Whether to enable monitoring via the Database Management service.
    DbSystemId string
    The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
    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.
    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.
    SecureConnections List<GetMysqlDbSystemSecureConnection>
    Secure connection configuration details.
    ShapeName string
    The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
    ShutdownType string
    Sources List<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
    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.
    DatabaseManagement string
    Whether to enable monitoring via the Database Management service.
    DbSystemId string
    The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
    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.
    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.
    SecureConnections []GetMysqlDbSystemSecureConnection
    Secure connection configuration details.
    ShapeName string
    The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
    ShutdownType string
    Sources []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
    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.
    databaseManagement String
    Whether to enable monitoring via the Database Management service.
    dbSystemId String
    The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
    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.
    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.
    secureConnections List<GetDbSystemSecureConnection>
    Secure connection configuration details.
    shapeName String
    The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
    shutdownType String
    sources List<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
    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.
    databaseManagement string
    Whether to enable monitoring via the Database Management service.
    dbSystemId string
    The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
    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.
    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.
    secureConnections GetMysqlDbSystemSecureConnection[]
    Secure connection configuration details.
    shapeName string
    The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
    shutdownType string
    sources 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
    availability_domain str
    The availability domain in which the DB System is placed.
    backup_policies Sequence[mysql.GetMysqlDbSystemBackupPolicy]
    The Backup policy for the DB System.
    channels Sequence[mysql.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 Sequence[mysql.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.
    database_management str
    Whether to enable monitoring via the Database Management service.
    db_system_id str
    The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
    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 Sequence[mysql.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 Sequence[mysql.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 Sequence[mysql.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_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 Sequence[mysql.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 Sequence[mysql.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.
    secure_connections Sequence[mysql.GetMysqlDbSystemSecureConnection]
    Secure connection configuration details.
    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 Sequence[mysql.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
    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.
    databaseManagement String
    Whether to enable monitoring via the Database Management service.
    dbSystemId String
    The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
    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.
    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.
    secureConnections List<Property Map>
    Secure connection configuration details.
    shapeName String
    The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
    shutdownType String
    sources List<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

    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 Sequence[mysql.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 Sequence[mysql.GetMysqlDbSystemChannelSource]
    Parameters detailing how to provision the initial data of the DB System.
    state str
    The current state of the DB System.
    targets Sequence[mysql.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 Sequence[mysql.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 Sequence[mysql.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.
    DelayInSeconds int
    Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
    Filters List<GetMysqlDbSystemChannelTargetFilter>
    Replication filter rules to be applied at the DB System Channel target.
    TablesWithoutPrimaryKeyHandling string
    Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
    TargetType string
    The specific target identifier.
    ApplierUsername string
    The username for the replication applier of the target MySQL DB System.
    ChannelName string
    The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
    DbSystemId string
    The DB System OCID.
    DelayInSeconds int
    Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
    Filters []GetMysqlDbSystemChannelTargetFilter
    Replication filter rules to be applied at the DB System Channel target.
    TablesWithoutPrimaryKeyHandling string
    Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
    TargetType string
    The specific target identifier.
    applierUsername String
    The username for the replication applier of the target MySQL DB System.
    channelName String
    The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
    dbSystemId String
    The DB System OCID.
    delayInSeconds Integer
    Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
    filters List<GetDbSystemChannelTargetFilter>
    Replication filter rules to be applied at the DB System Channel target.
    tablesWithoutPrimaryKeyHandling String
    Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
    targetType String
    The specific target identifier.
    applierUsername string
    The username for the replication applier of the target MySQL DB System.
    channelName string
    The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
    dbSystemId string
    The DB System OCID.
    delayInSeconds number
    Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
    filters GetMysqlDbSystemChannelTargetFilter[]
    Replication filter rules to be applied at the DB System Channel target.
    tablesWithoutPrimaryKeyHandling string
    Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
    targetType string
    The specific target identifier.
    applier_username str
    The username for the replication applier of the target MySQL DB System.
    channel_name str
    The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
    db_system_id str
    The DB System OCID.
    delay_in_seconds int
    Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
    filters Sequence[mysql.GetMysqlDbSystemChannelTargetFilter]
    Replication filter rules to be applied at the DB System Channel target.
    tables_without_primary_key_handling str
    Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
    target_type str
    The specific target identifier.
    applierUsername String
    The username for the replication applier of the target MySQL DB System.
    channelName String
    The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
    dbSystemId String
    The DB System OCID.
    delayInSeconds Number
    Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
    filters List<Property Map>
    Replication filter rules to be applied at the DB System Channel target.
    tablesWithoutPrimaryKeyHandling String
    Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
    targetType String
    The specific target identifier.

    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.
    IsLakehouseEnabled bool
    Lakehouse enabled status for the HeatWave cluster.
    ShapeName string
    The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
    State string
    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.
    IsLakehouseEnabled bool
    Lakehouse enabled status for the HeatWave cluster.
    ShapeName string
    The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
    State string
    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.
    isLakehouseEnabled Boolean
    Lakehouse enabled status for the HeatWave cluster.
    shapeName String
    The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
    state String
    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.
    isLakehouseEnabled boolean
    Lakehouse enabled status for the HeatWave cluster.
    shapeName string
    The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
    state string
    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.
    is_lakehouse_enabled bool
    Lakehouse enabled status for the HeatWave cluster.
    shape_name str
    The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
    state str
    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.
    isLakehouseEnabled Boolean
    Lakehouse enabled status for the HeatWave cluster.
    shapeName String
    The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
    state String
    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.

    GetMysqlDbSystemSecureConnection

    CertificateGenerationType string
    Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
    CertificateId string
    The OCID of the certificate to use.
    CertificateGenerationType string
    Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
    CertificateId string
    The OCID of the certificate to use.
    certificateGenerationType String
    Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
    certificateId String
    The OCID of the certificate to use.
    certificateGenerationType string
    Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
    certificateId string
    The OCID of the certificate to use.
    certificate_generation_type str
    Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
    certificate_id str
    The OCID of the certificate to use.
    certificateGenerationType String
    Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
    certificateId String
    The OCID of the certificate to use.

    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.
    oci logo
    Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi
    pulumi/pulumi-oci