oci.Mysql.MysqlDbSystem
Explore with Pulumi AI
This resource provides the Mysql Db System resource in Oracle Cloud Infrastructure MySQL Database service.
Creates and launches a DB System.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testMysqlDbSystem = new oci.mysql.MysqlDbSystem("test_mysql_db_system", {
availabilityDomain: mysqlDbSystemAvailabilityDomain,
compartmentId: compartmentId,
shapeName: mysqlShapeName,
subnetId: testSubnet.id,
adminPassword: mysqlDbSystemAdminPassword,
adminUsername: mysqlDbSystemAdminUsername,
backupPolicy: {
definedTags: {
"foo-namespace.bar-key": "value",
},
freeformTags: {
"bar-key": "value",
},
isEnabled: mysqlDbSystemBackupPolicyIsEnabled,
pitrPolicy: {
isEnabled: mysqlDbSystemBackupPolicyPitrPolicyIsEnabled,
},
retentionInDays: mysqlDbSystemBackupPolicyRetentionInDays,
windowStartTime: mysqlDbSystemBackupPolicyWindowStartTime,
},
configurationId: testConfiguration.id,
crashRecovery: mysqlDbSystemCrashRecovery,
customerContacts: [{
email: mysqlDbSystemCustomerContactsEmail,
}],
dataStorage: {
isAutoExpandStorageEnabled: mysqlDbSystemDataStorageIsAutoExpandStorageEnabled,
maxStorageSizeInGbs: mysqlDbSystemDataStorageMaxStorageSizeInGbs,
},
dataStorageSizeInGb: mysqlDbSystemDataStorageSizeInGb,
databaseManagement: mysqlDbSystemDatabaseManagement,
definedTags: {
"foo-namespace.bar-key": "value",
},
deletionPolicies: [{
automaticBackupRetention: mysqlDbSystemDeletionPolicyAutomaticBackupRetention,
finalBackup: mysqlDbSystemDeletionPolicyFinalBackup,
isDeleteProtected: mysqlDbSystemDeletionPolicyIsDeleteProtected,
}],
description: mysqlDbSystemDescription,
displayName: mysqlDbSystemDisplayName,
faultDomain: mysqlDbSystemFaultDomain,
freeformTags: {
"bar-key": "value",
},
hostnameLabel: mysqlDbSystemHostnameLabel,
ipAddress: mysqlDbSystemIpAddress,
isHighlyAvailable: mysqlDbSystemIsHighlyAvailable,
maintenance: {
windowStartTime: mysqlDbSystemMaintenanceWindowStartTime,
},
port: mysqlDbSystemPort,
portX: mysqlDbSystemPortX,
secureConnections: {
certificateGenerationType: mysqlDbSystemSecureConnectionsCertificateGenerationType,
certificateId: testCertificate.id,
},
source: {
sourceType: mysqlDbSystemSourceSourceType,
backupId: testBackup.id,
},
});
import pulumi
import pulumi_oci as oci
test_mysql_db_system = oci.mysql.MysqlDbSystem("test_mysql_db_system",
availability_domain=mysql_db_system_availability_domain,
compartment_id=compartment_id,
shape_name=mysql_shape_name,
subnet_id=test_subnet["id"],
admin_password=mysql_db_system_admin_password,
admin_username=mysql_db_system_admin_username,
backup_policy={
"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,
"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,
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,
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,
},
port=mysql_db_system_port,
port_x=mysql_db_system_port_x,
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/v2/go/oci/Mysql"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := Mysql.NewMysqlDbSystem(ctx, "test_mysql_db_system", &Mysql.MysqlDbSystemArgs{
AvailabilityDomain: pulumi.Any(mysqlDbSystemAvailabilityDomain),
CompartmentId: pulumi.Any(compartmentId),
ShapeName: pulumi.Any(mysqlShapeName),
SubnetId: pulumi.Any(testSubnet.Id),
AdminPassword: pulumi.Any(mysqlDbSystemAdminPassword),
AdminUsername: pulumi.Any(mysqlDbSystemAdminUsername),
BackupPolicy: &mysql.MysqlDbSystemBackupPolicyArgs{
DefinedTags: pulumi.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),
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),
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),
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),
},
Port: pulumi.Any(mysqlDbSystemPort),
PortX: pulumi.Any(mysqlDbSystemPortX),
SecureConnections: &mysql.MysqlDbSystemSecureConnectionsArgs{
CertificateGenerationType: pulumi.Any(mysqlDbSystemSecureConnectionsCertificateGenerationType),
CertificateId: pulumi.Any(testCertificate.Id),
},
Source: &mysql.MysqlDbSystemSourceArgs{
SourceType: pulumi.Any(mysqlDbSystemSourceSourceType),
BackupId: pulumi.Any(testBackup.Id),
},
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;
return await Deployment.RunAsync(() =>
{
var testMysqlDbSystem = new Oci.Mysql.MysqlDbSystem("test_mysql_db_system", new()
{
AvailabilityDomain = mysqlDbSystemAvailabilityDomain,
CompartmentId = compartmentId,
ShapeName = mysqlShapeName,
SubnetId = testSubnet.Id,
AdminPassword = mysqlDbSystemAdminPassword,
AdminUsername = mysqlDbSystemAdminUsername,
BackupPolicy = new Oci.Mysql.Inputs.MysqlDbSystemBackupPolicyArgs
{
DefinedTags =
{
{ "foo-namespace.bar-key", "value" },
},
FreeformTags =
{
{ "bar-key", "value" },
},
IsEnabled = mysqlDbSystemBackupPolicyIsEnabled,
PitrPolicy = new Oci.Mysql.Inputs.MysqlDbSystemBackupPolicyPitrPolicyArgs
{
IsEnabled = mysqlDbSystemBackupPolicyPitrPolicyIsEnabled,
},
RetentionInDays = mysqlDbSystemBackupPolicyRetentionInDays,
WindowStartTime = mysqlDbSystemBackupPolicyWindowStartTime,
},
ConfigurationId = testConfiguration.Id,
CrashRecovery = mysqlDbSystemCrashRecovery,
CustomerContacts = new[]
{
new Oci.Mysql.Inputs.MysqlDbSystemCustomerContactArgs
{
Email = mysqlDbSystemCustomerContactsEmail,
},
},
DataStorage = new Oci.Mysql.Inputs.MysqlDbSystemDataStorageArgs
{
IsAutoExpandStorageEnabled = mysqlDbSystemDataStorageIsAutoExpandStorageEnabled,
MaxStorageSizeInGbs = mysqlDbSystemDataStorageMaxStorageSizeInGbs,
},
DataStorageSizeInGb = mysqlDbSystemDataStorageSizeInGb,
DatabaseManagement = mysqlDbSystemDatabaseManagement,
DefinedTags =
{
{ "foo-namespace.bar-key", "value" },
},
DeletionPolicies = new[]
{
new Oci.Mysql.Inputs.MysqlDbSystemDeletionPolicyArgs
{
AutomaticBackupRetention = mysqlDbSystemDeletionPolicyAutomaticBackupRetention,
FinalBackup = mysqlDbSystemDeletionPolicyFinalBackup,
IsDeleteProtected = mysqlDbSystemDeletionPolicyIsDeleteProtected,
},
},
Description = mysqlDbSystemDescription,
DisplayName = mysqlDbSystemDisplayName,
FaultDomain = mysqlDbSystemFaultDomain,
FreeformTags =
{
{ "bar-key", "value" },
},
HostnameLabel = mysqlDbSystemHostnameLabel,
IpAddress = mysqlDbSystemIpAddress,
IsHighlyAvailable = mysqlDbSystemIsHighlyAvailable,
Maintenance = new Oci.Mysql.Inputs.MysqlDbSystemMaintenanceArgs
{
WindowStartTime = mysqlDbSystemMaintenanceWindowStartTime,
},
Port = mysqlDbSystemPort,
PortX = mysqlDbSystemPortX,
SecureConnections = new Oci.Mysql.Inputs.MysqlDbSystemSecureConnectionsArgs
{
CertificateGenerationType = mysqlDbSystemSecureConnectionsCertificateGenerationType,
CertificateId = testCertificate.Id,
},
Source = new Oci.Mysql.Inputs.MysqlDbSystemSourceArgs
{
SourceType = mysqlDbSystemSourceSourceType,
BackupId = testBackup.Id,
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Mysql.MysqlDbSystem;
import com.pulumi.oci.Mysql.MysqlDbSystemArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemBackupPolicyArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemBackupPolicyPitrPolicyArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemCustomerContactArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemDataStorageArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemDeletionPolicyArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemMaintenanceArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemSecureConnectionsArgs;
import com.pulumi.oci.Mysql.inputs.MysqlDbSystemSourceArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var testMysqlDbSystem = new MysqlDbSystem("testMysqlDbSystem", MysqlDbSystemArgs.builder()
.availabilityDomain(mysqlDbSystemAvailabilityDomain)
.compartmentId(compartmentId)
.shapeName(mysqlShapeName)
.subnetId(testSubnet.id())
.adminPassword(mysqlDbSystemAdminPassword)
.adminUsername(mysqlDbSystemAdminUsername)
.backupPolicy(MysqlDbSystemBackupPolicyArgs.builder()
.definedTags(Map.of("foo-namespace.bar-key", "value"))
.freeformTags(Map.of("bar-key", "value"))
.isEnabled(mysqlDbSystemBackupPolicyIsEnabled)
.pitrPolicy(MysqlDbSystemBackupPolicyPitrPolicyArgs.builder()
.isEnabled(mysqlDbSystemBackupPolicyPitrPolicyIsEnabled)
.build())
.retentionInDays(mysqlDbSystemBackupPolicyRetentionInDays)
.windowStartTime(mysqlDbSystemBackupPolicyWindowStartTime)
.build())
.configurationId(testConfiguration.id())
.crashRecovery(mysqlDbSystemCrashRecovery)
.customerContacts(MysqlDbSystemCustomerContactArgs.builder()
.email(mysqlDbSystemCustomerContactsEmail)
.build())
.dataStorage(MysqlDbSystemDataStorageArgs.builder()
.isAutoExpandStorageEnabled(mysqlDbSystemDataStorageIsAutoExpandStorageEnabled)
.maxStorageSizeInGbs(mysqlDbSystemDataStorageMaxStorageSizeInGbs)
.build())
.dataStorageSizeInGb(mysqlDbSystemDataStorageSizeInGb)
.databaseManagement(mysqlDbSystemDatabaseManagement)
.definedTags(Map.of("foo-namespace.bar-key", "value"))
.deletionPolicies(MysqlDbSystemDeletionPolicyArgs.builder()
.automaticBackupRetention(mysqlDbSystemDeletionPolicyAutomaticBackupRetention)
.finalBackup(mysqlDbSystemDeletionPolicyFinalBackup)
.isDeleteProtected(mysqlDbSystemDeletionPolicyIsDeleteProtected)
.build())
.description(mysqlDbSystemDescription)
.displayName(mysqlDbSystemDisplayName)
.faultDomain(mysqlDbSystemFaultDomain)
.freeformTags(Map.of("bar-key", "value"))
.hostnameLabel(mysqlDbSystemHostnameLabel)
.ipAddress(mysqlDbSystemIpAddress)
.isHighlyAvailable(mysqlDbSystemIsHighlyAvailable)
.maintenance(MysqlDbSystemMaintenanceArgs.builder()
.windowStartTime(mysqlDbSystemMaintenanceWindowStartTime)
.build())
.port(mysqlDbSystemPort)
.portX(mysqlDbSystemPortX)
.secureConnections(MysqlDbSystemSecureConnectionsArgs.builder()
.certificateGenerationType(mysqlDbSystemSecureConnectionsCertificateGenerationType)
.certificateId(testCertificate.id())
.build())
.source(MysqlDbSystemSourceArgs.builder()
.sourceType(mysqlDbSystemSourceSourceType)
.backupId(testBackup.id())
.build())
.build());
}
}
resources:
testMysqlDbSystem:
type: oci:Mysql:MysqlDbSystem
name: test_mysql_db_system
properties:
availabilityDomain: ${mysqlDbSystemAvailabilityDomain}
compartmentId: ${compartmentId}
shapeName: ${mysqlShapeName}
subnetId: ${testSubnet.id}
adminPassword: ${mysqlDbSystemAdminPassword}
adminUsername: ${mysqlDbSystemAdminUsername}
backupPolicy:
definedTags:
foo-namespace.bar-key: value
freeformTags:
bar-key: value
isEnabled: ${mysqlDbSystemBackupPolicyIsEnabled}
pitrPolicy:
isEnabled: ${mysqlDbSystemBackupPolicyPitrPolicyIsEnabled}
retentionInDays: ${mysqlDbSystemBackupPolicyRetentionInDays}
windowStartTime: ${mysqlDbSystemBackupPolicyWindowStartTime}
configurationId: ${testConfiguration.id}
crashRecovery: ${mysqlDbSystemCrashRecovery}
customerContacts:
- email: ${mysqlDbSystemCustomerContactsEmail}
dataStorage:
isAutoExpandStorageEnabled: ${mysqlDbSystemDataStorageIsAutoExpandStorageEnabled}
maxStorageSizeInGbs: ${mysqlDbSystemDataStorageMaxStorageSizeInGbs}
dataStorageSizeInGb: ${mysqlDbSystemDataStorageSizeInGb}
databaseManagement: ${mysqlDbSystemDatabaseManagement}
definedTags:
foo-namespace.bar-key: value
deletionPolicies:
- automaticBackupRetention: ${mysqlDbSystemDeletionPolicyAutomaticBackupRetention}
finalBackup: ${mysqlDbSystemDeletionPolicyFinalBackup}
isDeleteProtected: ${mysqlDbSystemDeletionPolicyIsDeleteProtected}
description: ${mysqlDbSystemDescription}
displayName: ${mysqlDbSystemDisplayName}
faultDomain: ${mysqlDbSystemFaultDomain}
freeformTags:
bar-key: value
hostnameLabel: ${mysqlDbSystemHostnameLabel}
ipAddress: ${mysqlDbSystemIpAddress}
isHighlyAvailable: ${mysqlDbSystemIsHighlyAvailable}
maintenance:
windowStartTime: ${mysqlDbSystemMaintenanceWindowStartTime}
port: ${mysqlDbSystemPort}
portX: ${mysqlDbSystemPortX}
secureConnections:
certificateGenerationType: ${mysqlDbSystemSecureConnectionsCertificateGenerationType}
certificateId: ${testCertificate.id}
source:
sourceType: ${mysqlDbSystemSourceSourceType}
backupId: ${testBackup.id}
Create MysqlDbSystem Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new MysqlDbSystem(name: string, args: MysqlDbSystemArgs, opts?: CustomResourceOptions);
@overload
def MysqlDbSystem(resource_name: str,
args: MysqlDbSystemArgs,
opts: Optional[ResourceOptions] = None)
@overload
def MysqlDbSystem(resource_name: str,
opts: Optional[ResourceOptions] = None,
compartment_id: Optional[str] = None,
subnet_id: Optional[str] = None,
availability_domain: Optional[str] = None,
shape_name: Optional[str] = None,
display_name: Optional[str] = None,
hostname_label: Optional[str] = None,
crash_recovery: Optional[str] = None,
customer_contacts: Optional[Sequence[_mysql.MysqlDbSystemCustomerContactArgs]] = None,
data_storage: Optional[_mysql.MysqlDbSystemDataStorageArgs] = None,
data_storage_size_in_gb: Optional[int] = None,
database_management: Optional[str] = None,
defined_tags: Optional[Mapping[str, str]] = None,
deletion_policies: Optional[Sequence[_mysql.MysqlDbSystemDeletionPolicyArgs]] = None,
description: Optional[str] = None,
admin_password: Optional[str] = None,
fault_domain: Optional[str] = None,
freeform_tags: Optional[Mapping[str, str]] = None,
configuration_id: Optional[str] = None,
ip_address: Optional[str] = None,
is_highly_available: Optional[bool] = None,
maintenance: Optional[_mysql.MysqlDbSystemMaintenanceArgs] = None,
mysql_version: Optional[str] = None,
port: Optional[int] = None,
port_x: Optional[int] = None,
secure_connections: Optional[_mysql.MysqlDbSystemSecureConnectionsArgs] = None,
backup_policy: Optional[_mysql.MysqlDbSystemBackupPolicyArgs] = None,
shutdown_type: Optional[str] = None,
source: Optional[_mysql.MysqlDbSystemSourceArgs] = None,
state: Optional[str] = None,
admin_username: Optional[str] = None)
func NewMysqlDbSystem(ctx *Context, name string, args MysqlDbSystemArgs, opts ...ResourceOption) (*MysqlDbSystem, error)
public MysqlDbSystem(string name, MysqlDbSystemArgs args, CustomResourceOptions? opts = null)
public MysqlDbSystem(String name, MysqlDbSystemArgs args)
public MysqlDbSystem(String name, MysqlDbSystemArgs args, CustomResourceOptions options)
type: oci:Mysql:MysqlDbSystem
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name string
- The unique name of the resource.
- args MysqlDbSystemArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args MysqlDbSystemArgs
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args MysqlDbSystemArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args MysqlDbSystemArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args MysqlDbSystemArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
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",
AvailabilityDomain = "string",
ShapeName = "string",
DisplayName = "string",
HostnameLabel = "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",
DefinedTags =
{
{ "string", "string" },
},
DeletionPolicies = new[]
{
new Oci.Mysql.Inputs.MysqlDbSystemDeletionPolicyArgs
{
AutomaticBackupRetention = "string",
FinalBackup = "string",
IsDeleteProtected = false,
},
},
Description = "string",
AdminPassword = "string",
FaultDomain = "string",
FreeformTags =
{
{ "string", "string" },
},
ConfigurationId = "string",
IpAddress = "string",
IsHighlyAvailable = false,
Maintenance = new Oci.Mysql.Inputs.MysqlDbSystemMaintenanceArgs
{
WindowStartTime = "string",
},
MysqlVersion = "string",
Port = 0,
PortX = 0,
SecureConnections = new Oci.Mysql.Inputs.MysqlDbSystemSecureConnectionsArgs
{
CertificateGenerationType = "string",
CertificateId = "string",
},
BackupPolicy = new Oci.Mysql.Inputs.MysqlDbSystemBackupPolicyArgs
{
DefinedTags =
{
{ "string", "string" },
},
FreeformTags =
{
{ "string", "string" },
},
IsEnabled = false,
PitrPolicy = new Oci.Mysql.Inputs.MysqlDbSystemBackupPolicyPitrPolicyArgs
{
IsEnabled = false,
},
RetentionInDays = 0,
WindowStartTime = "string",
},
ShutdownType = "string",
Source = new Oci.Mysql.Inputs.MysqlDbSystemSourceArgs
{
SourceType = "string",
BackupId = "string",
DbSystemId = "string",
RecoveryPoint = "string",
SourceUrl = "string",
},
State = "string",
AdminUsername = "string",
});
example, err := Mysql.NewMysqlDbSystem(ctx, "mysqlDbSystemResource", &Mysql.MysqlDbSystemArgs{
CompartmentId: pulumi.String("string"),
SubnetId: pulumi.String("string"),
AvailabilityDomain: pulumi.String("string"),
ShapeName: pulumi.String("string"),
DisplayName: pulumi.String("string"),
HostnameLabel: 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"),
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"),
AdminPassword: pulumi.String("string"),
FaultDomain: pulumi.String("string"),
FreeformTags: pulumi.StringMap{
"string": pulumi.String("string"),
},
ConfigurationId: pulumi.String("string"),
IpAddress: pulumi.String("string"),
IsHighlyAvailable: pulumi.Bool(false),
Maintenance: &mysql.MysqlDbSystemMaintenanceArgs{
WindowStartTime: pulumi.String("string"),
},
MysqlVersion: pulumi.String("string"),
Port: pulumi.Int(0),
PortX: pulumi.Int(0),
SecureConnections: &mysql.MysqlDbSystemSecureConnectionsArgs{
CertificateGenerationType: pulumi.String("string"),
CertificateId: pulumi.String("string"),
},
BackupPolicy: &mysql.MysqlDbSystemBackupPolicyArgs{
DefinedTags: pulumi.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),
WindowStartTime: pulumi.String("string"),
},
ShutdownType: pulumi.String("string"),
Source: &mysql.MysqlDbSystemSourceArgs{
SourceType: pulumi.String("string"),
BackupId: pulumi.String("string"),
DbSystemId: pulumi.String("string"),
RecoveryPoint: pulumi.String("string"),
SourceUrl: pulumi.String("string"),
},
State: pulumi.String("string"),
AdminUsername: pulumi.String("string"),
})
var mysqlDbSystemResource = new MysqlDbSystem("mysqlDbSystemResource", MysqlDbSystemArgs.builder()
.compartmentId("string")
.subnetId("string")
.availabilityDomain("string")
.shapeName("string")
.displayName("string")
.hostnameLabel("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")
.definedTags(Map.of("string", "string"))
.deletionPolicies(MysqlDbSystemDeletionPolicyArgs.builder()
.automaticBackupRetention("string")
.finalBackup("string")
.isDeleteProtected(false)
.build())
.description("string")
.adminPassword("string")
.faultDomain("string")
.freeformTags(Map.of("string", "string"))
.configurationId("string")
.ipAddress("string")
.isHighlyAvailable(false)
.maintenance(MysqlDbSystemMaintenanceArgs.builder()
.windowStartTime("string")
.build())
.mysqlVersion("string")
.port(0)
.portX(0)
.secureConnections(MysqlDbSystemSecureConnectionsArgs.builder()
.certificateGenerationType("string")
.certificateId("string")
.build())
.backupPolicy(MysqlDbSystemBackupPolicyArgs.builder()
.definedTags(Map.of("string", "string"))
.freeformTags(Map.of("string", "string"))
.isEnabled(false)
.pitrPolicy(MysqlDbSystemBackupPolicyPitrPolicyArgs.builder()
.isEnabled(false)
.build())
.retentionInDays(0)
.windowStartTime("string")
.build())
.shutdownType("string")
.source(MysqlDbSystemSourceArgs.builder()
.sourceType("string")
.backupId("string")
.dbSystemId("string")
.recoveryPoint("string")
.sourceUrl("string")
.build())
.state("string")
.adminUsername("string")
.build());
mysql_db_system_resource = oci.mysql.MysqlDbSystem("mysqlDbSystemResource",
compartment_id="string",
subnet_id="string",
availability_domain="string",
shape_name="string",
display_name="string",
hostname_label="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",
defined_tags={
"string": "string",
},
deletion_policies=[{
"automatic_backup_retention": "string",
"final_backup": "string",
"is_delete_protected": False,
}],
description="string",
admin_password="string",
fault_domain="string",
freeform_tags={
"string": "string",
},
configuration_id="string",
ip_address="string",
is_highly_available=False,
maintenance={
"window_start_time": "string",
},
mysql_version="string",
port=0,
port_x=0,
secure_connections={
"certificate_generation_type": "string",
"certificate_id": "string",
},
backup_policy={
"defined_tags": {
"string": "string",
},
"freeform_tags": {
"string": "string",
},
"is_enabled": False,
"pitr_policy": {
"is_enabled": False,
},
"retention_in_days": 0,
"window_start_time": "string",
},
shutdown_type="string",
source={
"source_type": "string",
"backup_id": "string",
"db_system_id": "string",
"recovery_point": "string",
"source_url": "string",
},
state="string",
admin_username="string")
const mysqlDbSystemResource = new oci.mysql.MysqlDbSystem("mysqlDbSystemResource", {
compartmentId: "string",
subnetId: "string",
availabilityDomain: "string",
shapeName: "string",
displayName: "string",
hostnameLabel: "string",
crashRecovery: "string",
customerContacts: [{
email: "string",
}],
dataStorage: {
allocatedStorageSizeInGbs: 0,
dataStorageSizeInGb: 0,
dataStorageSizeLimitInGbs: 0,
isAutoExpandStorageEnabled: false,
maxStorageSizeInGbs: 0,
},
dataStorageSizeInGb: 0,
databaseManagement: "string",
definedTags: {
string: "string",
},
deletionPolicies: [{
automaticBackupRetention: "string",
finalBackup: "string",
isDeleteProtected: false,
}],
description: "string",
adminPassword: "string",
faultDomain: "string",
freeformTags: {
string: "string",
},
configurationId: "string",
ipAddress: "string",
isHighlyAvailable: false,
maintenance: {
windowStartTime: "string",
},
mysqlVersion: "string",
port: 0,
portX: 0,
secureConnections: {
certificateGenerationType: "string",
certificateId: "string",
},
backupPolicy: {
definedTags: {
string: "string",
},
freeformTags: {
string: "string",
},
isEnabled: false,
pitrPolicy: {
isEnabled: false,
},
retentionInDays: 0,
windowStartTime: "string",
},
shutdownType: "string",
source: {
sourceType: "string",
backupId: "string",
dbSystemId: "string",
recoveryPoint: "string",
sourceUrl: "string",
},
state: "string",
adminUsername: "string",
});
type: oci:Mysql:MysqlDbSystem
properties:
adminPassword: string
adminUsername: string
availabilityDomain: string
backupPolicy:
definedTags:
string: string
freeformTags:
string: string
isEnabled: false
pitrPolicy:
isEnabled: false
retentionInDays: 0
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
definedTags:
string: string
deletionPolicies:
- automaticBackupRetention: string
finalBackup: string
isDeleteProtected: false
description: string
displayName: string
faultDomain: string
freeformTags:
string: string
hostnameLabel: string
ipAddress: string
isHighlyAvailable: false
maintenance:
windowStartTime: string
mysqlVersion: string
port: 0
portX: 0
secureConnections:
certificateGenerationType: string
certificateId: string
shapeName: string
shutdownType: string
source:
backupId: string
dbSystemId: string
recoveryPoint: string
sourceType: string
sourceUrl: string
state: string
subnetId: string
MysqlDbSystem Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
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:
- Availability
Domain 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.
- Compartment
Id string - The OCID of the compartment.
- Shape
Name 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.
- Subnet
Id string - The OCID of the subnet the DB System is associated with.
- Admin
Password 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.
- Admin
Username string - The username for the administrative user.
- Backup
Policy MysqlDb System Backup Policy - (Updatable) Backup policy as optionally used for DB System Creation.
- Configuration
Id string - (Updatable) The OCID of the Configuration to be used for this DB System.
- Crash
Recovery 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.
- Customer
Contacts List<MysqlDb System Customer Contact> - (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.
- Data
Storage MysqlDb System Data Storage - (Updatable) Data Storage configuration properties.
- Data
Storage intSize In Gb - (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.
- Database
Management string - (Updatable) Whether to enable monitoring via the Database Management service.
- Dictionary<string, string>
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- Deletion
Policies List<MysqlDb System Deletion Policy> - (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.
- Display
Name string - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- Fault
Domain 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.
- 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"}
- Hostname
Label 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.
- Ip
Address 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.
- Is
Highly boolAvailable (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
Mysql
Db System Maintenance - (Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in.
maintenance
andbackup_policy
cannot be updated in the same request. - Mysql
Version string - The specific MySQL version identifier.
- Port int
- The port for primary endpoint of the DB System to listen on.
- Port
X int - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- Secure
Connections MysqlDb System Secure Connections - (Updatable) Secure connection configuration details.
- Shutdown
Type string It is applicable only for stopping a DB System. Could be set to
FAST
,SLOW
orIMMEDIATE
. Default value isFAST
.** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
- Source
Mysql
Db System Source - 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
orINACTIVE
.
- Availability
Domain 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.
- Compartment
Id string - The OCID of the compartment.
- Shape
Name 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.
- Subnet
Id string - The OCID of the subnet the DB System is associated with.
- Admin
Password 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.
- Admin
Username string - The username for the administrative user.
- Backup
Policy MysqlDb System Backup Policy Args - (Updatable) Backup policy as optionally used for DB System Creation.
- Configuration
Id string - (Updatable) The OCID of the Configuration to be used for this DB System.
- Crash
Recovery 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.
- Customer
Contacts []MysqlDb System Customer Contact Args - (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.
- Data
Storage MysqlDb System Data Storage Args - (Updatable) Data Storage configuration properties.
- Data
Storage intSize In Gb - (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.
- Database
Management string - (Updatable) Whether to enable monitoring via the Database Management service.
- map[string]string
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- Deletion
Policies []MysqlDb System Deletion Policy Args - (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.
- Display
Name string - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- Fault
Domain 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.
- 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"}
- Hostname
Label 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.
- Ip
Address 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.
- Is
Highly boolAvailable (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
Mysql
Db System Maintenance Args - (Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in.
maintenance
andbackup_policy
cannot be updated in the same request. - Mysql
Version string - The specific MySQL version identifier.
- Port int
- The port for primary endpoint of the DB System to listen on.
- Port
X int - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- Secure
Connections MysqlDb System Secure Connections Args - (Updatable) Secure connection configuration details.
- Shutdown
Type string It is applicable only for stopping a DB System. Could be set to
FAST
,SLOW
orIMMEDIATE
. Default value isFAST
.** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
- Source
Mysql
Db System Source Args - 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
orINACTIVE
.
- availability
Domain 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.
- compartment
Id String - The OCID of the compartment.
- shape
Name 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.
- subnet
Id String - The OCID of the subnet the DB System is associated with.
- admin
Password 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.
- admin
Username String - The username for the administrative user.
- backup
Policy DbSystem Backup Policy - (Updatable) Backup policy as optionally used for DB System Creation.
- configuration
Id String - (Updatable) The OCID of the Configuration to be used for this DB System.
- crash
Recovery 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.
- customer
Contacts List<DbSystem Customer Contact> - (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.
- data
Storage DbSystem Data Storage - (Updatable) Data Storage configuration properties.
- data
Storage IntegerSize In Gb - (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.
- database
Management String - (Updatable) Whether to enable monitoring via the Database Management service.
- Map<String,String>
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- deletion
Policies List<DbSystem Deletion Policy> - (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.
- display
Name String - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- fault
Domain 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.
- 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"}
- hostname
Label 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.
- ip
Address 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.
- is
Highly BooleanAvailable (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
Db
System Maintenance - (Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in.
maintenance
andbackup_policy
cannot be updated in the same request. - mysql
Version String - The specific MySQL version identifier.
- port Integer
- The port for primary endpoint of the DB System to listen on.
- port
X Integer - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- secure
Connections DbSystem Secure Connections - (Updatable) Secure connection configuration details.
- shutdown
Type String It is applicable only for stopping a DB System. Could be set to
FAST
,SLOW
orIMMEDIATE
. Default value isFAST
.** 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
Db
System Source - 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
orINACTIVE
.
- availability
Domain 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.
- compartment
Id string - The OCID of the compartment.
- shape
Name 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.
- subnet
Id string - The OCID of the subnet the DB System is associated with.
- admin
Password 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.
- admin
Username string - The username for the administrative user.
- backup
Policy MysqlDb System Backup Policy - (Updatable) Backup policy as optionally used for DB System Creation.
- configuration
Id string - (Updatable) The OCID of the Configuration to be used for this DB System.
- crash
Recovery 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.
- customer
Contacts MysqlDb System Customer Contact[] - (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.
- data
Storage MysqlDb System Data Storage - (Updatable) Data Storage configuration properties.
- data
Storage numberSize In Gb - (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.
- database
Management string - (Updatable) Whether to enable monitoring via the Database Management service.
- {[key: string]: string}
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- deletion
Policies MysqlDb System Deletion Policy[] - (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.
- display
Name string - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- fault
Domain 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.
- {[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"}
- hostname
Label 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.
- ip
Address 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.
- is
Highly booleanAvailable (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
Mysql
Db System Maintenance - (Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in.
maintenance
andbackup_policy
cannot be updated in the same request. - mysql
Version string - The specific MySQL version identifier.
- port number
- The port for primary endpoint of the DB System to listen on.
- port
X number - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- secure
Connections MysqlDb System Secure Connections - (Updatable) Secure connection configuration details.
- shutdown
Type string It is applicable only for stopping a DB System. Could be set to
FAST
,SLOW
orIMMEDIATE
. Default value isFAST
.** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
- source
Mysql
Db System Source - 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
orINACTIVE
.
- availability_
domain str 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.
- compartment_
id str - The OCID of the compartment.
- shape_
name str - (Updatable) The name of the shape. The shape determines the resources allocated
- CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use the ListShapes operation.
- subnet_
id str - The OCID of the subnet the DB System is associated with.
- admin_
password str - 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.
- admin_
username str - The username for the administrative user.
- backup_
policy mysql.Mysql Db System Backup Policy Args - (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[mysql.Mysql Db System Customer Contact Args] - (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.
- data_
storage mysql.Mysql Db System Data Storage Args - (Updatable) Data Storage configuration properties.
- data_
storage_ intsize_ in_ gb - (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.
- database_
management str - (Updatable) Whether to enable monitoring via the Database Management service.
- 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[mysql.Mysql Db System Deletion Policy Args] - (Updatable) Policy for how the DB System and related resources should be handled at the time of its deletion.
- description str
- (Updatable) User-provided data about the DB System.
- display_
name str - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- fault_
domain str The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
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.
- 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 - 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.
- is_
highly_ boolavailable (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
mysql.
Mysql Db System Maintenance Args - (Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in.
maintenance
andbackup_policy
cannot be updated in the same request. - mysql_
version str - The specific MySQL version identifier.
- port int
- The port for primary endpoint of the DB System to listen on.
- port_
x int - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- secure_
connections mysql.Mysql Db System Secure Connections Args - (Updatable) Secure connection configuration details.
- shutdown_
type str It is applicable only for stopping a DB System. Could be set to
FAST
,SLOW
orIMMEDIATE
. Default value isFAST
.** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
- source
mysql.
Mysql Db System Source Args - 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
orINACTIVE
.
- availability
Domain 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.
- compartment
Id String - The OCID of the compartment.
- shape
Name 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.
- subnet
Id String - The OCID of the subnet the DB System is associated with.
- admin
Password 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.
- admin
Username String - The username for the administrative user.
- backup
Policy Property Map - (Updatable) Backup policy as optionally used for DB System Creation.
- configuration
Id String - (Updatable) The OCID of the Configuration to be used for this DB System.
- crash
Recovery 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.
- customer
Contacts List<Property Map> - (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.
- data
Storage Property Map - (Updatable) Data Storage configuration properties.
- data
Storage NumberSize In Gb - (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.
- database
Management String - (Updatable) Whether to enable monitoring via the Database Management service.
- Map<String>
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- deletion
Policies 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.
- display
Name String - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- fault
Domain 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.
- Map<String>
- (Updatable) Simple key-value pair applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- hostname
Label 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.
- ip
Address 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.
- is
Highly BooleanAvailable (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 Property Map
- (Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in.
maintenance
andbackup_policy
cannot be updated in the same request. - mysql
Version String - The specific MySQL version identifier.
- port Number
- The port for primary endpoint of the DB System to listen on.
- port
X Number - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- secure
Connections Property Map - (Updatable) Secure connection configuration details.
- shutdown
Type String It is applicable only for stopping a DB System. Could be set to
FAST
,SLOW
orIMMEDIATE
. Default value isFAST
.** 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
orINACTIVE
.
Outputs
All input properties are implicitly available as output properties. Additionally, the MysqlDbSystem resource produces the following output properties:
- Channels
List<Mysql
Db System Channel> - A list with a summary of all the Channels attached to the DB System.
- Current
Placements List<MysqlDb System Current Placement> - The availability domain and fault domain a DB System is placed in.
- Endpoints
List<Mysql
Db System Endpoint> - The network endpoints available for this DB System.
- Heat
Wave List<MysqlClusters Db System Heat Wave Cluster> - A summary of a HeatWave cluster.
- Id string
- The provider-assigned unique ID for this managed resource.
- Is
Heat boolWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- Lifecycle
Details string - Additional information about the current lifecycleState.
- Point
In List<MysqlTime Recovery Details Db System Point In Time Recovery Detail> - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- Time
Created string - The date and time the DB System was created.
- Time
Updated string - The time the DB System was last updated.
- Channels
[]Mysql
Db System Channel - A list with a summary of all the Channels attached to the DB System.
- Current
Placements []MysqlDb System Current Placement - The availability domain and fault domain a DB System is placed in.
- Endpoints
[]Mysql
Db System Endpoint - The network endpoints available for this DB System.
- Heat
Wave []MysqlClusters Db System Heat Wave Cluster - A summary of a HeatWave cluster.
- Id string
- The provider-assigned unique ID for this managed resource.
- Is
Heat boolWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- Lifecycle
Details string - Additional information about the current lifecycleState.
- Point
In []MysqlTime Recovery Details Db System Point In Time Recovery Detail - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- Time
Created string - The date and time the DB System was created.
- Time
Updated string - The time the DB System was last updated.
- channels
List<Db
System Channel> - A list with a summary of all the Channels attached to the DB System.
- current
Placements List<DbSystem Current Placement> - The availability domain and fault domain a DB System is placed in.
- endpoints
List<Db
System Endpoint> - The network endpoints available for this DB System.
- heat
Wave List<DbClusters System Heat Wave Cluster> - A summary of a HeatWave cluster.
- id String
- The provider-assigned unique ID for this managed resource.
- is
Heat BooleanWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- lifecycle
Details String - Additional information about the current lifecycleState.
- point
In List<DbTime Recovery Details System Point In Time Recovery Detail> - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- time
Created String - The date and time the DB System was created.
- time
Updated String - The time the DB System was last updated.
- channels
Mysql
Db System Channel[] - A list with a summary of all the Channels attached to the DB System.
- current
Placements MysqlDb System Current Placement[] - The availability domain and fault domain a DB System is placed in.
- endpoints
Mysql
Db System Endpoint[] - The network endpoints available for this DB System.
- heat
Wave MysqlClusters Db System Heat Wave Cluster[] - A summary of a HeatWave cluster.
- id string
- The provider-assigned unique ID for this managed resource.
- is
Heat booleanWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- lifecycle
Details string - Additional information about the current lifecycleState.
- point
In MysqlTime Recovery Details Db System Point In Time Recovery Detail[] - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- time
Created string - The date and time the DB System was created.
- time
Updated string - The time the DB System was last updated.
- channels
Sequence[mysql.
Mysql Db System Channel] - A list with a summary of all the Channels attached to the DB System.
- current_
placements Sequence[mysql.Mysql Db System Current Placement] - The availability domain and fault domain a DB System is placed in.
- endpoints
Sequence[mysql.
Mysql Db System Endpoint] - The network endpoints available for this DB System.
- heat_
wave_ Sequence[mysql.clusters Mysql Db System Heat Wave Cluster] - A summary of a HeatWave cluster.
- id str
- The provider-assigned unique ID for this managed resource.
- is_
heat_ boolwave_ cluster_ attached - If the DB System has a HeatWave Cluster attached.
- lifecycle_
details str - Additional information about the current lifecycleState.
- point_
in_ Sequence[mysql.time_ recovery_ details Mysql Db System Point In Time Recovery Detail] - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- time_
created str - The date and time the DB System was created.
- time_
updated str - The time the DB System was last updated.
- channels List<Property Map>
- A list with a summary of all the Channels attached to the DB System.
- current
Placements 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.
- heat
Wave List<Property Map>Clusters - A summary of a HeatWave cluster.
- id String
- The provider-assigned unique ID for this managed resource.
- is
Heat BooleanWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- lifecycle
Details String - Additional information about the current lifecycleState.
- point
In List<Property Map>Time Recovery Details - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- time
Created String - The date and time the DB System was created.
- time
Updated String - The time the DB System was last updated.
Look up Existing MysqlDbSystem Resource
Get an existing MysqlDbSystem resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: MysqlDbSystemState, opts?: CustomResourceOptions): MysqlDbSystem
@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
admin_password: Optional[str] = None,
admin_username: Optional[str] = None,
availability_domain: Optional[str] = None,
backup_policy: Optional[_mysql.MysqlDbSystemBackupPolicyArgs] = None,
channels: Optional[Sequence[_mysql.MysqlDbSystemChannelArgs]] = None,
compartment_id: Optional[str] = None,
configuration_id: Optional[str] = None,
crash_recovery: Optional[str] = None,
current_placements: Optional[Sequence[_mysql.MysqlDbSystemCurrentPlacementArgs]] = None,
customer_contacts: Optional[Sequence[_mysql.MysqlDbSystemCustomerContactArgs]] = None,
data_storage: Optional[_mysql.MysqlDbSystemDataStorageArgs] = None,
data_storage_size_in_gb: Optional[int] = None,
database_management: Optional[str] = None,
defined_tags: Optional[Mapping[str, str]] = None,
deletion_policies: Optional[Sequence[_mysql.MysqlDbSystemDeletionPolicyArgs]] = None,
description: Optional[str] = None,
display_name: Optional[str] = None,
endpoints: Optional[Sequence[_mysql.MysqlDbSystemEndpointArgs]] = None,
fault_domain: Optional[str] = None,
freeform_tags: Optional[Mapping[str, str]] = None,
heat_wave_clusters: Optional[Sequence[_mysql.MysqlDbSystemHeatWaveClusterArgs]] = None,
hostname_label: Optional[str] = None,
ip_address: Optional[str] = None,
is_heat_wave_cluster_attached: Optional[bool] = None,
is_highly_available: Optional[bool] = None,
lifecycle_details: Optional[str] = None,
maintenance: Optional[_mysql.MysqlDbSystemMaintenanceArgs] = None,
mysql_version: Optional[str] = None,
point_in_time_recovery_details: Optional[Sequence[_mysql.MysqlDbSystemPointInTimeRecoveryDetailArgs]] = None,
port: Optional[int] = None,
port_x: Optional[int] = None,
secure_connections: Optional[_mysql.MysqlDbSystemSecureConnectionsArgs] = None,
shape_name: Optional[str] = None,
shutdown_type: Optional[str] = None,
source: Optional[_mysql.MysqlDbSystemSourceArgs] = None,
state: Optional[str] = None,
subnet_id: Optional[str] = None,
time_created: Optional[str] = None,
time_updated: Optional[str] = None) -> MysqlDbSystem
func GetMysqlDbSystem(ctx *Context, name string, id IDInput, state *MysqlDbSystemState, opts ...ResourceOption) (*MysqlDbSystem, error)
public static MysqlDbSystem Get(string name, Input<string> id, MysqlDbSystemState? state, CustomResourceOptions? opts = null)
public static MysqlDbSystem get(String name, Output<String> id, MysqlDbSystemState state, CustomResourceOptions options)
Resource lookup is not supported in YAML
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Admin
Password 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.
- Admin
Username string - The username for the administrative user.
- Availability
Domain 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.
- Backup
Policy MysqlDb System Backup Policy - (Updatable) Backup policy as optionally used for DB System Creation.
- Channels
List<Mysql
Db System Channel> - A list with a summary of all the Channels attached to the DB System.
- Compartment
Id string - The OCID of the compartment.
- Configuration
Id string - (Updatable) The OCID of the Configuration to be used for this DB System.
- Crash
Recovery 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.
- Current
Placements List<MysqlDb System Current Placement> - The availability domain and fault domain a DB System is placed in.
- Customer
Contacts List<MysqlDb System Customer Contact> - (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.
- Data
Storage MysqlDb System Data Storage - (Updatable) Data Storage configuration properties.
- Data
Storage intSize In Gb - (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.
- Database
Management string - (Updatable) Whether to enable monitoring via the Database Management service.
- Dictionary<string, string>
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- Deletion
Policies List<MysqlDb System Deletion Policy> - (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.
- Display
Name string - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- Endpoints
List<Mysql
Db System Endpoint> - The network endpoints available for this DB System.
- Fault
Domain 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.
- 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"}
- Heat
Wave List<MysqlClusters Db System Heat Wave Cluster> - A summary of a HeatWave cluster.
- Hostname
Label 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.
- Ip
Address 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.
- Is
Heat boolWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- Is
Highly boolAvailable (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.
- Lifecycle
Details string - Additional information about the current lifecycleState.
- Maintenance
Mysql
Db System Maintenance - (Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in.
maintenance
andbackup_policy
cannot be updated in the same request. - Mysql
Version string - The specific MySQL version identifier.
- Point
In List<MysqlTime Recovery Details Db System Point In Time Recovery Detail> - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- Port int
- The port for primary endpoint of the DB System to listen on.
- Port
X int - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- Secure
Connections MysqlDb System Secure Connections - (Updatable) Secure connection configuration details.
- Shape
Name 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.
- Shutdown
Type string It is applicable only for stopping a DB System. Could be set to
FAST
,SLOW
orIMMEDIATE
. Default value isFAST
.** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
- Source
Mysql
Db System Source - 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
orINACTIVE
. - Subnet
Id string - The OCID of the subnet the DB System is associated with.
- Time
Created string - The date and time the DB System was created.
- Time
Updated string - The time the DB System was last updated.
- Admin
Password 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.
- Admin
Username string - The username for the administrative user.
- Availability
Domain 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.
- Backup
Policy MysqlDb System Backup Policy Args - (Updatable) Backup policy as optionally used for DB System Creation.
- Channels
[]Mysql
Db System Channel Args - A list with a summary of all the Channels attached to the DB System.
- Compartment
Id string - The OCID of the compartment.
- Configuration
Id string - (Updatable) The OCID of the Configuration to be used for this DB System.
- Crash
Recovery 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.
- Current
Placements []MysqlDb System Current Placement Args - The availability domain and fault domain a DB System is placed in.
- Customer
Contacts []MysqlDb System Customer Contact Args - (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.
- Data
Storage MysqlDb System Data Storage Args - (Updatable) Data Storage configuration properties.
- Data
Storage intSize In Gb - (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.
- Database
Management string - (Updatable) Whether to enable monitoring via the Database Management service.
- map[string]string
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- Deletion
Policies []MysqlDb System Deletion Policy Args - (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.
- Display
Name string - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- Endpoints
[]Mysql
Db System Endpoint Args - The network endpoints available for this DB System.
- Fault
Domain 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.
- 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"}
- Heat
Wave []MysqlClusters Db System Heat Wave Cluster Args - A summary of a HeatWave cluster.
- Hostname
Label 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.
- Ip
Address 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.
- Is
Heat boolWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- Is
Highly boolAvailable (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.
- Lifecycle
Details string - Additional information about the current lifecycleState.
- Maintenance
Mysql
Db System Maintenance Args - (Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in.
maintenance
andbackup_policy
cannot be updated in the same request. - Mysql
Version string - The specific MySQL version identifier.
- Point
In []MysqlTime Recovery Details Db System Point In Time Recovery Detail Args - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- Port int
- The port for primary endpoint of the DB System to listen on.
- Port
X int - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- Secure
Connections MysqlDb System Secure Connections Args - (Updatable) Secure connection configuration details.
- Shape
Name 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.
- Shutdown
Type string It is applicable only for stopping a DB System. Could be set to
FAST
,SLOW
orIMMEDIATE
. Default value isFAST
.** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
- Source
Mysql
Db System Source Args - 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
orINACTIVE
. - Subnet
Id string - The OCID of the subnet the DB System is associated with.
- Time
Created string - The date and time the DB System was created.
- Time
Updated string - The time the DB System was last updated.
- admin
Password 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.
- admin
Username String - The username for the administrative user.
- availability
Domain 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.
- backup
Policy DbSystem Backup Policy - (Updatable) Backup policy as optionally used for DB System Creation.
- channels
List<Db
System Channel> - A list with a summary of all the Channels attached to the DB System.
- compartment
Id String - The OCID of the compartment.
- configuration
Id String - (Updatable) The OCID of the Configuration to be used for this DB System.
- crash
Recovery 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.
- current
Placements List<DbSystem Current Placement> - The availability domain and fault domain a DB System is placed in.
- customer
Contacts List<DbSystem Customer Contact> - (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.
- data
Storage DbSystem Data Storage - (Updatable) Data Storage configuration properties.
- data
Storage IntegerSize In Gb - (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.
- database
Management String - (Updatable) Whether to enable monitoring via the Database Management service.
- Map<String,String>
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- deletion
Policies List<DbSystem Deletion Policy> - (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.
- display
Name String - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- endpoints
List<Db
System Endpoint> - The network endpoints available for this DB System.
- fault
Domain 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.
- 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"}
- heat
Wave List<DbClusters System Heat Wave Cluster> - A summary of a HeatWave cluster.
- hostname
Label 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.
- ip
Address 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.
- is
Heat BooleanWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- is
Highly BooleanAvailable (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.
- lifecycle
Details String - Additional information about the current lifecycleState.
- maintenance
Db
System Maintenance - (Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in.
maintenance
andbackup_policy
cannot be updated in the same request. - mysql
Version String - The specific MySQL version identifier.
- point
In List<DbTime Recovery Details System Point In Time Recovery Detail> - 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.
- port
X Integer - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- secure
Connections DbSystem Secure Connections - (Updatable) Secure connection configuration details.
- shape
Name 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.
- shutdown
Type String It is applicable only for stopping a DB System. Could be set to
FAST
,SLOW
orIMMEDIATE
. Default value isFAST
.** 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
Db
System Source - 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
orINACTIVE
. - subnet
Id String - The OCID of the subnet the DB System is associated with.
- time
Created String - The date and time the DB System was created.
- time
Updated String - The time the DB System was last updated.
- admin
Password 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.
- admin
Username string - The username for the administrative user.
- availability
Domain 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.
- backup
Policy MysqlDb System Backup Policy - (Updatable) Backup policy as optionally used for DB System Creation.
- channels
Mysql
Db System Channel[] - A list with a summary of all the Channels attached to the DB System.
- compartment
Id string - The OCID of the compartment.
- configuration
Id string - (Updatable) The OCID of the Configuration to be used for this DB System.
- crash
Recovery 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.
- current
Placements MysqlDb System Current Placement[] - The availability domain and fault domain a DB System is placed in.
- customer
Contacts MysqlDb System Customer Contact[] - (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.
- data
Storage MysqlDb System Data Storage - (Updatable) Data Storage configuration properties.
- data
Storage numberSize In Gb - (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.
- database
Management string - (Updatable) Whether to enable monitoring via the Database Management service.
- {[key: string]: string}
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- deletion
Policies MysqlDb System Deletion Policy[] - (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.
- display
Name string - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- endpoints
Mysql
Db System Endpoint[] - The network endpoints available for this DB System.
- fault
Domain 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.
- {[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"}
- heat
Wave MysqlClusters Db System Heat Wave Cluster[] - A summary of a HeatWave cluster.
- hostname
Label 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.
- ip
Address 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.
- is
Heat booleanWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- is
Highly booleanAvailable (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.
- lifecycle
Details string - Additional information about the current lifecycleState.
- maintenance
Mysql
Db System Maintenance - (Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in.
maintenance
andbackup_policy
cannot be updated in the same request. - mysql
Version string - The specific MySQL version identifier.
- point
In MysqlTime Recovery Details Db System Point In Time Recovery Detail[] - 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.
- port
X number - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- secure
Connections MysqlDb System Secure Connections - (Updatable) Secure connection configuration details.
- shape
Name 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.
- shutdown
Type string It is applicable only for stopping a DB System. Could be set to
FAST
,SLOW
orIMMEDIATE
. Default value isFAST
.** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
- source
Mysql
Db System Source - 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
orINACTIVE
. - subnet
Id string - The OCID of the subnet the DB System is associated with.
- time
Created string - The date and time the DB System was created.
- time
Updated string - The time the DB System was last updated.
- admin_
password str - 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.
- 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.
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.
- backup_
policy mysql.Mysql Db System Backup Policy Args - (Updatable) Backup policy as optionally used for DB System Creation.
- channels
Sequence[mysql.
Mysql Db System Channel Args] - A list with a summary of all the Channels attached to the DB System.
- compartment_
id str - The OCID of the compartment.
- configuration_
id str - (Updatable) The OCID of the Configuration to be used for this DB System.
- crash_
recovery str - (Updatable) Whether to run the DB System with InnoDB Redo Logs and the Double Write Buffer enabled or disabled, and whether to enable or disable syncing of the Binary Logs.
- current_
placements Sequence[mysql.Mysql Db System Current Placement Args] - The availability domain and fault domain a DB System is placed in.
- customer_
contacts Sequence[mysql.Mysql Db System Customer Contact Args] - (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.
- data_
storage mysql.Mysql Db System Data Storage Args - (Updatable) Data Storage configuration properties.
- data_
storage_ intsize_ in_ gb - (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.
- database_
management str - (Updatable) Whether to enable monitoring via the Database Management service.
- 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[mysql.Mysql Db System Deletion Policy Args] - (Updatable) Policy for how the DB System and related resources should be handled at the time of its deletion.
- description str
- (Updatable) User-provided data about the DB System.
- display_
name str - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- endpoints
Sequence[mysql.
Mysql Db System Endpoint Args] - 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.
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.
- 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_ Sequence[mysql.clusters Mysql Db System Heat Wave Cluster Args] - 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 - 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.
- is_
heat_ boolwave_ cluster_ attached - If the DB System has a HeatWave Cluster attached.
- is_
highly_ boolavailable (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.
- lifecycle_
details str - Additional information about the current lifecycleState.
- maintenance
mysql.
Mysql Db System Maintenance Args - (Updatable) The Maintenance Policy for the DB System or Read Replica that this model is included in.
maintenance
andbackup_policy
cannot be updated in the same request. - mysql_
version str - The specific MySQL version identifier.
- point_
in_ Sequence[mysql.time_ recovery_ details Mysql Db System Point In Time Recovery Detail Args] - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- port int
- The port for primary endpoint of the DB System to listen on.
- port_
x int - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- secure_
connections mysql.Mysql Db System Secure Connections Args - (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
orIMMEDIATE
. Default value isFAST
.** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
- source
mysql.
Mysql Db System Source Args - 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
orINACTIVE
. - subnet_
id str - The OCID of the subnet the DB System is associated with.
- time_
created str - The date and time the DB System was created.
- time_
updated str - The time the DB System was last updated.
- admin
Password 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.
- admin
Username String - The username for the administrative user.
- availability
Domain 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.
- backup
Policy 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.
- compartment
Id String - The OCID of the compartment.
- configuration
Id String - (Updatable) The OCID of the Configuration to be used for this DB System.
- crash
Recovery 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.
- current
Placements List<Property Map> - The availability domain and fault domain a DB System is placed in.
- customer
Contacts List<Property Map> - (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.
- data
Storage Property Map - (Updatable) Data Storage configuration properties.
- data
Storage NumberSize In Gb - (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.
- database
Management String - (Updatable) Whether to enable monitoring via the Database Management service.
- Map<String>
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- deletion
Policies 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.
- display
Name String - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- endpoints List<Property Map>
- The network endpoints available for this DB System.
- fault
Domain 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.
- Map<String>
- (Updatable) Simple key-value pair applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- heat
Wave List<Property Map>Clusters - A summary of a HeatWave cluster.
- hostname
Label 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.
- ip
Address 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.
- is
Heat BooleanWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- is
Highly BooleanAvailable (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.
- lifecycle
Details 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
andbackup_policy
cannot be updated in the same request. - mysql
Version String - The specific MySQL version identifier.
- point
In List<Property Map>Time Recovery Details - 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.
- port
X Number - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- secure
Connections Property Map - (Updatable) Secure connection configuration details.
- shape
Name 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.
- shutdown
Type String It is applicable only for stopping a DB System. Could be set to
FAST
,SLOW
orIMMEDIATE
. Default value isFAST
.** 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
orINACTIVE
. - subnet
Id String - The OCID of the subnet the DB System is associated with.
- time
Created String - The date and time the DB System was created.
- time
Updated String - The time the DB System was last updated.
Supporting Types
MysqlDbSystemBackupPolicy, MysqlDbSystemBackupPolicyArgs
- 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"}
- 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"}
- Is
Enabled bool - (Updatable) Specifies if automatic backups are enabled.
- Pitr
Policy MysqlDb System Backup Policy Pitr Policy - (Updatable) The PITR policy for the DB System.
- Retention
In intDays - (Updatable) Number of days to retain an automatic backup.
- Window
Start stringTime (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.
- 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"}
- 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"}
- Is
Enabled bool - (Updatable) Specifies if automatic backups are enabled.
- Pitr
Policy MysqlDb System Backup Policy Pitr Policy - (Updatable) The PITR policy for the DB System.
- Retention
In intDays - (Updatable) Number of days to retain an automatic backup.
- Window
Start stringTime (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.
- 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"}
- 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"}
- is
Enabled Boolean - (Updatable) Specifies if automatic backups are enabled.
- pitr
Policy DbSystem Backup Policy Pitr Policy - (Updatable) The PITR policy for the DB System.
- retention
In IntegerDays - (Updatable) Number of days to retain an automatic backup.
- window
Start StringTime (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.
- {[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"}
- {[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"}
- is
Enabled boolean - (Updatable) Specifies if automatic backups are enabled.
- pitr
Policy MysqlDb System Backup Policy Pitr Policy - (Updatable) The PITR policy for the DB System.
- retention
In numberDays - (Updatable) Number of days to retain an automatic backup.
- window
Start stringTime (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.
- 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"}
- 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 mysql.Mysql Db System Backup Policy Pitr Policy - (Updatable) The PITR policy for the DB System.
- retention_
in_ intdays - (Updatable) Number of days to retain an automatic backup.
- window_
start_ strtime (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.
- 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"}
- 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"}
- is
Enabled Boolean - (Updatable) Specifies if automatic backups are enabled.
- pitr
Policy Property Map - (Updatable) The PITR policy for the DB System.
- retention
In NumberDays - (Updatable) Number of days to retain an automatic backup.
- window
Start StringTime (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.
MysqlDbSystemBackupPolicyPitrPolicy, MysqlDbSystemBackupPolicyPitrPolicyArgs
- Is
Enabled bool - (Updatable) Specifies if PITR is enabled or disabled.
- Is
Enabled bool - (Updatable) Specifies if PITR is enabled or disabled.
- is
Enabled Boolean - (Updatable) Specifies if PITR is enabled or disabled.
- is
Enabled boolean - (Updatable) Specifies if PITR is enabled or disabled.
- is_
enabled bool - (Updatable) Specifies if PITR is enabled or disabled.
- is
Enabled Boolean - (Updatable) Specifies if PITR is enabled or disabled.
MysqlDbSystemChannel, MysqlDbSystemChannelArgs
- Compartment
Id string - The OCID of the compartment.
- Dictionary<string, string>
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- Display
Name string - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- 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.
- Is
Enabled bool - Whether the Channel has been enabled by the user.
- Lifecycle
Details string - Additional information about the current lifecycleState.
- Sources
List<Mysql
Db System Channel Source> - 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
orINACTIVE
. - Targets
List<Mysql
Db System Channel Target> - Details about the Channel target.
- Time
Created string - The date and time the DB System was created.
- Time
Updated string - The time the DB System was last updated.
- Compartment
Id string - The OCID of the compartment.
- map[string]string
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- Display
Name string - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- 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.
- Is
Enabled bool - Whether the Channel has been enabled by the user.
- Lifecycle
Details string - Additional information about the current lifecycleState.
- Sources
[]Mysql
Db System Channel Source - 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
orINACTIVE
. - Targets
[]Mysql
Db System Channel Target - Details about the Channel target.
- Time
Created string - The date and time the DB System was created.
- Time
Updated string - The time the DB System was last updated.
- compartment
Id String - The OCID of the compartment.
- Map<String,String>
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- display
Name String - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- 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.
- is
Enabled Boolean - Whether the Channel has been enabled by the user.
- lifecycle
Details String - Additional information about the current lifecycleState.
- sources
List<Db
System Channel Source> - 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
orINACTIVE
. - targets
List<Db
System Channel Target> - Details about the Channel target.
- time
Created String - The date and time the DB System was created.
- time
Updated String - The time the DB System was last updated.
- compartment
Id string - The OCID of the compartment.
- {[key: string]: string}
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- display
Name string - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- {[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.
- is
Enabled boolean - Whether the Channel has been enabled by the user.
- lifecycle
Details string - Additional information about the current lifecycleState.
- sources
Mysql
Db System Channel Source[] - 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
orINACTIVE
. - targets
Mysql
Db System Channel Target[] - Details about the Channel target.
- time
Created string - The date and time the DB System was created.
- time
Updated string - The time the DB System was last updated.
- compartment_
id str - The OCID of the compartment.
- 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.
- 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 - Whether the Channel has been enabled by the user.
- lifecycle_
details str - Additional information about the current lifecycleState.
- sources
Sequence[mysql.
Mysql Db System Channel Source] - 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
orINACTIVE
. - targets
Sequence[mysql.
Mysql Db System Channel Target] - 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.
- compartment
Id String - The OCID of the compartment.
- Map<String>
- (Updatable) Usage of predefined tag keys. These predefined keys are scoped to namespaces. Example:
{"foo-namespace.bar-key": "value"}
- display
Name String - (Updatable) The user-friendly name for the DB System. It does not have to be unique.
- 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.
- is
Enabled Boolean - Whether the Channel has been enabled by the user.
- lifecycle
Details 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
orINACTIVE
. - targets List<Property Map>
- Details about the Channel target.
- time
Created String - The date and time the DB System was created.
- time
Updated String - The time the DB System was last updated.
MysqlDbSystemChannelSource, MysqlDbSystemChannelSourceArgs
- Anonymous
Transactions List<MysqlHandlings Db System Channel Source Anonymous Transactions Handling> - 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.
- Source
Type string - The specific source identifier. Use
BACKUP
for creating a new database by restoring from a backup. UseIMPORTURL
for creating a new database from a URL Object Storage PAR. - Ssl
Ca List<MysqlCertificates Db System Channel Source Ssl Ca Certificate> - The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
- Ssl
Mode 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 []MysqlHandlings Db System Channel Source Anonymous Transactions Handling - 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.
- Source
Type string - The specific source identifier. Use
BACKUP
for creating a new database by restoring from a backup. UseIMPORTURL
for creating a new database from a URL Object Storage PAR. - Ssl
Ca []MysqlCertificates Db System Channel Source Ssl Ca Certificate - The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
- Ssl
Mode 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 List<DbHandlings System Channel Source Anonymous Transactions Handling> - 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.
- source
Type String - The specific source identifier. Use
BACKUP
for creating a new database by restoring from a backup. UseIMPORTURL
for creating a new database from a URL Object Storage PAR. - ssl
Ca List<DbCertificates System Channel Source Ssl Ca Certificate> - The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
- ssl
Mode 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 MysqlHandlings Db System Channel Source Anonymous Transactions Handling[] - 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.
- source
Type string - The specific source identifier. Use
BACKUP
for creating a new database by restoring from a backup. UseIMPORTURL
for creating a new database from a URL Object Storage PAR. - ssl
Ca MysqlCertificates Db System Channel Source Ssl Ca Certificate[] - The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
- ssl
Mode 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_ Sequence[mysql.handlings Mysql Db System Channel Source Anonymous Transactions Handling] - 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. UseIMPORTURL
for creating a new database from a URL Object Storage PAR. - ssl_
ca_ Sequence[mysql.certificates Mysql Db System Channel Source Ssl Ca Certificate] - 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
- anonymous
Transactions List<Property Map>Handlings - 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.
- source
Type String - The specific source identifier. Use
BACKUP
for creating a new database by restoring from a backup. UseIMPORTURL
for creating a new database from a URL Object Storage PAR. - ssl
Ca List<Property Map>Certificates - The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
- ssl
Mode 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
- Last
Configured stringLog Filename - 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 stringLog Offset - 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 stringLog Filename - 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 stringLog Offset - 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 StringLog Filename - 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 StringLog Offset - 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 stringLog Filename - 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 stringLog Offset - 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_ strlog_ filename - 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_ strlog_ offset - 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.
- last
Configured StringLog Filename - 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 StringLog Offset - 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
- Certificate
Type string - The type of CA certificate.
- Contents string
- The string containing the CA certificate in PEM format.
- Certificate
Type string - The type of CA certificate.
- Contents string
- The string containing the CA certificate in PEM format.
- certificate
Type String - The type of CA certificate.
- contents String
- The string containing the CA certificate in PEM format.
- certificate
Type 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.
- certificate
Type String - The type of CA certificate.
- contents String
- The string containing the CA certificate in PEM format.
MysqlDbSystemChannelTarget, MysqlDbSystemChannelTargetArgs
- Applier
Username string - The username for the replication applier of the target MySQL DB System.
- Channel
Name 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.
- Db
System stringId - 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 intSeconds - Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
- Filters
List<Mysql
Db System Channel Target Filter> - Replication filter rules to be applied at the DB System Channel target.
- Tables
Without stringPrimary Key Handling - Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
- Target
Type string - The specific target identifier.
- Applier
Username string - The username for the replication applier of the target MySQL DB System.
- Channel
Name 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.
- Db
System stringId - 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 intSeconds - Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
- Filters
[]Mysql
Db System Channel Target Filter - Replication filter rules to be applied at the DB System Channel target.
- Tables
Without stringPrimary Key Handling - Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
- Target
Type string - The specific target identifier.
- applier
Username String - The username for the replication applier of the target MySQL DB System.
- channel
Name 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.
- db
System StringId - 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 IntegerSeconds - Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
- filters
List<Db
System Channel Target Filter> - Replication filter rules to be applied at the DB System Channel target.
- tables
Without StringPrimary Key Handling - Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
- target
Type String - The specific target identifier.
- applier
Username string - The username for the replication applier of the target MySQL DB System.
- channel
Name 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.
- db
System stringId - 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 numberSeconds - Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
- filters
Mysql
Db System Channel Target Filter[] - Replication filter rules to be applied at the DB System Channel target.
- tables
Without stringPrimary Key Handling - Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
- target
Type 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_ strid - 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_ intseconds - Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
- filters
Sequence[mysql.
Mysql Db System Channel Target Filter] - Replication filter rules to be applied at the DB System Channel target.
- tables_
without_ strprimary_ key_ handling - 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.
- applier
Username String - The username for the replication applier of the target MySQL DB System.
- channel
Name 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.
- db
System StringId - 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 NumberSeconds - 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.
- tables
Without StringPrimary Key Handling - Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
- target
Type 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
- Availability
Domain 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.
- Fault
Domain 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.
- Availability
Domain 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.
- Fault
Domain 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.
- availability
Domain 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.
- fault
Domain 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.
- availability
Domain 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.
- fault
Domain 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.
- availability_
domain str 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.
- fault_
domain str 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.
- availability
Domain 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.
- fault
Domain 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.
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
- Allocated
Storage intSize In Gbs - The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
- Data
Storage intSize In Gb - (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.
- Data
Storage intSize Limit In Gbs - 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.
- Is
Auto boolExpand Storage Enabled - (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 intSize In Gbs (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.
- Allocated
Storage intSize In Gbs - The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
- Data
Storage intSize In Gb - (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.
- Data
Storage intSize Limit In Gbs - 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.
- Is
Auto boolExpand Storage Enabled - (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 intSize In Gbs (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.
- allocated
Storage IntegerSize In Gbs - The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
- data
Storage IntegerSize In Gb - (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.
- data
Storage IntegerSize Limit In Gbs - 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.
- is
Auto BooleanExpand Storage Enabled - (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 IntegerSize In Gbs (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.
- allocated
Storage numberSize In Gbs - The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
- data
Storage numberSize In Gb - (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.
- data
Storage numberSize Limit In Gbs - 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.
- is
Auto booleanExpand Storage Enabled - (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 numberSize In Gbs (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.
- allocated_
storage_ intsize_ in_ gbs - The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
- data_
storage_ intsize_ in_ gb - (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.
- data_
storage_ intsize_ limit_ in_ gbs - 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.
- is_
auto_ boolexpand_ storage_ enabled - (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_ intsize_ in_ gbs (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.
- allocated
Storage NumberSize In Gbs - The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
- data
Storage NumberSize In Gb - (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.
- data
Storage NumberSize Limit In Gbs - 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.
- is
Auto BooleanExpand Storage Enabled - (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 NumberSize In Gbs (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.
MysqlDbSystemDeletionPolicy, MysqlDbSystemDeletionPolicyArgs
- Automatic
Backup stringRetention - (Updatable) Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
- Final
Backup 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.
- Is
Delete boolProtected - (Updatable) Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.
- Automatic
Backup stringRetention - (Updatable) Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
- Final
Backup 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.
- Is
Delete boolProtected - (Updatable) Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.
- automatic
Backup StringRetention - (Updatable) Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
- final
Backup 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.
- is
Delete BooleanProtected - (Updatable) Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.
- automatic
Backup stringRetention - (Updatable) Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
- final
Backup 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.
- is
Delete booleanProtected - (Updatable) Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.
- automatic_
backup_ strretention - (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_ boolprotected - (Updatable) Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.
- automatic
Backup StringRetention - (Updatable) Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
- final
Backup 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.
- is
Delete BooleanProtected - (Updatable) Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.
MysqlDbSystemEndpoint, MysqlDbSystemEndpointArgs
- Hostname string
- The network address of the DB System.
- Ip
Address 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.
- Port
X int - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- Resource
Id string - The OCID of the resource that this endpoint is attached to.
- Resource
Type 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.
- Status
Details string - Additional information about the current endpoint status.
- Hostname string
- The network address of the DB System.
- Ip
Address 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.
- Port
X int - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- Resource
Id string - The OCID of the resource that this endpoint is attached to.
- Resource
Type 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.
- Status
Details string - Additional information about the current endpoint status.
- hostname String
- The network address of the DB System.
- ip
Address 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.
- port
X Integer - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- resource
Id String - The OCID of the resource that this endpoint is attached to.
- resource
Type 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.
- status
Details String - Additional information about the current endpoint status.
- hostname string
- The network address of the DB System.
- ip
Address 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.
- port
X number - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- resource
Id string - The OCID of the resource that this endpoint is attached to.
- resource
Type 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.
- status
Details 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.
- ip
Address 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.
- port
X Number - The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
- resource
Id String - The OCID of the resource that this endpoint is attached to.
- resource
Type 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.
- status
Details String - Additional information about the current endpoint status.
MysqlDbSystemHeatWaveCluster, MysqlDbSystemHeatWaveClusterArgs
- Cluster
Size int - The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
- Is
Lakehouse boolEnabled - Lakehouse enabled status for the HeatWave cluster.
- Shape
Name 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
orINACTIVE
. - Time
Created string - The date and time the DB System was created.
- Time
Updated 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 boolEnabled - Lakehouse enabled status for the HeatWave cluster.
- Shape
Name 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
orINACTIVE
. - Time
Created string - The date and time the DB System was created.
- Time
Updated string - The time the DB System was last updated.
- cluster
Size Integer - The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
- is
Lakehouse BooleanEnabled - Lakehouse enabled status for the HeatWave cluster.
- shape
Name 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
orINACTIVE
. - time
Created String - The date and time the DB System was created.
- time
Updated String - The time the DB System was last updated.
- cluster
Size number - The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
- is
Lakehouse booleanEnabled - Lakehouse enabled status for the HeatWave cluster.
- shape
Name 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
orINACTIVE
. - time
Created string - The date and time the DB System was created.
- time
Updated 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_ boolenabled - 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
orINACTIVE
. - time_
created str - The date and time the DB System was created.
- time_
updated str - The time the DB System was last updated.
- cluster
Size Number - The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
- is
Lakehouse BooleanEnabled - Lakehouse enabled status for the HeatWave cluster.
- shape
Name 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
orINACTIVE
. - time
Created String - The date and time the DB System was created.
- time
Updated String - The time the DB System was last updated.
MysqlDbSystemMaintenance, MysqlDbSystemMaintenanceArgs
- Window
Start stringTime (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 stringTime (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 StringTime (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 stringTime (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_ strtime (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 StringTime (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
- Time
Earliest stringRecovery Point - Earliest recovery time point for the DB System, as described by RFC 3339.
- Time
Latest stringRecovery Point - Latest recovery time point for the DB System, as described by RFC 3339.
- Time
Earliest stringRecovery Point - Earliest recovery time point for the DB System, as described by RFC 3339.
- Time
Latest stringRecovery Point - Latest recovery time point for the DB System, as described by RFC 3339.
- time
Earliest StringRecovery Point - Earliest recovery time point for the DB System, as described by RFC 3339.
- time
Latest StringRecovery Point - Latest recovery time point for the DB System, as described by RFC 3339.
- time
Earliest stringRecovery Point - Earliest recovery time point for the DB System, as described by RFC 3339.
- time
Latest stringRecovery Point - Latest recovery time point for the DB System, as described by RFC 3339.
- time_
earliest_ strrecovery_ point - Earliest recovery time point for the DB System, as described by RFC 3339.
- time_
latest_ strrecovery_ point - Latest recovery time point for the DB System, as described by RFC 3339.
- time
Earliest StringRecovery Point - Earliest recovery time point for the DB System, as described by RFC 3339.
- time
Latest StringRecovery Point - Latest recovery time point for the DB System, as described by RFC 3339.
MysqlDbSystemSecureConnections, MysqlDbSystemSecureConnectionsArgs
- Certificate
Generation stringType - (Updatable) Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
- Certificate
Id string - (Updatable) The OCID of the certificate to use.
- Certificate
Generation stringType - (Updatable) Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
- Certificate
Id string - (Updatable) The OCID of the certificate to use.
- certificate
Generation StringType - (Updatable) Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
- certificate
Id String - (Updatable) The OCID of the certificate to use.
- certificate
Generation stringType - (Updatable) Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
- certificate
Id string - (Updatable) The OCID of the certificate to use.
- certificate_
generation_ strtype - (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.
- certificate
Generation StringType - (Updatable) Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
- certificate
Id String - (Updatable) The OCID of the certificate to use.
MysqlDbSystemSource, MysqlDbSystemSourceArgs
- Source
Type string - The specific source identifier. Use
BACKUP
for creating a new database by restoring from a backup. UseIMPORTURL
for creating a new database from a URL Object Storage PAR. - Backup
Id string - The OCID of the backup to be used as the source for the new DB System.
- Db
System stringId - 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 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.
- Source
Url 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 string - The specific source identifier. Use
BACKUP
for creating a new database by restoring from a backup. UseIMPORTURL
for creating a new database from a URL Object Storage PAR. - Backup
Id string - The OCID of the backup to be used as the source for the new DB System.
- Db
System stringId - 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 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.
- Source
Url 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 String - The specific source identifier. Use
BACKUP
for creating a new database by restoring from a backup. UseIMPORTURL
for creating a new database from a URL Object Storage PAR. - backup
Id String - The OCID of the backup to be used as the source for the new DB System.
- db
System StringId - 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 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.
- source
Url 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 string - The specific source identifier. Use
BACKUP
for creating a new database by restoring from a backup. UseIMPORTURL
for creating a new database from a URL Object Storage PAR. - backup
Id string - The OCID of the backup to be used as the source for the new DB System.
- db
System stringId - 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 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.
- source
Url 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. UseIMPORTURL
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_ strid - 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.
- source
Type String - The specific source identifier. Use
BACKUP
for creating a new database by restoring from a backup. UseIMPORTURL
for creating a new database from a URL Object Storage PAR. - backup
Id String - The OCID of the backup to be used as the source for the new DB System.
- db
System StringId - 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 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.
- source
Url 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.