AWS Classroom Series – Database – 02/Dec/2019

AWS Database Services

  • Data Services of AWS Preview

Service Models


  • Physical:
    • Completely owned by Amazon
    • users have no control
  • Infrastructure
    • Create ec2 machines and install databases
    • Require DBA
    • OS patching, DB patching, networking is users responsibility
    • This is often referred as unmanaged
    • Pros:
      • Full control of DB
      • Any version can be installed
    • Cons:
      • Administrative Efforts are huge
  • Platform
    • Create database platform (mysql/maria/Aurora, postgres/Aurora, SQL server, Oracle)
    • Minimal DBA activities
    • NO need of any patching. Users need to maintain only data
    • This is often referred as Managed Database Services
    • Pros:
      • Administrative Efforts are minimal
    • Cons:
      • Specific list of databases/versions are supported.

RDS (Relational Database Services)

  • This is managed Service for Relational Databases
  • RDS supports
    • mysql
    • mariadb
    • SQL Server
    • Oracle
    • Postgres
  • RDS introduces
    • Aurora for mysql
    • Aurora for Postgres
  • RDS automates
    • Backup/Restore
    • Failover
    • Replications
  • DBAs are required for Query Performance Tuning. Amazon gives necessary tooling support.

AWS Marketplace Images

  • These are AMIs (Amazon Machine Images) with Preinstalled Databases.
  • But rest of the activites as shown below are user responsibilities.
    • License Mangement
    • Backup/Restore
    • Failover
    • Replications
  • It is not recommended to use Marketplace for supported Databases.
  • It is used to create only unsupported Databases.
  • In the below image, IBM DB2 is shown as the marketplace iamge Preview

Create a free tier mysql rds instance

  • Database => mysql
  • Database instance type => db.t2.micro
  • Select template => Free Tier Preview

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About continuous learner

devops & cloud enthusiastic learner