Amazon Relational Database Operations

Internal

• Amazon Relational Database Service

Create a Database Instance with CloudFormation

AWS::RDS::DBInstance

AWS::RDS::DBInstance

Resources:
  RelationalDatabase: 
  Type: AWS::RDS::DBInstance
  DeletionPolicy: Delete
  Properties: 
    DBName: themyscira01
    DBInstanceIdentifier: !Sub ${EnvironmentName}-${MicroworldName}-postgres
    AllocatedStorage: 8
    DBInstanceClass: db.t2.micro
    Engine: postgres
    EngineVersion: 9.4.20
    MasterUsername: bn73hewc
    MasterUserPassword: ce75h9w0
    Tags: 
      - Key: Name
        Value: !Sub ${EnvironmentName}-${MicroworldName}-postgres

Return Values

Ref

Returns instance identifier (DBInstanceIdentifier).

GetAtt

• Endpoint.Address returns the connection endpoint for the database (e.g. mystack-mydb-1apw1j4phylrk.cg034hpkmmjt.us-east-2.rds.amazonaws.com)
• Endpoint.Port

AWS::RDS::DBSubnetGroup

AWS::RDS::DBSubnetGroup

Resources:
  RDSubnetGroup:
    Type: "AWS::RDS::DBSubnetGroup"
      Properties: 
        DBSubnetGroupDescription: String
        DBSubnetGroupName: String
        SubnetIds:
          - String
        Tags:
          - Resource Tag

Deploying a RDS Instance into a Specific VPC

Deploying a RDS Instance into a Specific VPC