Oracle Cloud Infrastructure v3.9.0, Sep 24 25

Oracle Cloud Infrastructure v3.9.0 published on Wednesday, Sep 24, 2025 by Pulumi

oci.Mysql.MysqlDbSystem

Oracle Cloud Infrastructure v3.9.0 published on Wednesday, Sep 24, 2025 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,
    accessMode: mysqlDbSystemAccessMode,
    adminPassword: mysqlDbSystemAdminPassword,
    adminUsername: mysqlDbSystemAdminUsername,
    backupPolicy: {
        copyPolicies: [{
            copyToRegion: mysqlDbSystemBackupPolicyCopyPoliciesCopyToRegion,
            backupCopyRetentionInDays: mysqlDbSystemBackupPolicyCopyPoliciesBackupCopyRetentionInDays,
        }],
        definedTags: {
            "foo-namespace.bar-key": "value",
        },
        freeformTags: {
            "bar-key": "value",
        },
        isEnabled: mysqlDbSystemBackupPolicyIsEnabled,
        pitrPolicy: {
            isEnabled: mysqlDbSystemBackupPolicyPitrPolicyIsEnabled,
        },
        retentionInDays: mysqlDbSystemBackupPolicyRetentionInDays,
        softDelete: mysqlDbSystemBackupPolicySoftDelete,
        windowStartTime: mysqlDbSystemBackupPolicyWindowStartTime,
    },
    configurationId: testConfiguration.id,
    crashRecovery: mysqlDbSystemCrashRecovery,
    customerContacts: [{
        email: mysqlDbSystemCustomerContactsEmail,
    }],
    dataStorage: {
        isAutoExpandStorageEnabled: mysqlDbSystemDataStorageIsAutoExpandStorageEnabled,
        maxStorageSizeInGbs: mysqlDbSystemDataStorageMaxStorageSizeInGbs,
    },
    dataStorageSizeInGb: mysqlDbSystemDataStorageSizeInGb,
    databaseManagement: mysqlDbSystemDatabaseManagement,
    databaseMode: mysqlDbSystemDatabaseMode,
    definedTags: {
        "foo-namespace.bar-key": "value",
    },
    deletionPolicies: [{
        automaticBackupRetention: mysqlDbSystemDeletionPolicyAutomaticBackupRetention,
        finalBackup: mysqlDbSystemDeletionPolicyFinalBackup,
        isDeleteProtected: mysqlDbSystemDeletionPolicyIsDeleteProtected,
    }],
    description: mysqlDbSystemDescription,
    displayName: mysqlDbSystemDisplayName,
    encryptData: {
        keyGenerationType: mysqlDbSystemEncryptDataKeyGenerationType,
        keyId: testKey.id,
    },
    faultDomain: mysqlDbSystemFaultDomain,
    freeformTags: {
        "bar-key": "value",
    },
    hostnameLabel: mysqlDbSystemHostnameLabel,
    ipAddress: mysqlDbSystemIpAddress,
    isHighlyAvailable: mysqlDbSystemIsHighlyAvailable,
    maintenance: {
        windowStartTime: mysqlDbSystemMaintenanceWindowStartTime,
    },
    nsgIds: mysqlDbSystemNsgIds,
    port: mysqlDbSystemPort,
    portX: mysqlDbSystemPortX,
    readEndpoint: {
        excludeIps: mysqlDbSystemReadEndpointExcludeIps,
        isEnabled: mysqlDbSystemReadEndpointIsEnabled,
        readEndpointHostnameLabel: mysqlDbSystemReadEndpointReadEndpointHostnameLabel,
        readEndpointIpAddress: mysqlDbSystemReadEndpointReadEndpointIpAddress,
    },
    rest: {
        configuration: mysqlDbSystemRestConfiguration,
        port: mysqlDbSystemRestPort,
    },
    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"],
    access_mode=mysql_db_system_access_mode,
    admin_password=mysql_db_system_admin_password,
    admin_username=mysql_db_system_admin_username,
    backup_policy={
        "copy_policies": [{
            "copy_to_region": mysql_db_system_backup_policy_copy_policies_copy_to_region,
            "backup_copy_retention_in_days": mysql_db_system_backup_policy_copy_policies_backup_copy_retention_in_days,
        }],
        "defined_tags": {
            "foo-namespace.bar-key": "value",
        },
        "freeform_tags": {
            "bar-key": "value",
        },
        "is_enabled": mysql_db_system_backup_policy_is_enabled,
        "pitr_policy": {
            "is_enabled": mysql_db_system_backup_policy_pitr_policy_is_enabled,
        },
        "retention_in_days": mysql_db_system_backup_policy_retention_in_days,
        "soft_delete": mysql_db_system_backup_policy_soft_delete,
        "window_start_time": mysql_db_system_backup_policy_window_start_time,
    },
    configuration_id=test_configuration["id"],
    crash_recovery=mysql_db_system_crash_recovery,
    customer_contacts=[{
        "email": mysql_db_system_customer_contacts_email,
    }],
    data_storage={
        "is_auto_expand_storage_enabled": mysql_db_system_data_storage_is_auto_expand_storage_enabled,
        "max_storage_size_in_gbs": mysql_db_system_data_storage_max_storage_size_in_gbs,
    },
    data_storage_size_in_gb=mysql_db_system_data_storage_size_in_gb,
    database_management=mysql_db_system_database_management,
    database_mode=mysql_db_system_database_mode,
    defined_tags={
        "foo-namespace.bar-key": "value",
    },
    deletion_policies=[{
        "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,
    encrypt_data={
        "key_generation_type": mysql_db_system_encrypt_data_key_generation_type,
        "key_id": test_key["id"],
    },
    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={
        "window_start_time": mysql_db_system_maintenance_window_start_time,
    },
    nsg_ids=mysql_db_system_nsg_ids,
    port=mysql_db_system_port,
    port_x=mysql_db_system_port_x,
    read_endpoint={
        "exclude_ips": mysql_db_system_read_endpoint_exclude_ips,
        "is_enabled": mysql_db_system_read_endpoint_is_enabled,
        "read_endpoint_hostname_label": mysql_db_system_read_endpoint_read_endpoint_hostname_label,
        "read_endpoint_ip_address": mysql_db_system_read_endpoint_read_endpoint_ip_address,
    },
    rest={
        "configuration": mysql_db_system_rest_configuration,
        "port": mysql_db_system_rest_port,
    },
    secure_connections={
        "certificate_generation_type": mysql_db_system_secure_connections_certificate_generation_type,
        "certificate_id": test_certificate["id"],
    },
    source={
        "source_type": mysql_db_system_source_source_type,
        "backup_id": test_backup["id"],
    })

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v3/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),
			AccessMode:         pulumi.Any(mysqlDbSystemAccessMode),
			AdminPassword:      pulumi.Any(mysqlDbSystemAdminPassword),
			AdminUsername:      pulumi.Any(mysqlDbSystemAdminUsername),
			BackupPolicy: &mysql.MysqlDbSystemBackupPolicyArgs{
				CopyPolicies: mysql.MysqlDbSystemBackupPolicyCopyPolicyArray{
					&mysql.MysqlDbSystemBackupPolicyCopyPolicyArgs{
						CopyToRegion:              pulumi.Any(mysqlDbSystemBackupPolicyCopyPoliciesCopyToRegion),
						BackupCopyRetentionInDays: pulumi.Any(mysqlDbSystemBackupPolicyCopyPoliciesBackupCopyRetentionInDays),
					},
				},
				DefinedTags: pulumi.StringMap{
					"foo-namespace.bar-key": pulumi.String("value"),
				},
				FreeformTags: pulumi.StringMap{
					"bar-key": pulumi.String("value"),
				},
				IsEnabled: pulumi.Any(mysqlDbSystemBackupPolicyIsEnabled),
				PitrPolicy: &mysql.MysqlDbSystemBackupPolicyPitrPolicyArgs{
					IsEnabled: pulumi.Any(mysqlDbSystemBackupPolicyPitrPolicyIsEnabled),
				},
				RetentionInDays: pulumi.Any(mysqlDbSystemBackupPolicyRetentionInDays),
				SoftDelete:      pulumi.Any(mysqlDbSystemBackupPolicySoftDelete),
				WindowStartTime: pulumi.Any(mysqlDbSystemBackupPolicyWindowStartTime),
			},
			ConfigurationId: pulumi.Any(testConfiguration.Id),
			CrashRecovery:   pulumi.Any(mysqlDbSystemCrashRecovery),
			CustomerContacts: mysql.MysqlDbSystemCustomerContactArray{
				&mysql.MysqlDbSystemCustomerContactArgs{
					Email: pulumi.Any(mysqlDbSystemCustomerContactsEmail),
				},
			},
			DataStorage: &mysql.MysqlDbSystemDataStorageArgs{
				IsAutoExpandStorageEnabled: pulumi.Any(mysqlDbSystemDataStorageIsAutoExpandStorageEnabled),
				MaxStorageSizeInGbs:        pulumi.Any(mysqlDbSystemDataStorageMaxStorageSizeInGbs),
			},
			DataStorageSizeInGb: pulumi.Any(mysqlDbSystemDataStorageSizeInGb),
			DatabaseManagement:  pulumi.Any(mysqlDbSystemDatabaseManagement),
			DatabaseMode:        pulumi.Any(mysqlDbSystemDatabaseMode),
			DefinedTags: pulumi.StringMap{
				"foo-namespace.bar-key": pulumi.String("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),
			EncryptData: &mysql.MysqlDbSystemEncryptDataArgs{
				KeyGenerationType: pulumi.Any(mysqlDbSystemEncryptDataKeyGenerationType),
				KeyId:             pulumi.Any(testKey.Id),
			},
			FaultDomain: pulumi.Any(mysqlDbSystemFaultDomain),
			FreeformTags: pulumi.StringMap{
				"bar-key": pulumi.String("value"),
			},
			HostnameLabel:     pulumi.Any(mysqlDbSystemHostnameLabel),
			IpAddress:         pulumi.Any(mysqlDbSystemIpAddress),
			IsHighlyAvailable: pulumi.Any(mysqlDbSystemIsHighlyAvailable),
			Maintenance: &mysql.MysqlDbSystemMaintenanceArgs{
				WindowStartTime: pulumi.Any(mysqlDbSystemMaintenanceWindowStartTime),
			},
			NsgIds: pulumi.Any(mysqlDbSystemNsgIds),
			Port:   pulumi.Any(mysqlDbSystemPort),
			PortX:  pulumi.Any(mysqlDbSystemPortX),
			ReadEndpoint: &mysql.MysqlDbSystemReadEndpointArgs{
				ExcludeIps:                pulumi.Any(mysqlDbSystemReadEndpointExcludeIps),
				IsEnabled:                 pulumi.Any(mysqlDbSystemReadEndpointIsEnabled),
				ReadEndpointHostnameLabel: pulumi.Any(mysqlDbSystemReadEndpointReadEndpointHostnameLabel),
				ReadEndpointIpAddress:     pulumi.Any(mysqlDbSystemReadEndpointReadEndpointIpAddress),
			},
			Rest: &mysql.MysqlDbSystemRestArgs{
				Configuration: pulumi.Any(mysqlDbSystemRestConfiguration),
				Port:          pulumi.Any(mysqlDbSystemRestPort),
			},
			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,
        AccessMode = mysqlDbSystemAccessMode,
        AdminPassword = mysqlDbSystemAdminPassword,
        AdminUsername = mysqlDbSystemAdminUsername,
        BackupPolicy = new Oci.Mysql.Inputs.MysqlDbSystemBackupPolicyArgs
        {
            CopyPolicies = new[]
            {
                new Oci.Mysql.Inputs.MysqlDbSystemBackupPolicyCopyPolicyArgs
                {
                    CopyToRegion = mysqlDbSystemBackupPolicyCopyPoliciesCopyToRegion,
                    BackupCopyRetentionInDays = mysqlDbSystemBackupPolicyCopyPoliciesBackupCopyRetentionInDays,
                },
            },
            DefinedTags = 
            {
                { "foo-namespace.bar-key", "value" },
            },
            FreeformTags = 
            {
                { "bar-key", "value" },
            },
            IsEnabled = mysqlDbSystemBackupPolicyIsEnabled,
            PitrPolicy = new Oci.Mysql.Inputs.MysqlDbSystemBackupPolicyPitrPolicyArgs
            {
                IsEnabled = mysqlDbSystemBackupPolicyPitrPolicyIsEnabled,
            },
            RetentionInDays = mysqlDbSystemBackupPolicyRetentionInDays,
            SoftDelete = mysqlDbSystemBackupPolicySoftDelete,
            WindowStartTime = mysqlDbSystemBackupPolicyWindowStartTime,
        },
        ConfigurationId = testConfiguration.Id,
        CrashRecovery = mysqlDbSystemCrashRecovery,
        CustomerContacts = new[]
        {
            new Oci.Mysql.Inputs.MysqlDbSystemCustomerContactArgs
            {
                Email = mysqlDbSystemCustomerContactsEmail,
            },
        },
        DataStorage = new Oci.Mysql.Inputs.MysqlDbSystemDataStorageArgs
        {
            IsAutoExpandStorageEnabled = mysqlDbSystemDataStorageIsAutoExpandStorageEnabled,
            MaxStorageSizeInGbs = mysqlDbSystemDataStorageMaxStorageSizeInGbs,
        },
        DataStorageSizeInGb = mysqlDbSystemDataStorageSizeInGb,
        DatabaseManagement = mysqlDbSystemDatabaseManagement,
        DatabaseMode = mysqlDbSystemDatabaseMode,
        DefinedTags = 
        {
            { "foo-namespace.bar-key", "value" },
        },
        DeletionPolicies = new[]
        {
            new Oci.Mysql.Inputs.MysqlDbSystemDeletionPolicyArgs
            {
                AutomaticBackupRetention = mysqlDbSystemDeletionPolicyAutomaticBackupRetention,
                FinalBackup = mysqlDbSystemDeletionPolicyFinalBackup,
                IsDeleteProtected = mysqlDbSystemDeletionPolicyIsDeleteProtected,
            },
        },
        Description = mysqlDbSystemDescription,
        DisplayName = mysqlDbSystemDisplayName,
        EncryptData = new Oci.Mysql.Inputs.MysqlDbSystemEncryptDataArgs
        {
            KeyGenerationType = mysqlDbSystemEncryptDataKeyGenerationType,
            KeyId = testKey.Id,
        },
        FaultDomain = mysqlDbSystemFaultDomain,
        FreeformTags = 
        {
            { "bar-key", "value" },
        },
        HostnameLabel = mysqlDbSystemHostnameLabel,
        IpAddress = mysqlDbSystemIpAddress,
        IsHighlyAvailable = mysqlDbSystemIsHighlyAvailable,
        Maintenance = new Oci.Mysql.Inputs.MysqlDbSystemMaintenanceArgs
        {
            WindowStartTime = mysqlDbSystemMaintenanceWindowStartTime,
        },
        NsgIds = mysqlDbSystemNsgIds,
        Port = mysqlDbSystemPort,
        PortX = mysqlDbSystemPortX,
        ReadEndpoint = new Oci.Mysql.Inputs.MysqlDbSystemReadEndpointArgs
        {
            ExcludeIps = mysqlDbSystemReadEndpointExcludeIps,
            IsEnabled = mysqlDbSystemReadEndpointIsEnabled,
            ReadEndpointHostnameLabel = mysqlDbSystemReadEndpointReadEndpointHostnameLabel,
            ReadEndpointIpAddress = mysqlDbSystemReadEndpointReadEndpointIpAddress,
        },
        Rest = new Oci.Mysql.Inputs.MysqlDbSystemRestArgs
        {
            Configuration = mysqlDbSystemRestConfiguration,
            Port = mysqlDbSystemRestPort,
        },
        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.MysqlDbSystemCustomerContactArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemDataStorageArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemDeletionPolicyArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemEncryptDataArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemMaintenanceArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemReadEndpointArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemRestArgs;
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())
            .accessMode(mysqlDbSystemAccessMode)
            .adminPassword(mysqlDbSystemAdminPassword)
            .adminUsername(mysqlDbSystemAdminUsername)
            .backupPolicy(MysqlDbSystemBackupPolicyArgs.builder()
                .copyPolicies(MysqlDbSystemBackupPolicyCopyPolicyArgs.builder()
                    .copyToRegion(mysqlDbSystemBackupPolicyCopyPoliciesCopyToRegion)
                    .backupCopyRetentionInDays(mysqlDbSystemBackupPolicyCopyPoliciesBackupCopyRetentionInDays)
                    .build())
                .definedTags(Map.of("foo-namespace.bar-key", "value"))
                .freeformTags(Map.of("bar-key", "value"))
                .isEnabled(mysqlDbSystemBackupPolicyIsEnabled)
                .pitrPolicy(MysqlDbSystemBackupPolicyPitrPolicyArgs.builder()
                    .isEnabled(mysqlDbSystemBackupPolicyPitrPolicyIsEnabled)
                    .build())
                .retentionInDays(mysqlDbSystemBackupPolicyRetentionInDays)
                .softDelete(mysqlDbSystemBackupPolicySoftDelete)
                .windowStartTime(mysqlDbSystemBackupPolicyWindowStartTime)
                .build())
            .configurationId(testConfiguration.id())
            .crashRecovery(mysqlDbSystemCrashRecovery)
            .customerContacts(MysqlDbSystemCustomerContactArgs.builder()
                .email(mysqlDbSystemCustomerContactsEmail)
                .build())
            .dataStorage(MysqlDbSystemDataStorageArgs.builder()
                .isAutoExpandStorageEnabled(mysqlDbSystemDataStorageIsAutoExpandStorageEnabled)
                .maxStorageSizeInGbs(mysqlDbSystemDataStorageMaxStorageSizeInGbs)
                .build())
            .dataStorageSizeInGb(mysqlDbSystemDataStorageSizeInGb)
            .databaseManagement(mysqlDbSystemDatabaseManagement)
            .databaseMode(mysqlDbSystemDatabaseMode)
            .definedTags(Map.of("foo-namespace.bar-key", "value"))
            .deletionPolicies(MysqlDbSystemDeletionPolicyArgs.builder()
                .automaticBackupRetention(mysqlDbSystemDeletionPolicyAutomaticBackupRetention)
                .finalBackup(mysqlDbSystemDeletionPolicyFinalBackup)
                .isDeleteProtected(mysqlDbSystemDeletionPolicyIsDeleteProtected)
                .build())
            .description(mysqlDbSystemDescription)
            .displayName(mysqlDbSystemDisplayName)
            .encryptData(MysqlDbSystemEncryptDataArgs.builder()
                .keyGenerationType(mysqlDbSystemEncryptDataKeyGenerationType)
                .keyId(testKey.id())
                .build())
            .faultDomain(mysqlDbSystemFaultDomain)
            .freeformTags(Map.of("bar-key", "value"))
            .hostnameLabel(mysqlDbSystemHostnameLabel)
            .ipAddress(mysqlDbSystemIpAddress)
            .isHighlyAvailable(mysqlDbSystemIsHighlyAvailable)
            .maintenance(MysqlDbSystemMaintenanceArgs.builder()
                .windowStartTime(mysqlDbSystemMaintenanceWindowStartTime)
                .build())
            .nsgIds(mysqlDbSystemNsgIds)
            .port(mysqlDbSystemPort)
            .portX(mysqlDbSystemPortX)
            .readEndpoint(MysqlDbSystemReadEndpointArgs.builder()
                .excludeIps(mysqlDbSystemReadEndpointExcludeIps)
                .isEnabled(mysqlDbSystemReadEndpointIsEnabled)
                .readEndpointHostnameLabel(mysqlDbSystemReadEndpointReadEndpointHostnameLabel)
                .readEndpointIpAddress(mysqlDbSystemReadEndpointReadEndpointIpAddress)
                .build())
            .rest(MysqlDbSystemRestArgs.builder()
                .configuration(mysqlDbSystemRestConfiguration)
                .port(mysqlDbSystemRestPort)
                .build())
            .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}
      accessMode: ${mysqlDbSystemAccessMode}
      adminPassword: ${mysqlDbSystemAdminPassword}
      adminUsername: ${mysqlDbSystemAdminUsername}
      backupPolicy:
        copyPolicies:
          - copyToRegion: ${mysqlDbSystemBackupPolicyCopyPoliciesCopyToRegion}
            backupCopyRetentionInDays: ${mysqlDbSystemBackupPolicyCopyPoliciesBackupCopyRetentionInDays}
        definedTags:
          foo-namespace.bar-key: value
        freeformTags:
          bar-key: value
        isEnabled: ${mysqlDbSystemBackupPolicyIsEnabled}
        pitrPolicy:
          isEnabled: ${mysqlDbSystemBackupPolicyPitrPolicyIsEnabled}
        retentionInDays: ${mysqlDbSystemBackupPolicyRetentionInDays}
        softDelete: ${mysqlDbSystemBackupPolicySoftDelete}
        windowStartTime: ${mysqlDbSystemBackupPolicyWindowStartTime}
      configurationId: ${testConfiguration.id}
      crashRecovery: ${mysqlDbSystemCrashRecovery}
      customerContacts:
        - email: ${mysqlDbSystemCustomerContactsEmail}
      dataStorage:
        isAutoExpandStorageEnabled: ${mysqlDbSystemDataStorageIsAutoExpandStorageEnabled}
        maxStorageSizeInGbs: ${mysqlDbSystemDataStorageMaxStorageSizeInGbs}
      dataStorageSizeInGb: ${mysqlDbSystemDataStorageSizeInGb}
      databaseManagement: ${mysqlDbSystemDatabaseManagement}
      databaseMode: ${mysqlDbSystemDatabaseMode}
      definedTags:
        foo-namespace.bar-key: value
      deletionPolicies:
        - automaticBackupRetention: ${mysqlDbSystemDeletionPolicyAutomaticBackupRetention}
          finalBackup: ${mysqlDbSystemDeletionPolicyFinalBackup}
          isDeleteProtected: ${mysqlDbSystemDeletionPolicyIsDeleteProtected}
      description: ${mysqlDbSystemDescription}
      displayName: ${mysqlDbSystemDisplayName}
      encryptData:
        keyGenerationType: ${mysqlDbSystemEncryptDataKeyGenerationType}
        keyId: ${testKey.id}
      faultDomain: ${mysqlDbSystemFaultDomain}
      freeformTags:
        bar-key: value
      hostnameLabel: ${mysqlDbSystemHostnameLabel}
      ipAddress: ${mysqlDbSystemIpAddress}
      isHighlyAvailable: ${mysqlDbSystemIsHighlyAvailable}
      maintenance:
        windowStartTime: ${mysqlDbSystemMaintenanceWindowStartTime}
      nsgIds: ${mysqlDbSystemNsgIds}
      port: ${mysqlDbSystemPort}
      portX: ${mysqlDbSystemPortX}
      readEndpoint:
        excludeIps: ${mysqlDbSystemReadEndpointExcludeIps}
        isEnabled: ${mysqlDbSystemReadEndpointIsEnabled}
        readEndpointHostnameLabel: ${mysqlDbSystemReadEndpointReadEndpointHostnameLabel}
        readEndpointIpAddress: ${mysqlDbSystemReadEndpointReadEndpointIpAddress}
      rest:
        configuration: ${mysqlDbSystemRestConfiguration}
        port: ${mysqlDbSystemRestPort}
      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,
                  shape_name: Optional[str] = None,
                  availability_domain: Optional[str] = None,
                  fault_domain: Optional[str] = None,
                  freeform_tags: Optional[Mapping[str, str]] = None,
                  configuration_id: Optional[str] = None,
                  crash_recovery: Optional[str] = None,
                  customer_contacts: Optional[Sequence[MysqlDbSystemCustomerContactArgs]] = None,
                  data_storage: Optional[MysqlDbSystemDataStorageArgs] = None,
                  data_storage_size_in_gb: Optional[int] = None,
                  database_management: Optional[str] = None,
                  database_mode: Optional[str] = None,
                  defined_tags: Optional[Mapping[str, str]] = None,
                  deletion_policies: Optional[Sequence[MysqlDbSystemDeletionPolicyArgs]] = None,
                  description: Optional[str] = None,
                  display_name: Optional[str] = None,
                  encrypt_data: Optional[MysqlDbSystemEncryptDataArgs] = None,
                  access_mode: Optional[str] = None,
                  backup_policy: Optional[MysqlDbSystemBackupPolicyArgs] = None,
                  hostname_label: Optional[str] = None,
                  ip_address: Optional[str] = None,
                  is_highly_available: Optional[bool] = None,
                  maintenance: Optional[MysqlDbSystemMaintenanceArgs] = None,
                  mysql_version: Optional[str] = None,
                  nsg_ids: Optional[Sequence[str]] = None,
                  port: Optional[int] = None,
                  port_x: Optional[int] = None,
                  read_endpoint: Optional[MysqlDbSystemReadEndpointArgs] = None,
                  rest: Optional[MysqlDbSystemRestArgs] = None,
                  secure_connections: Optional[MysqlDbSystemSecureConnectionsArgs] = None,
                  admin_username: Optional[str] = None,
                  shutdown_type: Optional[str] = None,
                  source: Optional[MysqlDbSystemSourceArgs] = None,
                  state: Optional[str] = None,
                  admin_password: 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.

