AWS RDS Contd…

• Concepts
  

AWS Interfaces

• We have 3 popular interfaces to work with AWS
  • Using Browser: AWS Console Refer Here
  • Using Commands: AWS CLI
  • Using Code:
    • Python Boto3
    • Other AWS SDK

Lets Create a single mysql database managed by AWS (RDS)

• Cost Aspects: Refer Here for pricing calculator
  • Prices vary from region to region
  • Pricing Choices :
    • On-demand:
      • No-Commitments
    • Reservations (Might not be available for all services):
      • We give commitment to AWS for 1 or 3 years
  • Charges:
    • RDS
    • storage
    • backup
• Right Sizing:
  • instance classes: Refer Here for db instance type
    • Memory Optimized: High Memory to CPU Ratio
    • General Purpose: Balanced CPU to Memory Ratio
    • Burstable
  • Storage:
    • Types:
      • General purpose
      • Provisioned
    • Size:
      • Fixed
      • AutoScaled
  • Backup: Size of Backup directly propotional to costs

Scenario:

• Your organization has a mysql database which runs on linux vm with for dev environment
  • 2 vCPUs
  • 8 GB of RAM
  • 100 GB Harddisk (20 GB is used and 80 GB is free)
  • Size: db.t3.large
• Your organization has a postgres database which requires caching (requires decent memory)
  • 8 vCPU
  • 32 GB
  • 100 GB (used: 80 GB)
  • Size: db.r5.xlarge or db.r5.2xlarge
  • Storage : min Size: 80 Autoscaling till 200 GB