Class CfnDBInstance
- All Implemented Interfaces:
IConstruct
,IDependable
,IInspectable
,software.amazon.jsii.JsiiSerializable
,software.constructs.IConstruct
AWS::RDS::DBInstance
.
The AWS::RDS::DBInstance
resource creates an Amazon DB instance. The new DB instance can be an RDS DB instance, or it can be a DB instance in an Aurora DB cluster.
For more information about creating an RDS DB instance, see Creating an Amazon RDS DB instance in the Amazon RDS User Guide .
For more information about creating a DB instance in an Aurora DB cluster, see Creating an Amazon Aurora DB cluster in the Amazon Aurora User Guide .
If you import an existing DB instance, and the template configuration doesn't match the actual configuration of the DB instance, AWS CloudFormation applies the changes in the template during the import operation.
If a DB instance is deleted or replaced during an update, AWS CloudFormation deletes all automated snapshots. However, it retains manual DB snapshots. During an update that requires replacement, you can apply a stack policy to prevent DB instances from being replaced. For more information, see Prevent Updates to Stack Resources .
Updating DB instances
When properties labeled " Update requires: Replacement " are updated, AWS CloudFormation first creates a replacement DB instance, then changes references from other dependent resources to point to the replacement DB instance, and finally deletes the old DB instance.
We highly recommend that you take a snapshot of the database before updating the stack. If you don't, you lose the data when AWS CloudFormation replaces your DB instance. To preserve your data, perform the following procedure:
- Deactivate any applications that are using the DB instance so that there's no activity on the DB instance.
- Create a snapshot of the DB instance. For more information, see Creating a DB Snapshot .
- If you want to restore your instance using a DB snapshot, modify the updated template with your DB instance changes and add the
DBSnapshotIdentifier
property with the ID of the DB snapshot that you want to use.After you restore a DB instance with a
DBSnapshotIdentifier
property, you must specify the sameDBSnapshotIdentifier
property for any future updates to the DB instance. When you specify this property for an update, the DB instance is not restored from the DB snapshot again, and the data in the database is not changed. However, if you don't specify theDBSnapshotIdentifier
property, an empty DB instance is created, and the original DB instance is deleted. If you specify a property that is different from the previous snapshot restore property, a new DB instance is restored from the specifiedDBSnapshotIdentifier
property, and the original DB instance is deleted.
- Update the stack.
For more information about updating other properties of this resource, see [ModifyDBInstance](https://docs.aws.amazon.com//AmazonRDS/latest/APIReference/API_ModifyDBInstance.html)
. For more information about updating stacks, see AWS CloudFormation Stacks Updates .
Deleting DB instances
For DB instances that are part of an Aurora DB cluster, you can set a deletion policy for your DB instance to control how AWS CloudFormation handles the DB instance when the stack is deleted. For Amazon RDS DB instances, you can choose to retain the DB instance, to delete the DB instance, or to create a snapshot of the DB instance. The default AWS CloudFormation behavior depends on the DBClusterIdentifier
property:
- For
AWS::RDS::DBInstance
resources that don't specify theDBClusterIdentifier
property, AWS CloudFormation saves a snapshot of the DB instance. - For
AWS::RDS::DBInstance
resources that do specify theDBClusterIdentifier
property, AWS CloudFormation deletes the DB instance.
For more information, see DeletionPolicy Attribute .
Example:
// The code below shows an example of how to instantiate this type. // The values are placeholders you should change. import software.amazon.awscdk.services.rds.*; CfnDBInstance cfnDBInstance = CfnDBInstance.Builder.create(this, "MyCfnDBInstance") .allocatedStorage("allocatedStorage") .allowMajorVersionUpgrade(false) .associatedRoles(List.of(DBInstanceRoleProperty.builder() .featureName("featureName") .roleArn("roleArn") .build())) .autoMinorVersionUpgrade(false) .availabilityZone("availabilityZone") .backupRetentionPeriod(123) .caCertificateIdentifier("caCertificateIdentifier") .certificateDetails(CertificateDetailsProperty.builder() .caIdentifier("caIdentifier") .validTill("validTill") .build()) .certificateRotationRestart(false) .characterSetName("characterSetName") .copyTagsToSnapshot(false) .customIamInstanceProfile("customIamInstanceProfile") .dbClusterIdentifier("dbClusterIdentifier") .dbClusterSnapshotIdentifier("dbClusterSnapshotIdentifier") .dbInstanceClass("dbInstanceClass") .dbInstanceIdentifier("dbInstanceIdentifier") .dbName("dbName") .dbParameterGroupName("dbParameterGroupName") .dbSecurityGroups(List.of("dbSecurityGroups")) .dbSnapshotIdentifier("dbSnapshotIdentifier") .dbSubnetGroupName("dbSubnetGroupName") .deleteAutomatedBackups(false) .deletionProtection(false) .domain("domain") .domainIamRoleName("domainIamRoleName") .enableCloudwatchLogsExports(List.of("enableCloudwatchLogsExports")) .enableIamDatabaseAuthentication(false) .enablePerformanceInsights(false) .endpoint(EndpointProperty.builder() .address("address") .hostedZoneId("hostedZoneId") .port("port") .build()) .engine("engine") .engineVersion("engineVersion") .iops(123) .kmsKeyId("kmsKeyId") .licenseModel("licenseModel") .manageMasterUserPassword(false) .masterUsername("masterUsername") .masterUserPassword("masterUserPassword") .masterUserSecret(MasterUserSecretProperty.builder() .kmsKeyId("kmsKeyId") .secretArn("secretArn") .build()) .maxAllocatedStorage(123) .monitoringInterval(123) .monitoringRoleArn("monitoringRoleArn") .multiAz(false) .ncharCharacterSetName("ncharCharacterSetName") .networkType("networkType") .optionGroupName("optionGroupName") .performanceInsightsKmsKeyId("performanceInsightsKmsKeyId") .performanceInsightsRetentionPeriod(123) .port("port") .preferredBackupWindow("preferredBackupWindow") .preferredMaintenanceWindow("preferredMaintenanceWindow") .processorFeatures(List.of(ProcessorFeatureProperty.builder() .name("name") .value("value") .build())) .promotionTier(123) .publiclyAccessible(false) .replicaMode("replicaMode") .restoreTime("restoreTime") .sourceDbClusterIdentifier("sourceDbClusterIdentifier") .sourceDbInstanceAutomatedBackupsArn("sourceDbInstanceAutomatedBackupsArn") .sourceDbInstanceIdentifier("sourceDbInstanceIdentifier") .sourceDbiResourceId("sourceDbiResourceId") .sourceRegion("sourceRegion") .storageEncrypted(false) .storageThroughput(123) .storageType("storageType") .tags(List.of(CfnTag.builder() .key("key") .value("value") .build())) .timezone("timezone") .useDefaultProcessorFeatures(false) .useLatestRestorableTime(false) .vpcSecurityGroups(List.of("vpcSecurityGroups")) .build();
-
Nested Class Summary
Modifier and TypeClassDescriptionstatic final class
A fluent builder forCfnDBInstance
.static interface
Returns the details of the DB instance’s server certificate.static interface
Describes an AWS Identity and Access Management (IAM) role that is associated with a DB instance.static interface
This data type represents the information you need to connect to an Amazon RDS DB instance.static interface
TheMasterUserSecret
return value specifies the secret managed by RDS in AWS Secrets Manager for the master user password.static interface
TheProcessorFeature
property type specifies the processor features of a DB instance class status.Nested classes/interfaces inherited from class software.amazon.jsii.JsiiObject
software.amazon.jsii.JsiiObject.InitializationMode
Nested classes/interfaces inherited from interface software.amazon.awscdk.core.IConstruct
IConstruct.Jsii$Default
Nested classes/interfaces inherited from interface software.constructs.IConstruct
software.constructs.IConstruct.Jsii$Default
Nested classes/interfaces inherited from interface software.amazon.awscdk.core.IInspectable
IInspectable.Jsii$Default, IInspectable.Jsii$Proxy
-
Field Summary
Modifier and TypeFieldDescriptionstatic final String
The CloudFormation resource type name for this resource class. -
Constructor Summary
ModifierConstructorDescriptionCfnDBInstance
(Construct scope, String id) Create a newAWS::RDS::DBInstance
.CfnDBInstance
(Construct scope, String id, CfnDBInstanceProps props) Create a newAWS::RDS::DBInstance
.protected
CfnDBInstance
(software.amazon.jsii.JsiiObject.InitializationMode initializationMode) protected
CfnDBInstance
(software.amazon.jsii.JsiiObjectRef objRef) -
Method Summary
Modifier and TypeMethodDescriptionThe amount of storage in gibibytes (GiB) to be initially allocated for the database instance.A value that indicates whether major version upgrades are allowed.The AWS Identity and Access Management (IAM) roles associated with the DB instance.The CA identifier of the CA certificate used for the DB instance's server certificate.The expiration date of the DB instance’s server certificate.The Amazon Resource Name (ARN) for the DB instance.The AWS Region-unique, immutable identifier for the DB instance.The Oracle system ID (Oracle SID) for a container database (CDB).The connection endpoint for the database.The ID that Amazon Route 53 assigns when you create a hosted zone.The port number on which the database accepts connections.The Amazon Resource Name (ARN) of the secret.A value that indicates whether minor engine upgrades are applied automatically to the DB instance during the maintenance window.The Availability Zone (AZ) where the database will be created.The number of days for which automated backups are retained.The identifier of the CA certificate for this DB instance.The details of the DB instance's server certificate.A value that indicates whether the DB instance is restarted when you rotate your SSL/TLS certificate.For supported engines, indicates that the DB instance should be associated with the specified character set.A value that indicates whether to copy tags from the DB instance to snapshots of the DB instance.The instance profile associated with the underlying Amazon EC2 instance of an RDS Custom DB instance.The identifier of the DB cluster that the instance will belong to.The identifier for the RDS for MySQL Multi-AZ DB cluster snapshot to restore from.The compute and memory capacity of the DB instance, for example,db.m4.large
.A name for the DB instance.The meaning of this parameter differs according to the database engine you use.The name of an existing DB parameter group or a reference to an AWS::RDS::DBParameterGroup resource created in the template.A list of the DB security groups to assign to the DB instance.The name or Amazon Resource Name (ARN) of the DB snapshot that's used to restore the DB instance.A DB subnet group to associate with the DB instance.A value that indicates whether to remove automated backups immediately after the DB instance is deleted.A value that indicates whether the DB instance has deletion protection enabled.The Active Directory directory ID to create the DB instance in.Specify the name of the IAM role to be used when making API calls to the Directory Service.The list of log types that need to be enabled for exporting to CloudWatch Logs.A value that indicates whether to enable mapping of AWS Identity and Access Management (IAM) accounts to database accounts.A value that indicates whether to enable Performance Insights for the DB instance.Specifies the connection endpoint.The name of the database engine that you want to use for this DB instance.The version number of the database engine to use.getIops()
The number of I/O operations per second (IOPS) that the database provisions.The ARN of the AWS KMS key that's used to encrypt the DB instance, such asarn:aws:kms:us-east-1:012345678910:key/abcd1234-a123-456a-a12b-a123b4cd56ef
.License model information for this DB instance.A value that indicates whether to manage the master user password with AWS Secrets Manager.The master user name for the DB instance.The password for the master user.Contains the secret managed by RDS in AWS Secrets Manager for the master user password.The upper limit in gibibytes (GiB) to which Amazon RDS can automatically scale the storage of the DB instance.The interval, in seconds, between points when Enhanced Monitoring metrics are collected for the DB instance.The ARN for the IAM role that permits RDS to send enhanced monitoring metrics to Amazon CloudWatch Logs.Specifies whether the database instance is a Multi-AZ DB instance deployment.The name of the NCHAR character set for the Oracle DB instance.The network type of the DB instance.Indicates that the DB instance should be associated with the specified option group.The AWS KMS key identifier for encryption of Performance Insights data.The number of days to retain Performance Insights data.getPort()
The port number on which the database accepts connections.The daily time range during which automated backups are created if automated backups are enabled, using theBackupRetentionPeriod
parameter.The weekly time range during which system maintenance can occur, in Universal Coordinated Time (UTC).The number of CPU cores and the number of threads per core for the DB instance class of the DB instance.A value that specifies the order in which an Aurora Replica is promoted to the primary instance after a failure of the existing primary instance.Indicates whether the DB instance is an internet-facing instance.The open mode of an Oracle read replica.The date and time to restore from.The identifier of the Multi-AZ DB cluster that will act as the source for the read replica.The Amazon Resource Name (ARN) of the replicated automated backups from which to restore, for example,arn:aws:rds:useast-1:123456789012:auto-backup:ab-L2IJCEXJP7XQ7HOJ4SIEXAMPLE
.If you want to create a read replica DB instance, specify the ID of the source DB instance.The resource ID of the source DB instance from which to restore.The ID of the region that contains the source DB instance for the read replica.A value that indicates whether the DB instance is encrypted.Specifies the storage throughput value for the DB instance.Specifies the storage type to be associated with the DB instance.getTags()
An optional array of key-value pairs to apply to this DB instance.The time zone of the DB instance.A value that indicates whether the DB instance class of the DB instance uses its default processor features.A value that indicates whether the DB instance is restored from the latest backup time.A list of the VPC security group IDs to assign to the DB instance.void
inspect
(TreeInspector inspector) Examines the CloudFormation resource and discloses attributes.renderProperties
(Map<String, Object> props) void
setAllocatedStorage
(String value) The amount of storage in gibibytes (GiB) to be initially allocated for the database instance.void
A value that indicates whether major version upgrades are allowed.void
A value that indicates whether major version upgrades are allowed.void
setAssociatedRoles
(List<Object> value) The AWS Identity and Access Management (IAM) roles associated with the DB instance.void
setAssociatedRoles
(IResolvable value) The AWS Identity and Access Management (IAM) roles associated with the DB instance.void
A value that indicates whether minor engine upgrades are applied automatically to the DB instance during the maintenance window.void
A value that indicates whether minor engine upgrades are applied automatically to the DB instance during the maintenance window.void
setAvailabilityZone
(String value) The Availability Zone (AZ) where the database will be created.void
setBackupRetentionPeriod
(Number value) The number of days for which automated backups are retained.void
setCaCertificateIdentifier
(String value) The identifier of the CA certificate for this DB instance.void
setCertificateDetails
(IResolvable value) The details of the DB instance's server certificate.void
The details of the DB instance's server certificate.void
A value that indicates whether the DB instance is restarted when you rotate your SSL/TLS certificate.void
A value that indicates whether the DB instance is restarted when you rotate your SSL/TLS certificate.void
setCharacterSetName
(String value) For supported engines, indicates that the DB instance should be associated with the specified character set.void
setCopyTagsToSnapshot
(Boolean value) A value that indicates whether to copy tags from the DB instance to snapshots of the DB instance.void
setCopyTagsToSnapshot
(IResolvable value) A value that indicates whether to copy tags from the DB instance to snapshots of the DB instance.void
The instance profile associated with the underlying Amazon EC2 instance of an RDS Custom DB instance.void
setDbClusterIdentifier
(String value) The identifier of the DB cluster that the instance will belong to.void
The identifier for the RDS for MySQL Multi-AZ DB cluster snapshot to restore from.void
setDbInstanceClass
(String value) The compute and memory capacity of the DB instance, for example,db.m4.large
.void
setDbInstanceIdentifier
(String value) A name for the DB instance.void
The meaning of this parameter differs according to the database engine you use.void
setDbParameterGroupName
(String value) The name of an existing DB parameter group or a reference to an AWS::RDS::DBParameterGroup resource created in the template.void
setDbSecurityGroups
(List<String> value) A list of the DB security groups to assign to the DB instance.void
setDbSnapshotIdentifier
(String value) The name or Amazon Resource Name (ARN) of the DB snapshot that's used to restore the DB instance.void
setDbSubnetGroupName
(String value) A DB subnet group to associate with the DB instance.void
setDeleteAutomatedBackups
(Boolean value) A value that indicates whether to remove automated backups immediately after the DB instance is deleted.void
A value that indicates whether to remove automated backups immediately after the DB instance is deleted.void
setDeletionProtection
(Boolean value) A value that indicates whether the DB instance has deletion protection enabled.void
setDeletionProtection
(IResolvable value) A value that indicates whether the DB instance has deletion protection enabled.void
The Active Directory directory ID to create the DB instance in.void
setDomainIamRoleName
(String value) Specify the name of the IAM role to be used when making API calls to the Directory Service.void
setEnableCloudwatchLogsExports
(List<String> value) The list of log types that need to be enabled for exporting to CloudWatch Logs.void
A value that indicates whether to enable mapping of AWS Identity and Access Management (IAM) accounts to database accounts.void
A value that indicates whether to enable mapping of AWS Identity and Access Management (IAM) accounts to database accounts.void
A value that indicates whether to enable Performance Insights for the DB instance.void
A value that indicates whether to enable Performance Insights for the DB instance.void
setEndpoint
(IResolvable value) Specifies the connection endpoint.void
Specifies the connection endpoint.void
The name of the database engine that you want to use for this DB instance.void
setEngineVersion
(String value) The version number of the database engine to use.void
The number of I/O operations per second (IOPS) that the database provisions.void
setKmsKeyId
(String value) The ARN of the AWS KMS key that's used to encrypt the DB instance, such asarn:aws:kms:us-east-1:012345678910:key/abcd1234-a123-456a-a12b-a123b4cd56ef
.void
setLicenseModel
(String value) License model information for this DB instance.void
A value that indicates whether to manage the master user password with AWS Secrets Manager.void
A value that indicates whether to manage the master user password with AWS Secrets Manager.void
setMasterUsername
(String value) The master user name for the DB instance.void
setMasterUserPassword
(String value) The password for the master user.void
setMasterUserSecret
(IResolvable value) Contains the secret managed by RDS in AWS Secrets Manager for the master user password.void
Contains the secret managed by RDS in AWS Secrets Manager for the master user password.void
setMaxAllocatedStorage
(Number value) The upper limit in gibibytes (GiB) to which Amazon RDS can automatically scale the storage of the DB instance.void
setMonitoringInterval
(Number value) The interval, in seconds, between points when Enhanced Monitoring metrics are collected for the DB instance.void
setMonitoringRoleArn
(String value) The ARN for the IAM role that permits RDS to send enhanced monitoring metrics to Amazon CloudWatch Logs.void
setMultiAz
(Boolean value) Specifies whether the database instance is a Multi-AZ DB instance deployment.void
setMultiAz
(IResolvable value) Specifies whether the database instance is a Multi-AZ DB instance deployment.void
setNcharCharacterSetName
(String value) The name of the NCHAR character set for the Oracle DB instance.void
setNetworkType
(String value) The network type of the DB instance.void
setOptionGroupName
(String value) Indicates that the DB instance should be associated with the specified option group.void
The AWS KMS key identifier for encryption of Performance Insights data.void
The number of days to retain Performance Insights data.void
The port number on which the database accepts connections.void
setPreferredBackupWindow
(String value) The daily time range during which automated backups are created if automated backups are enabled, using theBackupRetentionPeriod
parameter.void
The weekly time range during which system maintenance can occur, in Universal Coordinated Time (UTC).void
setProcessorFeatures
(List<Object> value) The number of CPU cores and the number of threads per core for the DB instance class of the DB instance.void
setProcessorFeatures
(IResolvable value) The number of CPU cores and the number of threads per core for the DB instance class of the DB instance.void
setPromotionTier
(Number value) A value that specifies the order in which an Aurora Replica is promoted to the primary instance after a failure of the existing primary instance.void
setPubliclyAccessible
(Boolean value) Indicates whether the DB instance is an internet-facing instance.void
setPubliclyAccessible
(IResolvable value) Indicates whether the DB instance is an internet-facing instance.void
setReplicaMode
(String value) The open mode of an Oracle read replica.void
setRestoreTime
(String value) The date and time to restore from.void
The identifier of the Multi-AZ DB cluster that will act as the source for the read replica.void
The Amazon Resource Name (ARN) of the replicated automated backups from which to restore, for example,arn:aws:rds:useast-1:123456789012:auto-backup:ab-L2IJCEXJP7XQ7HOJ4SIEXAMPLE
.void
If you want to create a read replica DB instance, specify the ID of the source DB instance.void
setSourceDbiResourceId
(String value) The resource ID of the source DB instance from which to restore.void
setSourceRegion
(String value) The ID of the region that contains the source DB instance for the read replica.void
setStorageEncrypted
(Boolean value) A value that indicates whether the DB instance is encrypted.void
setStorageEncrypted
(IResolvable value) A value that indicates whether the DB instance is encrypted.void
setStorageThroughput
(Number value) Specifies the storage throughput value for the DB instance.void
setStorageType
(String value) Specifies the storage type to be associated with the DB instance.void
setTimezone
(String value) The time zone of the DB instance.void
A value that indicates whether the DB instance class of the DB instance uses its default processor features.void
A value that indicates whether the DB instance class of the DB instance uses its default processor features.void
A value that indicates whether the DB instance is restored from the latest backup time.void
A value that indicates whether the DB instance is restored from the latest backup time.void
setVpcSecurityGroups
(List<String> value) A list of the VPC security group IDs to assign to the DB instance.Methods inherited from class software.amazon.awscdk.core.CfnResource
addDeletionOverride, addDependsOn, addMetadata, addOverride, addPropertyDeletionOverride, addPropertyOverride, applyRemovalPolicy, applyRemovalPolicy, applyRemovalPolicy, getAtt, getCfnOptions, getCfnResourceType, getMetadata, getUpdatedProperites, isCfnResource, shouldSynthesize, toString, validateProperties
Methods inherited from class software.amazon.awscdk.core.CfnRefElement
getRef
Methods inherited from class software.amazon.awscdk.core.CfnElement
getCreationStack, getLogicalId, getStack, isCfnElement, overrideLogicalId
Methods inherited from class software.amazon.awscdk.core.Construct
getNode, isConstruct, onPrepare, onSynthesize, onValidate, prepare, synthesize, validate
Methods inherited from class software.amazon.jsii.JsiiObject
jsiiAsyncCall, jsiiAsyncCall, jsiiCall, jsiiCall, jsiiGet, jsiiGet, jsiiSet, jsiiStaticCall, jsiiStaticCall, jsiiStaticGet, jsiiStaticGet, jsiiStaticSet, jsiiStaticSet
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
Methods inherited from interface software.amazon.jsii.JsiiSerializable
$jsii$toJson
-
Field Details
-
CFN_RESOURCE_TYPE_NAME
The CloudFormation resource type name for this resource class.
-
-
Constructor Details
-
CfnDBInstance
protected CfnDBInstance(software.amazon.jsii.JsiiObjectRef objRef) -
CfnDBInstance
protected CfnDBInstance(software.amazon.jsii.JsiiObject.InitializationMode initializationMode) -
CfnDBInstance
@Stability(Stable) public CfnDBInstance(@NotNull Construct scope, @NotNull String id, @Nullable CfnDBInstanceProps props) Create a newAWS::RDS::DBInstance
.- Parameters:
scope
-- scope in which this resource is defined.
id
-- scoped id of the resource.
props
-- resource properties.
-
CfnDBInstance
Create a newAWS::RDS::DBInstance
.- Parameters:
scope
-- scope in which this resource is defined.
id
-- scoped id of the resource.
-
-
Method Details
-
inspect
Examines the CloudFormation resource and discloses attributes.- Specified by:
inspect
in interfaceIInspectable
- Parameters:
inspector
-- tree inspector to collect and process attributes.
-
renderProperties
@Stability(Stable) @NotNull protected Map<String,Object> renderProperties(@NotNull Map<String, Object> props) - Overrides:
renderProperties
in classCfnResource
- Parameters:
props
- This parameter is required.
-
getAttrCertificateDetailsCaIdentifier
The CA identifier of the CA certificate used for the DB instance's server certificate. -
getAttrCertificateDetailsValidTill
The expiration date of the DB instance’s server certificate. -
getAttrDbInstanceArn
The Amazon Resource Name (ARN) for the DB instance. -
getAttrDbiResourceId
The AWS Region-unique, immutable identifier for the DB instance.This identifier is found in AWS CloudTrail log entries whenever the AWS KMS key for the DB instance is accessed.
-
getAttrDbSystemId
The Oracle system ID (Oracle SID) for a container database (CDB).The Oracle SID is also the name of the CDB.
This setting is valid for RDS Custom only.
-
getAttrEndpointAddress
The connection endpoint for the database. For example:mystack-mydb-1apw1j4phylrk.cg034hpkmmjt.us-east-2.rds.amazonaws.com
.For Aurora Serverless DB clusters, the connection endpoint only applies to the DB cluster.
-
getAttrEndpointHostedZoneId
The ID that Amazon Route 53 assigns when you create a hosted zone. -
getAttrEndpointPort
The port number on which the database accepts connections.For example:
3306
-
getAttrMasterUserSecretSecretArn
The Amazon Resource Name (ARN) of the secret. -
getCfnProperties
- Overrides:
getCfnProperties
in classCfnResource
-
getTags
An optional array of key-value pairs to apply to this DB instance. -
getAllocatedStorage
The amount of storage in gibibytes (GiB) to be initially allocated for the database instance.If any value is set in the
Iops
parameter,AllocatedStorage
must be at least 100 GiB, which corresponds to the minimum Iops value of 1,000. If you increase theIops
value (in 1,000 IOPS increments), then you must also increase theAllocatedStorage
value (in 100-GiB increments).Amazon Aurora
Not applicable. Aurora cluster volumes automatically grow as the amount of data in your database increases, though you are only charged for the space that you use in an Aurora cluster volume.
MySQL
Constraints to the amount of storage for each storage type are the following:
- General Purpose (SSD) storage (gp2): Must be an integer from 20 to 65536.
- Provisioned IOPS storage (io1): Must be an integer from 100 to 65536.
- Magnetic storage (standard): Must be an integer from 5 to 3072.
MariaDB
Constraints to the amount of storage for each storage type are the following:
- General Purpose (SSD) storage (gp2): Must be an integer from 20 to 65536.
- Provisioned IOPS storage (io1): Must be an integer from 100 to 65536.
- Magnetic storage (standard): Must be an integer from 5 to 3072.
PostgreSQL
Constraints to the amount of storage for each storage type are the following:
- General Purpose (SSD) storage (gp2): Must be an integer from 20 to 65536.
- Provisioned IOPS storage (io1): Must be an integer from 100 to 65536.
- Magnetic storage (standard): Must be an integer from 5 to 3072.
Oracle
Constraints to the amount of storage for each storage type are the following:
- General Purpose (SSD) storage (gp2): Must be an integer from 20 to 65536.
- Provisioned IOPS storage (io1): Must be an integer from 100 to 65536.
- Magnetic storage (standard): Must be an integer from 10 to 3072.
SQL Server
Constraints to the amount of storage for each storage type are the following:
- General Purpose (SSD) storage (gp2):
- Enterprise and Standard editions: Must be an integer from 20 to 16384.
- Web and Express editions: Must be an integer from 20 to 16384.
- Provisioned IOPS storage (io1):
- Enterprise and Standard editions: Must be an integer from 20 to 16384.
- Web and Express editions: Must be an integer from 20 to 16384.
- Magnetic storage (standard):
- Enterprise and Standard editions: Must be an integer from 20 to 1024.
- Web and Express editions: Must be an integer from 20 to 1024.
-
setAllocatedStorage
The amount of storage in gibibytes (GiB) to be initially allocated for the database instance.If any value is set in the
Iops
parameter,AllocatedStorage
must be at least 100 GiB, which corresponds to the minimum Iops value of 1,000. If you increase theIops
value (in 1,000 IOPS increments), then you must also increase theAllocatedStorage
value (in 100-GiB increments).Amazon Aurora
Not applicable. Aurora cluster volumes automatically grow as the amount of data in your database increases, though you are only charged for the space that you use in an Aurora cluster volume.
MySQL
Constraints to the amount of storage for each storage type are the following:
- General Purpose (SSD) storage (gp2): Must be an integer from 20 to 65536.
- Provisioned IOPS storage (io1): Must be an integer from 100 to 65536.
- Magnetic storage (standard): Must be an integer from 5 to 3072.
MariaDB
Constraints to the amount of storage for each storage type are the following:
- General Purpose (SSD) storage (gp2): Must be an integer from 20 to 65536.
- Provisioned IOPS storage (io1): Must be an integer from 100 to 65536.
- Magnetic storage (standard): Must be an integer from 5 to 3072.
PostgreSQL
Constraints to the amount of storage for each storage type are the following:
- General Purpose (SSD) storage (gp2): Must be an integer from 20 to 65536.
- Provisioned IOPS storage (io1): Must be an integer from 100 to 65536.
- Magnetic storage (standard): Must be an integer from 5 to 3072.
Oracle
Constraints to the amount of storage for each storage type are the following:
- General Purpose (SSD) storage (gp2): Must be an integer from 20 to 65536.
- Provisioned IOPS storage (io1): Must be an integer from 100 to 65536.
- Magnetic storage (standard): Must be an integer from 10 to 3072.
SQL Server
Constraints to the amount of storage for each storage type are the following:
- General Purpose (SSD) storage (gp2):
- Enterprise and Standard editions: Must be an integer from 20 to 16384.
- Web and Express editions: Must be an integer from 20 to 16384.
- Provisioned IOPS storage (io1):
- Enterprise and Standard editions: Must be an integer from 20 to 16384.
- Web and Express editions: Must be an integer from 20 to 16384.
- Magnetic storage (standard):
- Enterprise and Standard editions: Must be an integer from 20 to 1024.
- Web and Express editions: Must be an integer from 20 to 1024.
-
getAllowMajorVersionUpgrade
A value that indicates whether major version upgrades are allowed.Changing this parameter doesn't result in an outage and the change is asynchronously applied as soon as possible.
Constraints: Major version upgrades must be allowed when specifying a value for the
EngineVersion
parameter that is a different major version than the DB instance's current version. -
setAllowMajorVersionUpgrade
A value that indicates whether major version upgrades are allowed.Changing this parameter doesn't result in an outage and the change is asynchronously applied as soon as possible.
Constraints: Major version upgrades must be allowed when specifying a value for the
EngineVersion
parameter that is a different major version than the DB instance's current version. -
setAllowMajorVersionUpgrade
A value that indicates whether major version upgrades are allowed.Changing this parameter doesn't result in an outage and the change is asynchronously applied as soon as possible.
Constraints: Major version upgrades must be allowed when specifying a value for the
EngineVersion
parameter that is a different major version than the DB instance's current version. -
getAssociatedRoles
The AWS Identity and Access Management (IAM) roles associated with the DB instance.Amazon Aurora
Not applicable. The associated roles are managed by the DB cluster.
-
setAssociatedRoles
The AWS Identity and Access Management (IAM) roles associated with the DB instance.Amazon Aurora
Not applicable. The associated roles are managed by the DB cluster.
-
setAssociatedRoles
The AWS Identity and Access Management (IAM) roles associated with the DB instance.Amazon Aurora
Not applicable. The associated roles are managed by the DB cluster.
-
getAutoMinorVersionUpgrade
A value that indicates whether minor engine upgrades are applied automatically to the DB instance during the maintenance window.By default, minor engine upgrades are applied automatically.
-
setAutoMinorVersionUpgrade
A value that indicates whether minor engine upgrades are applied automatically to the DB instance during the maintenance window.By default, minor engine upgrades are applied automatically.
-
setAutoMinorVersionUpgrade
A value that indicates whether minor engine upgrades are applied automatically to the DB instance during the maintenance window.By default, minor engine upgrades are applied automatically.
-
getAvailabilityZone
The Availability Zone (AZ) where the database will be created.For information on AWS Regions and Availability Zones, see Regions and Availability Zones .
Amazon Aurora
Each Aurora DB cluster hosts copies of its storage in three separate Availability Zones. Specify one of these Availability Zones. Aurora automatically chooses an appropriate Availability Zone if you don't specify one.
Default: A random, system-chosen Availability Zone in the endpoint's AWS Region .
Example:
us-east-1d
Constraint: The
AvailabilityZone
parameter can't be specified if the DB instance is a Multi-AZ deployment. The specified Availability Zone must be in the same AWS Region as the current endpoint. -
setAvailabilityZone
The Availability Zone (AZ) where the database will be created.For information on AWS Regions and Availability Zones, see Regions and Availability Zones .
Amazon Aurora
Each Aurora DB cluster hosts copies of its storage in three separate Availability Zones. Specify one of these Availability Zones. Aurora automatically chooses an appropriate Availability Zone if you don't specify one.
Default: A random, system-chosen Availability Zone in the endpoint's AWS Region .
Example:
us-east-1d
Constraint: The
AvailabilityZone
parameter can't be specified if the DB instance is a Multi-AZ deployment. The specified Availability Zone must be in the same AWS Region as the current endpoint. -
getBackupRetentionPeriod
The number of days for which automated backups are retained.Setting this parameter to a positive number enables backups. Setting this parameter to 0 disables automated backups.
Amazon Aurora
Not applicable. The retention period for automated backups is managed by the DB cluster.
Default: 1
Constraints:
- Must be a value from 0 to 35
- Can't be set to 0 if the DB instance is a source to read replicas
-
setBackupRetentionPeriod
The number of days for which automated backups are retained.Setting this parameter to a positive number enables backups. Setting this parameter to 0 disables automated backups.
Amazon Aurora
Not applicable. The retention period for automated backups is managed by the DB cluster.
Default: 1
Constraints:
- Must be a value from 0 to 35
- Can't be set to 0 if the DB instance is a source to read replicas
-
getCaCertificateIdentifier
The identifier of the CA certificate for this DB instance.Specifying or updating this property triggers a reboot.
For more information about CA certificate identifiers for RDS DB engines, see Rotating Your SSL/TLS Certificate in the Amazon RDS User Guide .
For more information about CA certificate identifiers for Aurora DB engines, see Rotating Your SSL/TLS Certificate in the Amazon Aurora User Guide .
-
setCaCertificateIdentifier
The identifier of the CA certificate for this DB instance.Specifying or updating this property triggers a reboot.
For more information about CA certificate identifiers for RDS DB engines, see Rotating Your SSL/TLS Certificate in the Amazon RDS User Guide .
For more information about CA certificate identifiers for Aurora DB engines, see Rotating Your SSL/TLS Certificate in the Amazon Aurora User Guide .
-
getCertificateDetails
The details of the DB instance's server certificate. -
setCertificateDetails
The details of the DB instance's server certificate. -
setCertificateDetails
@Stability(Stable) public void setCertificateDetails(@Nullable CfnDBInstance.CertificateDetailsProperty value) The details of the DB instance's server certificate. -
getCertificateRotationRestart
A value that indicates whether the DB instance is restarted when you rotate your SSL/TLS certificate.By default, the DB instance is restarted when you rotate your SSL/TLS certificate. The certificate is not updated until the DB instance is restarted.
Set this parameter only if you are not using SSL/TLS to connect to the DB instance.
If you are using SSL/TLS to connect to the DB instance, follow the appropriate instructions for your DB engine to rotate your SSL/TLS certificate:
- For more information about rotating your SSL/TLS certificate for RDS DB engines, see Rotating Your SSL/TLS Certificate. in the Amazon RDS User Guide.
- For more information about rotating your SSL/TLS certificate for Aurora DB engines, see Rotating Your SSL/TLS Certificate in the Amazon Aurora User Guide .
This setting doesn't apply to RDS Custom.
-
setCertificateRotationRestart
A value that indicates whether the DB instance is restarted when you rotate your SSL/TLS certificate.By default, the DB instance is restarted when you rotate your SSL/TLS certificate. The certificate is not updated until the DB instance is restarted.
Set this parameter only if you are not using SSL/TLS to connect to the DB instance.
If you are using SSL/TLS to connect to the DB instance, follow the appropriate instructions for your DB engine to rotate your SSL/TLS certificate:
- For more information about rotating your SSL/TLS certificate for RDS DB engines, see Rotating Your SSL/TLS Certificate. in the Amazon RDS User Guide.
- For more information about rotating your SSL/TLS certificate for Aurora DB engines, see Rotating Your SSL/TLS Certificate in the Amazon Aurora User Guide .
This setting doesn't apply to RDS Custom.
-
setCertificateRotationRestart
A value that indicates whether the DB instance is restarted when you rotate your SSL/TLS certificate.By default, the DB instance is restarted when you rotate your SSL/TLS certificate. The certificate is not updated until the DB instance is restarted.
Set this parameter only if you are not using SSL/TLS to connect to the DB instance.
If you are using SSL/TLS to connect to the DB instance, follow the appropriate instructions for your DB engine to rotate your SSL/TLS certificate:
- For more information about rotating your SSL/TLS certificate for RDS DB engines, see Rotating Your SSL/TLS Certificate. in the Amazon RDS User Guide.
- For more information about rotating your SSL/TLS certificate for Aurora DB engines, see Rotating Your SSL/TLS Certificate in the Amazon Aurora User Guide .
This setting doesn't apply to RDS Custom.
-
getCharacterSetName
For supported engines, indicates that the DB instance should be associated with the specified character set.Amazon Aurora
Not applicable. The character set is managed by the DB cluster. For more information, see AWS::RDS::DBCluster .
-
setCharacterSetName
For supported engines, indicates that the DB instance should be associated with the specified character set.Amazon Aurora
Not applicable. The character set is managed by the DB cluster. For more information, see AWS::RDS::DBCluster .
-
getCopyTagsToSnapshot
A value that indicates whether to copy tags from the DB instance to snapshots of the DB instance.By default, tags are not copied.
Amazon Aurora
Not applicable. Copying tags to snapshots is managed by the DB cluster. Setting this value for an Aurora DB instance has no effect on the DB cluster setting.
-
setCopyTagsToSnapshot
A value that indicates whether to copy tags from the DB instance to snapshots of the DB instance.By default, tags are not copied.
Amazon Aurora
Not applicable. Copying tags to snapshots is managed by the DB cluster. Setting this value for an Aurora DB instance has no effect on the DB cluster setting.
-
setCopyTagsToSnapshot
A value that indicates whether to copy tags from the DB instance to snapshots of the DB instance.By default, tags are not copied.
Amazon Aurora
Not applicable. Copying tags to snapshots is managed by the DB cluster. Setting this value for an Aurora DB instance has no effect on the DB cluster setting.
-
getCustomIamInstanceProfile
The instance profile associated with the underlying Amazon EC2 instance of an RDS Custom DB instance.The instance profile must meet the following requirements:
- The profile must exist in your account.
- The profile must have an IAM role that Amazon EC2 has permissions to assume.
- The instance profile name and the associated IAM role name must start with the prefix
AWSRDSCustom
.
For the list of permissions required for the IAM role, see Configure IAM and your VPC in the Amazon RDS User Guide .
This setting is required for RDS Custom.
-
setCustomIamInstanceProfile
The instance profile associated with the underlying Amazon EC2 instance of an RDS Custom DB instance.The instance profile must meet the following requirements:
- The profile must exist in your account.
- The profile must have an IAM role that Amazon EC2 has permissions to assume.
- The instance profile name and the associated IAM role name must start with the prefix
AWSRDSCustom
.
For the list of permissions required for the IAM role, see Configure IAM and your VPC in the Amazon RDS User Guide .
This setting is required for RDS Custom.
-
getDbClusterIdentifier
The identifier of the DB cluster that the instance will belong to. -
setDbClusterIdentifier
The identifier of the DB cluster that the instance will belong to. -
getDbClusterSnapshotIdentifier
The identifier for the RDS for MySQL Multi-AZ DB cluster snapshot to restore from.For more information on Multi-AZ DB clusters, see Multi-AZ DB cluster deployments in the Amazon RDS User Guide .
Constraints:
- Must match the identifier of an existing Multi-AZ DB cluster snapshot.
- Can't be specified when
DBSnapshotIdentifier
is specified. - Must be specified when
DBSnapshotIdentifier
isn't specified. - If you are restoring from a shared manual Multi-AZ DB cluster snapshot, the
DBClusterSnapshotIdentifier
must be the ARN of the shared snapshot. - Can't be the identifier of an Aurora DB cluster snapshot.
- Can't be the identifier of an RDS for PostgreSQL Multi-AZ DB cluster snapshot.
-
setDbClusterSnapshotIdentifier
The identifier for the RDS for MySQL Multi-AZ DB cluster snapshot to restore from.For more information on Multi-AZ DB clusters, see Multi-AZ DB cluster deployments in the Amazon RDS User Guide .
Constraints:
- Must match the identifier of an existing Multi-AZ DB cluster snapshot.
- Can't be specified when
DBSnapshotIdentifier
is specified. - Must be specified when
DBSnapshotIdentifier
isn't specified. - If you are restoring from a shared manual Multi-AZ DB cluster snapshot, the
DBClusterSnapshotIdentifier
must be the ARN of the shared snapshot. - Can't be the identifier of an Aurora DB cluster snapshot.
- Can't be the identifier of an RDS for PostgreSQL Multi-AZ DB cluster snapshot.
-
getDbInstanceClass
The compute and memory capacity of the DB instance, for example,db.m4.large
. Not all DB instance classes are available in all AWS Regions, or for all database engines.For the full list of DB instance classes, and availability for your engine, see DB Instance Class in the Amazon RDS User Guide. For more information about DB instance class pricing and AWS Region support for DB instance classes, see Amazon RDS Pricing .
-
setDbInstanceClass
The compute and memory capacity of the DB instance, for example,db.m4.large
. Not all DB instance classes are available in all AWS Regions, or for all database engines.For the full list of DB instance classes, and availability for your engine, see DB Instance Class in the Amazon RDS User Guide. For more information about DB instance class pricing and AWS Region support for DB instance classes, see Amazon RDS Pricing .
-
getDbInstanceIdentifier
A name for the DB instance.If you specify a name, AWS CloudFormation converts it to lowercase. If you don't specify a name, AWS CloudFormation generates a unique physical ID and uses that ID for the DB instance. For more information, see Name Type .
For information about constraints that apply to DB instance identifiers, see Naming constraints in Amazon RDS in the Amazon RDS User Guide .
If you specify a name, you can't perform updates that require replacement of this resource. You can perform updates that require no or some interruption. If you must replace the resource, specify a new name.
-
setDbInstanceIdentifier
A name for the DB instance.If you specify a name, AWS CloudFormation converts it to lowercase. If you don't specify a name, AWS CloudFormation generates a unique physical ID and uses that ID for the DB instance. For more information, see Name Type .
For information about constraints that apply to DB instance identifiers, see Naming constraints in Amazon RDS in the Amazon RDS User Guide .
If you specify a name, you can't perform updates that require replacement of this resource. You can perform updates that require no or some interruption. If you must replace the resource, specify a new name.
-
getDbName
The meaning of this parameter differs according to the database engine you use.If you specify the
[DBSnapshotIdentifier](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-rds-database-instance.html#cfn-rds-dbinstance-dbsnapshotidentifier)
property, this property only applies to RDS for Oracle.Amazon Aurora
Not applicable. The database name is managed by the DB cluster.
MySQL
The name of the database to create when the DB instance is created. If this parameter is not specified, no database is created in the DB instance.
Constraints:
- Must contain 1 to 64 letters or numbers.
- Can't be a word reserved by the specified database engine
MariaDB
The name of the database to create when the DB instance is created. If this parameter is not specified, no database is created in the DB instance.
Constraints:
- Must contain 1 to 64 letters or numbers.
- Can't be a word reserved by the specified database engine
PostgreSQL
The name of the database to create when the DB instance is created. If this parameter is not specified, the default
postgres
database is created in the DB instance.Constraints:
- Must begin with a letter. Subsequent characters can be letters, underscores, or digits (0-9).
- Must contain 1 to 63 characters.
- Can't be a word reserved by the specified database engine
Oracle
The Oracle System ID (SID) of the created DB instance. If you specify
null
, the default valueORCL
is used. You can't specify the string NULL, or any other reserved word, forDBName
.Default:
ORCL
Constraints:
- Can't be longer than 8 characters
SQL Server
Not applicable. Must be null.
-
setDbName
The meaning of this parameter differs according to the database engine you use.If you specify the
[DBSnapshotIdentifier](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-rds-database-instance.html#cfn-rds-dbinstance-dbsnapshotidentifier)
property, this property only applies to RDS for Oracle.Amazon Aurora
Not applicable. The database name is managed by the DB cluster.
MySQL
The name of the database to create when the DB instance is created. If this parameter is not specified, no database is created in the DB instance.
Constraints:
- Must contain 1 to 64 letters or numbers.
- Can't be a word reserved by the specified database engine
MariaDB
The name of the database to create when the DB instance is created. If this parameter is not specified, no database is created in the DB instance.
Constraints:
- Must contain 1 to 64 letters or numbers.
- Can't be a word reserved by the specified database engine
PostgreSQL
The name of the database to create when the DB instance is created. If this parameter is not specified, the default
postgres
database is created in the DB instance.Constraints:
- Must begin with a letter. Subsequent characters can be letters, underscores, or digits (0-9).
- Must contain 1 to 63 characters.
- Can't be a word reserved by the specified database engine
Oracle
The Oracle System ID (SID) of the created DB instance. If you specify
null
, the default valueORCL
is used. You can't specify the string NULL, or any other reserved word, forDBName
.Default:
ORCL
Constraints:
- Can't be longer than 8 characters
SQL Server
Not applicable. Must be null.
-
getDbParameterGroupName
The name of an existing DB parameter group or a reference to an AWS::RDS::DBParameterGroup resource created in the template.To list all of the available DB parameter group names, use the following command:
aws rds describe-db-parameter-groups --query "DBParameterGroups[].DBParameterGroupName" --output text
If any of the data members of the referenced parameter group are changed during an update, the DB instance might need to be restarted, which causes some interruption. If the parameter group contains static parameters, whether they were changed or not, an update triggers a reboot.
If you don't specify a value for
DBParameterGroupName
property, the default DB parameter group for the specified engine and engine version is used. -
setDbParameterGroupName
The name of an existing DB parameter group or a reference to an AWS::RDS::DBParameterGroup resource created in the template.To list all of the available DB parameter group names, use the following command:
aws rds describe-db-parameter-groups --query "DBParameterGroups[].DBParameterGroupName" --output text
If any of the data members of the referenced parameter group are changed during an update, the DB instance might need to be restarted, which causes some interruption. If the parameter group contains static parameters, whether they were changed or not, an update triggers a reboot.
If you don't specify a value for
DBParameterGroupName
property, the default DB parameter group for the specified engine and engine version is used. -
getDbSecurityGroups
A list of the DB security groups to assign to the DB instance.The list can include both the name of existing DB security groups or references to AWS::RDS::DBSecurityGroup resources created in the template.
If you set DBSecurityGroups, you must not set VPCSecurityGroups, and vice versa. Also, note that the DBSecurityGroups property exists only for backwards compatibility with older regions and is no longer recommended for providing security information to an RDS DB instance. Instead, use VPCSecurityGroups.
If you specify this property, AWS CloudFormation sends only the following properties (if specified) to Amazon RDS during create operations:
AllocatedStorage
AutoMinorVersionUpgrade
AvailabilityZone
BackupRetentionPeriod
CharacterSetName
DBInstanceClass
DBName
DBParameterGroupName
DBSecurityGroups
DBSubnetGroupName
Engine
EngineVersion
Iops
LicenseModel
MasterUsername
MasterUserPassword
MultiAZ
OptionGroupName
PreferredBackupWindow
PreferredMaintenanceWindow
All other properties are ignored. Specify a virtual private cloud (VPC) security group if you want to submit other properties, such as
StorageType
,StorageEncrypted
, orKmsKeyId
. If you're already using theDBSecurityGroups
property, you can't use these other properties by updating your DB instance to use a VPC security group. You must recreate the DB instance. -
setDbSecurityGroups
A list of the DB security groups to assign to the DB instance.The list can include both the name of existing DB security groups or references to AWS::RDS::DBSecurityGroup resources created in the template.
If you set DBSecurityGroups, you must not set VPCSecurityGroups, and vice versa. Also, note that the DBSecurityGroups property exists only for backwards compatibility with older regions and is no longer recommended for providing security information to an RDS DB instance. Instead, use VPCSecurityGroups.
If you specify this property, AWS CloudFormation sends only the following properties (if specified) to Amazon RDS during create operations:
AllocatedStorage
AutoMinorVersionUpgrade
AvailabilityZone
BackupRetentionPeriod
CharacterSetName
DBInstanceClass
DBName
DBParameterGroupName
DBSecurityGroups
DBSubnetGroupName
Engine
EngineVersion
Iops
LicenseModel
MasterUsername
MasterUserPassword
MultiAZ
OptionGroupName
PreferredBackupWindow
PreferredMaintenanceWindow
All other properties are ignored. Specify a virtual private cloud (VPC) security group if you want to submit other properties, such as
StorageType
,StorageEncrypted
, orKmsKeyId
. If you're already using theDBSecurityGroups
property, you can't use these other properties by updating your DB instance to use a VPC security group. You must recreate the DB instance. -
getDbSnapshotIdentifier
The name or Amazon Resource Name (ARN) of the DB snapshot that's used to restore the DB instance.If you're restoring from a shared manual DB snapshot, you must specify the ARN of the snapshot.
By specifying this property, you can create a DB instance from the specified DB snapshot. If the
DBSnapshotIdentifier
property is an empty string or theAWS::RDS::DBInstance
declaration has noDBSnapshotIdentifier
property, AWS CloudFormation creates a new database. If the property contains a value (other than an empty string), AWS CloudFormation creates a database from the specified snapshot. If a snapshot with the specified name doesn't exist, AWS CloudFormation can't create the database and it rolls back the stack.Some DB instance properties aren't valid when you restore from a snapshot, such as the
MasterUsername
andMasterUserPassword
properties. For information about the properties that you can specify, see theRestoreDBInstanceFromDBSnapshot
action in the Amazon RDS API Reference .After you restore a DB instance with a
DBSnapshotIdentifier
property, you must specify the sameDBSnapshotIdentifier
property for any future updates to the DB instance. When you specify this property for an update, the DB instance is not restored from the DB snapshot again, and the data in the database is not changed. However, if you don't specify theDBSnapshotIdentifier
property, an empty DB instance is created, and the original DB instance is deleted. If you specify a property that is different from the previous snapshot restore property, a new DB instance is restored from the specifiedDBSnapshotIdentifier
property, and the original DB instance is deleted.If you specify the
DBSnapshotIdentifier
property to restore a DB instance (as opposed to specifying it for DB instance updates), then don't specify the following properties:CharacterSetName
DBClusterIdentifier
DBName
DeleteAutomatedBackups
EnablePerformanceInsights
KmsKeyId
MasterUsername
MasterUserPassword
PerformanceInsightsKMSKeyId
PerformanceInsightsRetentionPeriod
PromotionTier
SourceDBInstanceIdentifier
SourceRegion
StorageEncrypted
(for an encrypted snapshot)Timezone
Amazon Aurora
Not applicable. Snapshot restore is managed by the DB cluster.
-
setDbSnapshotIdentifier
The name or Amazon Resource Name (ARN) of the DB snapshot that's used to restore the DB instance.If you're restoring from a shared manual DB snapshot, you must specify the ARN of the snapshot.
By specifying this property, you can create a DB instance from the specified DB snapshot. If the
DBSnapshotIdentifier
property is an empty string or theAWS::RDS::DBInstance
declaration has noDBSnapshotIdentifier
property, AWS CloudFormation creates a new database. If the property contains a value (other than an empty string), AWS CloudFormation creates a database from the specified snapshot. If a snapshot with the specified name doesn't exist, AWS CloudFormation can't create the database and it rolls back the stack.Some DB instance properties aren't valid when you restore from a snapshot, such as the
MasterUsername
andMasterUserPassword
properties. For information about the properties that you can specify, see theRestoreDBInstanceFromDBSnapshot
action in the Amazon RDS API Reference .After you restore a DB instance with a
DBSnapshotIdentifier
property, you must specify the sameDBSnapshotIdentifier
property for any future updates to the DB instance. When you specify this property for an update, the DB instance is not restored from the DB snapshot again, and the data in the database is not changed. However, if you don't specify theDBSnapshotIdentifier
property, an empty DB instance is created, and the original DB instance is deleted. If you specify a property that is different from the previous snapshot restore property, a new DB instance is restored from the specifiedDBSnapshotIdentifier
property, and the original DB instance is deleted.If you specify the
DBSnapshotIdentifier
property to restore a DB instance (as opposed to specifying it for DB instance updates), then don't specify the following properties:CharacterSetName
DBClusterIdentifier
DBName
DeleteAutomatedBackups
EnablePerformanceInsights
KmsKeyId
MasterUsername
MasterUserPassword
PerformanceInsightsKMSKeyId
PerformanceInsightsRetentionPeriod
PromotionTier
SourceDBInstanceIdentifier
SourceRegion
StorageEncrypted
(for an encrypted snapshot)Timezone
Amazon Aurora
Not applicable. Snapshot restore is managed by the DB cluster.
-
getDbSubnetGroupName
A DB subnet group to associate with the DB instance.If you update this value, the new subnet group must be a subnet group in a new VPC.
If there's no DB subnet group, then the DB instance isn't a VPC DB instance.
For more information about using Amazon RDS in a VPC, see Using Amazon RDS with Amazon Virtual Private Cloud (VPC) in the Amazon RDS User Guide .
Amazon Aurora
Not applicable. The DB subnet group is managed by the DB cluster. If specified, the setting must match the DB cluster setting.
-
setDbSubnetGroupName
A DB subnet group to associate with the DB instance.If you update this value, the new subnet group must be a subnet group in a new VPC.
If there's no DB subnet group, then the DB instance isn't a VPC DB instance.
For more information about using Amazon RDS in a VPC, see Using Amazon RDS with Amazon Virtual Private Cloud (VPC) in the Amazon RDS User Guide .
Amazon Aurora
Not applicable. The DB subnet group is managed by the DB cluster. If specified, the setting must match the DB cluster setting.
-
getDeleteAutomatedBackups
A value that indicates whether to remove automated backups immediately after the DB instance is deleted.This parameter isn't case-sensitive. The default is to remove automated backups immediately after the DB instance is deleted.
Amazon Aurora
Not applicable. When you delete a DB cluster, all automated backups for that DB cluster are deleted and can't be recovered. Manual DB cluster snapshots of the DB cluster are not deleted.
-
setDeleteAutomatedBackups
A value that indicates whether to remove automated backups immediately after the DB instance is deleted.This parameter isn't case-sensitive. The default is to remove automated backups immediately after the DB instance is deleted.
Amazon Aurora
Not applicable. When you delete a DB cluster, all automated backups for that DB cluster are deleted and can't be recovered. Manual DB cluster snapshots of the DB cluster are not deleted.
-
setDeleteAutomatedBackups
A value that indicates whether to remove automated backups immediately after the DB instance is deleted.This parameter isn't case-sensitive. The default is to remove automated backups immediately after the DB instance is deleted.
Amazon Aurora
Not applicable. When you delete a DB cluster, all automated backups for that DB cluster are deleted and can't be recovered. Manual DB cluster snapshots of the DB cluster are not deleted.
-
getDeletionProtection
A value that indicates whether the DB instance has deletion protection enabled.The database can't be deleted when deletion protection is enabled. By default, deletion protection is disabled. For more information, see Deleting a DB Instance .
Amazon Aurora
Not applicable. You can enable or disable deletion protection for the DB cluster. For more information, see
CreateDBCluster
. DB instances in a DB cluster can be deleted even when deletion protection is enabled for the DB cluster. -
setDeletionProtection
A value that indicates whether the DB instance has deletion protection enabled.The database can't be deleted when deletion protection is enabled. By default, deletion protection is disabled. For more information, see Deleting a DB Instance .
Amazon Aurora
Not applicable. You can enable or disable deletion protection for the DB cluster. For more information, see
CreateDBCluster
. DB instances in a DB cluster can be deleted even when deletion protection is enabled for the DB cluster. -
setDeletionProtection
A value that indicates whether the DB instance has deletion protection enabled.The database can't be deleted when deletion protection is enabled. By default, deletion protection is disabled. For more information, see Deleting a DB Instance .
Amazon Aurora
Not applicable. You can enable or disable deletion protection for the DB cluster. For more information, see
CreateDBCluster
. DB instances in a DB cluster can be deleted even when deletion protection is enabled for the DB cluster. -
getDomain
The Active Directory directory ID to create the DB instance in.Currently, only Microsoft SQL Server, Oracle, and PostgreSQL DB instances can be created in an Active Directory Domain.
For more information, see Kerberos Authentication in the Amazon RDS User Guide .
-
setDomain
The Active Directory directory ID to create the DB instance in.Currently, only Microsoft SQL Server, Oracle, and PostgreSQL DB instances can be created in an Active Directory Domain.
For more information, see Kerberos Authentication in the Amazon RDS User Guide .
-
getDomainIamRoleName
Specify the name of the IAM role to be used when making API calls to the Directory Service.This setting doesn't apply to RDS Custom.
Amazon Aurora
Not applicable. The domain is managed by the DB cluster.
-
setDomainIamRoleName
Specify the name of the IAM role to be used when making API calls to the Directory Service.This setting doesn't apply to RDS Custom.
Amazon Aurora
Not applicable. The domain is managed by the DB cluster.
-
getEnableCloudwatchLogsExports
The list of log types that need to be enabled for exporting to CloudWatch Logs.The values in the list depend on the DB engine being used. For more information, see Publishing Database Logs to Amazon CloudWatch Logs in the Amazon Relational Database Service User Guide .
Amazon Aurora
Not applicable. CloudWatch Logs exports are managed by the DB cluster.
MariaDB
Valid values:
audit
,error
,general
,slowquery
Microsoft SQL Server
Valid values:
agent
,error
MySQL
Valid values:
audit
,error
,general
,slowquery
Oracle
Valid values:
alert
,audit
,listener
,trace
PostgreSQL
Valid values:
postgresql
,upgrade
-
setEnableCloudwatchLogsExports
The list of log types that need to be enabled for exporting to CloudWatch Logs.The values in the list depend on the DB engine being used. For more information, see Publishing Database Logs to Amazon CloudWatch Logs in the Amazon Relational Database Service User Guide .
Amazon Aurora
Not applicable. CloudWatch Logs exports are managed by the DB cluster.
MariaDB
Valid values:
audit
,error
,general
,slowquery
Microsoft SQL Server
Valid values:
agent
,error
MySQL
Valid values:
audit
,error
,general
,slowquery
Oracle
Valid values:
alert
,audit
,listener
,trace
PostgreSQL
Valid values:
postgresql
,upgrade
-
getEnableIamDatabaseAuthentication
A value that indicates whether to enable mapping of AWS Identity and Access Management (IAM) accounts to database accounts.By default, mapping is disabled.
This property is supported for RDS for MariaDB, RDS for MySQL, and RDS for PostgreSQL. For more information, see IAM Database Authentication for MariaDB, MySQL, and PostgreSQL in the Amazon RDS User Guide.
Amazon Aurora
Not applicable. Mapping AWS IAM accounts to database accounts is managed by the DB cluster.
-
setEnableIamDatabaseAuthentication
A value that indicates whether to enable mapping of AWS Identity and Access Management (IAM) accounts to database accounts.By default, mapping is disabled.
This property is supported for RDS for MariaDB, RDS for MySQL, and RDS for PostgreSQL. For more information, see IAM Database Authentication for MariaDB, MySQL, and PostgreSQL in the Amazon RDS User Guide.
Amazon Aurora
Not applicable. Mapping AWS IAM accounts to database accounts is managed by the DB cluster.
-
setEnableIamDatabaseAuthentication
A value that indicates whether to enable mapping of AWS Identity and Access Management (IAM) accounts to database accounts.By default, mapping is disabled.
This property is supported for RDS for MariaDB, RDS for MySQL, and RDS for PostgreSQL. For more information, see IAM Database Authentication for MariaDB, MySQL, and PostgreSQL in the Amazon RDS User Guide.
Amazon Aurora
Not applicable. Mapping AWS IAM accounts to database accounts is managed by the DB cluster.
-
getEnablePerformanceInsights
A value that indicates whether to enable Performance Insights for the DB instance.For more information, see Using Amazon Performance Insights in the Amazon RDS User Guide .
This setting doesn't apply to RDS Custom.
-
setEnablePerformanceInsights
A value that indicates whether to enable Performance Insights for the DB instance.For more information, see Using Amazon Performance Insights in the Amazon RDS User Guide .
This setting doesn't apply to RDS Custom.
-
setEnablePerformanceInsights
A value that indicates whether to enable Performance Insights for the DB instance.For more information, see Using Amazon Performance Insights in the Amazon RDS User Guide .
This setting doesn't apply to RDS Custom.
-
getEndpoint
Specifies the connection endpoint.The endpoint might not be shown for instances whose status is
creating
. -
setEndpoint
Specifies the connection endpoint.The endpoint might not be shown for instances whose status is
creating
. -
setEndpoint
Specifies the connection endpoint.The endpoint might not be shown for instances whose status is
creating
. -
getEngine
The name of the database engine that you want to use for this DB instance.When you are creating a DB instance, the
Engine
property is required.Valid Values:
aurora-mysql
(for Aurora MySQL DB instances)aurora-postgresql
(for Aurora PostgreSQL DB instances)custom-oracle-ee
(for RDS Custom for Oracle DB instances)custom-oracle-ee-cdb
(for RDS Custom for Oracle DB instances)custom-sqlserver-ee
(for RDS Custom for SQL Server DB instances)custom-sqlserver-se
(for RDS Custom for SQL Server DB instances)custom-sqlserver-web
(for RDS Custom for SQL Server DB instances)mariadb
mysql
oracle-ee
oracle-ee-cdb
oracle-se2
oracle-se2-cdb
postgres
sqlserver-ee
sqlserver-se
sqlserver-ex
sqlserver-web
-
setEngine
The name of the database engine that you want to use for this DB instance.When you are creating a DB instance, the
Engine
property is required.Valid Values:
aurora-mysql
(for Aurora MySQL DB instances)aurora-postgresql
(for Aurora PostgreSQL DB instances)custom-oracle-ee
(for RDS Custom for Oracle DB instances)custom-oracle-ee-cdb
(for RDS Custom for Oracle DB instances)custom-sqlserver-ee
(for RDS Custom for SQL Server DB instances)custom-sqlserver-se
(for RDS Custom for SQL Server DB instances)custom-sqlserver-web
(for RDS Custom for SQL Server DB instances)mariadb
mysql
oracle-ee
oracle-ee-cdb
oracle-se2
oracle-se2-cdb
postgres
sqlserver-ee
sqlserver-se
sqlserver-ex
sqlserver-web
-
getEngineVersion
The version number of the database engine to use.For a list of valid engine versions, use the
DescribeDBEngineVersions
action.The following are the database engines and links to information about the major and minor versions that are available with Amazon RDS. Not every database engine is available for every AWS Region.
Amazon Aurora
Not applicable. The version number of the database engine to be used by the DB instance is managed by the DB cluster.
MariaDB
See MariaDB on Amazon RDS Versions in the Amazon RDS User Guide.
Microsoft SQL Server
See Microsoft SQL Server Versions on Amazon RDS in the Amazon RDS User Guide.
MySQL
See MySQL on Amazon RDS Versions in the Amazon RDS User Guide.
Oracle
See Oracle Database Engine Release Notes in the Amazon RDS User Guide.
PostgreSQL
See Supported PostgreSQL Database Versions in the Amazon RDS User Guide.
-
setEngineVersion
The version number of the database engine to use.For a list of valid engine versions, use the
DescribeDBEngineVersions
action.The following are the database engines and links to information about the major and minor versions that are available with Amazon RDS. Not every database engine is available for every AWS Region.
Amazon Aurora
Not applicable. The version number of the database engine to be used by the DB instance is managed by the DB cluster.
MariaDB
See MariaDB on Amazon RDS Versions in the Amazon RDS User Guide.
Microsoft SQL Server
See Microsoft SQL Server Versions on Amazon RDS in the Amazon RDS User Guide.
MySQL
See MySQL on Amazon RDS Versions in the Amazon RDS User Guide.
Oracle
See Oracle Database Engine Release Notes in the Amazon RDS User Guide.
PostgreSQL
See Supported PostgreSQL Database Versions in the Amazon RDS User Guide.
-
getIops
The number of I/O operations per second (IOPS) that the database provisions.The value must be equal to or greater than 1000.
If you specify this property, you must follow the range of allowed ratios of your requested IOPS rate to the amount of storage that you allocate (IOPS to allocated storage). For example, you can provision an Oracle database instance with 1000 IOPS and 200 GiB of storage (a ratio of 5:1), or specify 2000 IOPS with 200 GiB of storage (a ratio of 10:1). For more information, see Amazon RDS Provisioned IOPS Storage to Improve Performance in the Amazon RDS User Guide .
If you specify
io1
for theStorageType
property, then you must also specify theIops
property. -
setIops
The number of I/O operations per second (IOPS) that the database provisions.The value must be equal to or greater than 1000.
If you specify this property, you must follow the range of allowed ratios of your requested IOPS rate to the amount of storage that you allocate (IOPS to allocated storage). For example, you can provision an Oracle database instance with 1000 IOPS and 200 GiB of storage (a ratio of 5:1), or specify 2000 IOPS with 200 GiB of storage (a ratio of 10:1). For more information, see Amazon RDS Provisioned IOPS Storage to Improve Performance in the Amazon RDS User Guide .
If you specify
io1
for theStorageType
property, then you must also specify theIops
property. -
getKmsKeyId
The ARN of the AWS KMS key that's used to encrypt the DB instance, such asarn:aws:kms:us-east-1:012345678910:key/abcd1234-a123-456a-a12b-a123b4cd56ef
.If you enable the StorageEncrypted property but don't specify this property, AWS CloudFormation uses the default KMS key. If you specify this property, you must set the StorageEncrypted property to true.
If you specify the
SourceDBInstanceIdentifier
property, the value is inherited from the source DB instance if the read replica is created in the same region.If you create an encrypted read replica in a different AWS Region, then you must specify a KMS key for the destination AWS Region. KMS encryption keys are specific to the region that they're created in, and you can't use encryption keys from one region in another region.
If you specify the
SnapshotIdentifier
property, theStorageEncrypted
property value is inherited from the snapshot, and if the DB instance is encrypted, the specifiedKmsKeyId
property is used.If you specify
DBSecurityGroups
, AWS CloudFormation ignores this property. To specify both a security group and this property, you must use a VPC security group. For more information about Amazon RDS and VPC, see Using Amazon RDS with Amazon VPC in the Amazon RDS User Guide .Amazon Aurora
Not applicable. The KMS key identifier is managed by the DB cluster.
-
setKmsKeyId
The ARN of the AWS KMS key that's used to encrypt the DB instance, such asarn:aws:kms:us-east-1:012345678910:key/abcd1234-a123-456a-a12b-a123b4cd56ef
.If you enable the StorageEncrypted property but don't specify this property, AWS CloudFormation uses the default KMS key. If you specify this property, you must set the StorageEncrypted property to true.
If you specify the
SourceDBInstanceIdentifier
property, the value is inherited from the source DB instance if the read replica is created in the same region.If you create an encrypted read replica in a different AWS Region, then you must specify a KMS key for the destination AWS Region. KMS encryption keys are specific to the region that they're created in, and you can't use encryption keys from one region in another region.
If you specify the
SnapshotIdentifier
property, theStorageEncrypted
property value is inherited from the snapshot, and if the DB instance is encrypted, the specifiedKmsKeyId
property is used.If you specify
DBSecurityGroups
, AWS CloudFormation ignores this property. To specify both a security group and this property, you must use a VPC security group. For more information about Amazon RDS and VPC, see Using Amazon RDS with Amazon VPC in the Amazon RDS User Guide .Amazon Aurora
Not applicable. The KMS key identifier is managed by the DB cluster.
-
getLicenseModel
License model information for this DB instance.Valid values:
- Aurora MySQL -
general-public-license
- Aurora PostgreSQL -
postgresql-license
- MariaDB -
general-public-license
- Microsoft SQL Server -
license-included
- MySQL -
general-public-license
- Oracle -
bring-your-own-license
orlicense-included
- PostgreSQL -
postgresql-license
If you've specified
DBSecurityGroups
and then you update the license model, AWS CloudFormation replaces the underlying DB instance. This will incur some interruptions to database availability. - Aurora MySQL -
-
setLicenseModel
License model information for this DB instance.Valid values:
- Aurora MySQL -
general-public-license
- Aurora PostgreSQL -
postgresql-license
- MariaDB -
general-public-license
- Microsoft SQL Server -
license-included
- MySQL -
general-public-license
- Oracle -
bring-your-own-license
orlicense-included
- PostgreSQL -
postgresql-license
If you've specified
DBSecurityGroups
and then you update the license model, AWS CloudFormation replaces the underlying DB instance. This will incur some interruptions to database availability. - Aurora MySQL -
-
getManageMasterUserPassword
A value that indicates whether to manage the master user password with AWS Secrets Manager.For more information, see Password management with AWS Secrets Manager in the Amazon RDS User Guide.
Constraints:
- Can't manage the master user password with AWS Secrets Manager if
MasterUserPassword
is specified.
- Can't manage the master user password with AWS Secrets Manager if
-
setManageMasterUserPassword
A value that indicates whether to manage the master user password with AWS Secrets Manager.For more information, see Password management with AWS Secrets Manager in the Amazon RDS User Guide.
Constraints:
- Can't manage the master user password with AWS Secrets Manager if
MasterUserPassword
is specified.
- Can't manage the master user password with AWS Secrets Manager if
-
setManageMasterUserPassword
A value that indicates whether to manage the master user password with AWS Secrets Manager.For more information, see Password management with AWS Secrets Manager in the Amazon RDS User Guide.
Constraints:
- Can't manage the master user password with AWS Secrets Manager if
MasterUserPassword
is specified.
- Can't manage the master user password with AWS Secrets Manager if
-
getMasterUsername
The master user name for the DB instance.If you specify the
SourceDBInstanceIdentifier
orDBSnapshotIdentifier
property, don't specify this property. The value is inherited from the source DB instance or snapshot.Amazon Aurora
Not applicable. The name for the master user is managed by the DB cluster.
MariaDB
Constraints:
- Required for MariaDB.
- Must be 1 to 16 letters or numbers.
- Can't be a reserved word for the chosen database engine.
Microsoft SQL Server
Constraints:
- Required for SQL Server.
- Must be 1 to 128 letters or numbers.
- The first character must be a letter.
- Can't be a reserved word for the chosen database engine.
MySQL
Constraints:
- Required for MySQL.
- Must be 1 to 16 letters or numbers.
- First character must be a letter.
- Can't be a reserved word for the chosen database engine.
Oracle
Constraints:
- Required for Oracle.
- Must be 1 to 30 letters or numbers.
- First character must be a letter.
- Can't be a reserved word for the chosen database engine.
PostgreSQL
Constraints:
- Required for PostgreSQL.
- Must be 1 to 63 letters or numbers.
- First character must be a letter.
- Can't be a reserved word for the chosen database engine.
-
setMasterUsername
The master user name for the DB instance.If you specify the
SourceDBInstanceIdentifier
orDBSnapshotIdentifier
property, don't specify this property. The value is inherited from the source DB instance or snapshot.Amazon Aurora
Not applicable. The name for the master user is managed by the DB cluster.
MariaDB
Constraints:
- Required for MariaDB.
- Must be 1 to 16 letters or numbers.
- Can't be a reserved word for the chosen database engine.
Microsoft SQL Server
Constraints:
- Required for SQL Server.
- Must be 1 to 128 letters or numbers.
- The first character must be a letter.
- Can't be a reserved word for the chosen database engine.
MySQL
Constraints:
- Required for MySQL.
- Must be 1 to 16 letters or numbers.
- First character must be a letter.
- Can't be a reserved word for the chosen database engine.
Oracle
Constraints:
- Required for Oracle.
- Must be 1 to 30 letters or numbers.
- First character must be a letter.
- Can't be a reserved word for the chosen database engine.
PostgreSQL
Constraints:
- Required for PostgreSQL.
- Must be 1 to 63 letters or numbers.
- First character must be a letter.
- Can't be a reserved word for the chosen database engine.
-
getMasterUserPassword
The password for the master user. The password can include any printable ASCII character except "/", """, or "@".Amazon Aurora
Not applicable. The password for the master user is managed by the DB cluster.
MariaDB
Constraints: Must contain from 8 to 41 characters.
Microsoft SQL Server
Constraints: Must contain from 8 to 128 characters.
MySQL
Constraints: Must contain from 8 to 41 characters.
Oracle
Constraints: Must contain from 8 to 30 characters.
PostgreSQL
Constraints: Must contain from 8 to 128 characters.
-
setMasterUserPassword
The password for the master user. The password can include any printable ASCII character except "/", """, or "@".Amazon Aurora
Not applicable. The password for the master user is managed by the DB cluster.
MariaDB
Constraints: Must contain from 8 to 41 characters.
Microsoft SQL Server
Constraints: Must contain from 8 to 128 characters.
MySQL
Constraints: Must contain from 8 to 41 characters.
Oracle
Constraints: Must contain from 8 to 30 characters.
PostgreSQL
Constraints: Must contain from 8 to 128 characters.
-
getMasterUserSecret
Contains the secret managed by RDS in AWS Secrets Manager for the master user password.For more information, see Password management with AWS Secrets Manager in the Amazon RDS User Guide.
-
setMasterUserSecret
Contains the secret managed by RDS in AWS Secrets Manager for the master user password.For more information, see Password management with AWS Secrets Manager in the Amazon RDS User Guide.
-
setMasterUserSecret
@Stability(Stable) public void setMasterUserSecret(@Nullable CfnDBInstance.MasterUserSecretProperty value) Contains the secret managed by RDS in AWS Secrets Manager for the master user password.For more information, see Password management with AWS Secrets Manager in the Amazon RDS User Guide.
-
getMaxAllocatedStorage
The upper limit in gibibytes (GiB) to which Amazon RDS can automatically scale the storage of the DB instance.For more information about this setting, including limitations that apply to it, see Managing capacity automatically with Amazon RDS storage autoscaling in the Amazon RDS User Guide .
This setting doesn't apply to RDS Custom.
Amazon Aurora
Not applicable. Storage is managed by the DB cluster.
-
setMaxAllocatedStorage
The upper limit in gibibytes (GiB) to which Amazon RDS can automatically scale the storage of the DB instance.For more information about this setting, including limitations that apply to it, see Managing capacity automatically with Amazon RDS storage autoscaling in the Amazon RDS User Guide .
This setting doesn't apply to RDS Custom.
Amazon Aurora
Not applicable. Storage is managed by the DB cluster.
-
getMonitoringInterval
The interval, in seconds, between points when Enhanced Monitoring metrics are collected for the DB instance.To disable collection of Enhanced Monitoring metrics, specify 0. The default is 0.
If
MonitoringRoleArn
is specified, then you must setMonitoringInterval
to a value other than 0.This setting doesn't apply to RDS Custom.
Valid Values:
0, 1, 5, 10, 15, 30, 60
-
setMonitoringInterval
The interval, in seconds, between points when Enhanced Monitoring metrics are collected for the DB instance.To disable collection of Enhanced Monitoring metrics, specify 0. The default is 0.
If
MonitoringRoleArn
is specified, then you must setMonitoringInterval
to a value other than 0.This setting doesn't apply to RDS Custom.
Valid Values:
0, 1, 5, 10, 15, 30, 60
-
getMonitoringRoleArn
The ARN for the IAM role that permits RDS to send enhanced monitoring metrics to Amazon CloudWatch Logs.For example,
arn:aws:iam:123456789012:role/emaccess
. For information on creating a monitoring role, see Setting Up and Enabling Enhanced Monitoring in the Amazon RDS User Guide .If
MonitoringInterval
is set to a value other than 0, then you must supply aMonitoringRoleArn
value.This setting doesn't apply to RDS Custom.
-
setMonitoringRoleArn
The ARN for the IAM role that permits RDS to send enhanced monitoring metrics to Amazon CloudWatch Logs.For example,
arn:aws:iam:123456789012:role/emaccess
. For information on creating a monitoring role, see Setting Up and Enabling Enhanced Monitoring in the Amazon RDS User Guide .If
MonitoringInterval
is set to a value other than 0, then you must supply aMonitoringRoleArn
value.This setting doesn't apply to RDS Custom.
-
getMultiAz
Specifies whether the database instance is a Multi-AZ DB instance deployment.You can't set the
AvailabilityZone
parameter if theMultiAZ
parameter is set to true.For more information, see Multi-AZ deployments for high availability in the Amazon RDS User Guide .
Amazon Aurora
Not applicable. Amazon Aurora storage is replicated across all of the Availability Zones and doesn't require the
MultiAZ
option to be set. -
setMultiAz
Specifies whether the database instance is a Multi-AZ DB instance deployment.You can't set the
AvailabilityZone
parameter if theMultiAZ
parameter is set to true.For more information, see Multi-AZ deployments for high availability in the Amazon RDS User Guide .
Amazon Aurora
Not applicable. Amazon Aurora storage is replicated across all of the Availability Zones and doesn't require the
MultiAZ
option to be set. -
setMultiAz
Specifies whether the database instance is a Multi-AZ DB instance deployment.You can't set the
AvailabilityZone
parameter if theMultiAZ
parameter is set to true.For more information, see Multi-AZ deployments for high availability in the Amazon RDS User Guide .
Amazon Aurora
Not applicable. Amazon Aurora storage is replicated across all of the Availability Zones and doesn't require the
MultiAZ
option to be set. -
getNcharCharacterSetName
The name of the NCHAR character set for the Oracle DB instance.This parameter doesn't apply to RDS Custom.
-
setNcharCharacterSetName
The name of the NCHAR character set for the Oracle DB instance.This parameter doesn't apply to RDS Custom.
-
getNetworkType
The network type of the DB instance.Valid values:
IPV4
DUAL
The network type is determined by the
DBSubnetGroup
specified for the DB instance. ADBSubnetGroup
can support only the IPv4 protocol or the IPv4 and IPv6 protocols (DUAL
).For more information, see Working with a DB instance in a VPC in the Amazon RDS User Guide.
-
setNetworkType
The network type of the DB instance.Valid values:
IPV4
DUAL
The network type is determined by the
DBSubnetGroup
specified for the DB instance. ADBSubnetGroup
can support only the IPv4 protocol or the IPv4 and IPv6 protocols (DUAL
).For more information, see Working with a DB instance in a VPC in the Amazon RDS User Guide.
-
getOptionGroupName
Indicates that the DB instance should be associated with the specified option group.Permanent options, such as the TDE option for Oracle Advanced Security TDE, can't be removed from an option group. Also, that option group can't be removed from a DB instance once it is associated with a DB instance.
-
setOptionGroupName
Indicates that the DB instance should be associated with the specified option group.Permanent options, such as the TDE option for Oracle Advanced Security TDE, can't be removed from an option group. Also, that option group can't be removed from a DB instance once it is associated with a DB instance.
-
getPerformanceInsightsKmsKeyId
The AWS KMS key identifier for encryption of Performance Insights data.The KMS key identifier is the key ARN, key ID, alias ARN, or alias name for the KMS key.
If you do not specify a value for
PerformanceInsightsKMSKeyId
, then Amazon RDS uses your default KMS key. There is a default KMS key for your AWS account. Your AWS account has a different default KMS key for each AWS Region.For information about enabling Performance Insights, see EnablePerformanceInsights .
-
setPerformanceInsightsKmsKeyId
The AWS KMS key identifier for encryption of Performance Insights data.The KMS key identifier is the key ARN, key ID, alias ARN, or alias name for the KMS key.
If you do not specify a value for
PerformanceInsightsKMSKeyId
, then Amazon RDS uses your default KMS key. There is a default KMS key for your AWS account. Your AWS account has a different default KMS key for each AWS Region.For information about enabling Performance Insights, see EnablePerformanceInsights .
-
getPerformanceInsightsRetentionPeriod
The number of days to retain Performance Insights data. The default is 7 days. The following values are valid:.- 7
- month * 31, where month is a number of months from 1-23
- 731
For example, the following values are valid:
- 93 (3 months * 31)
- 341 (11 months * 31)
- 589 (19 months * 31)
- 731
If you specify a retention period such as 94, which isn't a valid value, RDS issues an error.
This setting doesn't apply to RDS Custom.
-
setPerformanceInsightsRetentionPeriod
The number of days to retain Performance Insights data. The default is 7 days. The following values are valid:.- 7
- month * 31, where month is a number of months from 1-23
- 731
For example, the following values are valid:
- 93 (3 months * 31)
- 341 (11 months * 31)
- 589 (19 months * 31)
- 731
If you specify a retention period such as 94, which isn't a valid value, RDS issues an error.
This setting doesn't apply to RDS Custom.
-
getPort
The port number on which the database accepts connections.Amazon Aurora
Not applicable. The port number is managed by the DB cluster.
-
setPort
The port number on which the database accepts connections.Amazon Aurora
Not applicable. The port number is managed by the DB cluster.
-
getPreferredBackupWindow
The daily time range during which automated backups are created if automated backups are enabled, using theBackupRetentionPeriod
parameter.For more information, see Backup Window in the Amazon RDS User Guide.
Constraints:
- Must be in the format
hh24:mi-hh24:mi
. - Must be in Universal Coordinated Time (UTC).
- Must not conflict with the preferred maintenance window.
- Must be at least 30 minutes.
Amazon Aurora
Not applicable. The daily time range for creating automated backups is managed by the DB cluster.
- Must be in the format
-
setPreferredBackupWindow
The daily time range during which automated backups are created if automated backups are enabled, using theBackupRetentionPeriod
parameter.For more information, see Backup Window in the Amazon RDS User Guide.
Constraints:
- Must be in the format
hh24:mi-hh24:mi
. - Must be in Universal Coordinated Time (UTC).
- Must not conflict with the preferred maintenance window.
- Must be at least 30 minutes.
Amazon Aurora
Not applicable. The daily time range for creating automated backups is managed by the DB cluster.
- Must be in the format
-
getPreferredMaintenanceWindow
The weekly time range during which system maintenance can occur, in Universal Coordinated Time (UTC).Format:
ddd:hh24:mi-ddd:hh24:mi
The default is a 30-minute window selected at random from an 8-hour block of time for each AWS Region, occurring on a random day of the week. To see the time blocks available, see Adjusting the Preferred DB Instance Maintenance Window in the Amazon RDS User Guide.
This property applies when AWS CloudFormation initially creates the DB instance. If you use AWS CloudFormation to update the DB instance, those updates are applied immediately.
Constraints: Minimum 30-minute window.
-
setPreferredMaintenanceWindow
The weekly time range during which system maintenance can occur, in Universal Coordinated Time (UTC).Format:
ddd:hh24:mi-ddd:hh24:mi
The default is a 30-minute window selected at random from an 8-hour block of time for each AWS Region, occurring on a random day of the week. To see the time blocks available, see Adjusting the Preferred DB Instance Maintenance Window in the Amazon RDS User Guide.
This property applies when AWS CloudFormation initially creates the DB instance. If you use AWS CloudFormation to update the DB instance, those updates are applied immediately.
Constraints: Minimum 30-minute window.
-
getProcessorFeatures
The number of CPU cores and the number of threads per core for the DB instance class of the DB instance.This setting doesn't apply to RDS Custom.
Amazon Aurora
Not applicable.
-
setProcessorFeatures
The number of CPU cores and the number of threads per core for the DB instance class of the DB instance.This setting doesn't apply to RDS Custom.
Amazon Aurora
Not applicable.
-
setProcessorFeatures
The number of CPU cores and the number of threads per core for the DB instance class of the DB instance.This setting doesn't apply to RDS Custom.
Amazon Aurora
Not applicable.
-
getPromotionTier
A value that specifies the order in which an Aurora Replica is promoted to the primary instance after a failure of the existing primary instance.For more information, see Fault Tolerance for an Aurora DB Cluster in the Amazon Aurora User Guide .
This setting doesn't apply to RDS Custom.
Default: 1
Valid Values: 0 - 15
-
setPromotionTier
A value that specifies the order in which an Aurora Replica is promoted to the primary instance after a failure of the existing primary instance.For more information, see Fault Tolerance for an Aurora DB Cluster in the Amazon Aurora User Guide .
This setting doesn't apply to RDS Custom.
Default: 1
Valid Values: 0 - 15
-
getPubliclyAccessible
Indicates whether the DB instance is an internet-facing instance.If you specify true, AWS CloudFormation creates an instance with a publicly resolvable DNS name, which resolves to a public IP address. If you specify false, AWS CloudFormation creates an internal instance with a DNS name that resolves to a private IP address.
The default behavior value depends on your VPC setup and the database subnet group. For more information, see the
PubliclyAccessible
parameter in the CreateDBInstance in the Amazon RDS API Reference . -
setPubliclyAccessible
Indicates whether the DB instance is an internet-facing instance.If you specify true, AWS CloudFormation creates an instance with a publicly resolvable DNS name, which resolves to a public IP address. If you specify false, AWS CloudFormation creates an internal instance with a DNS name that resolves to a private IP address.
The default behavior value depends on your VPC setup and the database subnet group. For more information, see the
PubliclyAccessible
parameter in the CreateDBInstance in the Amazon RDS API Reference . -
setPubliclyAccessible
Indicates whether the DB instance is an internet-facing instance.If you specify true, AWS CloudFormation creates an instance with a publicly resolvable DNS name, which resolves to a public IP address. If you specify false, AWS CloudFormation creates an internal instance with a DNS name that resolves to a private IP address.
The default behavior value depends on your VPC setup and the database subnet group. For more information, see the
PubliclyAccessible
parameter in the CreateDBInstance in the Amazon RDS API Reference . -
getReplicaMode
The open mode of an Oracle read replica.For more information, see Working with Oracle Read Replicas for Amazon RDS in the Amazon RDS User Guide .
This setting is only supported in RDS for Oracle.
Default:
open-read-only
Valid Values:
open-read-only
ormounted
-
setReplicaMode
The open mode of an Oracle read replica.For more information, see Working with Oracle Read Replicas for Amazon RDS in the Amazon RDS User Guide .
This setting is only supported in RDS for Oracle.
Default:
open-read-only
Valid Values:
open-read-only
ormounted
-
getRestoreTime
The date and time to restore from.Valid Values: Value must be a time in Universal Coordinated Time (UTC) format
Constraints:
- Must be before the latest restorable time for the DB instance
- Can't be specified if the
UseLatestRestorableTime
parameter is enabled
Example:
2009-09-07T23:45:00Z
-
setRestoreTime
The date and time to restore from.Valid Values: Value must be a time in Universal Coordinated Time (UTC) format
Constraints:
- Must be before the latest restorable time for the DB instance
- Can't be specified if the
UseLatestRestorableTime
parameter is enabled
Example:
2009-09-07T23:45:00Z
-
getSourceDbClusterIdentifier
The identifier of the Multi-AZ DB cluster that will act as the source for the read replica.Each DB cluster can have up to 15 read replicas.
Constraints:
- Must be the identifier of an existing Multi-AZ DB cluster.
- Can't be specified if the
SourceDBInstanceIdentifier
parameter is also specified. - The specified DB cluster must have automatic backups enabled, that is, its backup retention period must be greater than 0.
- The source DB cluster must be in the same AWS Region as the read replica. Cross-Region replication isn't supported.
-
setSourceDbClusterIdentifier
The identifier of the Multi-AZ DB cluster that will act as the source for the read replica.Each DB cluster can have up to 15 read replicas.
Constraints:
- Must be the identifier of an existing Multi-AZ DB cluster.
- Can't be specified if the
SourceDBInstanceIdentifier
parameter is also specified. - The specified DB cluster must have automatic backups enabled, that is, its backup retention period must be greater than 0.
- The source DB cluster must be in the same AWS Region as the read replica. Cross-Region replication isn't supported.
-
getSourceDbInstanceAutomatedBackupsArn
The Amazon Resource Name (ARN) of the replicated automated backups from which to restore, for example,arn:aws:rds:useast-1:123456789012:auto-backup:ab-L2IJCEXJP7XQ7HOJ4SIEXAMPLE
.This setting doesn't apply to RDS Custom.
-
setSourceDbInstanceAutomatedBackupsArn
The Amazon Resource Name (ARN) of the replicated automated backups from which to restore, for example,arn:aws:rds:useast-1:123456789012:auto-backup:ab-L2IJCEXJP7XQ7HOJ4SIEXAMPLE
.This setting doesn't apply to RDS Custom.
-
getSourceDbInstanceIdentifier
If you want to create a read replica DB instance, specify the ID of the source DB instance.Each DB instance can have a limited number of read replicas. For more information, see Working with Read Replicas in the Amazon RDS User Guide .
For information about constraints that apply to DB instance identifiers, see Naming constraints in Amazon RDS in the Amazon RDS User Guide .
The
SourceDBInstanceIdentifier
property determines whether a DB instance is a read replica. If you remove theSourceDBInstanceIdentifier
property from your template and then update your stack, AWS CloudFormation promotes the Read Replica to a standalone DB instance.- If you specify a source DB instance that uses VPC security groups, we recommend that you specify the
VPCSecurityGroups
property. If you don't specify the property, the read replica inherits the value of theVPCSecurityGroups
property from the source DB when you create the replica. However, if you update the stack, AWS CloudFormation reverts the replica'sVPCSecurityGroups
property to the default value because it's not defined in the stack's template. This change might cause unexpected issues. - Read replicas don't support deletion policies. AWS CloudFormation ignores any deletion policy that's associated with a read replica.
- If you specify
SourceDBInstanceIdentifier
, don't specify theDBSnapshotIdentifier
property. You can't create a read replica from a snapshot. - Don't set the
BackupRetentionPeriod
,DBName
,MasterUsername
,MasterUserPassword
, andPreferredBackupWindow
properties. The database attributes are inherited from the source DB instance, and backups are disabled for read replicas. - If the source DB instance is in a different region than the read replica, specify the source region in
SourceRegion
, and specify an ARN for a valid DB instance inSourceDBInstanceIdentifier
. For more information, see Constructing a Amazon RDS Amazon Resource Name (ARN) in the Amazon RDS User Guide . - For DB instances in Amazon Aurora clusters, don't specify this property. Amazon RDS automatically assigns writer and reader DB instances.
- If you specify a source DB instance that uses VPC security groups, we recommend that you specify the
-
setSourceDbInstanceIdentifier
If you want to create a read replica DB instance, specify the ID of the source DB instance.Each DB instance can have a limited number of read replicas. For more information, see Working with Read Replicas in the Amazon RDS User Guide .
For information about constraints that apply to DB instance identifiers, see Naming constraints in Amazon RDS in the Amazon RDS User Guide .
The
SourceDBInstanceIdentifier
property determines whether a DB instance is a read replica. If you remove theSourceDBInstanceIdentifier
property from your template and then update your stack, AWS CloudFormation promotes the Read Replica to a standalone DB instance.- If you specify a source DB instance that uses VPC security groups, we recommend that you specify the
VPCSecurityGroups
property. If you don't specify the property, the read replica inherits the value of theVPCSecurityGroups
property from the source DB when you create the replica. However, if you update the stack, AWS CloudFormation reverts the replica'sVPCSecurityGroups
property to the default value because it's not defined in the stack's template. This change might cause unexpected issues. - Read replicas don't support deletion policies. AWS CloudFormation ignores any deletion policy that's associated with a read replica.
- If you specify
SourceDBInstanceIdentifier
, don't specify theDBSnapshotIdentifier
property. You can't create a read replica from a snapshot. - Don't set the
BackupRetentionPeriod
,DBName
,MasterUsername
,MasterUserPassword
, andPreferredBackupWindow
properties. The database attributes are inherited from the source DB instance, and backups are disabled for read replicas. - If the source DB instance is in a different region than the read replica, specify the source region in
SourceRegion
, and specify an ARN for a valid DB instance inSourceDBInstanceIdentifier
. For more information, see Constructing a Amazon RDS Amazon Resource Name (ARN) in the Amazon RDS User Guide . - For DB instances in Amazon Aurora clusters, don't specify this property. Amazon RDS automatically assigns writer and reader DB instances.
- If you specify a source DB instance that uses VPC security groups, we recommend that you specify the
-
getSourceDbiResourceId
The resource ID of the source DB instance from which to restore. -
setSourceDbiResourceId
The resource ID of the source DB instance from which to restore. -
getSourceRegion
The ID of the region that contains the source DB instance for the read replica. -
setSourceRegion
The ID of the region that contains the source DB instance for the read replica. -
getStorageEncrypted
A value that indicates whether the DB instance is encrypted. By default, it isn't encrypted.If you specify the
KmsKeyId
property, then you must enable encryption.If you specify the
SourceDBInstanceIdentifier
property, don't specify this property. The value is inherited from the source DB instance, and if the DB instance is encrypted, the specifiedKmsKeyId
property is used.If you specify the
SnapshotIdentifier
and the specified snapshot is encrypted, don't specify this property. The value is inherited from the snapshot, and the specifiedKmsKeyId
property is used.If you specify the
SnapshotIdentifier
and the specified snapshot isn't encrypted, you can use this property to specify that the restored DB instance is encrypted. Specify theKmsKeyId
property for the KMS key to use for encryption. If you don't want the restored DB instance to be encrypted, then don't set this property or set it tofalse
.Amazon Aurora
Not applicable. The encryption for DB instances is managed by the DB cluster.
-
setStorageEncrypted
A value that indicates whether the DB instance is encrypted. By default, it isn't encrypted.If you specify the
KmsKeyId
property, then you must enable encryption.If you specify the
SourceDBInstanceIdentifier
property, don't specify this property. The value is inherited from the source DB instance, and if the DB instance is encrypted, the specifiedKmsKeyId
property is used.If you specify the
SnapshotIdentifier
and the specified snapshot is encrypted, don't specify this property. The value is inherited from the snapshot, and the specifiedKmsKeyId
property is used.If you specify the
SnapshotIdentifier
and the specified snapshot isn't encrypted, you can use this property to specify that the restored DB instance is encrypted. Specify theKmsKeyId
property for the KMS key to use for encryption. If you don't want the restored DB instance to be encrypted, then don't set this property or set it tofalse
.Amazon Aurora
Not applicable. The encryption for DB instances is managed by the DB cluster.
-
setStorageEncrypted
A value that indicates whether the DB instance is encrypted. By default, it isn't encrypted.If you specify the
KmsKeyId
property, then you must enable encryption.If you specify the
SourceDBInstanceIdentifier
property, don't specify this property. The value is inherited from the source DB instance, and if the DB instance is encrypted, the specifiedKmsKeyId
property is used.If you specify the
SnapshotIdentifier
and the specified snapshot is encrypted, don't specify this property. The value is inherited from the snapshot, and the specifiedKmsKeyId
property is used.If you specify the
SnapshotIdentifier
and the specified snapshot isn't encrypted, you can use this property to specify that the restored DB instance is encrypted. Specify theKmsKeyId
property for the KMS key to use for encryption. If you don't want the restored DB instance to be encrypted, then don't set this property or set it tofalse
.Amazon Aurora
Not applicable. The encryption for DB instances is managed by the DB cluster.
-
getStorageThroughput
Specifies the storage throughput value for the DB instance. This setting applies only to thegp3
storage type.This setting doesn't apply to RDS Custom or Amazon Aurora.
-
setStorageThroughput
Specifies the storage throughput value for the DB instance. This setting applies only to thegp3
storage type.This setting doesn't apply to RDS Custom or Amazon Aurora.
-
getStorageType
Specifies the storage type to be associated with the DB instance.Valid values:
gp2 | gp3 | io1 | standard
The
standard
value is also known as magnetic.If you specify
io1
orgp3
, you must also include a value for theIops
parameter.Default:
io1
if theIops
parameter is specified, otherwisegp2
For more information, see Amazon RDS DB Instance Storage in the Amazon RDS User Guide .
Amazon Aurora
Not applicable. Aurora data is stored in the cluster volume, which is a single, virtual volume that uses solid state drives (SSDs).
-
setStorageType
Specifies the storage type to be associated with the DB instance.Valid values:
gp2 | gp3 | io1 | standard
The
standard
value is also known as magnetic.If you specify
io1
orgp3
, you must also include a value for theIops
parameter.Default:
io1
if theIops
parameter is specified, otherwisegp2
For more information, see Amazon RDS DB Instance Storage in the Amazon RDS User Guide .
Amazon Aurora
Not applicable. Aurora data is stored in the cluster volume, which is a single, virtual volume that uses solid state drives (SSDs).
-
getTimezone
The time zone of the DB instance.The time zone parameter is currently supported only by Microsoft SQL Server .
-
setTimezone
The time zone of the DB instance.The time zone parameter is currently supported only by Microsoft SQL Server .
-
getUseDefaultProcessorFeatures
A value that indicates whether the DB instance class of the DB instance uses its default processor features.This setting doesn't apply to RDS Custom.
-
setUseDefaultProcessorFeatures
A value that indicates whether the DB instance class of the DB instance uses its default processor features.This setting doesn't apply to RDS Custom.
-
setUseDefaultProcessorFeatures
A value that indicates whether the DB instance class of the DB instance uses its default processor features.This setting doesn't apply to RDS Custom.
-
getUseLatestRestorableTime
A value that indicates whether the DB instance is restored from the latest backup time.By default, the DB instance isn't restored from the latest backup time.
Constraints: Can't be specified if the
RestoreTime
parameter is provided. -
setUseLatestRestorableTime
A value that indicates whether the DB instance is restored from the latest backup time.By default, the DB instance isn't restored from the latest backup time.
Constraints: Can't be specified if the
RestoreTime
parameter is provided. -
setUseLatestRestorableTime
A value that indicates whether the DB instance is restored from the latest backup time.By default, the DB instance isn't restored from the latest backup time.
Constraints: Can't be specified if the
RestoreTime
parameter is provided. -
getVpcSecurityGroups
A list of the VPC security group IDs to assign to the DB instance.The list can include both the physical IDs of existing VPC security groups and references to AWS::EC2::SecurityGroup resources created in the template.
If you plan to update the resource, don't specify VPC security groups in a shared VPC.
If you set
VPCSecurityGroups
, you must not setDBSecurityGroups
, and vice versa.You can migrate a DB instance in your stack from an RDS DB security group to a VPC security group, but keep the following in mind:
- You can't revert to using an RDS security group after you establish a VPC security group membership.
- When you migrate your DB instance to VPC security groups, if your stack update rolls back because the DB instance update fails or because an update fails in another AWS CloudFormation resource, the rollback fails because it can't revert to an RDS security group.
- To use the properties that are available when you use a VPC security group, you must recreate the DB instance. If you don't, AWS CloudFormation submits only the property values that are listed in the
DBSecurityGroups
property.
To avoid this situation, migrate your DB instance to using VPC security groups only when that is the only change in your stack template.
Amazon Aurora
Not applicable. The associated list of EC2 VPC security groups is managed by the DB cluster. If specified, the setting must match the DB cluster setting.
-
setVpcSecurityGroups
A list of the VPC security group IDs to assign to the DB instance.The list can include both the physical IDs of existing VPC security groups and references to AWS::EC2::SecurityGroup resources created in the template.
If you plan to update the resource, don't specify VPC security groups in a shared VPC.
If you set
VPCSecurityGroups
, you must not setDBSecurityGroups
, and vice versa.You can migrate a DB instance in your stack from an RDS DB security group to a VPC security group, but keep the following in mind:
- You can't revert to using an RDS security group after you establish a VPC security group membership.
- When you migrate your DB instance to VPC security groups, if your stack update rolls back because the DB instance update fails or because an update fails in another AWS CloudFormation resource, the rollback fails because it can't revert to an RDS security group.
- To use the properties that are available when you use a VPC security group, you must recreate the DB instance. If you don't, AWS CloudFormation submits only the property values that are listed in the
DBSecurityGroups
property.
To avoid this situation, migrate your DB instance to using VPC security groups only when that is the only change in your stack template.
Amazon Aurora
Not applicable. The associated list of EC2 VPC security groups is managed by the DB cluster. If specified, the setting must match the DB cluster setting.
-