Constructor example

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

var mysqlDbSystemResource = new Oci.Mysql.MysqlDbSystem("mysqlDbSystemResource", new()
{
    CompartmentId = "string",
    SubnetId = "string",
    ShapeName = "string",
    AvailabilityDomain = "string",
    FaultDomain = "string",
    FreeformTags = 
    {
        { "string", "string" },
    },
    ConfigurationId = "string",
    CrashRecovery = "string",
    CustomerContacts = new[]
    {
        new Oci.Mysql.Inputs.MysqlDbSystemCustomerContactArgs
        {
            Email = "string",
        },
    },
    DataStorage = new Oci.Mysql.Inputs.MysqlDbSystemDataStorageArgs
    {
        AllocatedStorageSizeInGbs = 0,
        DataStorageSizeInGb = 0,
        DataStorageSizeLimitInGbs = 0,
        IsAutoExpandStorageEnabled = false,
        MaxStorageSizeInGbs = 0,
    },
    DataStorageSizeInGb = 0,
    DatabaseManagement = "string",
    DatabaseMode = "string",
    DefinedTags = 
    {
        { "string", "string" },
    },
    DeletionPolicies = new[]
    {
        new Oci.Mysql.Inputs.MysqlDbSystemDeletionPolicyArgs
        {
            AutomaticBackupRetention = "string",
            FinalBackup = "string",
            IsDeleteProtected = false,
        },
    },
    Description = "string",
    DisplayName = "string",
    EncryptData = new Oci.Mysql.Inputs.MysqlDbSystemEncryptDataArgs
    {
        KeyGenerationType = "string",
        KeyId = "string",
    },
    AccessMode = "string",
    BackupPolicy = new Oci.Mysql.Inputs.MysqlDbSystemBackupPolicyArgs
    {
        CopyPolicies = new[]
        {
            new Oci.Mysql.Inputs.MysqlDbSystemBackupPolicyCopyPolicyArgs
            {
                CopyToRegion = "string",
                BackupCopyRetentionInDays = 0,
            },
        },
        DefinedTags = 
        {
            { "string", "string" },
        },
        FreeformTags = 
        {
            { "string", "string" },
        },
        IsEnabled = false,
        PitrPolicy = new Oci.Mysql.Inputs.MysqlDbSystemBackupPolicyPitrPolicyArgs
        {
            IsEnabled = false,
        },
        RetentionInDays = 0,
        SoftDelete = "string",
        WindowStartTime = "string",
    },
    HostnameLabel = "string",
    IpAddress = "string",
    IsHighlyAvailable = false,
    Maintenance = new Oci.Mysql.Inputs.MysqlDbSystemMaintenanceArgs
    {
        WindowStartTime = "string",
    },
    MysqlVersion = "string",
    NsgIds = new[]
    {
        "string",
    },
    Port = 0,
    PortX = 0,
    ReadEndpoint = new Oci.Mysql.Inputs.MysqlDbSystemReadEndpointArgs
    {
        ExcludeIps = new[]
        {
            "string",
        },
        IsEnabled = false,
        ReadEndpointHostnameLabel = "string",
        ReadEndpointIpAddress = "string",
    },
    Rest = new Oci.Mysql.Inputs.MysqlDbSystemRestArgs
    {
        Configuration = "string",
        Port = 0,
    },
    SecureConnections = new Oci.Mysql.Inputs.MysqlDbSystemSecureConnectionsArgs
    {
        CertificateGenerationType = "string",
        CertificateId = "string",
    },
    AdminUsername = "string",
    ShutdownType = "string",
    Source = new Oci.Mysql.Inputs.MysqlDbSystemSourceArgs
    {
        SourceType = "string",
        BackupId = "string",
        DbSystemId = "string",
        RecoveryPoint = "string",
        SourceUrl = "string",
    },
    State = "string",
    AdminPassword = "string",
});

