Oracle Cloud Infrastructure v1.33.0, Apr 25 24

Oracle Cloud Infrastructure v1.33.0 published on Thursday, Apr 25, 2024 by Pulumi

oci.Mysql.getMysqlDbSystem

Explore with Pulumi AI

Oracle Cloud Infrastructure v1.33.0 published on Thursday, Apr 25, 2024 by Pulumi

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.

Oracle Cloud Infrastructure v1.33.0 published on Thursday, Apr 25, 2024 by Pulumi

pulumi/pulumi-oci

oci.Mysql.getMysqlDbSystem

On this page

On this page

Example Usage

Using getMysqlDbSystem

getMysqlDbSystem Result

Supporting Types

GetMysqlDbSystemBackupPolicy

GetMysqlDbSystemBackupPolicyPitrPolicy

GetMysqlDbSystemChannel

GetMysqlDbSystemChannelSource

GetMysqlDbSystemChannelSourceAnonymousTransactionsHandling

GetMysqlDbSystemChannelSourceSslCaCertificate

GetMysqlDbSystemChannelTarget

GetMysqlDbSystemChannelTargetFilter

GetMysqlDbSystemCurrentPlacement

GetMysqlDbSystemDeletionPolicy

GetMysqlDbSystemEndpoint

GetMysqlDbSystemHeatWaveCluster

GetMysqlDbSystemMaintenance

GetMysqlDbSystemPointInTimeRecoveryDetail

GetMysqlDbSystemSecureConnection

GetMysqlDbSystemSource

Package Details

On this page

On this page