Amazon Relational Database Operations: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 10: Line 10:
   RelationalDatabase:  
   RelationalDatabase:  
   Type: AWS::RDS::DBInstance
   Type: AWS::RDS::DBInstance
  [[AWS_CloudFormation_Concepts#DeletionPolicy|DeletionPolicy]]: Delete
   Properties:  
   Properties:  
     [[Amazon Relational Database Concepts#Database_Name|DBName]]: some-name
     [[Amazon Relational Database Concepts#Database_Name|DBName]]: some-name
Line 19: Line 20:
     [[Amazon_Relational_Database_Concepts#Master_Username|MasterUsername]]: admin
     [[Amazon_Relational_Database_Concepts#Master_Username|MasterUsername]]: admin
     MasterUserPassword: ...
     MasterUserPassword: ...
    [[AWS_CloudFormation_Concepts#DeletionPolicy|DeletionPolicy]]: Delete
     Tags:  
     Tags:  
       - Key: Name
       - Key: Name

Revision as of 03:33, 17 April 2019

Internal

Create a Database Instance with CloudFormation

AWS::RDS::DBInstance

AWS::RDS::DBInstance
Resources:
  RelationalDatabase: 
  Type: AWS::RDS::DBInstance
  DeletionPolicy: Delete
  Properties: 
    DBName: some-name
    DBInstanceIdentifier: some-id
    AllocatedStorage: 8
    DBInstanceClass: db.m1.medium
    Engine: postgres
    EngineVersion: 9.4.20
    MasterUsername: admin
    MasterUserPassword: ...
    Tags: 
      - Key: Name
        Value: "My Postgres Database"

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