Databases 101 Flashcards
5 Types of Database Services
RDS DynamoDB Elasticache Redshift DMS (database migration service)
6 OLTP Relational Database Types
(SMO-PAM) SQL MySQL Oracle PostgreSQL Aurora MariaDB
Non-relational databases
DynamoDB (No SQL)
document-oriented databases
Non relational database components
Collection (like a table)
Document (like a row)
Key-Value Pairs (fields in table)
Data Warehousing
used for BI
Cognos, SQL Reporting Services, Oracle hyperion
used for large data sets
OLTP
Online Transaction Processing
Transactional process
Queries pull up record sets
Includes Relational Database Types
OLAP
Online Analytics Processing
Queries pull up large number of records
Redshift
ie net profit calculations for regions
Which 2 caching engines does Elasticache support?
Memached
Redis
Which 2 caching engines does Elasticache support?
Memcached
Redis
DMS
Database Migration Services
Lets you migrate your production to AWS
Manages complexities like data type transformation, compression.
Lets you convert source database (ie Oracle) to different type (ie Aurora MySQL) in AWS.
DMS
Database Migration Services
Lets you migrate your production to AWS
Manages complexities like data type transformation, compression.
Lets you convert source database (ie Oracle) to different type (ie Aurora MySQL) in AWS.
TCP Port for MySQL / Aurora
Popular exam question for troubleshooting access - make sure it’s allowed in security groups
TCP 3306
What is Elasticache?
in-memory caching
What is multi-AZ?
EC2 instances behind ELB point to RDS instance in one AZ. That RDS instance is automatically synchronized to another AZ
Failover performed automatically
How many copies of your data does Aurora keep?
6
2 copies in 3 AZ’s