example, err := mysql.NewMysqlDbSystem(ctx, "mysqlDbSystemResource", &mysql.MysqlDbSystemArgs{
	CompartmentId:      pulumi.String("string"),
	SubnetId:           pulumi.String("string"),
	ShapeName:          pulumi.String("string"),
	AvailabilityDomain: pulumi.String("string"),
	FaultDomain:        pulumi.String("string"),
	FreeformTags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	ConfigurationId: pulumi.String("string"),
	CrashRecovery:   pulumi.String("string"),
	CustomerContacts: mysql.MysqlDbSystemCustomerContactArray{
		&mysql.MysqlDbSystemCustomerContactArgs{
			Email: pulumi.String("string"),
		},
	},
	DataStorage: &mysql.MysqlDbSystemDataStorageArgs{
		AllocatedStorageSizeInGbs:  pulumi.Int(0),
		DataStorageSizeInGb:        pulumi.Int(0),
		DataStorageSizeLimitInGbs:  pulumi.Int(0),
		IsAutoExpandStorageEnabled: pulumi.Bool(false),
		MaxStorageSizeInGbs:        pulumi.Int(0),
	},
	DataStorageSizeInGb: pulumi.Int(0),
	DatabaseManagement:  pulumi.String("string"),
	DatabaseMode:        pulumi.String("string"),
	DefinedTags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	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"),
	EncryptData: &mysql.MysqlDbSystemEncryptDataArgs{
		KeyGenerationType: pulumi.String("string"),
		KeyId:             pulumi.String("string"),
	},
	AccessMode: pulumi.String("string"),
	BackupPolicy: &mysql.MysqlDbSystemBackupPolicyArgs{
		CopyPolicies: mysql.MysqlDbSystemBackupPolicyCopyPolicyArray{
			&mysql.MysqlDbSystemBackupPolicyCopyPolicyArgs{
				CopyToRegion:              pulumi.String("string"),
				BackupCopyRetentionInDays: pulumi.Int(0),
			},
		},
		DefinedTags: pulumi.StringMap{
			"string": pulumi.String("string"),
		},
		FreeformTags: pulumi.StringMap{
			"string": pulumi.String("string"),
		},
		IsEnabled: pulumi.Bool(false),
		PitrPolicy: &mysql.MysqlDbSystemBackupPolicyPitrPolicyArgs{
			IsEnabled: pulumi.Bool(false),
		},
		RetentionInDays: pulumi.Int(0),
		SoftDelete:      pulumi.String("string"),
		WindowStartTime: pulumi.String("string"),
	},
	HostnameLabel:     pulumi.String("string"),
	IpAddress:         pulumi.String("string"),
	IsHighlyAvailable: pulumi.Bool(false),
	Maintenance: &mysql.MysqlDbSystemMaintenanceArgs{
		WindowStartTime: pulumi.String("string"),
	},
	MysqlVersion: pulumi.String("string"),
	NsgIds: pulumi.StringArray{
		pulumi.String("string"),
	},
	Port:  pulumi.Int(0),
	PortX: pulumi.Int(0),
	ReadEndpoint: &mysql.MysqlDbSystemReadEndpointArgs{
		ExcludeIps: pulumi.StringArray{
			pulumi.String("string"),
		},
		IsEnabled:                 pulumi.Bool(false),
		ReadEndpointHostnameLabel: pulumi.String("string"),
		ReadEndpointIpAddress:     pulumi.String("string"),
	},
	Rest: &mysql.MysqlDbSystemRestArgs{
		Configuration: pulumi.String("string"),
		Port:          pulumi.Int(0),
	},
	SecureConnections: &mysql.MysqlDbSystemSecureConnectionsArgs{
		CertificateGenerationType: pulumi.String("string"),
		CertificateId:             pulumi.String("string"),
	},
	AdminUsername: 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"),
	AdminPassword: pulumi.String("string"),
})

