Difference between revisions of "AWS::RDS::DBInstance"
Jump to navigation
Jump to search
(16 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | <code>[[AWS::RDS]]::DBInstance</code> | ||
* https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-rds-database-instance.html | * https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-rds-database-instance.html | ||
− | * Template [[snippets]]: https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/quickref-rds.html | + | * Template [[Cloudformation snippets|snippets]]: https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/quickref-rds.html |
− | |||
− | |||
− | |||
* [[AWS CloudFormation templates]]: https://s3.us-west-2.amazonaws.com/cloudformation-templates-us-west-2/RDS_Snapshot_On_Delete.template | * [[AWS CloudFormation templates]]: https://s3.us-west-2.amazonaws.com/cloudformation-templates-us-west-2/RDS_Snapshot_On_Delete.template | ||
Line 11: | Line 9: | ||
PostgreSQL [[AWS Free Tier]]: <code>[[db.t2.micro]]</code> and 20 GB of database storage and backup. | PostgreSQL [[AWS Free Tier]]: <code>[[db.t2.micro]]</code> and 20 GB of database storage and backup. | ||
+ | |||
+ | MyDB: | ||
+ | Type: [[AWS::RDS]]::DBInstance | ||
+ | Properties: | ||
+ | [[AllocatedStorage]]: '5' | ||
+ | [[DBInstanceClass]]: [[db.t2.micro]] | ||
+ | Engine: [[postgres]] | ||
+ | MasterUsername: MyName | ||
+ | MasterUserPassword: MyPassword | ||
+ | [[DeletionPolicy]]: Delete | ||
+ | |||
+ | Complete example: [[RDS_template.cf]] | ||
+ | |||
+ | * Engines: MySQL, postgres, ... https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_CreateDBInstance.html | ||
+ | |||
+ | |||
MyDB: | MyDB: | ||
Line 16: | Line 30: | ||
Properties: | Properties: | ||
[[DBSecurityGroups]]: | [[DBSecurityGroups]]: | ||
− | - Ref: MyDbSecurityByEC2SecurityGroup | + | - [[Ref:]] MyDbSecurityByEC2SecurityGroup |
- Ref: MyDbSecurityByCIDRIPGroup | - Ref: MyDbSecurityByCIDRIPGroup | ||
AllocatedStorage: '5' | AllocatedStorage: '5' | ||
Line 23: | Line 37: | ||
MasterUsername: MyName | MasterUsername: MyName | ||
MasterUserPassword: MyPassword | MasterUserPassword: MyPassword | ||
− | [[DeletionPolicy]]: Snapshot | + | [[DeletionPolicy]]: Delete |
+ | |||
+ | |||
+ | |||
+ | Delete | Snapshot | Retain | ||
+ | |||
+ | == Complete example == | ||
+ | <pre> | ||
+ | Type: AWS::RDS::DBInstance | ||
+ | Properties: | ||
+ | AllocatedStorage: String | ||
+ | AllowMajorVersionUpgrade: Boolean | ||
+ | AssociatedRoles: | ||
+ | - DBInstanceRole | ||
+ | AutoMinorVersionUpgrade: Boolean | ||
+ | AvailabilityZone: String | ||
+ | BackupRetentionPeriod: Integer | ||
+ | CACertificateIdentifier: String | ||
+ | CharacterSetName: String | ||
+ | CopyTagsToSnapshot: Boolean | ||
+ | DBClusterIdentifier: String | ||
+ | DBInstanceClass: String | ||
+ | DBInstanceIdentifier: String | ||
+ | DBName: String | ||
+ | DBParameterGroupName: String | ||
+ | DBSecurityGroups: | ||
+ | - String | ||
+ | DBSnapshotIdentifier: String | ||
+ | DBSubnetGroupName: String | ||
+ | DeleteAutomatedBackups: Boolean | ||
+ | DeletionProtection: Boolean | ||
+ | Domain: String | ||
+ | DomainIAMRoleName: String | ||
+ | EnableCloudwatchLogsExports: | ||
+ | - String | ||
+ | EnableIAMDatabaseAuthentication: Boolean | ||
+ | EnablePerformanceInsights: Boolean | ||
+ | Engine: String | ||
+ | EngineVersion: String | ||
+ | Iops: Integer | ||
+ | KmsKeyId: String | ||
+ | LicenseModel: String | ||
+ | MasterUsername: String | ||
+ | MasterUserPassword: String | ||
+ | MaxAllocatedStorage: Integer | ||
+ | MonitoringInterval: Integer | ||
+ | MonitoringRoleArn: String | ||
+ | MultiAZ: Boolean | ||
+ | OptionGroupName: String | ||
+ | PerformanceInsightsKMSKeyId: String | ||
+ | PerformanceInsightsRetentionPeriod: Integer | ||
+ | Port: String | ||
+ | PreferredBackupWindow: String | ||
+ | PreferredMaintenanceWindow: String | ||
+ | ProcessorFeatures: | ||
+ | - ProcessorFeature | ||
+ | PromotionTier: Integer | ||
+ | PubliclyAccessible: Boolean | ||
+ | SourceDBInstanceIdentifier: String | ||
+ | SourceRegion: String | ||
+ | StorageEncrypted: Boolean | ||
+ | StorageType: String | ||
+ | Tags: | ||
+ | - Tag | ||
+ | Timezone: String | ||
+ | UseDefaultProcessorFeatures: Boolean | ||
+ | VPCSecurityGroups: | ||
+ | - String | ||
+ | </pre> | ||
== Related terms == | == Related terms == | ||
* <code>[[aws cloudformation create-stack]] </code> | * <code>[[aws cloudformation create-stack]] </code> | ||
− | * <code>[[Fn::GetAtt]]</code> | + | * [[AWS CloudFormation functions]]: <code>[[Fn::GetAtt]]</code> |
− | |||
* <code>[[aws rds create-db-instance]]</code> | * <code>[[aws rds create-db-instance]]</code> | ||
+ | * <code>[[SourceDBInstanceIdentifier]]</code> for [[replicas]] | ||
== See also == | == See also == | ||
+ | * {{AWS::RDS}} | ||
* {{aws rds}} | * {{aws rds}} | ||
* {{RDS}} | * {{RDS}} |
Latest revision as of 21:02, 1 June 2022
AWS::RDS::DBInstance
- https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-rds-database-instance.html
- Template snippets: https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/quickref-rds.html
- AWS CloudFormation templates: https://s3.us-west-2.amazonaws.com/cloudformation-templates-us-west-2/RDS_Snapshot_On_Delete.template
Snippets[edit]
PostgreSQL AWS Free Tier: db.t2.micro
and 20 GB of database storage and backup.
MyDB: Type: AWS::RDS::DBInstance Properties: AllocatedStorage: '5' DBInstanceClass: db.t2.micro Engine: postgres MasterUsername: MyName MasterUserPassword: MyPassword DeletionPolicy: Delete
Complete example: RDS_template.cf
- Engines: MySQL, postgres, ... https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_CreateDBInstance.html
MyDB: Type: AWS::RDS::DBInstance Properties: DBSecurityGroups: - Ref: MyDbSecurityByEC2SecurityGroup - Ref: MyDbSecurityByCIDRIPGroup AllocatedStorage: '5' DBInstanceClass: db.t2.micro Engine: PostgreSQL MasterUsername: MyName MasterUserPassword: MyPassword DeletionPolicy: Delete
Delete | Snapshot | Retain
Complete example[edit]
Type: AWS::RDS::DBInstance Properties: AllocatedStorage: String AllowMajorVersionUpgrade: Boolean AssociatedRoles: - DBInstanceRole AutoMinorVersionUpgrade: Boolean AvailabilityZone: String BackupRetentionPeriod: Integer CACertificateIdentifier: String CharacterSetName: String CopyTagsToSnapshot: Boolean DBClusterIdentifier: String DBInstanceClass: String DBInstanceIdentifier: String DBName: String DBParameterGroupName: String DBSecurityGroups: - String DBSnapshotIdentifier: String DBSubnetGroupName: String DeleteAutomatedBackups: Boolean DeletionProtection: Boolean Domain: String DomainIAMRoleName: String EnableCloudwatchLogsExports: - String EnableIAMDatabaseAuthentication: Boolean EnablePerformanceInsights: Boolean Engine: String EngineVersion: String Iops: Integer KmsKeyId: String LicenseModel: String MasterUsername: String MasterUserPassword: String MaxAllocatedStorage: Integer MonitoringInterval: Integer MonitoringRoleArn: String MultiAZ: Boolean OptionGroupName: String PerformanceInsightsKMSKeyId: String PerformanceInsightsRetentionPeriod: Integer Port: String PreferredBackupWindow: String PreferredMaintenanceWindow: String ProcessorFeatures: - ProcessorFeature PromotionTier: Integer PubliclyAccessible: Boolean SourceDBInstanceIdentifier: String SourceRegion: String StorageEncrypted: Boolean StorageType: String Tags: - Tag Timezone: String UseDefaultProcessorFeatures: Boolean VPCSecurityGroups: - String
Related terms[edit]
aws cloudformation create-stack
- AWS CloudFormation functions:
Fn::GetAtt
aws rds create-db-instance
SourceDBInstanceIdentifier
for replicas
See also[edit]
AWS::RDS, AWS::RDS::DBInstance
- AWS RDS:
AWS::RDS
,aws rds
[create-db-instance | create-db-instance-read-replica
|describe-db-instances
|modify-db-instance | modify-db-cluster | create-db-subnet-group
|delete-db-instance
|create-db-snapshot | aws rds create-db-parameter-group
],AllocatedStorage, FreeStorageSpace
- Amazon databases: AWS RDS, storage,
aws rds
, Amazon RDS Proxy, RDS FAQs, PostgreSQL, MySQL, SQL Server, AWS Outposts, Amazon Aurora, Amazon Aurora Serverless , Amazon DocumentDB, Amazon DynamoDB, Amazon Redshift, Amazon QLDB, Amazon RDS Performance Insights, DataFileRead, DMS, Amazon Neptune, Amazon MemoryDB for Redis, Amazon RDS query editor for Aurora Serverless, Amazon Redshift query editor, AWS RDS Snapshots, AWS RDS Instance Types,rds_superuser
, Authentication, autoscaling
Advertising: