09 - Databases for SysOps


This note is dedicated to in-depth discussion about the available database options from AWS.

This note is broken down into the following secions.

[<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/d94e65fc-4fa6-42fe-8dee-eb0fdcb5a540/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/d94e65fc-4fa6-42fe-8dee-eb0fdcb5a540/notes-aws-sysops-masterImages02-preview.png>)
[<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/f7485733-27e8-4f50-9e38-7e9e1ddcf1d2/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/f7485733-27e8-4f50-9e38-7e9e1ddcf1d2/notes-aws-sysops-masterImages02-preview.png>)
[<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/ae95e1ed-9acd-40a1-83a0-d51438e5eea0/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/ae95e1ed-9acd-40a1-83a0-d51438e5eea0/notes-aws-sysops-masterImages02-preview.png>)
[<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/26eceaca-1885-45e3-826e-084822d707a5/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/26eceaca-1885-45e3-826e-084822d707a5/notes-aws-sysops-masterImages02-preview.png>)
[<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/8c7c4a31-0d2e-4cdf-902a-96cc91d523de/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/8c7c4a31-0d2e-4cdf-902a-96cc91d523de/notes-aws-sysops-masterImages02-preview.png>)
[<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/024bcb34-e282-45a4-8ccb-d014bcb48e14/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/024bcb34-e282-45a4-8ccb-d014bcb48e14/notes-aws-sysops-masterImages02-preview.png>)
[<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/95a32355-d908-4bb0-be73-818dd997b0a8/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/95a32355-d908-4bb0-be73-818dd997b0a8/notes-aws-sysops-masterImages02-preview.png>)
[<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/180d160d-7e93-43a8-a36d-240c7569e6f5/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/180d160d-7e93-43a8-a36d-240c7569e6f5/notes-aws-sysops-masterImages02-preview.png>)
[<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/cf10009d-96cf-4ce7-a36c-88d471cc67b5/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/cf10009d-96cf-4ce7-a36c-88d471cc67b5/notes-aws-sysops-masterImages02-preview.png>)

- 
    
    [<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/5a0d7e71-853f-4ea8-9b74-b197ec846eae/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/5a0d7e71-853f-4ea8-9b74-b197ec846eae/notes-aws-sysops-masterImages02-preview.png>)
    
- 
    
    [<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/ce3dc680-b289-4c9b-bb32-68d1995b95dd/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/ce3dc680-b289-4c9b-bb32-68d1995b95dd/notes-aws-sysops-masterImages02-preview.png>)
    
- 
    
    [<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/f17406e3-00ba-48ce-bc14-17550948c53c/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/f17406e3-00ba-48ce-bc14-17550948c53c/notes-aws-sysops-masterImages02-preview.png>)
[<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/2c993c40-c226-4243-a9f7-fcbd21b64d3f/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/2c993c40-c226-4243-a9f7-fcbd21b64d3f/notes-aws-sysops-masterImages02-preview.png>)

- 
    
    [<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/68a6077e-af9b-4447-8705-2c720814a1f3/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/68a6077e-af9b-4447-8705-2c720814a1f3/notes-aws-sysops-masterImages02-preview.png>)
    
- 
    
    [<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/4fc9c59e-7d9f-4058-8e15-b43f49b545b6/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/4fc9c59e-7d9f-4058-8e15-b43f49b545b6/notes-aws-sysops-masterImages02-preview.png>)
    
- _________________________________________
    
    [<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/4e0f0f24-ffff-49c6-aa2d-1c58b746717e/notes-aws-sysops-masterImages02-preview.png>](<https://prod-files-secure.s3.us-west-2.amazonaws.com/514dc457-5e07-4181-8560-a8825ab015d8/4e0f0f24-ffff-49c6-aa2d-1c58b746717e/notes-aws-sysops-masterImages02-preview.png>)

RDS Overview

Relational Database Service or RDS is a managed database service - AWS manages the database. - you can use SQL as query alnguage - available are: (MyPOSAM) - MySQL - PostgreSQL - Oracle - SQL Server (Microsoft) - Aurora - MariaDB

Why use RDS?

RDS has a lot of benefits versus deploying your own DB in an EC2 instance. - OS patching level - continuous backup and restore to specific timestamp - monitoring dashboards - read replicas for increased performance - multi-AZ setup for DR - maintenance windows for upgrades - scaling capability

BUT you cannot SSH into your DB instances - RDS.