var mysqlDbSystemResource = new MysqlDbSystem("mysqlDbSystemResource", MysqlDbSystemArgs.builder()
    .compartmentId("string")
    .subnetId("string")
    .shapeName("string")
    .availabilityDomain("string")
    .faultDomain("string")
    .freeformTags(Map.of("string", "string"))
    .configurationId("string")
    .crashRecovery("string")
    .customerContacts(MysqlDbSystemCustomerContactArgs.builder()
        .email("string")
        .build())
    .dataStorage(MysqlDbSystemDataStorageArgs.builder()
        .allocatedStorageSizeInGbs(0)
        .dataStorageSizeInGb(0)
        .dataStorageSizeLimitInGbs(0)
        .isAutoExpandStorageEnabled(false)
        .maxStorageSizeInGbs(0)
        .build())
    .dataStorageSizeInGb(0)
    .databaseManagement("string")
    .databaseMode("string")
    .definedTags(Map.of("string", "string"))
    .deletionPolicies(MysqlDbSystemDeletionPolicyArgs.builder()
        .automaticBackupRetention("string")
        .finalBackup("string")
        .isDeleteProtected(false)
        .build())
    .description("string")
    .displayName("string")
    .encryptData(MysqlDbSystemEncryptDataArgs.builder()
        .keyGenerationType("string")
        .keyId("string")
        .build())
    .accessMode("string")
    .backupPolicy(MysqlDbSystemBackupPolicyArgs.builder()
        .copyPolicies(MysqlDbSystemBackupPolicyCopyPolicyArgs.builder()
            .copyToRegion("string")
            .backupCopyRetentionInDays(0)
            .build())
        .definedTags(Map.of("string", "string"))
        .freeformTags(Map.of("string", "string"))
        .isEnabled(false)
        .pitrPolicy(MysqlDbSystemBackupPolicyPitrPolicyArgs.builder()
            .isEnabled(false)
            .build())
        .retentionInDays(0)
        .softDelete("string")
        .windowStartTime("string")
        .build())
    .hostnameLabel("string")
    .ipAddress("string")
    .isHighlyAvailable(false)
    .maintenance(MysqlDbSystemMaintenanceArgs.builder()
        .windowStartTime("string")
        .build())
    .mysqlVersion("string")
    .nsgIds("string")
    .port(0)
    .portX(0)
    .readEndpoint(MysqlDbSystemReadEndpointArgs.builder()
        .excludeIps("string")
        .isEnabled(false)
        .readEndpointHostnameLabel("string")
        .readEndpointIpAddress("string")
        .build())
    .rest(MysqlDbSystemRestArgs.builder()
        .configuration("string")
        .port(0)
        .build())
    .secureConnections(MysqlDbSystemSecureConnectionsArgs.builder()
        .certificateGenerationType("string")
        .certificateId("string")
        .build())
    .adminUsername("string")
    .shutdownType("string")
    .source(MysqlDbSystemSourceArgs.builder()
        .sourceType("string")
        .backupId("string")
        .dbSystemId("string")
        .recoveryPoint("string")
        .sourceUrl("string")
        .build())
    .state("string")
    .adminPassword("string")
    .build());

mysql_db_system_resource = oci.mysql.MysqlDbSystem("mysqlDbSystemResource",
    compartment_id="string",
    subnet_id="string",
    shape_name="string",
    availability_domain="string",
    fault_domain="string",
    freeform_tags={
        "string": "string",
    },
    configuration_id="string",
    crash_recovery="string",
    customer_contacts=[{
        "email": "string",
    }],
    data_storage={
        "allocated_storage_size_in_gbs": 0,
        "data_storage_size_in_gb": 0,
        "data_storage_size_limit_in_gbs": 0,
        "is_auto_expand_storage_enabled": False,
        "max_storage_size_in_gbs": 0,
    },
    data_storage_size_in_gb=0,
    database_management="string",
    database_mode="string",
    defined_tags={
        "string": "string",
    },
    deletion_policies=[{
        "automatic_backup_retention": "string",
        "final_backup": "string",
        "is_delete_protected": False,
    }],
    description="string",
    display_name="string",
    encrypt_data={
        "key_generation_type": "string",
        "key_id": "string",
    },
    access_mode="string",
    backup_policy={
        "copy_policies": [{
            "copy_to_region": "string",
            "backup_copy_retention_in_days": 0,
        }],
        "defined_tags": {
            "string": "string",
        },
        "freeform_tags": {
            "string": "string",
        },
        "is_enabled": False,
        "pitr_policy": {
            "is_enabled": False,
        },
        "retention_in_days": 0,
        "soft_delete": "string",
        "window_start_time": "string",
    },
    hostname_label="string",
    ip_address="string",
    is_highly_available=False,
    maintenance={
        "window_start_time": "string",
    },
    mysql_version="string",
    nsg_ids=["string"],
    port=0,
    port_x=0,
    read_endpoint={
        "exclude_ips": ["string"],
        "is_enabled": False,
        "read_endpoint_hostname_label": "string",
        "read_endpoint_ip_address": "string",
    },
    rest={
        "configuration": "string",
        "port": 0,
    },
    secure_connections={
        "certificate_generation_type": "string",
        "certificate_id": "string",
    },
    admin_username="string",
    shutdown_type="string",
    source={
        "source_type": "string",
        "backup_id": "string",
        "db_system_id": "string",
        "recovery_point": "string",
        "source_url": "string",
    },
    state="string",
    admin_password="string")

