Database as a Service

Relational Databases

• In this category of Databases, Data is stored in a database, which is categorized into tables.
• Each Table will have columns which represent fields and rows which represent records
• Tables will have relationships between them
• We need DBMS to manage database, Softwares which offer them are
  • Microsoft SQL Server
  • Oracle
  • mysql
  • Postgres
  • DB2
• AWS has a service called as RDS where the following database engines are offered as service
  • SQL Server
  • Oracle
  • mysql/mariadb
  • Postgres
  • SQL Server
  • Aurora:
    • Postgres
    • mysql
• Azure offers Database as a service for
  • SQL Server
  • mysql/maria
  • postgres

AWS RDS

• Overview
  
• RDS is created in the network (VPC) and requires at least two subnets provided to RDS (DB Subnet Group) while creation.
• RDS instances can be public or private
• RDS instances will have pricing similar to ec2 i.e. hourly billing and storage charges
• RDS instances support disks with autoscaling (Start from 20 GB and AWS will automatically increase disk size when needed)
• AWS Generally gives 3 ways of creating a database instance
  • Single AZ
  • Multi AZ
  • Multi Az Cluster

Lets create a Single AZ mysql instance

• Single AZ mysql
• network: default
• subnet group: default
• access: public
• free tier:
• Watch classroom video for screen shots
  
  
• Terms to understand
  • Replications
  • Failover
• Exercise: Try creating
  • Single Database with mysql in Azure
  • Single Database with Postgres in AWS