AWS Database Services

• Data Services of AWS

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

Create a free tier mysql rds instance

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