const mysqlDbSystemResource = new oci.mysql.MysqlDbSystem("mysqlDbSystemResource", {
    compartmentId: "string",
    subnetId: "string",
    shapeName: "string",
    availabilityDomain: "string",
    faultDomain: "string",
    freeformTags: {
        string: "string",
    },
    configurationId: "string",
    crashRecovery: "string",
    customerContacts: [{
        email: "string",
    }],
    dataStorage: {
        allocatedStorageSizeInGbs: 0,
        dataStorageSizeInGb: 0,
        dataStorageSizeLimitInGbs: 0,
        isAutoExpandStorageEnabled: false,
        maxStorageSizeInGbs: 0,
    },
    dataStorageSizeInGb: 0,
    databaseManagement: "string",
    databaseMode: "string",
    definedTags: {
        string: "string",
    },
    deletionPolicies: [{
        automaticBackupRetention: "string",
        finalBackup: "string",
        isDeleteProtected: false,
    }],
    description: "string",
    displayName: "string",
    encryptData: {
        keyGenerationType: "string",
        keyId: "string",
    },
    accessMode: "string",
    backupPolicy: {
        copyPolicies: [{
            copyToRegion: "string",
            backupCopyRetentionInDays: 0,
        }],
        definedTags: {
            string: "string",
        },
        freeformTags: {
            string: "string",
        },
        isEnabled: false,
        pitrPolicy: {
            isEnabled: false,
        },
        retentionInDays: 0,
        softDelete: "string",
        windowStartTime: "string",
    },
    hostnameLabel: "string",
    ipAddress: "string",
    isHighlyAvailable: false,
    maintenance: {
        windowStartTime: "string",
    },
    mysqlVersion: "string",
    nsgIds: ["string"],
    port: 0,
    portX: 0,
    readEndpoint: {
        excludeIps: ["string"],
        isEnabled: false,
        readEndpointHostnameLabel: "string",
        readEndpointIpAddress: "string",
    },
    rest: {
        configuration: "string",
        port: 0,
    },
    secureConnections: {
        certificateGenerationType: "string",
        certificateId: "string",
    },
    adminUsername: "string",
    shutdownType: "string",
    source: {
        sourceType: "string",
        backupId: "string",
        dbSystemId: "string",
        recoveryPoint: "string",
        sourceUrl: "string",
    },
    state: "string",
    adminPassword: "string",
});

type: oci:Mysql:MysqlDbSystem
properties:
    accessMode: string
    adminPassword: string
    adminUsername: string
    availabilityDomain: string
    backupPolicy:
        copyPolicies:
            - backupCopyRetentionInDays: 0
              copyToRegion: string
        definedTags:
            string: string
        freeformTags:
            string: string
        isEnabled: false
        pitrPolicy:
            isEnabled: false
        retentionInDays: 0
        softDelete: string
        windowStartTime: string
    compartmentId: string
    configurationId: string
    crashRecovery: string
    customerContacts:
        - email: string
    dataStorage:
        allocatedStorageSizeInGbs: 0
        dataStorageSizeInGb: 0
        dataStorageSizeLimitInGbs: 0
        isAutoExpandStorageEnabled: false
        maxStorageSizeInGbs: 0
    dataStorageSizeInGb: 0
    databaseManagement: string
    databaseMode: string
    definedTags:
        string: string
    deletionPolicies:
        - automaticBackupRetention: string
          finalBackup: string
          isDeleteProtected: false
    description: string
    displayName: string
    encryptData:
        keyGenerationType: string
        keyId: string
    faultDomain: string
    freeformTags:
        string: string
    hostnameLabel: string
    ipAddress: string
    isHighlyAvailable: false
    maintenance:
        windowStartTime: string
    mysqlVersion: string
    nsgIds:
        - string
    port: 0
    portX: 0
    readEndpoint:
        excludeIps:
            - string
        isEnabled: false
        readEndpointHostnameLabel: string
        readEndpointIpAddress: string
    rest:
        configuration: string
        port: 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

In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

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.

AccessMode string

(Updatable) The access mode indicating if the database access will be restricted only to administrators or not:

UNRESTRICTED (default): the access to the database is not restricted;
RESTRICTED: the access will be allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

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.

CustomerContacts List<MysqlDbSystemCustomerContact>

(Updatable) The list of customer email addresses that receive information from Oracle about the specified Oracle Cloud Infrastructure DB System resource. Oracle uses these email addresses to send notifications about planned and unplanned software maintenance updates, information about system hardware, and other information needed by administrators. Up to 10 email addresses can be added to the customer contacts for a DB System.

DataStorage MysqlDbSystemDataStorage

(Updatable) Data Storage configuration properties.

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.

DatabaseMode string

(Updatable) The database mode indicating the types of statements that will be allowed to run in the DB system. This mode will apply only to statements run by user connections. Replicated write statements will continue to be allowed regardless of the DatabaseMode.

READ_WRITE (default): allow running read and write statements on the DB system;
READ_ONLY: only allow running read statements on the DB system.

DefinedTags Dictionary<string, string>

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

EncryptData MysqlDbSystemEncryptData

(Updatable) Encrypt data details.

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

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

HostnameLabel string

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

NsgIds List<string>

(Updatable) Network Security Group OCIDs used for the VNIC attachment.

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.

ReadEndpoint MysqlDbSystemReadEndpoint

(Updatable) Details required to create a Read Endpoint.

Rest MysqlDbSystemRest

(Updatable) Details required to configure REST while creating a DB System.

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.

AccessMode string

(Updatable) The access mode indicating if the database access will be restricted only to administrators or not:

UNRESTRICTED (default): the access to the database is not restricted;
RESTRICTED: the access will be allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

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.

CustomerContacts []MysqlDbSystemCustomerContactArgs

DataStorage MysqlDbSystemDataStorageArgs

(Updatable) Data Storage configuration properties.

DataStorageSizeInGb int

DatabaseManagement string

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

DatabaseMode string

READ_WRITE (default): allow running read and write statements on the DB system;
READ_ONLY: only allow running read statements on the DB system.

DefinedTags map[string]string

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

EncryptData MysqlDbSystemEncryptDataArgs

(Updatable) Encrypt data details.

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

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

HostnameLabel string

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

NsgIds []string

(Updatable) Network Security Group OCIDs used for the VNIC attachment.

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.

ReadEndpoint MysqlDbSystemReadEndpointArgs

(Updatable) Details required to create a Read Endpoint.

Rest MysqlDbSystemRestArgs

(Updatable) Details required to configure REST while creating a DB System.

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.

accessMode String

(Updatable) The access mode indicating if the database access will be restricted only to administrators or not:

UNRESTRICTED (default): the access to the database is not restricted;
RESTRICTED: the access will be allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

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.

customerContacts List<DbSystemCustomerContact>

dataStorage DbSystemDataStorage

(Updatable) Data Storage configuration properties.

dataStorageSizeInGb Integer

databaseManagement String

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

databaseMode String

READ_WRITE (default): allow running read and write statements on the DB system;
READ_ONLY: only allow running read statements on the DB system.

definedTags Map<String,String>

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

encryptData DbSystemEncryptData

(Updatable) Encrypt data details.

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

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

hostnameLabel String

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

nsgIds List<String>

(Updatable) Network Security Group OCIDs used for the VNIC attachment.

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.

readEndpoint DbSystemReadEndpoint

(Updatable) Details required to create a Read Endpoint.

rest DbSystemRest

(Updatable) Details required to configure REST while creating a DB System.

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.

accessMode string

(Updatable) The access mode indicating if the database access will be restricted only to administrators or not:

UNRESTRICTED (default): the access to the database is not restricted;
RESTRICTED: the access will be allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

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.

customerContacts MysqlDbSystemCustomerContact[]

dataStorage MysqlDbSystemDataStorage

(Updatable) Data Storage configuration properties.

dataStorageSizeInGb number

databaseManagement string

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

databaseMode string

READ_WRITE (default): allow running read and write statements on the DB system;
READ_ONLY: only allow running read statements on the DB system.

definedTags {[key: string]: string}

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

encryptData MysqlDbSystemEncryptData

(Updatable) Encrypt data details.

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

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

hostnameLabel string

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

nsgIds string[]

(Updatable) Network Security Group OCIDs used for the VNIC attachment.

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.

readEndpoint MysqlDbSystemReadEndpoint

(Updatable) Details required to create a Read Endpoint.

rest MysqlDbSystemRest

(Updatable) Details required to configure REST while creating a DB System.

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.

access_mode str

(Updatable) The access mode indicating if the database access will be restricted only to administrators or not:

UNRESTRICTED (default): the access to the database is not restricted;
RESTRICTED: the access will be allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

admin_password str

admin_username str

The username for the administrative user.

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

customer_contacts Sequence[MysqlDbSystemCustomerContactArgs]

data_storage MysqlDbSystemDataStorageArgs

(Updatable) Data Storage configuration properties.

data_storage_size_in_gb int

database_management str

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

database_mode str

READ_WRITE (default): allow running read and write statements on the DB system;
READ_ONLY: only allow running read statements on the DB system.

defined_tags Mapping[str, str]

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

