Chapter 5. Databases

Chapter 5. Databases

1. Relational

   • Categories
     • Online Transaction Processing (OLTP)
       • Fast, regular queries
       • Single server with ample memory & compute power
     • Online Analytic Processing (OLAP)
       • Complex queries
       • Multiple servers with heavy compute & storage power
   • Amazon RDS
     • Fully managed instanced that exists in a VPC
     • Multiple engines: MySQL, MariaDB, Oracle, PostgreSQL, Amazon Aurora, Microsoft SQL Server
     • Licensing Considerations
       • License Included
       • Bring Your Own License
     • Instance Classes
       • Standard
       • Memory Optimized
       • Burst Capable (Burstable)
     • Storage
       • General-Purpose SSD
       • Provisioned IOPS SSD (io1)
       • Magnetic Storage
     • Scales horizontally with Read Replicas
     • High Availability (Multi-AZ)
     • Backup and Recovery
   • Amazon Redshift
     • Managed data warehouse solution designed for OLAP databases
     • Data Distribution Styles
       • EVEN
       • KEY
       • ALL

2. Nonrelational

   • Optimized for unstructured data.
   • Schemaless
   • DynamoDB
     • Partioned in SSDs in Multi AZs
     • Max size of items: 400 KB
     • Partitions based on PK
     • Autoscaling based on WCU/RCU used
     • Reserve WCU/RCU (100 to 100K each) for periods of 1 to 3 years to reduce costs
     • Read ops
       • Scan
       • Query