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

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 = new oci.mysql.MysqlDbSystem("test_mysql_db_system", {
    availabilityDomain: mysqlDbSystemAvailabilityDomain,
    compartmentId: compartmentId,
    shapeName: mysqlShapeName,
    subnetId: testSubnet.id,
    adminPassword: mysqlDbSystemAdminPassword,
    adminUsername: mysqlDbSystemAdminUsername,
    backupPolicy: {
        definedTags: {
            "foo-namespace.bar-key": "value",
        },
        freeformTags: {
            "bar-key": "value",
        },
        isEnabled: mysqlDbSystemBackupPolicyIsEnabled,
        pitrPolicy: {
            isEnabled: mysqlDbSystemBackupPolicyPitrPolicyIsEnabled,
        },
        retentionInDays: mysqlDbSystemBackupPolicyRetentionInDays,
        windowStartTime: mysqlDbSystemBackupPolicyWindowStartTime,
    },
    configurationId: testConfiguration.id,
    crashRecovery: mysqlDbSystemCrashRecovery,
    dataStorageSizeInGb: mysqlDbSystemDataStorageSizeInGb,
    databaseManagement: mysqlDbSystemDatabaseManagement,
    definedTags: {
        "foo-namespace.bar-key": "value",
    },
    deletionPolicies: [{
        automaticBackupRetention: mysqlDbSystemDeletionPolicyAutomaticBackupRetention,
        finalBackup: mysqlDbSystemDeletionPolicyFinalBackup,
        isDeleteProtected: mysqlDbSystemDeletionPolicyIsDeleteProtected,
    }],
    description: mysqlDbSystemDescription,
    displayName: mysqlDbSystemDisplayName,
    faultDomain: mysqlDbSystemFaultDomain,
    freeformTags: {
        "bar-key": "value",
    },
    hostnameLabel: mysqlDbSystemHostnameLabel,
    ipAddress: mysqlDbSystemIpAddress,
    isHighlyAvailable: mysqlDbSystemIsHighlyAvailable,
    maintenance: {
        windowStartTime: mysqlDbSystemMaintenanceWindowStartTime,
    },
    port: mysqlDbSystemPort,
    portX: mysqlDbSystemPortX,
    secureConnections: {
        certificateGenerationType: mysqlDbSystemSecureConnectionsCertificateGenerationType,
        certificateId: testCertificate.id,
    },
    source: {
        sourceType: mysqlDbSystemSourceSourceType,
        backupId: testBackup.id,
    },
});

import pulumi
import pulumi_oci as oci