deletion_policies Sequence[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.

encrypt_data MysqlDbSystemEncryptDataArgs

(Updatable) Encrypt data details.

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

(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

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

nsg_ids Sequence[str]

(Updatable) Network Security Group OCIDs used for the VNIC attachment.

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.

read_endpoint MysqlDbSystemReadEndpointArgs

(Updatable) Details required to create a Read Endpoint.

rest MysqlDbSystemRestArgs

(Updatable) Details required to configure REST while creating a DB System.

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

accessMode String

(Updatable) The access mode indicating if the database access will be restricted only to administrators or not:

UNRESTRICTED (default): the access to the database is not restricted;
RESTRICTED: the access will be allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

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.

customerContacts List<Property Map>

dataStorage Property Map

(Updatable) Data Storage configuration properties.

dataStorageSizeInGb Number

databaseManagement String

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

databaseMode String

READ_WRITE (default): allow running read and write statements on the DB system;
READ_ONLY: only allow running read statements on the DB system.

definedTags Map<String>

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

encryptData Property Map

(Updatable) Encrypt data details.

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>

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

hostnameLabel String

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

nsgIds List<String>

(Updatable) Network Security Group OCIDs used for the VNIC attachment.

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.

readEndpoint Property Map

(Updatable) Details required to create a Read Endpoint.

rest Property Map

(Updatable) Details required to configure REST while creating a DB System.

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.
SystemTags Dictionary<string, string>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
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.
SystemTags map[string]string: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
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.
systemTags Map<String,String>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
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.
systemTags {[key: string]: string}: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated string: The date and time the DB System was created.
timeUpdated string: The time the DB System was last updated.

channels Sequence[MysqlDbSystemChannel]: A list with a summary of all the Channels attached to the DB System.
current_placements Sequence[MysqlDbSystemCurrentPlacement]: The availability domain and fault domain a DB System is placed in.
endpoints Sequence[MysqlDbSystemEndpoint]: The network endpoints available for this DB System.
heat_wave_clusters Sequence[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[MysqlDbSystemPointInTimeRecoveryDetail]: Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
system_tags Mapping[str, str]: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
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.
systemTags Map<String>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
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,
        access_mode: Optional[str] = None,
        admin_password: Optional[str] = None,
        admin_username: Optional[str] = None,
        availability_domain: Optional[str] = None,
        backup_policy: Optional[MysqlDbSystemBackupPolicyArgs] = None,
        channels: Optional[Sequence[MysqlDbSystemChannelArgs]] = None,
        compartment_id: Optional[str] = None,
        configuration_id: Optional[str] = None,
        crash_recovery: Optional[str] = None,
        current_placements: Optional[Sequence[MysqlDbSystemCurrentPlacementArgs]] = None,
        customer_contacts: Optional[Sequence[MysqlDbSystemCustomerContactArgs]] = None,
        data_storage: Optional[MysqlDbSystemDataStorageArgs] = None,
        data_storage_size_in_gb: Optional[int] = None,
        database_management: Optional[str] = None,
        database_mode: Optional[str] = None,
        defined_tags: Optional[Mapping[str, str]] = None,
        deletion_policies: Optional[Sequence[MysqlDbSystemDeletionPolicyArgs]] = None,
        description: Optional[str] = None,
        display_name: Optional[str] = None,
        encrypt_data: Optional[MysqlDbSystemEncryptDataArgs] = None,
        endpoints: Optional[Sequence[MysqlDbSystemEndpointArgs]] = None,
        fault_domain: Optional[str] = None,
        freeform_tags: Optional[Mapping[str, str]] = None,
        heat_wave_clusters: Optional[Sequence[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[MysqlDbSystemMaintenanceArgs] = None,
        mysql_version: Optional[str] = None,
        nsg_ids: Optional[Sequence[str]] = None,
        point_in_time_recovery_details: Optional[Sequence[MysqlDbSystemPointInTimeRecoveryDetailArgs]] = None,
        port: Optional[int] = None,
        port_x: Optional[int] = None,
        read_endpoint: Optional[MysqlDbSystemReadEndpointArgs] = None,
        rest: Optional[MysqlDbSystemRestArgs] = None,
        secure_connections: Optional[MysqlDbSystemSecureConnectionsArgs] = None,
        shape_name: Optional[str] = None,
        shutdown_type: Optional[str] = None,
        source: Optional[MysqlDbSystemSourceArgs] = None,
        state: Optional[str] = None,
        subnet_id: Optional[str] = None,
        system_tags: Optional[Mapping[str, 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)

resources:  _:    type: oci:Mysql:MysqlDbSystem    get:      id: ${id}

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:

AccessMode string

(Updatable) The access mode indicating if the database access will be restricted only to administrators or not:

UNRESTRICTED (default): the access to the database is not restricted;
RESTRICTED: the access will be allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

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.

CustomerContacts List<MysqlDbSystemCustomerContact>

DataStorage MysqlDbSystemDataStorage

(Updatable) Data Storage configuration properties.

DataStorageSizeInGb int

DatabaseManagement string

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

DatabaseMode string

READ_WRITE (default): allow running read and write statements on the DB system;
READ_ONLY: only allow running read statements on the DB system.

DefinedTags Dictionary<string, string>

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

EncryptData MysqlDbSystemEncryptData

(Updatable) Encrypt data details.

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

(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

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

NsgIds List<string>

(Updatable) Network Security Group OCIDs used for the VNIC attachment.

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.

ReadEndpoint MysqlDbSystemReadEndpoint

(Updatable) Details required to create a Read Endpoint.

Rest MysqlDbSystemRest

(Updatable) Details required to configure REST while creating a DB System.

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.

SystemTags Dictionary<string, string>

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

TimeCreated string

The date and time the DB System was created.

TimeUpdated string

The time the DB System was last updated.

AccessMode string

(Updatable) The access mode indicating if the database access will be restricted only to administrators or not:

UNRESTRICTED (default): the access to the database is not restricted;
RESTRICTED: the access will be allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

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.

CustomerContacts []MysqlDbSystemCustomerContactArgs

DataStorage MysqlDbSystemDataStorageArgs

(Updatable) Data Storage configuration properties.

DataStorageSizeInGb int

DatabaseManagement string

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

DatabaseMode string

READ_WRITE (default): allow running read and write statements on the DB system;
READ_ONLY: only allow running read statements on the DB system.

DefinedTags map[string]string

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

EncryptData MysqlDbSystemEncryptDataArgs

(Updatable) Encrypt data details.

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

(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

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

NsgIds []string

(Updatable) Network Security Group OCIDs used for the VNIC attachment.

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.

ReadEndpoint MysqlDbSystemReadEndpointArgs

(Updatable) Details required to create a Read Endpoint.

Rest MysqlDbSystemRestArgs

(Updatable) Details required to configure REST while creating a DB System.

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.

SystemTags map[string]string

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

TimeCreated string

The date and time the DB System was created.

TimeUpdated string

The time the DB System was last updated.

accessMode String

(Updatable) The access mode indicating if the database access will be restricted only to administrators or not:

UNRESTRICTED (default): the access to the database is not restricted;
RESTRICTED: the access will be allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

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.

customerContacts List<DbSystemCustomerContact>

dataStorage DbSystemDataStorage

(Updatable) Data Storage configuration properties.

dataStorageSizeInGb Integer

databaseManagement String

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

databaseMode String

READ_WRITE (default): allow running read and write statements on the DB system;
READ_ONLY: only allow running read statements on the DB system.

definedTags Map<String,String>

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

encryptData DbSystemEncryptData

(Updatable) Encrypt data details.

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

(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

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

nsgIds List<String>

(Updatable) Network Security Group OCIDs used for the VNIC attachment.

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.

readEndpoint DbSystemReadEndpoint

(Updatable) Details required to create a Read Endpoint.

rest DbSystemRest

(Updatable) Details required to configure REST while creating a DB System.

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.

systemTags Map<String,String>

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

timeCreated String

The date and time the DB System was created.

timeUpdated String

The time the DB System was last updated.

accessMode string

(Updatable) The access mode indicating if the database access will be restricted only to administrators or not:

UNRESTRICTED (default): the access to the database is not restricted;
RESTRICTED: the access will be allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

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.

customerContacts MysqlDbSystemCustomerContact[]

dataStorage MysqlDbSystemDataStorage

(Updatable) Data Storage configuration properties.

dataStorageSizeInGb number

databaseManagement string

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

databaseMode string

READ_WRITE (default): allow running read and write statements on the DB system;
READ_ONLY: only allow running read statements on the DB system.

definedTags {[key: string]: string}

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

encryptData MysqlDbSystemEncryptData

(Updatable) Encrypt data details.

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

(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

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

nsgIds string[]

(Updatable) Network Security Group OCIDs used for the VNIC attachment.

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.

readEndpoint MysqlDbSystemReadEndpoint

(Updatable) Details required to create a Read Endpoint.

rest MysqlDbSystemRest

(Updatable) Details required to configure REST while creating a DB System.

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.

systemTags {[key: string]: string}

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

timeCreated string

The date and time the DB System was created.

timeUpdated string

The time the DB System was last updated.

access_mode str

(Updatable) The access mode indicating if the database access will be restricted only to administrators or not:

UNRESTRICTED (default): the access to the database is not restricted;
RESTRICTED: the access will be allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

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 MysqlDbSystemBackupPolicyArgs

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

channels Sequence[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[MysqlDbSystemCurrentPlacementArgs]

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

customer_contacts Sequence[MysqlDbSystemCustomerContactArgs]

data_storage MysqlDbSystemDataStorageArgs

(Updatable) Data Storage configuration properties.

data_storage_size_in_gb int

database_management str

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

database_mode str

READ_WRITE (default): allow running read and write statements on the DB system;
READ_ONLY: only allow running read statements on the DB system.

defined_tags Mapping[str, str]

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

deletion_policies Sequence[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.

encrypt_data MysqlDbSystemEncryptDataArgs

(Updatable) Encrypt data details.

endpoints Sequence[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, str]

(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[MysqlDbSystemHeatWaveClusterArgs]

A summary of a HeatWave cluster.

hostname_label str

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

nsg_ids Sequence[str]

(Updatable) Network Security Group OCIDs used for the VNIC attachment.

point_in_time_recovery_details Sequence[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.

read_endpoint MysqlDbSystemReadEndpointArgs

(Updatable) Details required to create a Read Endpoint.

rest MysqlDbSystemRestArgs

(Updatable) Details required to configure REST while creating a DB System.

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

system_tags Mapping[str, str]

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

time_created str

The date and time the DB System was created.

time_updated str

The time the DB System was last updated.

accessMode String

(Updatable) The access mode indicating if the database access will be restricted only to administrators or not:

UNRESTRICTED (default): the access to the database is not restricted;
RESTRICTED: the access will be allowed only to users with specific privileges; RESTRICTED will correspond to setting the MySQL system variable offline_mode to ON.

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.

customerContacts List<Property Map>

dataStorage Property Map

(Updatable) Data Storage configuration properties.

dataStorageSizeInGb Number

databaseManagement String

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

databaseMode String

READ_WRITE (default): allow running read and write statements on the DB system;
READ_ONLY: only allow running read statements on the DB system.

definedTags Map<String>

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

encryptData Property Map

(Updatable) Encrypt data details.

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

(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

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

nsgIds List<String>

(Updatable) Network Security Group OCIDs used for the VNIC attachment.

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.

readEndpoint Property Map

(Updatable) Details required to create a Read Endpoint.

rest Property Map

(Updatable) Details required to configure REST while creating a DB System.

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.

systemTags Map<String>

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

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

CopyPolicies List<MysqlDbSystemBackupPolicyCopyPolicy>

(Updatable) List of policies of a DB system to schedule cross-region DB system backup copy.

The policy includes the name of the destination region to which the DB system backup will be copied, and an optional parameter which specifies the retention period of the copied DB system backup in days.

Note: Currently, only one policy can be specified in the list.

DefinedTags Dictionary<string, string>

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces.

Tags defined here will be copied verbatim as tags on the Backup resource created by this BackupPolicy.

Example: {"foo-namespace.bar-key": "value"}

FreeformTags Dictionary<string, string>

(Updatable) Simple key-value pair applied without any predefined name, type or scope. Exists for cross-compatibility only.

Tags defined here will be copied verbatim as tags on the Backup resource created by this BackupPolicy.

Example: {"bar-key": "value"}

IsEnabled bool

(Updatable) Specifies if automatic backups are enabled.

PitrPolicy MysqlDbSystemBackupPolicyPitrPolicy

(Updatable) The PITR policy for the DB System.

RetentionInDays int

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

SoftDelete string

(Updatable) Retains the backup to be deleted due to the retention policy in DELETE SCHEDULED state for 7 days before permanently deleting it.

WindowStartTime string

(Updatable) The start of a 30-minute window of time in which daily, automated backups occur.

This should be in the format of the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

At some point in the window, the system may incur a brief service disruption as the backup is performed.

CopyPolicies []MysqlDbSystemBackupPolicyCopyPolicy

(Updatable) List of policies of a DB system to schedule cross-region DB system backup copy.

Note: Currently, only one policy can be specified in the list.

DefinedTags map[string]string

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces.

Tags defined here will be copied verbatim as tags on the Backup resource created by this BackupPolicy.

Example: {"foo-namespace.bar-key": "value"}

FreeformTags map[string]string

(Updatable) Simple key-value pair applied without any predefined name, type or scope. Exists for cross-compatibility only.

Tags defined here will be copied verbatim as tags on the Backup resource created by this BackupPolicy.

Example: {"bar-key": "value"}

IsEnabled bool

(Updatable) Specifies if automatic backups are enabled.

PitrPolicy MysqlDbSystemBackupPolicyPitrPolicy

(Updatable) The PITR policy for the DB System.

RetentionInDays int

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

SoftDelete string

(Updatable) Retains the backup to be deleted due to the retention policy in DELETE SCHEDULED state for 7 days before permanently deleting it.

WindowStartTime string

(Updatable) The start of a 30-minute window of time in which daily, automated backups occur.

This should be in the format of the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

At some point in the window, the system may incur a brief service disruption as the backup is performed.

copyPolicies List<DbSystemBackupPolicyCopyPolicy>

(Updatable) List of policies of a DB system to schedule cross-region DB system backup copy.

Note: Currently, only one policy can be specified in the list.

definedTags Map<String,String>

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces.

Tags defined here will be copied verbatim as tags on the Backup resource created by this BackupPolicy.

Example: {"foo-namespace.bar-key": "value"}

freeformTags Map<String,String>

(Updatable) Simple key-value pair applied without any predefined name, type or scope. Exists for cross-compatibility only.

Tags defined here will be copied verbatim as tags on the Backup resource created by this BackupPolicy.

Example: {"bar-key": "value"}

isEnabled Boolean

(Updatable) Specifies if automatic backups are enabled.

pitrPolicy DbSystemBackupPolicyPitrPolicy

(Updatable) The PITR policy for the DB System.

retentionInDays Integer

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

softDelete String

(Updatable) Retains the backup to be deleted due to the retention policy in DELETE SCHEDULED state for 7 days before permanently deleting it.

windowStartTime String

(Updatable) The start of a 30-minute window of time in which daily, automated backups occur.

This should be in the format of the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

At some point in the window, the system may incur a brief service disruption as the backup is performed.

copyPolicies MysqlDbSystemBackupPolicyCopyPolicy[]

(Updatable) List of policies of a DB system to schedule cross-region DB system backup copy.

Note: Currently, only one policy can be specified in the list.

definedTags {[key: string]: string}

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces.

Tags defined here will be copied verbatim as tags on the Backup resource created by this BackupPolicy.

Example: {"foo-namespace.bar-key": "value"}

freeformTags {[key: string]: string}

(Updatable) Simple key-value pair applied without any predefined name, type or scope. Exists for cross-compatibility only.

Tags defined here will be copied verbatim as tags on the Backup resource created by this BackupPolicy.

Example: {"bar-key": "value"}

isEnabled boolean

(Updatable) Specifies if automatic backups are enabled.

pitrPolicy MysqlDbSystemBackupPolicyPitrPolicy

(Updatable) The PITR policy for the DB System.

retentionInDays number

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

softDelete string

(Updatable) Retains the backup to be deleted due to the retention policy in DELETE SCHEDULED state for 7 days before permanently deleting it.

windowStartTime string

(Updatable) The start of a 30-minute window of time in which daily, automated backups occur.

This should be in the format of the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

At some point in the window, the system may incur a brief service disruption as the backup is performed.

copy_policies Sequence[MysqlDbSystemBackupPolicyCopyPolicy]

(Updatable) List of policies of a DB system to schedule cross-region DB system backup copy.

Note: Currently, only one policy can be specified in the list.

defined_tags Mapping[str, str]

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces.

Tags defined here will be copied verbatim as tags on the Backup resource created by this BackupPolicy.

Example: {"foo-namespace.bar-key": "value"}

freeform_tags Mapping[str, str]

(Updatable) Simple key-value pair applied without any predefined name, type or scope. Exists for cross-compatibility only.

Tags defined here will be copied verbatim as tags on the Backup resource created by this BackupPolicy.

Example: {"bar-key": "value"}

is_enabled bool

(Updatable) Specifies if automatic backups are enabled.

pitr_policy MysqlDbSystemBackupPolicyPitrPolicy

(Updatable) The PITR policy for the DB System.

retention_in_days int

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

soft_delete str

(Updatable) Retains the backup to be deleted due to the retention policy in DELETE SCHEDULED state for 7 days before permanently deleting it.

window_start_time str

(Updatable) The start of a 30-minute window of time in which daily, automated backups occur.

This should be in the format of the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

At some point in the window, the system may incur a brief service disruption as the backup is performed.

copyPolicies List<Property Map>

(Updatable) List of policies of a DB system to schedule cross-region DB system backup copy.

Note: Currently, only one policy can be specified in the list.

definedTags Map<String>

(Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces.

Tags defined here will be copied verbatim as tags on the Backup resource created by this BackupPolicy.

Example: {"foo-namespace.bar-key": "value"}

freeformTags Map<String>

(Updatable) Simple key-value pair applied without any predefined name, type or scope. Exists for cross-compatibility only.

Tags defined here will be copied verbatim as tags on the Backup resource created by this BackupPolicy.

Example: {"bar-key": "value"}

isEnabled Boolean

(Updatable) Specifies if automatic backups are enabled.

pitrPolicy Property Map

(Updatable) The PITR policy for the DB System.

retentionInDays Number

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

softDelete String

(Updatable) Retains the backup to be deleted due to the retention policy in DELETE SCHEDULED state for 7 days before permanently deleting it.

windowStartTime String

(Updatable) The start of a 30-minute window of time in which daily, automated backups occur.

This should be in the format of the "Time" portion of an RFC3339-formatted timestamp. Any second or sub-second time data will be truncated to zero.

At some point in the window, the system may incur a brief service disruption as the backup is performed.

MysqlDbSystemBackupPolicyCopyPolicy, MysqlDbSystemBackupPolicyCopyPolicyArgs

CopyToRegion string: (Updatable) The destination region name to which the DB system backup will be copied.
BackupCopyRetentionInDays int: (Updatable) Number of days to retain the copied DB system backup.

CopyToRegion string: (Updatable) The destination region name to which the DB system backup will be copied.
BackupCopyRetentionInDays int: (Updatable) Number of days to retain the copied DB system backup.

copyToRegion String: (Updatable) The destination region name to which the DB system backup will be copied.
backupCopyRetentionInDays Integer: (Updatable) Number of days to retain the copied DB system backup.

copyToRegion string: (Updatable) The destination region name to which the DB system backup will be copied.
backupCopyRetentionInDays number: (Updatable) Number of days to retain the copied DB system backup.

copy_to_region str: (Updatable) The destination region name to which the DB system backup will be copied.
backup_copy_retention_in_days int: (Updatable) Number of days to retain the copied DB system backup.

copyToRegion String: (Updatable) The destination region name to which the DB system backup will be copied.
backupCopyRetentionInDays Number: (Updatable) Number of days to retain the copied DB system backup.

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, string>: (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, string>: (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: Specifies if the DB System read endpoint is enabled or not.
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.
SystemTags Dictionary<string, string>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
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]string: (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]string: (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: Specifies if the DB System read endpoint is enabled or not.
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.
SystemTags map[string]string: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
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,String>: (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,String>: (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: Specifies if the DB System read endpoint is enabled or not.
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.
systemTags Map<String,String>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
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]: string}: (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]: string}: (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: Specifies if the DB System read endpoint is enabled or not.
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.
systemTags {[key: string]: string}: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
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, str]: (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, str]: (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: Specifies if the DB System read endpoint is enabled or not.
lifecycle_details str: Additional information about the current lifecycleState.
sources Sequence[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.
system_tags Mapping[str, str]: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
targets Sequence[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<String>: (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>: (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: Specifies if the DB System read endpoint is enabled or not.
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.
systemTags Map<String>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
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[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[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[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.

MysqlDbSystemCustomerContact, MysqlDbSystemCustomerContactArgs

Email string: (Updatable) The email address used by Oracle to send notifications regarding the DB System.

Email string: (Updatable) The email address used by Oracle to send notifications regarding the DB System.

email String: (Updatable) The email address used by Oracle to send notifications regarding the DB System.

email string: (Updatable) The email address used by Oracle to send notifications regarding the DB System.

email str: (Updatable) The email address used by Oracle to send notifications regarding the DB System.

email String: (Updatable) The email address used by Oracle to send notifications regarding the DB System.

MysqlDbSystemDataStorage, MysqlDbSystemDataStorageArgs

AllocatedStorageSizeInGbs int

The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.

DataStorageSizeInGb int

DataStorageSizeLimitInGbs int

The absolute limit the DB System's storage size may ever expand to, either manually or automatically. This limit is based based on the initial dataStorageSizeInGBs when the DB System was first created. Both dataStorageSizeInGBs and maxDataStorageSizeInGBs can not exceed this value.

IsAutoExpandStorageEnabled bool

(Updatable) Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.

MaxStorageSizeInGbs int

(Updatable) Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.

DB Systems with an initial storage size of 400 GB or less can be expanded up to 32 TB. DB Systems with an initial storage size between 401-800 GB can be expanded up to 64 TB. DB Systems with an initial storage size between 801-1200 GB can be expanded up to 96 TB. DB Systems with an initial storage size of 1201 GB or more can be expanded up to 128 TB.

It is not possible to decrease data storage size. You cannot set the maximum data storage size to less than either current DB System dataStorageSizeInGBs or allocatedStorageSizeInGBs.

AllocatedStorageSizeInGbs int

The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.

DataStorageSizeInGb int

DataStorageSizeLimitInGbs int

IsAutoExpandStorageEnabled bool

(Updatable) Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.

MaxStorageSizeInGbs int

(Updatable) Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.

It is not possible to decrease data storage size. You cannot set the maximum data storage size to less than either current DB System dataStorageSizeInGBs or allocatedStorageSizeInGBs.

allocatedStorageSizeInGbs Integer

The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.

dataStorageSizeInGb Integer

dataStorageSizeLimitInGbs Integer

isAutoExpandStorageEnabled Boolean

(Updatable) Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.

maxStorageSizeInGbs Integer

(Updatable) Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.

It is not possible to decrease data storage size. You cannot set the maximum data storage size to less than either current DB System dataStorageSizeInGBs or allocatedStorageSizeInGBs.

allocatedStorageSizeInGbs number

The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.

dataStorageSizeInGb number

dataStorageSizeLimitInGbs number

isAutoExpandStorageEnabled boolean

(Updatable) Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.

maxStorageSizeInGbs number

(Updatable) Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.

It is not possible to decrease data storage size. You cannot set the maximum data storage size to less than either current DB System dataStorageSizeInGBs or allocatedStorageSizeInGBs.

allocated_storage_size_in_gbs int

The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.

data_storage_size_in_gb int

data_storage_size_limit_in_gbs int

is_auto_expand_storage_enabled bool

(Updatable) Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.

max_storage_size_in_gbs int

(Updatable) Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.

It is not possible to decrease data storage size. You cannot set the maximum data storage size to less than either current DB System dataStorageSizeInGBs or allocatedStorageSizeInGBs.

allocatedStorageSizeInGbs Number

The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.

dataStorageSizeInGb Number

dataStorageSizeLimitInGbs Number

isAutoExpandStorageEnabled Boolean

(Updatable) Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.

maxStorageSizeInGbs Number

(Updatable) Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.

It is not possible to decrease data storage size. You cannot set the maximum data storage size to less than either current DB System dataStorageSizeInGBs or allocatedStorageSizeInGBs.

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.

MysqlDbSystemEncryptData, MysqlDbSystemEncryptDataArgs

KeyGenerationType string: (Updatable) Select whether to use Oracle-managed key (SYSTEM) or your own key (BYOK).
KeyId string: (Updatable) The OCID of the key to use.

KeyGenerationType string: (Updatable) Select whether to use Oracle-managed key (SYSTEM) or your own key (BYOK).
KeyId string: (Updatable) The OCID of the key to use.

keyGenerationType String: (Updatable) Select whether to use Oracle-managed key (SYSTEM) or your own key (BYOK).
keyId String: (Updatable) The OCID of the key to use.

keyGenerationType string: (Updatable) Select whether to use Oracle-managed key (SYSTEM) or your own key (BYOK).
keyId string: (Updatable) The OCID of the key to use.

key_generation_type str: (Updatable) Select whether to use Oracle-managed key (SYSTEM) or your own key (BYOK).
key_id str: (Updatable) The OCID of the key to use.

keyGenerationType String: (Updatable) Select whether to use Oracle-managed key (SYSTEM) or your own key (BYOK).
keyId String: (Updatable) The OCID of the key to use.

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.

MysqlDbSystemReadEndpoint, MysqlDbSystemReadEndpointArgs

ExcludeIps List<string>

(Updatable) A list of IP addresses of read replicas that are excluded from serving read requests.

IsEnabled bool

(Updatable) Specifies if the DB System read endpoint is enabled or not.

ReadEndpointHostnameLabel string

(Updatable) The hostname for the read 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.

ReadEndpointIpAddress string

(Updatable) The IP address the DB System read endpoint is configured to listen on. A private IP address of your choice to assign to the read 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.

ExcludeIps []string

(Updatable) A list of IP addresses of read replicas that are excluded from serving read requests.

IsEnabled bool

(Updatable) Specifies if the DB System read endpoint is enabled or not.

ReadEndpointHostnameLabel string

(Updatable) The hostname for the read 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.

ReadEndpointIpAddress string

excludeIps List<String>

(Updatable) A list of IP addresses of read replicas that are excluded from serving read requests.

isEnabled Boolean

(Updatable) Specifies if the DB System read endpoint is enabled or not.

readEndpointHostnameLabel String

(Updatable) The hostname for the read 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.

readEndpointIpAddress String

excludeIps string[]

(Updatable) A list of IP addresses of read replicas that are excluded from serving read requests.

isEnabled boolean

(Updatable) Specifies if the DB System read endpoint is enabled or not.

readEndpointHostnameLabel string

(Updatable) The hostname for the read 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.

readEndpointIpAddress string

exclude_ips Sequence[str]

(Updatable) A list of IP addresses of read replicas that are excluded from serving read requests.

is_enabled bool

(Updatable) Specifies if the DB System read endpoint is enabled or not.

read_endpoint_hostname_label str

(Updatable) The hostname for the read 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.

read_endpoint_ip_address str

excludeIps List<String>

(Updatable) A list of IP addresses of read replicas that are excluded from serving read requests.

isEnabled Boolean

(Updatable) Specifies if the DB System read endpoint is enabled or not.

readEndpointHostnameLabel String

(Updatable) The hostname for the read 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.

readEndpointIpAddress String

MysqlDbSystemRest, MysqlDbSystemRestArgs

Configuration string: (Updatable) Select how REST is configured across the DB System instances.
Port int: (Updatable) The port for REST to listen on. Supported port numbers are 443 and from 1024 to 65535.

Configuration string: (Updatable) Select how REST is configured across the DB System instances.
Port int: (Updatable) The port for REST to listen on. Supported port numbers are 443 and from 1024 to 65535.

configuration String: (Updatable) Select how REST is configured across the DB System instances.
port Integer: (Updatable) The port for REST to listen on. Supported port numbers are 443 and from 1024 to 65535.

configuration string: (Updatable) Select how REST is configured across the DB System instances.
port number: (Updatable) The port for REST to listen on. Supported port numbers are 443 and from 1024 to 65535.

configuration str: (Updatable) Select how REST is configured across the DB System instances.
port int: (Updatable) The port for REST to listen on. Supported port numbers are 443 and from 1024 to 65535.

configuration String: (Updatable) Select how REST is configured across the DB System instances.
port Number: (Updatable) The port for REST to listen on. Supported port numbers are 443 and from 1024 to 65535.

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 v3.9.0 published on Wednesday, Sep 24, 2025 by Pulumi

pulumi/pulumi-oci

oci.Mysql.MysqlDbSystem

On this page

On this page

Example Usage

Create MysqlDbSystem Resource

Constructor syntax

Parameters

Constructor example

MysqlDbSystem Resource Properties

Inputs

Outputs

Look up Existing MysqlDbSystem Resource

Supporting Types

MysqlDbSystemBackupPolicy, MysqlDbSystemBackupPolicyArgs

MysqlDbSystemBackupPolicyCopyPolicy, MysqlDbSystemBackupPolicyCopyPolicyArgs

MysqlDbSystemBackupPolicyPitrPolicy, MysqlDbSystemBackupPolicyPitrPolicyArgs

MysqlDbSystemChannel, MysqlDbSystemChannelArgs

MysqlDbSystemChannelSource, MysqlDbSystemChannelSourceArgs

MysqlDbSystemChannelSourceAnonymousTransactionsHandling, MysqlDbSystemChannelSourceAnonymousTransactionsHandlingArgs

MysqlDbSystemChannelSourceSslCaCertificate, MysqlDbSystemChannelSourceSslCaCertificateArgs

MysqlDbSystemChannelTarget, MysqlDbSystemChannelTargetArgs

MysqlDbSystemChannelTargetFilter, MysqlDbSystemChannelTargetFilterArgs

MysqlDbSystemCurrentPlacement, MysqlDbSystemCurrentPlacementArgs

MysqlDbSystemCustomerContact, MysqlDbSystemCustomerContactArgs

MysqlDbSystemDataStorage, MysqlDbSystemDataStorageArgs

MysqlDbSystemDeletionPolicy, MysqlDbSystemDeletionPolicyArgs

MysqlDbSystemEncryptData, MysqlDbSystemEncryptDataArgs

MysqlDbSystemEndpoint, MysqlDbSystemEndpointArgs

MysqlDbSystemHeatWaveCluster, MysqlDbSystemHeatWaveClusterArgs

MysqlDbSystemMaintenance, MysqlDbSystemMaintenanceArgs

MysqlDbSystemPointInTimeRecoveryDetail, MysqlDbSystemPointInTimeRecoveryDetailArgs

MysqlDbSystemReadEndpoint, MysqlDbSystemReadEndpointArgs

MysqlDbSystemRest, MysqlDbSystemRestArgs

MysqlDbSystemSecureConnections, MysqlDbSystemSecureConnectionsArgs

MysqlDbSystemSource, MysqlDbSystemSourceArgs

Import

Package Details

On this page

On this page