RDS pricing considerations in AWS - Mini Project: Build & Apply

RDS Pricing Considerations

📖 Scenario: You are planning to deploy a database using Amazon RDS for your small business application. You want to understand how different configurations affect the monthly cost.

🎯 Goal: Build a simple AWS CloudFormation template that defines an RDS instance with configurable parameters to explore pricing factors such as instance class, storage size, and multi-AZ deployment.

📋 What You'll Learn

Create a CloudFormation template with an RDS DB instance resource

Define parameters for DB instance class, allocated storage, and Multi-AZ deployment

Use the parameters to configure the RDS instance resource

Add outputs to show the chosen configuration values

💡 Why This Matters

🌍 Real World

CloudFormation templates help automate and standardize AWS resource deployment, making it easier to manage costs by adjusting configurations.

💼 Career

Understanding how to configure RDS instances and their pricing factors is essential for cloud architects and engineers managing AWS infrastructure.

1

Create CloudFormation template with RDS DB instance resource

Create a CloudFormation template with a resource named MyDBInstance of type AWS::RDS::DBInstance. Set the Engine property to mysql and MasterUsername to admin.

AWS

# Your code here

Need a hint?

Use the Resources section to define the RDS instance with the required properties.

2

Add parameters for instance class, storage, and Multi-AZ

Add parameters named DBInstanceClass (default db.t3.micro), AllocatedStorage (default 20), and MultiAZ (default false) to the template.

AWS

Resources:
  MyDBInstance:
    Type: AWS::RDS::DBInstance
    Properties:
      Engine: mysql
      MasterUsername: admin
# Your code here

Need a hint?

Define parameters under the Parameters section with the specified names and defaults.

3

Use parameters to configure the RDS instance properties

Update the MyDBInstance resource to use the parameters DBInstanceClass for DBInstanceClass, AllocatedStorage for AllocatedStorage, and MultiAZ for MultiAZ properties using !Ref.

AWS

Parameters:
  DBInstanceClass:
    Type: String
    Default: db.t3.micro
  AllocatedStorage:
    Type: Number
    Default: 20
  MultiAZ:
    Type: String
    AllowedValues:
      - true
      - false
    Default: false
Resources:
  MyDBInstance:
    Type: AWS::RDS::DBInstance
    Properties:
      Engine: mysql
      MasterUsername: admin
# Your code here

Need a hint?

Use !Ref to reference parameters in the resource properties.

4

Add outputs to show selected configuration values

Add outputs named SelectedInstanceClass, SelectedStorage, and SelectedMultiAZ that output the values of parameters DBInstanceClass, AllocatedStorage, and MultiAZ respectively using !Ref.

AWS

Parameters:
  DBInstanceClass:
    Type: String
    Default: db.t3.micro
  AllocatedStorage:
    Type: Number
    Default: 20
  MultiAZ:
    Type: String
    AllowedValues:
      - true
      - false
    Default: false
Resources:
  MyDBInstance:
    Type: AWS::RDS::DBInstance
    Properties:
      Engine: mysql
      MasterUsername: admin
      DBInstanceClass: !Ref DBInstanceClass
      AllocatedStorage: !Ref AllocatedStorage
      MultiAZ: !Ref MultiAZ
# Your code here

Need a hint?

Use the Outputs section to show parameter values using !Ref.