Amazon Relational Database Concepts: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 36: Line 36:


Cannot be "admin" for Postgres.
Cannot be "admin" for Postgres.
==VPC Association==
{{External|[https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.html Amazon Virtual Private Cloud (VPCs) and Amazon RDS]}}
To make the instance a VPC instance, it must be associated with a DB subnet group.

Revision as of 04:05, 17 April 2019

Internal

Relational Database Instance

Database Name

The database name must begin with a letter and contain only alphanumeric characters. It cannot be "db".

Instance Identifier

The name for the database instance. Can be explicitly specified, in which case CloudFormation converts it to lowercase. If not specified, CloudFormation generates a unique physical ID. Shows up in the endpoint as such: <someid>.ak29cdi3ewg0.ca-central-1.rds.amazonaws.com

Allocated Storage

Represents the allocated storage size, specified in gigabytes (GB). If any value is set in the Iops parameter, allocated storage must be at least 100 GB, which corresponds to the minimum Iops value of 1,000. If Iops value is increased (in 1,000 IOPS increments), then allocated storage value must be also increased. (in 100-GB increments). The value is required, except when DBClusterIdentifier property is specified or when a read replica is created by using the AWS::RDS::DBInstance resource.

Instance Class

Choosing the DB Instance Class

Designates the name of the compute and memory capacity classes for the database instance.

Engine

CreateDBInstance

Engine Version

DescribeDBEngineVersions
aws rds describe-db-engine-versions --engine postgres

Master Username

Cannot be "admin" for Postgres.

VPC Association

Amazon Virtual Private Cloud (VPCs) and Amazon RDS

To make the instance a VPC instance, it must be associated with a DB subnet group.