test_mysql_db_system = oci.mysql.MysqlDbSystem("test_mysql_db_system",
    availability_domain=mysql_db_system_availability_domain,
    compartment_id=compartment_id,
    shape_name=mysql_shape_name,
    subnet_id=test_subnet["id"],
    admin_password=mysql_db_system_admin_password,
    admin_username=mysql_db_system_admin_username,
    backup_policy=oci.mysql.MysqlDbSystemBackupPolicyArgs(
        defined_tags={
            "foo-namespace.bar-key": "value",
        },
        freeform_tags={
            "bar-key": "value",
        },
        is_enabled=mysql_db_system_backup_policy_is_enabled,
        pitr_policy=oci.mysql.MysqlDbSystemBackupPolicyPitrPolicyArgs(
            is_enabled=mysql_db_system_backup_policy_pitr_policy_is_enabled,
        ),
        retention_in_days=mysql_db_system_backup_policy_retention_in_days,
        window_start_time=mysql_db_system_backup_policy_window_start_time,
    ),
    configuration_id=test_configuration["id"],
    crash_recovery=mysql_db_system_crash_recovery,
    data_storage_size_in_gb=mysql_db_system_data_storage_size_in_gb,
    database_management=mysql_db_system_database_management,
    defined_tags={
        "foo-namespace.bar-key": "value",
    },
    deletion_policies=[oci.mysql.MysqlDbSystemDeletionPolicyArgs(
        automatic_backup_retention=mysql_db_system_deletion_policy_automatic_backup_retention,
        final_backup=mysql_db_system_deletion_policy_final_backup,
        is_delete_protected=mysql_db_system_deletion_policy_is_delete_protected,
    )],
    description=mysql_db_system_description,
    display_name=mysql_db_system_display_name,
    fault_domain=mysql_db_system_fault_domain,
    freeform_tags={
        "bar-key": "value",
    },
    hostname_label=mysql_db_system_hostname_label,
    ip_address=mysql_db_system_ip_address,
    is_highly_available=mysql_db_system_is_highly_available,
    maintenance=oci.mysql.MysqlDbSystemMaintenanceArgs(
        window_start_time=mysql_db_system_maintenance_window_start_time,
    ),
    port=mysql_db_system_port,
    port_x=mysql_db_system_port_x,
    secure_connections=oci.mysql.MysqlDbSystemSecureConnectionsArgs(
        certificate_generation_type=mysql_db_system_secure_connections_certificate_generation_type,
        certificate_id=test_certificate["id"],
    ),
    source=oci.mysql.MysqlDbSystemSourceArgs(
        source_type=mysql_db_system_source_source_type,
        backup_id=test_backup["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.NewMysqlDbSystem(ctx, "test_mysql_db_system", &Mysql.MysqlDbSystemArgs{
			AvailabilityDomain: pulumi.Any(mysqlDbSystemAvailabilityDomain),
			CompartmentId:      pulumi.Any(compartmentId),
			ShapeName:          pulumi.Any(mysqlShapeName),
			SubnetId:           pulumi.Any(testSubnet.Id),
			AdminPassword:      pulumi.Any(mysqlDbSystemAdminPassword),
			AdminUsername:      pulumi.Any(mysqlDbSystemAdminUsername),
			BackupPolicy: &mysql.MysqlDbSystemBackupPolicyArgs{
				DefinedTags: pulumi.Map{
					"foo-namespace.bar-key": pulumi.Any("value"),
				},
				FreeformTags: pulumi.Map{
					"bar-key": pulumi.Any("value"),
				},
				IsEnabled: pulumi.Any(mysqlDbSystemBackupPolicyIsEnabled),
				PitrPolicy: &mysql.MysqlDbSystemBackupPolicyPitrPolicyArgs{
					IsEnabled: pulumi.Any(mysqlDbSystemBackupPolicyPitrPolicyIsEnabled),
				},
				RetentionInDays: pulumi.Any(mysqlDbSystemBackupPolicyRetentionInDays),
				WindowStartTime: pulumi.Any(mysqlDbSystemBackupPolicyWindowStartTime),
			},
			ConfigurationId:     pulumi.Any(testConfiguration.Id),
			CrashRecovery:       pulumi.Any(mysqlDbSystemCrashRecovery),
			DataStorageSizeInGb: pulumi.Any(mysqlDbSystemDataStorageSizeInGb),
			DatabaseManagement:  pulumi.Any(mysqlDbSystemDatabaseManagement),
			DefinedTags: pulumi.Map{
				"foo-namespace.bar-key": pulumi.Any("value"),
			},
			DeletionPolicies: mysql.MysqlDbSystemDeletionPolicyArray{
				&mysql.MysqlDbSystemDeletionPolicyArgs{
					AutomaticBackupRetention: pulumi.Any(mysqlDbSystemDeletionPolicyAutomaticBackupRetention),
					FinalBackup:              pulumi.Any(mysqlDbSystemDeletionPolicyFinalBackup),
					IsDeleteProtected:        pulumi.Any(mysqlDbSystemDeletionPolicyIsDeleteProtected),
				},
			},
			Description: pulumi.Any(mysqlDbSystemDescription),
			DisplayName: pulumi.Any(mysqlDbSystemDisplayName),
			FaultDomain: pulumi.Any(mysqlDbSystemFaultDomain),
			FreeformTags: pulumi.Map{
				"bar-key": pulumi.Any("value"),
			},
			HostnameLabel:     pulumi.Any(mysqlDbSystemHostnameLabel),
			IpAddress:         pulumi.Any(mysqlDbSystemIpAddress),
			IsHighlyAvailable: pulumi.Any(mysqlDbSystemIsHighlyAvailable),
			Maintenance: &mysql.MysqlDbSystemMaintenanceArgs{
				WindowStartTime: pulumi.Any(mysqlDbSystemMaintenanceWindowStartTime),
			},
			Port:  pulumi.Any(mysqlDbSystemPort),
			PortX: pulumi.Any(mysqlDbSystemPortX),
			SecureConnections: &mysql.MysqlDbSystemSecureConnectionsArgs{
				CertificateGenerationType: pulumi.Any(mysqlDbSystemSecureConnectionsCertificateGenerationType),
				CertificateId:             pulumi.Any(testCertificate.Id),
			},
			Source: &mysql.MysqlDbSystemSourceArgs{
				SourceType: pulumi.Any(mysqlDbSystemSourceSourceType),
				BackupId:   pulumi.Any(testBackup.Id),
			},
		})
		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 = new Oci.Mysql.MysqlDbSystem("test_mysql_db_system", new()
    {
        AvailabilityDomain = mysqlDbSystemAvailabilityDomain,
        CompartmentId = compartmentId,
        ShapeName = mysqlShapeName,
        SubnetId = testSubnet.Id,
        AdminPassword = mysqlDbSystemAdminPassword,
        AdminUsername = mysqlDbSystemAdminUsername,
        BackupPolicy = new Oci.Mysql.Inputs.MysqlDbSystemBackupPolicyArgs
        {
            DefinedTags = 
            {
                { "foo-namespace.bar-key", "value" },
            },
            FreeformTags = 
            {
                { "bar-key", "value" },
            },
            IsEnabled = mysqlDbSystemBackupPolicyIsEnabled,
            PitrPolicy = new Oci.Mysql.Inputs.MysqlDbSystemBackupPolicyPitrPolicyArgs
            {
                IsEnabled = mysqlDbSystemBackupPolicyPitrPolicyIsEnabled,
            },
            RetentionInDays = mysqlDbSystemBackupPolicyRetentionInDays,
            WindowStartTime = mysqlDbSystemBackupPolicyWindowStartTime,
        },
        ConfigurationId = testConfiguration.Id,
        CrashRecovery = mysqlDbSystemCrashRecovery,
        DataStorageSizeInGb = mysqlDbSystemDataStorageSizeInGb,
        DatabaseManagement = mysqlDbSystemDatabaseManagement,
        DefinedTags = 
        {
            { "foo-namespace.bar-key", "value" },
        },
        DeletionPolicies = new[]
        {
            new Oci.Mysql.Inputs.MysqlDbSystemDeletionPolicyArgs
            {
                AutomaticBackupRetention = mysqlDbSystemDeletionPolicyAutomaticBackupRetention,
                FinalBackup = mysqlDbSystemDeletionPolicyFinalBackup,
                IsDeleteProtected = mysqlDbSystemDeletionPolicyIsDeleteProtected,
            },
        },
        Description = mysqlDbSystemDescription,
        DisplayName = mysqlDbSystemDisplayName,
        FaultDomain = mysqlDbSystemFaultDomain,
        FreeformTags = 
        {
            { "bar-key", "value" },
        },
        HostnameLabel = mysqlDbSystemHostnameLabel,
        IpAddress = mysqlDbSystemIpAddress,
        IsHighlyAvailable = mysqlDbSystemIsHighlyAvailable,
        Maintenance = new Oci.Mysql.Inputs.MysqlDbSystemMaintenanceArgs
        {
            WindowStartTime = mysqlDbSystemMaintenanceWindowStartTime,
        },
        Port = mysqlDbSystemPort,
        PortX = mysqlDbSystemPortX,
        SecureConnections = new Oci.Mysql.Inputs.MysqlDbSystemSecureConnectionsArgs
        {
            CertificateGenerationType = mysqlDbSystemSecureConnectionsCertificateGenerationType,
            CertificateId = testCertificate.Id,
        },
        Source = new Oci.Mysql.Inputs.MysqlDbSystemSourceArgs
        {
            SourceType = mysqlDbSystemSourceSourceType,
            BackupId = testBackup.Id,
        },
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Mysql.MysqlDbSystem;
import com.pulumi.oci.Mysql.MysqlDbSystemArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemBackupPolicyArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemBackupPolicyPitrPolicyArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemDeletionPolicyArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemMaintenanceArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemSecureConnectionsArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemSourceArgs;
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) {
        var testMysqlDbSystem = new MysqlDbSystem("testMysqlDbSystem", MysqlDbSystemArgs.builder()        
            .availabilityDomain(mysqlDbSystemAvailabilityDomain)
            .compartmentId(compartmentId)
            .shapeName(mysqlShapeName)
            .subnetId(testSubnet.id())
            .adminPassword(mysqlDbSystemAdminPassword)
            .adminUsername(mysqlDbSystemAdminUsername)
            .backupPolicy(MysqlDbSystemBackupPolicyArgs.builder()
                .definedTags(Map.of("foo-namespace.bar-key", "value"))
                .freeformTags(Map.of("bar-key", "value"))
                .isEnabled(mysqlDbSystemBackupPolicyIsEnabled)
                .pitrPolicy(MysqlDbSystemBackupPolicyPitrPolicyArgs.builder()
                    .isEnabled(mysqlDbSystemBackupPolicyPitrPolicyIsEnabled)
                    .build())
                .retentionInDays(mysqlDbSystemBackupPolicyRetentionInDays)
                .windowStartTime(mysqlDbSystemBackupPolicyWindowStartTime)
                .build())
            .configurationId(testConfiguration.id())
            .crashRecovery(mysqlDbSystemCrashRecovery)
            .dataStorageSizeInGb(mysqlDbSystemDataStorageSizeInGb)
            .databaseManagement(mysqlDbSystemDatabaseManagement)
            .definedTags(Map.of("foo-namespace.bar-key", "value"))
            .deletionPolicies(MysqlDbSystemDeletionPolicyArgs.builder()
                .automaticBackupRetention(mysqlDbSystemDeletionPolicyAutomaticBackupRetention)
                .finalBackup(mysqlDbSystemDeletionPolicyFinalBackup)
                .isDeleteProtected(mysqlDbSystemDeletionPolicyIsDeleteProtected)
                .build())
            .description(mysqlDbSystemDescription)
            .displayName(mysqlDbSystemDisplayName)
            .faultDomain(mysqlDbSystemFaultDomain)
            .freeformTags(Map.of("bar-key", "value"))
            .hostnameLabel(mysqlDbSystemHostnameLabel)
            .ipAddress(mysqlDbSystemIpAddress)
            .isHighlyAvailable(mysqlDbSystemIsHighlyAvailable)
            .maintenance(MysqlDbSystemMaintenanceArgs.builder()
                .windowStartTime(mysqlDbSystemMaintenanceWindowStartTime)
                .build())
            .port(mysqlDbSystemPort)
            .portX(mysqlDbSystemPortX)
            .secureConnections(MysqlDbSystemSecureConnectionsArgs.builder()
                .certificateGenerationType(mysqlDbSystemSecureConnectionsCertificateGenerationType)
                .certificateId(testCertificate.id())
                .build())
            .source(MysqlDbSystemSourceArgs.builder()
                .sourceType(mysqlDbSystemSourceSourceType)
                .backupId(testBackup.id())
                .build())
            .build());

    }
}

resources:
  testMysqlDbSystem:
    type: oci:Mysql:MysqlDbSystem
    name: test_mysql_db_system
    properties:
      availabilityDomain: ${mysqlDbSystemAvailabilityDomain}
      compartmentId: ${compartmentId}
      shapeName: ${mysqlShapeName}
      subnetId: ${testSubnet.id}
      adminPassword: ${mysqlDbSystemAdminPassword}
      adminUsername: ${mysqlDbSystemAdminUsername}
      backupPolicy:
        definedTags:
          foo-namespace.bar-key: value
        freeformTags:
          bar-key: value
        isEnabled: ${mysqlDbSystemBackupPolicyIsEnabled}
        pitrPolicy:
          isEnabled: ${mysqlDbSystemBackupPolicyPitrPolicyIsEnabled}
        retentionInDays: ${mysqlDbSystemBackupPolicyRetentionInDays}
        windowStartTime: ${mysqlDbSystemBackupPolicyWindowStartTime}
      configurationId: ${testConfiguration.id}
      crashRecovery: ${mysqlDbSystemCrashRecovery}
      dataStorageSizeInGb: ${mysqlDbSystemDataStorageSizeInGb}
      databaseManagement: ${mysqlDbSystemDatabaseManagement}
      definedTags:
        foo-namespace.bar-key: value
      deletionPolicies:
        - automaticBackupRetention: ${mysqlDbSystemDeletionPolicyAutomaticBackupRetention}
          finalBackup: ${mysqlDbSystemDeletionPolicyFinalBackup}
          isDeleteProtected: ${mysqlDbSystemDeletionPolicyIsDeleteProtected}
      description: ${mysqlDbSystemDescription}
      displayName: ${mysqlDbSystemDisplayName}
      faultDomain: ${mysqlDbSystemFaultDomain}
      freeformTags:
        bar-key: value
      hostnameLabel: ${mysqlDbSystemHostnameLabel}
      ipAddress: ${mysqlDbSystemIpAddress}
      isHighlyAvailable: ${mysqlDbSystemIsHighlyAvailable}
      maintenance:
        windowStartTime: ${mysqlDbSystemMaintenanceWindowStartTime}
      port: ${mysqlDbSystemPort}
      portX: ${mysqlDbSystemPortX}
      secureConnections:
        certificateGenerationType: ${mysqlDbSystemSecureConnectionsCertificateGenerationType}
        certificateId: ${testCertificate.id}
      source:
        sourceType: ${mysqlDbSystemSourceSourceType}
        backupId: ${testBackup.id}

Create MysqlDbSystem Resource

Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

Constructor syntax

new MysqlDbSystem(name: string, args: MysqlDbSystemArgs, opts?: CustomResourceOptions);

@overload
def MysqlDbSystem(resource_name: str,
                  args: MysqlDbSystemArgs,
                  opts: Optional[ResourceOptions] = None)

@overload
def MysqlDbSystem(resource_name: str,
                  opts: Optional[ResourceOptions] = None,
                  compartment_id: Optional[str] = None,
                  subnet_id: Optional[str] = None,
                  availability_domain: Optional[str] = None,
                  shape_name: Optional[str] = None,
                  freeform_tags: Optional[Mapping[str, Any]] = None,
                  hostname_label: Optional[str] = None,
                  crash_recovery: Optional[str] = None,
                  data_storage_size_in_gb: Optional[int] = None,
                  database_management: Optional[str] = None,
                  defined_tags: Optional[Mapping[str, Any]] = None,
                  deletion_policies: Optional[Sequence[_mysql.MysqlDbSystemDeletionPolicyArgs]] = None,
                  description: Optional[str] = None,
                  display_name: Optional[str] = None,
                  fault_domain: Optional[str] = None,
                  admin_password: Optional[str] = None,
                  configuration_id: Optional[str] = None,
                  ip_address: Optional[str] = None,
                  is_highly_available: Optional[bool] = None,
                  maintenance: Optional[_mysql.MysqlDbSystemMaintenanceArgs] = None,
                  mysql_version: Optional[str] = None,
                  port: Optional[int] = None,
                  port_x: Optional[int] = None,
                  secure_connections: Optional[_mysql.MysqlDbSystemSecureConnectionsArgs] = None,
                  backup_policy: Optional[_mysql.MysqlDbSystemBackupPolicyArgs] = None,
                  shutdown_type: Optional[str] = None,
                  source: Optional[_mysql.MysqlDbSystemSourceArgs] = None,
                  state: Optional[str] = None,
                  admin_username: Optional[str] = None)

func NewMysqlDbSystem(ctx *Context, name string, args MysqlDbSystemArgs, opts ...ResourceOption) (*MysqlDbSystem, error)

public MysqlDbSystem(string name, MysqlDbSystemArgs args, CustomResourceOptions? opts = null)

public MysqlDbSystem(String name, MysqlDbSystemArgs args)
public MysqlDbSystem(String name, MysqlDbSystemArgs args, CustomResourceOptions options)

type: oci:Mysql:MysqlDbSystem
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

Parameters

name string: The unique name of the resource.
args MysqlDbSystemArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

resource_name str: The unique name of the resource.
args MysqlDbSystemArgs: The arguments to resource properties.
opts ResourceOptions: Bag of options to control resource's behavior.

ctx Context: Context object for the current deployment.
name string: The unique name of the resource.
args MysqlDbSystemArgs: The arguments to resource properties.
opts ResourceOption: Bag of options to control resource's behavior.

name string: The unique name of the resource.
args MysqlDbSystemArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

name String: The unique name of the resource.
args MysqlDbSystemArgs: The arguments to resource properties.
options CustomResourceOptions: Bag of options to control resource's behavior.

Example

The following reference example uses placeholder values for all input properties.

var mysqlDbSystemResource = new Oci.Mysql.MysqlDbSystem("mysqlDbSystemResource", new()
{
    CompartmentId = "string",
    SubnetId = "string",
    AvailabilityDomain = "string",
    ShapeName = "string",
    FreeformTags = 
    {
        { "string", "any" },
    },
    HostnameLabel = "string",
    CrashRecovery = "string",
    DataStorageSizeInGb = 0,
    DatabaseManagement = "string",
    DefinedTags = 
    {
        { "string", "any" },
    },
    DeletionPolicies = new[]
    {
        new Oci.Mysql.Inputs.MysqlDbSystemDeletionPolicyArgs
        {
            AutomaticBackupRetention = "string",
            FinalBackup = "string",
            IsDeleteProtected = false,
        },
    },
    Description = "string",
    DisplayName = "string",
    FaultDomain = "string",
    AdminPassword = "string",
    ConfigurationId = "string",
    IpAddress = "string",
    IsHighlyAvailable = false,
    Maintenance = new Oci.Mysql.Inputs.MysqlDbSystemMaintenanceArgs
    {
        WindowStartTime = "string",
    },
    MysqlVersion = "string",
    Port = 0,
    PortX = 0,
    SecureConnections = new Oci.Mysql.Inputs.MysqlDbSystemSecureConnectionsArgs
    {
        CertificateGenerationType = "string",
        CertificateId = "string",
    },
    BackupPolicy = new Oci.Mysql.Inputs.MysqlDbSystemBackupPolicyArgs
    {
        DefinedTags = 
        {
            { "string", "any" },
        },
        FreeformTags = 
        {
            { "string", "any" },
        },
        IsEnabled = false,
        PitrPolicy = new Oci.Mysql.Inputs.MysqlDbSystemBackupPolicyPitrPolicyArgs
        {
            IsEnabled = false,
        },
        RetentionInDays = 0,
        WindowStartTime = "string",
    },
    ShutdownType = "string",
    Source = new Oci.Mysql.Inputs.MysqlDbSystemSourceArgs
    {
        SourceType = "string",
        BackupId = "string",
        DbSystemId = "string",
        RecoveryPoint = "string",
        SourceUrl = "string",
    },
    State = "string",
    AdminUsername = "string",
});

example, err := Mysql.NewMysqlDbSystem(ctx, "mysqlDbSystemResource", &Mysql.MysqlDbSystemArgs{
	CompartmentId:      pulumi.String("string"),
	SubnetId:           pulumi.String("string"),
	AvailabilityDomain: pulumi.String("string"),
	ShapeName:          pulumi.String("string"),
	FreeformTags: pulumi.Map{
		"string": pulumi.Any("any"),
	},
	HostnameLabel:       pulumi.String("string"),
	CrashRecovery:       pulumi.String("string"),
	DataStorageSizeInGb: pulumi.Int(0),
	DatabaseManagement:  pulumi.String("string"),
	DefinedTags: pulumi.Map{
		"string": pulumi.Any("any"),
	},
	DeletionPolicies: mysql.MysqlDbSystemDeletionPolicyArray{
		&mysql.MysqlDbSystemDeletionPolicyArgs{
			AutomaticBackupRetention: pulumi.String("string"),
			FinalBackup:              pulumi.String("string"),
			IsDeleteProtected:        pulumi.Bool(false),
		},
	},
	Description:       pulumi.String("string"),
	DisplayName:       pulumi.String("string"),
	FaultDomain:       pulumi.String("string"),
	AdminPassword:     pulumi.String("string"),
	ConfigurationId:   pulumi.String("string"),
	IpAddress:         pulumi.String("string"),
	IsHighlyAvailable: pulumi.Bool(false),
	Maintenance: &mysql.MysqlDbSystemMaintenanceArgs{
		WindowStartTime: pulumi.String("string"),
	},
	MysqlVersion: pulumi.String("string"),
	Port:         pulumi.Int(0),
	PortX:        pulumi.Int(0),
	SecureConnections: &mysql.MysqlDbSystemSecureConnectionsArgs{
		CertificateGenerationType: pulumi.String("string"),
		CertificateId:             pulumi.String("string"),
	},
	BackupPolicy: &mysql.MysqlDbSystemBackupPolicyArgs{
		DefinedTags: pulumi.Map{
			"string": pulumi.Any("any"),
		},
		FreeformTags: pulumi.Map{
			"string": pulumi.Any("any"),
		},
		IsEnabled: pulumi.Bool(false),
		PitrPolicy: &mysql.MysqlDbSystemBackupPolicyPitrPolicyArgs{
			IsEnabled: pulumi.Bool(false),
		},
		RetentionInDays: pulumi.Int(0),
		WindowStartTime: pulumi.String("string"),
	},
	ShutdownType: pulumi.String("string"),
	Source: &mysql.MysqlDbSystemSourceArgs{
		SourceType:    pulumi.String("string"),
		BackupId:      pulumi.String("string"),
		DbSystemId:    pulumi.String("string"),
		RecoveryPoint: pulumi.String("string"),
		SourceUrl:     pulumi.String("string"),
	},
	State:         pulumi.String("string"),
	AdminUsername: pulumi.String("string"),
})

var mysqlDbSystemResource = new MysqlDbSystem("mysqlDbSystemResource", MysqlDbSystemArgs.builder()        
    .compartmentId("string")
    .subnetId("string")
    .availabilityDomain("string")
    .shapeName("string")
    .freeformTags(Map.of("string", "any"))
    .hostnameLabel("string")
    .crashRecovery("string")
    .dataStorageSizeInGb(0)
    .databaseManagement("string")
    .definedTags(Map.of("string", "any"))
    .deletionPolicies(MysqlDbSystemDeletionPolicyArgs.builder()
        .automaticBackupRetention("string")
        .finalBackup("string")
        .isDeleteProtected(false)
        .build())
    .description("string")
    .displayName("string")
    .faultDomain("string")
    .adminPassword("string")
    .configurationId("string")
    .ipAddress("string")
    .isHighlyAvailable(false)
    .maintenance(MysqlDbSystemMaintenanceArgs.builder()
        .windowStartTime("string")
        .build())
    .mysqlVersion("string")
    .port(0)
    .portX(0)
    .secureConnections(MysqlDbSystemSecureConnectionsArgs.builder()
        .certificateGenerationType("string")
        .certificateId("string")
        .build())
    .backupPolicy(MysqlDbSystemBackupPolicyArgs.builder()
        .definedTags(Map.of("string", "any"))
        .freeformTags(Map.of("string", "any"))
        .isEnabled(false)
        .pitrPolicy(MysqlDbSystemBackupPolicyPitrPolicyArgs.builder()
            .isEnabled(false)
            .build())
        .retentionInDays(0)
        .windowStartTime("string")
        .build())
    .shutdownType("string")
    .source(MysqlDbSystemSourceArgs.builder()
        .sourceType("string")
        .backupId("string")
        .dbSystemId("string")
        .recoveryPoint("string")
        .sourceUrl("string")
        .build())
    .state("string")
    .adminUsername("string")
    .build());

mysql_db_system_resource = oci.mysql.MysqlDbSystem("mysqlDbSystemResource",
    compartment_id="string",
    subnet_id="string",
    availability_domain="string",
    shape_name="string",
    freeform_tags={
        "string": "any",
    },
    hostname_label="string",
    crash_recovery="string",
    data_storage_size_in_gb=0,
    database_management="string",
    defined_tags={
        "string": "any",
    },
    deletion_policies=[oci.mysql.MysqlDbSystemDeletionPolicyArgs(
        automatic_backup_retention="string",
        final_backup="string",
        is_delete_protected=False,
    )],
    description="string",
    display_name="string",
    fault_domain="string",
    admin_password="string",
    configuration_id="string",
    ip_address="string",
    is_highly_available=False,
    maintenance=oci.mysql.MysqlDbSystemMaintenanceArgs(
        window_start_time="string",
    ),
    mysql_version="string",
    port=0,
    port_x=0,
    secure_connections=oci.mysql.MysqlDbSystemSecureConnectionsArgs(
        certificate_generation_type="string",
        certificate_id="string",
    ),
    backup_policy=oci.mysql.MysqlDbSystemBackupPolicyArgs(
        defined_tags={
            "string": "any",
        },
        freeform_tags={
            "string": "any",
        },
        is_enabled=False,
        pitr_policy=oci.mysql.MysqlDbSystemBackupPolicyPitrPolicyArgs(
            is_enabled=False,
        ),
        retention_in_days=0,
        window_start_time="string",
    ),
    shutdown_type="string",
    source=oci.mysql.MysqlDbSystemSourceArgs(
        source_type="string",
        backup_id="string",
        db_system_id="string",
        recovery_point="string",
        source_url="string",
    ),
    state="string",
    admin_username="string")

const mysqlDbSystemResource = new oci.mysql.MysqlDbSystem("mysqlDbSystemResource", {
    compartmentId: "string",
    subnetId: "string",
    availabilityDomain: "string",
    shapeName: "string",
    freeformTags: {
        string: "any",
    },
    hostnameLabel: "string",
    crashRecovery: "string",
    dataStorageSizeInGb: 0,
    databaseManagement: "string",
    definedTags: {
        string: "any",
    },
    deletionPolicies: [{
        automaticBackupRetention: "string",
        finalBackup: "string",
        isDeleteProtected: false,
    }],
    description: "string",
    displayName: "string",
    faultDomain: "string",
    adminPassword: "string",
    configurationId: "string",
    ipAddress: "string",
    isHighlyAvailable: false,
    maintenance: {
        windowStartTime: "string",
    },
    mysqlVersion: "string",
    port: 0,
    portX: 0,
    secureConnections: {
        certificateGenerationType: "string",
        certificateId: "string",
    },
    backupPolicy: {
        definedTags: {
            string: "any",
        },
        freeformTags: {
            string: "any",
        },
        isEnabled: false,
        pitrPolicy: {
            isEnabled: false,
        },
        retentionInDays: 0,
        windowStartTime: "string",
    },
    shutdownType: "string",
    source: {
        sourceType: "string",
        backupId: "string",
        dbSystemId: "string",
        recoveryPoint: "string",
        sourceUrl: "string",
    },
    state: "string",
    adminUsername: "string",
});

type: oci:Mysql:MysqlDbSystem
properties:
    adminPassword: string
    adminUsername: string
    availabilityDomain: string
    backupPolicy:
        definedTags:
            string: any
        freeformTags:
            string: any
        isEnabled: false
        pitrPolicy:
            isEnabled: false
        retentionInDays: 0
        windowStartTime: string
    compartmentId: string
    configurationId: string
    crashRecovery: string
    dataStorageSizeInGb: 0
    databaseManagement: string
    definedTags:
        string: any
    deletionPolicies:
        - automaticBackupRetention: string
          finalBackup: string
          isDeleteProtected: false
    description: string
    displayName: string
    faultDomain: string
    freeformTags:
        string: any
    hostnameLabel: string
    ipAddress: string
    isHighlyAvailable: false
    maintenance:
        windowStartTime: string
    mysqlVersion: string
    port: 0
    portX: 0
    secureConnections:
        certificateGenerationType: string
        certificateId: string
    shapeName: string
    shutdownType: string
    source:
        backupId: string
        dbSystemId: string
        recoveryPoint: string
        sourceType: string
        sourceUrl: string
    state: string
    subnetId: string

MysqlDbSystem Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

The MysqlDbSystem resource accepts the following input properties:

AvailabilityDomain string

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

In a failover scenario, the Read/Write endpoint is redirected to one of the other availability domains and the MySQL instance in that domain is promoted to the primary instance. This redirection does not affect the IP address of the DB System in any way.

For a standalone DB System, this defines the availability domain in which the DB System is placed.

CompartmentId string

The OCID of the compartment.

ShapeName string

(Updatable) The name of the shape. The shape determines the resources allocated

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.

SubnetId string

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

AdminPassword string

The password for the administrative user. The password must be between 8 and 32 characters long, and must contain at least 1 numeric character, 1 lowercase character, 1 uppercase character, and 1 special (nonalphanumeric) character.

AdminUsername string

The username for the administrative user.

BackupPolicy MysqlDbSystemBackupPolicy

(Updatable) Backup policy as optionally used for DB System Creation.

ConfigurationId string

(Updatable) The OCID of the Configuration to be used for this DB System.

CrashRecovery string

(Updatable) 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.

DataStorageSizeInGb int

(Updatable) Initial size of the data volume in GBs that will be created and attached. Keep in mind that this only specifies the size of the database data volume, the log volume for the database will be scaled appropriately with its shape. It is required if you are creating a new database. It cannot be set if you are creating a database from a backup.

DatabaseManagement string

(Updatable) Whether to enable monitoring via the Database Management service.

DefinedTags Dictionary<string, object>

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

DeletionPolicies List<MysqlDbSystemDeletionPolicy>

(Updatable) Policy for how the DB System and related resources should be handled at the time of its deletion.

Description string

(Updatable) User-provided data about the DB System.

DisplayName string

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

FaultDomain string

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

In a failover scenario, the Read/Write endpoint is redirected to one of the other fault domains and the MySQL instance in that domain is promoted to the primary instance. This redirection does not affect the IP address of the DB System in any way.

For a standalone DB System, this defines the fault domain in which the DB System is placed.

FreeformTags Dictionary<string, object>

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

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.

IpAddress string

The IP address the DB System is configured to listen on. A private IP address of your choice to assign to the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. This should be a "dotted-quad" style IPv4 address.

IsHighlyAvailable bool

(Updatable) Specifies if the DB System is highly available.

When creating a DB System with High Availability, three instances are created and placed according to your region- and subnet-type. The secondaries are placed automatically in the other two availability or fault domains. You can choose the preferred location of your primary instance, only.

Maintenance MysqlDbSystemMaintenance

(Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in. maintenance and backup_policy cannot be updated in the same request.

MysqlVersion string

The specific MySQL version identifier.

Port int

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

PortX int

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

SecureConnections MysqlDbSystemSecureConnections

(Updatable) Secure connection configuration details.

ShutdownType string

It is applicable only for stopping a DB System. Could be set to FAST, SLOW or IMMEDIATE. Default value is FAST.

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

Source MysqlDbSystemSource

Parameters detailing how to provision the initial data of the system.

State string

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

AvailabilityDomain string

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

For a standalone DB System, this defines the availability domain in which the DB System is placed.

CompartmentId string

The OCID of the compartment.

ShapeName string

(Updatable) The name of the shape. The shape determines the resources allocated

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.

SubnetId string

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

AdminPassword string

AdminUsername string

The username for the administrative user.

BackupPolicy MysqlDbSystemBackupPolicyArgs

(Updatable) Backup policy as optionally used for DB System Creation.

ConfigurationId string

(Updatable) The OCID of the Configuration to be used for this DB System.

CrashRecovery string

(Updatable) 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.

DataStorageSizeInGb int

DatabaseManagement string

(Updatable) Whether to enable monitoring via the Database Management service.

DefinedTags map[string]interface{}

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

DeletionPolicies []MysqlDbSystemDeletionPolicyArgs

(Updatable) Policy for how the DB System and related resources should be handled at the time of its deletion.

Description string

(Updatable) User-provided data about the DB System.

DisplayName string

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

FaultDomain string

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

For a standalone DB System, this defines the fault domain in which the DB System is placed.

FreeformTags map[string]interface{}

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

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.

IpAddress string

IsHighlyAvailable bool

(Updatable) Specifies if the DB System is highly available.

Maintenance MysqlDbSystemMaintenanceArgs

(Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in. maintenance and backup_policy cannot be updated in the same request.

MysqlVersion string

The specific MySQL version identifier.

Port int

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

PortX int

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

SecureConnections MysqlDbSystemSecureConnectionsArgs

(Updatable) Secure connection configuration details.

ShutdownType string

It is applicable only for stopping a DB System. Could be set to FAST, SLOW or IMMEDIATE. Default value is FAST.

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

Source MysqlDbSystemSourceArgs

Parameters detailing how to provision the initial data of the system.

State string

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

availabilityDomain String

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

For a standalone DB System, this defines the availability domain in which the DB System is placed.

compartmentId String

The OCID of the compartment.

shapeName String

(Updatable) The name of the shape. The shape determines the resources allocated

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.

subnetId String

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

adminPassword String

adminUsername String

The username for the administrative user.

backupPolicy DbSystemBackupPolicy

(Updatable) Backup policy as optionally used for DB System Creation.

configurationId String

(Updatable) The OCID of the Configuration to be used for this DB System.

crashRecovery String

(Updatable) 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.

dataStorageSizeInGb Integer

databaseManagement String

(Updatable) Whether to enable monitoring via the Database Management service.

definedTags Map<String,Object>

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

deletionPolicies List<DbSystemDeletionPolicy>

(Updatable) Policy for how the DB System and related resources should be handled at the time of its deletion.

description String

(Updatable) User-provided data about the DB System.

displayName String

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

faultDomain String

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

For a standalone DB System, this defines the fault domain in which the DB System is placed.

freeformTags Map<String,Object>

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

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.

ipAddress String

isHighlyAvailable Boolean

(Updatable) Specifies if the DB System is highly available.

maintenance DbSystemMaintenance

(Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in. maintenance and backup_policy cannot be updated in the same request.

mysqlVersion String

The specific MySQL version identifier.

port Integer

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

portX Integer

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

secureConnections DbSystemSecureConnections

(Updatable) Secure connection configuration details.

shutdownType String

It is applicable only for stopping a DB System. Could be set to FAST, SLOW or IMMEDIATE. Default value is FAST.

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

source DbSystemSource

Parameters detailing how to provision the initial data of the system.

state String

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

availabilityDomain string

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

For a standalone DB System, this defines the availability domain in which the DB System is placed.

compartmentId string

The OCID of the compartment.

shapeName string

(Updatable) The name of the shape. The shape determines the resources allocated

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.

subnetId string

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

adminPassword string

adminUsername string

The username for the administrative user.

backupPolicy MysqlDbSystemBackupPolicy

(Updatable) Backup policy as optionally used for DB System Creation.

configurationId string

(Updatable) The OCID of the Configuration to be used for this DB System.

crashRecovery string

(Updatable) 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.

dataStorageSizeInGb number

databaseManagement string

(Updatable) Whether to enable monitoring via the Database Management service.

definedTags {[key: string]: any}

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

deletionPolicies MysqlDbSystemDeletionPolicy[]

(Updatable) Policy for how the DB System and related resources should be handled at the time of its deletion.

description string

(Updatable) User-provided data about the DB System.

displayName string

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

faultDomain string

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

For a standalone DB System, this defines the fault domain in which the DB System is placed.

freeformTags {[key: string]: any}

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

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.

ipAddress string

isHighlyAvailable boolean

(Updatable) Specifies if the DB System is highly available.

maintenance MysqlDbSystemMaintenance

(Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in. maintenance and backup_policy cannot be updated in the same request.

mysqlVersion string

The specific MySQL version identifier.

port number

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

portX number

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

secureConnections MysqlDbSystemSecureConnections

(Updatable) Secure connection configuration details.

shutdownType string

It is applicable only for stopping a DB System. Could be set to FAST, SLOW or IMMEDIATE. Default value is FAST.

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

source MysqlDbSystemSource

Parameters detailing how to provision the initial data of the system.

state string

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

availability_domain str

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

For a standalone DB System, this defines the availability domain in which the DB System is placed.

compartment_id str

The OCID of the compartment.

shape_name str

(Updatable) The name of the shape. The shape determines the resources allocated

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.

subnet_id str

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

admin_password str

admin_username str

The username for the administrative user.

backup_policy mysql.MysqlDbSystemBackupPolicyArgs

(Updatable) Backup policy as optionally used for DB System Creation.

configuration_id str

(Updatable) The OCID of the Configuration to be used for this DB System.

crash_recovery str

(Updatable) 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.

data_storage_size_in_gb int

database_management str

(Updatable) Whether to enable monitoring via the Database Management service.

defined_tags Mapping[str, Any]

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

deletion_policies Sequence[mysql.MysqlDbSystemDeletionPolicyArgs]

(Updatable) Policy for how the DB System and related resources should be handled at the time of its deletion.

description str

(Updatable) User-provided data about the DB System.

display_name str

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

fault_domain str

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

For a standalone DB System, this defines the fault domain in which the DB System is placed.

freeform_tags Mapping[str, Any]

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

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.

ip_address str

is_highly_available bool

(Updatable) Specifies if the DB System is highly available.

maintenance mysql.MysqlDbSystemMaintenanceArgs

(Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in. maintenance and backup_policy cannot be updated in the same request.

mysql_version str

The specific MySQL version identifier.

port int

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

port_x int

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

secure_connections mysql.MysqlDbSystemSecureConnectionsArgs

(Updatable) Secure connection configuration details.

shutdown_type str

It is applicable only for stopping a DB System. Could be set to FAST, SLOW or IMMEDIATE. Default value is FAST.

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

source mysql.MysqlDbSystemSourceArgs

Parameters detailing how to provision the initial data of the system.

state str

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

availabilityDomain String

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

For a standalone DB System, this defines the availability domain in which the DB System is placed.

compartmentId String

The OCID of the compartment.

shapeName String

(Updatable) The name of the shape. The shape determines the resources allocated

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.

subnetId String

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

adminPassword String

adminUsername String

The username for the administrative user.

backupPolicy Property Map

(Updatable) Backup policy as optionally used for DB System Creation.

configurationId String

(Updatable) The OCID of the Configuration to be used for this DB System.

crashRecovery String

(Updatable) 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.

dataStorageSizeInGb Number

databaseManagement String

(Updatable) Whether to enable monitoring via the Database Management service.

definedTags Map<Any>

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

deletionPolicies List<Property Map>

(Updatable) Policy for how the DB System and related resources should be handled at the time of its deletion.

description String

(Updatable) User-provided data about the DB System.

displayName String

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

faultDomain String

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

For a standalone DB System, this defines the fault domain in which the DB System is placed.

freeformTags Map<Any>

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

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.

ipAddress String

isHighlyAvailable Boolean

(Updatable) Specifies if the DB System is highly available.

maintenance Property Map

(Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in. maintenance and backup_policy cannot be updated in the same request.

mysqlVersion String

The specific MySQL version identifier.

port Number

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

portX Number

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

secureConnections Property Map

(Updatable) Secure connection configuration details.

shutdownType String

It is applicable only for stopping a DB System. Could be set to FAST, SLOW or IMMEDIATE. Default value is FAST.

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

source Property Map

Parameters detailing how to provision the initial data of the system.

state String

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

Outputs

All input properties are implicitly available as output properties. Additionally, the MysqlDbSystem resource produces the following output properties:

Channels List<MysqlDbSystemChannel>: A list with a summary of all the Channels attached to the DB System.
CurrentPlacements List<MysqlDbSystemCurrentPlacement>: The availability domain and fault domain a DB System is placed in.
Endpoints List<MysqlDbSystemEndpoint>: The network endpoints available for this DB System.
HeatWaveClusters List<MysqlDbSystemHeatWaveCluster>: A summary of a HeatWave cluster.
Id string: The provider-assigned unique ID for this managed resource.
IsHeatWaveClusterAttached bool: If the DB System has a HeatWave Cluster attached.
LifecycleDetails string: Additional information about the current lifecycleState.
PointInTimeRecoveryDetails List<MysqlDbSystemPointInTimeRecoveryDetail>: Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
TimeCreated string: The date and time the DB System was created.
TimeUpdated string: The time the DB System was last updated.

Channels []MysqlDbSystemChannel: A list with a summary of all the Channels attached to the DB System.
CurrentPlacements []MysqlDbSystemCurrentPlacement: The availability domain and fault domain a DB System is placed in.
Endpoints []MysqlDbSystemEndpoint: The network endpoints available for this DB System.
HeatWaveClusters []MysqlDbSystemHeatWaveCluster: A summary of a HeatWave cluster.
Id string: The provider-assigned unique ID for this managed resource.
IsHeatWaveClusterAttached bool: If the DB System has a HeatWave Cluster attached.
LifecycleDetails string: Additional information about the current lifecycleState.
PointInTimeRecoveryDetails []MysqlDbSystemPointInTimeRecoveryDetail: Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
TimeCreated string: The date and time the DB System was created.
TimeUpdated string: The time the DB System was last updated.

channels List<DbSystemChannel>: A list with a summary of all the Channels attached to the DB System.
currentPlacements List<DbSystemCurrentPlacement>: The availability domain and fault domain a DB System is placed in.
endpoints List<DbSystemEndpoint>: The network endpoints available for this DB System.
heatWaveClusters List<DbSystemHeatWaveCluster>: A summary of a HeatWave cluster.
id String: The provider-assigned unique ID for this managed resource.
isHeatWaveClusterAttached Boolean: If the DB System has a HeatWave Cluster attached.
lifecycleDetails String: Additional information about the current lifecycleState.
pointInTimeRecoveryDetails List<DbSystemPointInTimeRecoveryDetail>: Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
timeCreated String: The date and time the DB System was created.
timeUpdated String: The time the DB System was last updated.

channels MysqlDbSystemChannel[]: A list with a summary of all the Channels attached to the DB System.
currentPlacements MysqlDbSystemCurrentPlacement[]: The availability domain and fault domain a DB System is placed in.
endpoints MysqlDbSystemEndpoint[]: The network endpoints available for this DB System.
heatWaveClusters MysqlDbSystemHeatWaveCluster[]: A summary of a HeatWave cluster.
id string: The provider-assigned unique ID for this managed resource.
isHeatWaveClusterAttached boolean: If the DB System has a HeatWave Cluster attached.
lifecycleDetails string: Additional information about the current lifecycleState.
pointInTimeRecoveryDetails MysqlDbSystemPointInTimeRecoveryDetail[]: Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
timeCreated string: The date and time the DB System was created.
timeUpdated string: The time the DB System was last updated.

channels Sequence[mysql.MysqlDbSystemChannel]: A list with a summary of all the Channels attached to the DB System.
current_placements Sequence[mysql.MysqlDbSystemCurrentPlacement]: The availability domain and fault domain a DB System is placed in.
endpoints Sequence[mysql.MysqlDbSystemEndpoint]: The network endpoints available for this DB System.
heat_wave_clusters Sequence[mysql.MysqlDbSystemHeatWaveCluster]: A summary of a HeatWave cluster.
id str: The provider-assigned unique ID for this managed resource.
is_heat_wave_cluster_attached bool: If the DB System has a HeatWave Cluster attached.
lifecycle_details str: Additional information about the current lifecycleState.
point_in_time_recovery_details Sequence[mysql.MysqlDbSystemPointInTimeRecoveryDetail]: Point-in-time Recovery details like earliest and latest recovery time point for 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.

channels List<Property Map>: A list with a summary of all the Channels attached to the DB System.
currentPlacements List<Property Map>: The availability domain and fault domain a DB System is placed in.
endpoints List<Property Map>: The network endpoints available for this DB System.
heatWaveClusters List<Property Map>: A summary of a HeatWave cluster.
id String: The provider-assigned unique ID for this managed resource.
isHeatWaveClusterAttached Boolean: If the DB System has a HeatWave Cluster attached.
lifecycleDetails String: Additional information about the current lifecycleState.
pointInTimeRecoveryDetails List<Property Map>: Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
timeCreated String: The date and time the DB System was created.
timeUpdated String: The time the DB System was last updated.

Look up Existing MysqlDbSystem Resource

Get an existing MysqlDbSystem resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

public static get(name: string, id: Input<ID>, state?: MysqlDbSystemState, opts?: CustomResourceOptions): MysqlDbSystem

@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        admin_password: Optional[str] = None,
        admin_username: Optional[str] = None,
        availability_domain: Optional[str] = None,
        backup_policy: Optional[_mysql.MysqlDbSystemBackupPolicyArgs] = None,
        channels: Optional[Sequence[_mysql.MysqlDbSystemChannelArgs]] = None,
        compartment_id: Optional[str] = None,
        configuration_id: Optional[str] = None,
        crash_recovery: Optional[str] = None,
        current_placements: Optional[Sequence[_mysql.MysqlDbSystemCurrentPlacementArgs]] = None,
        data_storage_size_in_gb: Optional[int] = None,
        database_management: Optional[str] = None,
        defined_tags: Optional[Mapping[str, Any]] = None,
        deletion_policies: Optional[Sequence[_mysql.MysqlDbSystemDeletionPolicyArgs]] = None,
        description: Optional[str] = None,
        display_name: Optional[str] = None,
        endpoints: Optional[Sequence[_mysql.MysqlDbSystemEndpointArgs]] = None,
        fault_domain: Optional[str] = None,
        freeform_tags: Optional[Mapping[str, Any]] = None,
        heat_wave_clusters: Optional[Sequence[_mysql.MysqlDbSystemHeatWaveClusterArgs]] = None,
        hostname_label: Optional[str] = None,
        ip_address: Optional[str] = None,
        is_heat_wave_cluster_attached: Optional[bool] = None,
        is_highly_available: Optional[bool] = None,
        lifecycle_details: Optional[str] = None,
        maintenance: Optional[_mysql.MysqlDbSystemMaintenanceArgs] = None,
        mysql_version: Optional[str] = None,
        point_in_time_recovery_details: Optional[Sequence[_mysql.MysqlDbSystemPointInTimeRecoveryDetailArgs]] = None,
        port: Optional[int] = None,
        port_x: Optional[int] = None,
        secure_connections: Optional[_mysql.MysqlDbSystemSecureConnectionsArgs] = None,
        shape_name: Optional[str] = None,
        shutdown_type: Optional[str] = None,
        source: Optional[_mysql.MysqlDbSystemSourceArgs] = None,
        state: Optional[str] = None,
        subnet_id: Optional[str] = None,
        time_created: Optional[str] = None,
        time_updated: Optional[str] = None) -> MysqlDbSystem

func GetMysqlDbSystem(ctx *Context, name string, id IDInput, state *MysqlDbSystemState, opts ...ResourceOption) (*MysqlDbSystem, error)

public static MysqlDbSystem Get(string name, Input<string> id, MysqlDbSystemState? state, CustomResourceOptions? opts = null)

public static MysqlDbSystem get(String name, Output<String> id, MysqlDbSystemState state, CustomResourceOptions options)

Resource lookup is not supported in YAML

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

resource_name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

The following state arguments are supported:

AdminPassword string

AdminUsername string

The username for the administrative user.

AvailabilityDomain string

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

For a standalone DB System, this defines the availability domain in which the DB System is placed.

BackupPolicy MysqlDbSystemBackupPolicy

(Updatable) Backup policy as optionally used for DB System Creation.

Channels List<MysqlDbSystemChannel>

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

CompartmentId string

The OCID of the compartment.

ConfigurationId string

(Updatable) The OCID of the Configuration to be used for this DB System.

CrashRecovery string

(Updatable) 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<MysqlDbSystemCurrentPlacement>

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

DataStorageSizeInGb int

DatabaseManagement string

(Updatable) Whether to enable monitoring via the Database Management service.

DefinedTags Dictionary<string, object>

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

DeletionPolicies List<MysqlDbSystemDeletionPolicy>

(Updatable) Policy for how the DB System and related resources should be handled at the time of its deletion.

Description string

(Updatable) User-provided data about the DB System.

DisplayName string

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

Endpoints List<MysqlDbSystemEndpoint>

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.

For a standalone DB System, this defines the fault domain in which the DB System is placed.

FreeformTags Dictionary<string, object>

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

HeatWaveClusters List<MysqlDbSystemHeatWaveCluster>

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.

IpAddress string

IsHeatWaveClusterAttached bool

If the DB System has a HeatWave Cluster attached.

IsHighlyAvailable bool

(Updatable) Specifies if the DB System is highly available.

LifecycleDetails string

Additional information about the current lifecycleState.

Maintenance MysqlDbSystemMaintenance

(Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in. maintenance and backup_policy cannot be updated in the same request.

MysqlVersion string

The specific MySQL version identifier.

PointInTimeRecoveryDetails List<MysqlDbSystemPointInTimeRecoveryDetail>

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 TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.

SecureConnections MysqlDbSystemSecureConnections

(Updatable) Secure connection configuration details.

ShapeName string

(Updatable) The name of the shape. The shape determines the resources allocated

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

It is applicable only for stopping a DB System. Could be set to FAST, SLOW or IMMEDIATE. Default value is FAST.

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

Source MysqlDbSystemSource

Parameters detailing how to provision the initial data of the system.

State string

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

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

The username for the administrative user.

AvailabilityDomain string

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

For a standalone DB System, this defines the availability domain in which the DB System is placed.

BackupPolicy MysqlDbSystemBackupPolicyArgs

(Updatable) Backup policy as optionally used for DB System Creation.

Channels []MysqlDbSystemChannelArgs

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

CompartmentId string

The OCID of the compartment.

ConfigurationId string

(Updatable) The OCID of the Configuration to be used for this DB System.

CrashRecovery string

(Updatable) 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 []MysqlDbSystemCurrentPlacementArgs

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

DataStorageSizeInGb int

DatabaseManagement string

(Updatable) Whether to enable monitoring via the Database Management service.

DefinedTags map[string]interface{}

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

DeletionPolicies []MysqlDbSystemDeletionPolicyArgs

(Updatable) Policy for how the DB System and related resources should be handled at the time of its deletion.

Description string

(Updatable) User-provided data about the DB System.

DisplayName string

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

Endpoints []MysqlDbSystemEndpointArgs

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.

For a standalone DB System, this defines the fault domain in which the DB System is placed.

FreeformTags map[string]interface{}

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

HeatWaveClusters []MysqlDbSystemHeatWaveClusterArgs

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.

IpAddress string

IsHeatWaveClusterAttached bool

If the DB System has a HeatWave Cluster attached.

IsHighlyAvailable bool

(Updatable) Specifies if the DB System is highly available.

LifecycleDetails string

Additional information about the current lifecycleState.

Maintenance MysqlDbSystemMaintenanceArgs

(Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in. maintenance and backup_policy cannot be updated in the same request.

MysqlVersion string

The specific MySQL version identifier.

PointInTimeRecoveryDetails []MysqlDbSystemPointInTimeRecoveryDetailArgs

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 TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.

SecureConnections MysqlDbSystemSecureConnectionsArgs

(Updatable) Secure connection configuration details.

ShapeName string

(Updatable) The name of the shape. The shape determines the resources allocated

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

It is applicable only for stopping a DB System. Could be set to FAST, SLOW or IMMEDIATE. Default value is FAST.

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

Source MysqlDbSystemSourceArgs

Parameters detailing how to provision the initial data of the system.

State string

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

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

The username for the administrative user.

availabilityDomain String

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

For a standalone DB System, this defines the availability domain in which the DB System is placed.

backupPolicy DbSystemBackupPolicy

(Updatable) Backup policy as optionally used for DB System Creation.

channels List<DbSystemChannel>

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

compartmentId String

The OCID of the compartment.

configurationId String

(Updatable) The OCID of the Configuration to be used for this DB System.

crashRecovery String

(Updatable) 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<DbSystemCurrentPlacement>

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

dataStorageSizeInGb Integer

databaseManagement String

(Updatable) Whether to enable monitoring via the Database Management service.

definedTags Map<String,Object>

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

deletionPolicies List<DbSystemDeletionPolicy>

(Updatable) Policy for how the DB System and related resources should be handled at the time of its deletion.

description String

(Updatable) User-provided data about the DB System.

displayName String

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

endpoints List<DbSystemEndpoint>

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.

For a standalone DB System, this defines the fault domain in which the DB System is placed.

freeformTags Map<String,Object>

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

heatWaveClusters List<DbSystemHeatWaveCluster>

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.

ipAddress String

isHeatWaveClusterAttached Boolean

If the DB System has a HeatWave Cluster attached.

isHighlyAvailable Boolean

(Updatable) Specifies if the DB System is highly available.

lifecycleDetails String

Additional information about the current lifecycleState.

maintenance DbSystemMaintenance

(Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in. maintenance and backup_policy cannot be updated in the same request.

mysqlVersion String

The specific MySQL version identifier.

pointInTimeRecoveryDetails List<DbSystemPointInTimeRecoveryDetail>

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 TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.

secureConnections DbSystemSecureConnections

(Updatable) Secure connection configuration details.

shapeName String

(Updatable) The name of the shape. The shape determines the resources allocated

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

It is applicable only for stopping a DB System. Could be set to FAST, SLOW or IMMEDIATE. Default value is FAST.

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

source DbSystemSource

Parameters detailing how to provision the initial data of the system.

state String

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

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

The username for the administrative user.

availabilityDomain string

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

For a standalone DB System, this defines the availability domain in which the DB System is placed.

backupPolicy MysqlDbSystemBackupPolicy

(Updatable) Backup policy as optionally used for DB System Creation.

channels MysqlDbSystemChannel[]

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

compartmentId string

The OCID of the compartment.

configurationId string

(Updatable) The OCID of the Configuration to be used for this DB System.

crashRecovery string

(Updatable) 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 MysqlDbSystemCurrentPlacement[]

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

dataStorageSizeInGb number

databaseManagement string

(Updatable) Whether to enable monitoring via the Database Management service.

definedTags {[key: string]: any}

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

deletionPolicies MysqlDbSystemDeletionPolicy[]

(Updatable) Policy for how the DB System and related resources should be handled at the time of its deletion.

description string

(Updatable) User-provided data about the DB System.

displayName string

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

endpoints MysqlDbSystemEndpoint[]

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.

For a standalone DB System, this defines the fault domain in which the DB System is placed.

freeformTags {[key: string]: any}

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

heatWaveClusters MysqlDbSystemHeatWaveCluster[]

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.

ipAddress string

isHeatWaveClusterAttached boolean

If the DB System has a HeatWave Cluster attached.

isHighlyAvailable boolean

(Updatable) Specifies if the DB System is highly available.

lifecycleDetails string

Additional information about the current lifecycleState.

maintenance MysqlDbSystemMaintenance

(Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in. maintenance and backup_policy cannot be updated in the same request.

mysqlVersion string

The specific MySQL version identifier.

pointInTimeRecoveryDetails MysqlDbSystemPointInTimeRecoveryDetail[]

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 TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.

secureConnections MysqlDbSystemSecureConnections

(Updatable) Secure connection configuration details.

shapeName string

(Updatable) The name of the shape. The shape determines the resources allocated

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

It is applicable only for stopping a DB System. Could be set to FAST, SLOW or IMMEDIATE. Default value is FAST.

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

source MysqlDbSystemSource

Parameters detailing how to provision the initial data of the system.

state string

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

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

The username for the administrative user.

availability_domain str

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

For a standalone DB System, this defines the availability domain in which the DB System is placed.

backup_policy mysql.MysqlDbSystemBackupPolicyArgs

(Updatable) Backup policy as optionally used for DB System Creation.

channels Sequence[mysql.MysqlDbSystemChannelArgs]

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

compartment_id str

The OCID of the compartment.

configuration_id str

(Updatable) The OCID of the Configuration to be used for this DB System.

crash_recovery str

(Updatable) 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.MysqlDbSystemCurrentPlacementArgs]

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

data_storage_size_in_gb int

database_management str

(Updatable) Whether to enable monitoring via the Database Management service.

defined_tags Mapping[str, Any]

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

deletion_policies Sequence[mysql.MysqlDbSystemDeletionPolicyArgs]

(Updatable) Policy for how the DB System and related resources should be handled at the time of its deletion.

description str

(Updatable) User-provided data about the DB System.

display_name str

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

endpoints Sequence[mysql.MysqlDbSystemEndpointArgs]

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.

For a standalone DB System, this defines the fault domain in which the DB System is placed.

freeform_tags Mapping[str, Any]

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

heat_wave_clusters Sequence[mysql.MysqlDbSystemHeatWaveClusterArgs]

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.

ip_address str

is_heat_wave_cluster_attached bool

If the DB System has a HeatWave Cluster attached.

is_highly_available bool

(Updatable) Specifies if the DB System is highly available.

lifecycle_details str

Additional information about the current lifecycleState.

maintenance mysql.MysqlDbSystemMaintenanceArgs

(Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in. maintenance and backup_policy cannot be updated in the same request.

mysql_version str

The specific MySQL version identifier.

point_in_time_recovery_details Sequence[mysql.MysqlDbSystemPointInTimeRecoveryDetailArgs]

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 TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.

secure_connections mysql.MysqlDbSystemSecureConnectionsArgs

(Updatable) Secure connection configuration details.

shape_name str

(Updatable) The name of the shape. The shape determines the resources allocated

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

It is applicable only for stopping a DB System. Could be set to FAST, SLOW or IMMEDIATE. Default value is FAST.

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

source mysql.MysqlDbSystemSourceArgs

Parameters detailing how to provision the initial data of the system.

state str

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

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

The username for the administrative user.

availabilityDomain String

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

For a standalone DB System, this defines the availability domain in which the DB System is placed.

backupPolicy Property Map

(Updatable) Backup policy as optionally used for DB System Creation.

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.

configurationId String

(Updatable) The OCID of the Configuration to be used for this DB System.

crashRecovery String

(Updatable) 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

databaseManagement String

(Updatable) Whether to enable monitoring via the Database Management service.

definedTags Map<Any>

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

deletionPolicies List<Property Map>

(Updatable) Policy for how the DB System and related resources should be handled at the time of its deletion.

description String

(Updatable) User-provided data about the DB System.

displayName String

(Updatable) 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.

For a standalone DB System, this defines the fault domain in which the DB System is placed.

freeformTags Map<Any>

(Updatable) Simple key-value pair 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.

ipAddress String

isHeatWaveClusterAttached Boolean

If the DB System has a HeatWave Cluster attached.

isHighlyAvailable Boolean

(Updatable) Specifies if the DB System is highly available.

lifecycleDetails String

Additional information about the current lifecycleState.

maintenance Property Map

(Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in. maintenance and backup_policy cannot be updated in the same request.

mysqlVersion String

The specific MySQL version identifier.

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 TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.

secureConnections Property Map

(Updatable) Secure connection configuration details.

shapeName String

(Updatable) The name of the shape. The shape determines the resources allocated

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

It is applicable only for stopping a DB System. Could be set to FAST, SLOW or IMMEDIATE. Default value is FAST.

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

source Property Map

Parameters detailing how to provision the initial data of the system.

state String

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

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

MysqlDbSystemBackupPolicy, MysqlDbSystemBackupPolicyArgs

DefinedTags Dictionary<string, object>

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

FreeformTags Dictionary<string, object>

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

IsEnabled bool

(Updatable) Specifies if PITR is enabled or disabled.

PitrPolicy MysqlDbSystemBackupPolicyPitrPolicy

(Updatable) The PITR policy for the DB System.

RetentionInDays int

(Updatable) Number of days to retain an automatic backup.

WindowStartTime string

(Updatable) The start of the 2 hour maintenance window.

This string is of the format: "{day-of-week} {time-of-day}".

"{day-of-week}" is a case-insensitive string like "mon", "tue", &c.

"{time-of-day}" is the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

If you set the read replica maintenance window to "" or if not specified, the read replica is set same as the DB system maintenance window.

DefinedTags map[string]interface{}

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

FreeformTags map[string]interface{}

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

IsEnabled bool

(Updatable) Specifies if PITR is enabled or disabled.

PitrPolicy MysqlDbSystemBackupPolicyPitrPolicy

(Updatable) The PITR policy for the DB System.

RetentionInDays int

(Updatable) Number of days to retain an automatic backup.

WindowStartTime string

(Updatable) The start of the 2 hour maintenance window.

This string is of the format: "{day-of-week} {time-of-day}".

"{day-of-week}" is a case-insensitive string like "mon", "tue", &c.

"{time-of-day}" is the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

If you set the read replica maintenance window to "" or if not specified, the read replica is set same as the DB system maintenance window.

definedTags Map<String,Object>

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

freeformTags Map<String,Object>

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

isEnabled Boolean

(Updatable) Specifies if PITR is enabled or disabled.

pitrPolicy DbSystemBackupPolicyPitrPolicy

(Updatable) The PITR policy for the DB System.

retentionInDays Integer

(Updatable) Number of days to retain an automatic backup.

windowStartTime String

(Updatable) The start of the 2 hour maintenance window.

This string is of the format: "{day-of-week} {time-of-day}".

"{day-of-week}" is a case-insensitive string like "mon", "tue", &c.

"{time-of-day}" is the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

If you set the read replica maintenance window to "" or if not specified, the read replica is set same as the DB system maintenance window.

definedTags {[key: string]: any}

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

freeformTags {[key: string]: any}

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

isEnabled boolean

(Updatable) Specifies if PITR is enabled or disabled.

pitrPolicy MysqlDbSystemBackupPolicyPitrPolicy

(Updatable) The PITR policy for the DB System.

retentionInDays number

(Updatable) Number of days to retain an automatic backup.

windowStartTime string

(Updatable) The start of the 2 hour maintenance window.

This string is of the format: "{day-of-week} {time-of-day}".

"{day-of-week}" is a case-insensitive string like "mon", "tue", &c.

"{time-of-day}" is the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

If you set the read replica maintenance window to "" or if not specified, the read replica is set same as the DB system maintenance window.

defined_tags Mapping[str, Any]

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

freeform_tags Mapping[str, Any]

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

is_enabled bool

(Updatable) Specifies if PITR is enabled or disabled.

pitr_policy mysql.MysqlDbSystemBackupPolicyPitrPolicy

(Updatable) The PITR policy for the DB System.

retention_in_days int

(Updatable) Number of days to retain an automatic backup.

window_start_time str

(Updatable) The start of the 2 hour maintenance window.

This string is of the format: "{day-of-week} {time-of-day}".

"{day-of-week}" is a case-insensitive string like "mon", "tue", &c.

"{time-of-day}" is the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

If you set the read replica maintenance window to "" or if not specified, the read replica is set same as the DB system maintenance window.

definedTags Map<Any>

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}

freeformTags Map<Any>

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

isEnabled Boolean

(Updatable) Specifies if PITR is enabled or disabled.

pitrPolicy Property Map

(Updatable) The PITR policy for the DB System.

retentionInDays Number

(Updatable) Number of days to retain an automatic backup.

windowStartTime String

(Updatable) The start of the 2 hour maintenance window.

This string is of the format: "{day-of-week} {time-of-day}".

"{day-of-week}" is a case-insensitive string like "mon", "tue", &c.

"{time-of-day}" is the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

If you set the read replica maintenance window to "" or if not specified, the read replica is set same as the DB system maintenance window.

MysqlDbSystemBackupPolicyPitrPolicy, MysqlDbSystemBackupPolicyPitrPolicyArgs

IsEnabled bool: (Updatable) Specifies if PITR is enabled or disabled.

IsEnabled bool: (Updatable) Specifies if PITR is enabled or disabled.

isEnabled Boolean: (Updatable) Specifies if PITR is enabled or disabled.

isEnabled boolean: (Updatable) Specifies if PITR is enabled or disabled.

is_enabled bool: (Updatable) Specifies if PITR is enabled or disabled.

isEnabled Boolean: (Updatable) Specifies if PITR is enabled or disabled.

MysqlDbSystemChannel, MysqlDbSystemChannelArgs

CompartmentId string: The OCID of the compartment.
DefinedTags Dictionary<string, object>: (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}
DisplayName string: (Updatable) The user-friendly name for the DB System. It does not have to be unique.
FreeformTags Dictionary<string, object>: (Updatable) Simple key-value pair 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: (Updatable) Specifies if PITR is enabled or disabled.
LifecycleDetails string: Additional information about the current lifecycleState.
Sources List<MysqlDbSystemChannelSource>: Parameters detailing how to provision the initial data of the system.
State string: (Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.
Targets List<MysqlDbSystemChannelTarget>: 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.
DefinedTags map[string]interface{}: (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}
DisplayName string: (Updatable) The user-friendly name for the DB System. It does not have to be unique.
FreeformTags map[string]interface{}: (Updatable) Simple key-value pair 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: (Updatable) Specifies if PITR is enabled or disabled.
LifecycleDetails string: Additional information about the current lifecycleState.
Sources []MysqlDbSystemChannelSource: Parameters detailing how to provision the initial data of the system.
State string: (Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.
Targets []MysqlDbSystemChannelTarget: 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.
definedTags Map<String,Object>: (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}
displayName String: (Updatable) The user-friendly name for the DB System. It does not have to be unique.
freeformTags Map<String,Object>: (Updatable) Simple key-value pair 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: (Updatable) Specifies if PITR is enabled or disabled.
lifecycleDetails String: Additional information about the current lifecycleState.
sources List<DbSystemChannelSource>: Parameters detailing how to provision the initial data of the system.
state String: (Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.
targets List<DbSystemChannelTarget>: 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.
definedTags {[key: string]: any}: (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}
displayName string: (Updatable) The user-friendly name for the DB System. It does not have to be unique.
freeformTags {[key: string]: any}: (Updatable) Simple key-value pair 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: (Updatable) Specifies if PITR is enabled or disabled.
lifecycleDetails string: Additional information about the current lifecycleState.
sources MysqlDbSystemChannelSource[]: Parameters detailing how to provision the initial data of the system.
state string: (Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.
targets MysqlDbSystemChannelTarget[]: 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.
defined_tags Mapping[str, Any]: (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}
display_name str: (Updatable) The user-friendly name for the DB System. It does not have to be unique.
freeform_tags Mapping[str, Any]: (Updatable) Simple key-value pair 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: (Updatable) Specifies if PITR is enabled or disabled.
lifecycle_details str: Additional information about the current lifecycleState.
sources Sequence[mysql.MysqlDbSystemChannelSource]: Parameters detailing how to provision the initial data of the system.
state str: (Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.
targets Sequence[mysql.MysqlDbSystemChannelTarget]: 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.
definedTags Map<Any>: (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example: {"foo-namespace.bar-key": "value"}
displayName String: (Updatable) The user-friendly name for the DB System. It does not have to be unique.
freeformTags Map<Any>: (Updatable) Simple key-value pair 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: (Updatable) Specifies if PITR is enabled or disabled.
lifecycleDetails String: Additional information about the current lifecycleState.
sources List<Property Map>: Parameters detailing how to provision the initial data of the system.
state String: (Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.
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.

MysqlDbSystemChannelSource, MysqlDbSystemChannelSourceArgs

AnonymousTransactionsHandlings List<MysqlDbSystemChannelSourceAnonymousTransactionsHandling>: 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. Use BACKUP for creating a new database by restoring from a backup. Use IMPORTURL for creating a new database from a URL Object Storage PAR.
SslCaCertificates List<MysqlDbSystemChannelSourceSslCaCertificate>: 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 []MysqlDbSystemChannelSourceAnonymousTransactionsHandling: 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. Use BACKUP for creating a new database by restoring from a backup. Use IMPORTURL for creating a new database from a URL Object Storage PAR.
SslCaCertificates []MysqlDbSystemChannelSourceSslCaCertificate: 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<DbSystemChannelSourceAnonymousTransactionsHandling>: 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. Use BACKUP for creating a new database by restoring from a backup. Use IMPORTURL for creating a new database from a URL Object Storage PAR.
sslCaCertificates List<DbSystemChannelSourceSslCaCertificate>: 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 MysqlDbSystemChannelSourceAnonymousTransactionsHandling[]: 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. Use BACKUP for creating a new database by restoring from a backup. Use IMPORTURL for creating a new database from a URL Object Storage PAR.
sslCaCertificates MysqlDbSystemChannelSourceSslCaCertificate[]: 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.MysqlDbSystemChannelSourceAnonymousTransactionsHandling]: 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. Use BACKUP for creating a new database by restoring from a backup. Use IMPORTURL for creating a new database from a URL Object Storage PAR.
ssl_ca_certificates Sequence[mysql.MysqlDbSystemChannelSourceSslCaCertificate]: 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. Use BACKUP for creating a new database by restoring from a backup. Use IMPORTURL for creating a new database from a URL Object Storage PAR.
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

MysqlDbSystemChannelSourceAnonymousTransactionsHandling, MysqlDbSystemChannelSourceAnonymousTransactionsHandlingArgs

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.

MysqlDbSystemChannelSourceSslCaCertificate, MysqlDbSystemChannelSourceSslCaCertificateArgs

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.

MysqlDbSystemChannelTarget, MysqlDbSystemChannelTargetArgs

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 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.
DelayInSeconds int: Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
Filters List<MysqlDbSystemChannelTargetFilter>: 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 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.
DelayInSeconds int: Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
Filters []MysqlDbSystemChannelTargetFilter: 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 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.
delayInSeconds Integer: Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
filters List<DbSystemChannelTargetFilter>: 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 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.
delayInSeconds number: Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
filters MysqlDbSystemChannelTargetFilter[]: 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 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.
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.MysqlDbSystemChannelTargetFilter]: 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 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.
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.

MysqlDbSystemChannelTargetFilter, MysqlDbSystemChannelTargetFilterArgs

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.

MysqlDbSystemCurrentPlacement, MysqlDbSystemCurrentPlacementArgs

AvailabilityDomain string

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

For a standalone DB System, this defines 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.

For a standalone DB System, this defines the fault domain in which the DB System is placed.

AvailabilityDomain string

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

For a standalone DB System, this defines 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.

For a standalone DB System, this defines the fault domain in which the DB System is placed.

availabilityDomain String

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

For a standalone DB System, this defines 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.

For a standalone DB System, this defines the fault domain in which the DB System is placed.

availabilityDomain string

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

For a standalone DB System, this defines 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.

For a standalone DB System, this defines the fault domain in which the DB System is placed.

availability_domain str

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

For a standalone DB System, this defines 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.

For a standalone DB System, this defines the fault domain in which the DB System is placed.

availabilityDomain String

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

For a standalone DB System, this defines 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.

For a standalone DB System, this defines the fault domain in which the DB System is placed.

MysqlDbSystemDeletionPolicy, MysqlDbSystemDeletionPolicyArgs

AutomaticBackupRetention string: (Updatable) Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
FinalBackup string: (Updatable) 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: (Updatable) Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.

AutomaticBackupRetention string: (Updatable) Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
FinalBackup string: (Updatable) 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: (Updatable) Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.

automaticBackupRetention String: (Updatable) Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
finalBackup String: (Updatable) 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: (Updatable) Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.

automaticBackupRetention string: (Updatable) Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
finalBackup string: (Updatable) 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: (Updatable) Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.

automatic_backup_retention str: (Updatable) Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
final_backup str: (Updatable) 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: (Updatable) Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.

automaticBackupRetention String: (Updatable) Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
finalBackup String: (Updatable) 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: (Updatable) Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.

MysqlDbSystemEndpoint, MysqlDbSystemEndpointArgs

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 your choice to assign to the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. This should be a "dotted-quad" style IPv4 address.
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 TCP network port on which X Plugin listens for 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 your choice to assign to the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. This should be a "dotted-quad" style IPv4 address.
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 TCP network port on which X Plugin listens for 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 your choice to assign to the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. This should be a "dotted-quad" style IPv4 address.
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 TCP network port on which X Plugin listens for 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 your choice to assign to the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. This should be a "dotted-quad" style IPv4 address.
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 TCP network port on which X Plugin listens for 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 your choice to assign to the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. This should be a "dotted-quad" style IPv4 address.
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 TCP network port on which X Plugin listens for 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 your choice to assign to the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. This should be a "dotted-quad" style IPv4 address.
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 TCP network port on which X Plugin listens for 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.

MysqlDbSystemHeatWaveCluster, MysqlDbSystemHeatWaveClusterArgs

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

(Updatable) The name of the shape. The shape determines the resources allocated

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

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

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

(Updatable) The name of the shape. The shape determines the resources allocated

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

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

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

(Updatable) The name of the shape. The shape determines the resources allocated

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

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

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

(Updatable) The name of the shape. The shape determines the resources allocated

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

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

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

(Updatable) The name of the shape. The shape determines the resources allocated

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

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

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

(Updatable) The name of the shape. The shape determines the resources allocated

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

(Updatable) The target state for the DB System. Could be set to ACTIVE or INACTIVE.

timeCreated String

The date and time the DB System was created.

timeUpdated String

The time the DB System was last updated.

MysqlDbSystemMaintenance, MysqlDbSystemMaintenanceArgs

WindowStartTime string

(Updatable) The start of the 2 hour maintenance window.

This string is of the format: "{day-of-week} {time-of-day}".

"{day-of-week}" is a case-insensitive string like "mon", "tue", &c.

"{time-of-day}" is the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

If you set the read replica maintenance window to "" or if not specified, the read replica is set same as the DB system maintenance window.

WindowStartTime string

(Updatable) The start of the 2 hour maintenance window.

This string is of the format: "{day-of-week} {time-of-day}".

"{day-of-week}" is a case-insensitive string like "mon", "tue", &c.

"{time-of-day}" is the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

If you set the read replica maintenance window to "" or if not specified, the read replica is set same as the DB system maintenance window.

windowStartTime String

(Updatable) The start of the 2 hour maintenance window.

This string is of the format: "{day-of-week} {time-of-day}".

"{day-of-week}" is a case-insensitive string like "mon", "tue", &c.

"{time-of-day}" is the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

If you set the read replica maintenance window to "" or if not specified, the read replica is set same as the DB system maintenance window.

windowStartTime string

(Updatable) The start of the 2 hour maintenance window.

This string is of the format: "{day-of-week} {time-of-day}".

"{day-of-week}" is a case-insensitive string like "mon", "tue", &c.

"{time-of-day}" is the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

If you set the read replica maintenance window to "" or if not specified, the read replica is set same as the DB system maintenance window.

window_start_time str

(Updatable) The start of the 2 hour maintenance window.

This string is of the format: "{day-of-week} {time-of-day}".

"{day-of-week}" is a case-insensitive string like "mon", "tue", &c.

"{time-of-day}" is the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

If you set the read replica maintenance window to "" or if not specified, the read replica is set same as the DB system maintenance window.

windowStartTime String

(Updatable) The start of the 2 hour maintenance window.

This string is of the format: "{day-of-week} {time-of-day}".

"{day-of-week}" is a case-insensitive string like "mon", "tue", &c.

"{time-of-day}" is the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

If you set the read replica maintenance window to "" or if not specified, the read replica is set same as the DB system maintenance window.

MysqlDbSystemPointInTimeRecoveryDetail, MysqlDbSystemPointInTimeRecoveryDetailArgs

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.

MysqlDbSystemSecureConnections, MysqlDbSystemSecureConnectionsArgs

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

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

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

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

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

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

MysqlDbSystemSource, MysqlDbSystemSourceArgs

SourceType string: The specific source identifier. Use BACKUP for creating a new database by restoring from a backup. Use IMPORTURL for creating a new database from a URL Object Storage PAR.
BackupId string: The OCID of the backup to be used as the source for the new DB System.
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.
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.
SourceUrl string: The Pre-Authenticated Request (PAR) of a bucket/prefix or PAR of a @.manifest.json object from the Object Storage. Check Using Pre-Authenticated Requests for information related to PAR creation. Please create PAR with "Permit object reads" access type and "Enable Object Listing" permission when using a bucket/prefix PAR. Please create PAR with "Permit object reads" access type when using a @.manifest.json object PAR.

SourceType string: The specific source identifier. Use BACKUP for creating a new database by restoring from a backup. Use IMPORTURL for creating a new database from a URL Object Storage PAR.
BackupId string: The OCID of the backup to be used as the source for the new DB System.
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.
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.
SourceUrl string: The Pre-Authenticated Request (PAR) of a bucket/prefix or PAR of a @.manifest.json object from the Object Storage. Check Using Pre-Authenticated Requests for information related to PAR creation. Please create PAR with "Permit object reads" access type and "Enable Object Listing" permission when using a bucket/prefix PAR. Please create PAR with "Permit object reads" access type when using a @.manifest.json object PAR.

sourceType String: The specific source identifier. Use BACKUP for creating a new database by restoring from a backup. Use IMPORTURL for creating a new database from a URL Object Storage PAR.
backupId String: The OCID of the backup to be used as the source for the new DB System.
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.
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.
sourceUrl String: The Pre-Authenticated Request (PAR) of a bucket/prefix or PAR of a @.manifest.json object from the Object Storage. Check Using Pre-Authenticated Requests for information related to PAR creation. Please create PAR with "Permit object reads" access type and "Enable Object Listing" permission when using a bucket/prefix PAR. Please create PAR with "Permit object reads" access type when using a @.manifest.json object PAR.

sourceType string: The specific source identifier. Use BACKUP for creating a new database by restoring from a backup. Use IMPORTURL for creating a new database from a URL Object Storage PAR.
backupId string: The OCID of the backup to be used as the source for the new DB System.
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.
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.
sourceUrl string: The Pre-Authenticated Request (PAR) of a bucket/prefix or PAR of a @.manifest.json object from the Object Storage. Check Using Pre-Authenticated Requests for information related to PAR creation. Please create PAR with "Permit object reads" access type and "Enable Object Listing" permission when using a bucket/prefix PAR. Please create PAR with "Permit object reads" access type when using a @.manifest.json object PAR.

source_type str: The specific source identifier. Use BACKUP for creating a new database by restoring from a backup. Use IMPORTURL for creating a new database from a URL Object Storage PAR.
backup_id str: The OCID of the backup to be used as the source for the new DB System.
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.
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_url str: The Pre-Authenticated Request (PAR) of a bucket/prefix or PAR of a @.manifest.json object from the Object Storage. Check Using Pre-Authenticated Requests for information related to PAR creation. Please create PAR with "Permit object reads" access type and "Enable Object Listing" permission when using a bucket/prefix PAR. Please create PAR with "Permit object reads" access type when using a @.manifest.json object PAR.

sourceType String: The specific source identifier. Use BACKUP for creating a new database by restoring from a backup. Use IMPORTURL for creating a new database from a URL Object Storage PAR.
backupId String: The OCID of the backup to be used as the source for the new DB System.
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.
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.
sourceUrl String: The Pre-Authenticated Request (PAR) of a bucket/prefix or PAR of a @.manifest.json object from the Object Storage. Check Using Pre-Authenticated Requests for information related to PAR creation. Please create PAR with "Permit object reads" access type and "Enable Object Listing" permission when using a bucket/prefix PAR. Please create PAR with "Permit object reads" access type when using a @.manifest.json object PAR.

Import

MysqlDbSystems can be imported using the id, e.g.

$ pulumi import oci:Mysql/mysqlDbSystem:MysqlDbSystem test_mysql_db_system "id"

To learn more about importing existing cloud resources, see Importing resources.

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

On this page

On this page

Example Usage

Create MysqlDbSystem Resource

Constructor syntax

Parameters

Example

MysqlDbSystem Resource Properties

Inputs

Outputs

Look up Existing MysqlDbSystem Resource

Supporting Types

MysqlDbSystemBackupPolicy, MysqlDbSystemBackupPolicyArgs

MysqlDbSystemBackupPolicyPitrPolicy, MysqlDbSystemBackupPolicyPitrPolicyArgs

MysqlDbSystemChannel, MysqlDbSystemChannelArgs

MysqlDbSystemChannelSource, MysqlDbSystemChannelSourceArgs

MysqlDbSystemChannelSourceAnonymousTransactionsHandling, MysqlDbSystemChannelSourceAnonymousTransactionsHandlingArgs

MysqlDbSystemChannelSourceSslCaCertificate, MysqlDbSystemChannelSourceSslCaCertificateArgs

MysqlDbSystemChannelTarget, MysqlDbSystemChannelTargetArgs

MysqlDbSystemChannelTargetFilter, MysqlDbSystemChannelTargetFilterArgs

MysqlDbSystemCurrentPlacement, MysqlDbSystemCurrentPlacementArgs

MysqlDbSystemDeletionPolicy, MysqlDbSystemDeletionPolicyArgs

MysqlDbSystemEndpoint, MysqlDbSystemEndpointArgs

MysqlDbSystemHeatWaveCluster, MysqlDbSystemHeatWaveClusterArgs

MysqlDbSystemMaintenance, MysqlDbSystemMaintenanceArgs

MysqlDbSystemPointInTimeRecoveryDetail, MysqlDbSystemPointInTimeRecoveryDetailArgs

MysqlDbSystemSecureConnections, MysqlDbSystemSecureConnectionsArgs

MysqlDbSystemSource, MysqlDbSystemSourceArgs

Import

Package Details

On this page

On this page