Sample CFT for an RDS Instance

This is the sample CloudFormation Template (CFT) used to create RDS instances for testing this mApp® Solution. Because this mApp Solution pulls information dynamically via the AWS API, request details for provisioning the RDS samples in this integration come directly from this CFT.

                        
            {
   "AWSTemplateFormatVersion":"2010-09-09",
   "Description":"AWS CloudFormation Sample Template RDS_with_DBParameterGroup: Sample template showing how to create an Amazon RDS Database Instance with a DBParameterGroup.**WARNING** This template creates an Amazon Relational Database Service database instance. You will be billed for the AWS resources used if you create a stack from this template.",
   "Parameters":{
      "DBName":{
         "Default":"MyDatabase",
         "Description":"The database name",
         "Type":"String",
         "MinLength":"1",
         "MaxLength":"64",
         "AllowedPattern":"[a-zA-Z][a-zA-Z0-9]*",
         "ConstraintDescription":"must begin with a letter and contain only alphanumeric characters."
      },
      "DBUser":{
         "NoEcho":"true",
         "Description":"The database admin account username",
         "Type":"String",
         "MinLength":"1",
         "MaxLength":"16",
         "AllowedPattern":"[a-zA-Z][a-zA-Z0-9]*",
         "ConstraintDescription":"must begin with a letter and contain only alphanumeric characters."
      },
      "DBPassword":{
         "NoEcho":"true",
         "Description":"The database admin account password",
         "Type":"String",
         "MinLength":"8",
         "MaxLength":"41",
         "AllowedPattern":"[a-zA-Z0-9]*",
         "ConstraintDescription":"must contain only alphanumeric characters."
      }
   },
   "Resources":{
      "MyDB":{
         "Type":"AWS::RDS::DBInstance",
         "Properties":{
            "DBName":{
               "Ref":"DBName"
            },
            "AllocatedStorage":"5",
            "DBInstanceClass":"db.t2.small",
            "Engine":"MySQL",
            "EngineVersion":"5.7.22",
            "MasterUsername":{
               "Ref":"DBUser"
            },
            "MasterUserPassword":{
               "Ref":"DBPassword"
            }
         }
      }
   },
   "Outputs":{
      "JDBCConnectionString":{
         "Description":"JDBC connection string for the database",
         "Value":{
            "Fn::Join":[
               "",
               [
                  "jdbc:mysql://",
                  {
                     "Fn::GetAtt":[
                        "MyDB",
                        "Endpoint.Address"
                     ]
                  },
                  ":",
                  {
                     "Fn::GetAtt":[
                        "MyDB",
                        "Endpoint.Port"
                     ]
                  },
                  "/",
                  {
                     "Ref":"DBName"
                  }
               ]
            ]
         }
      }
   }
}