Databases Flashcards
List the types of AWS databases
RDS & Aurora: Relational
DynamoDB: NoSQL
ElastiCache: In-memory; Redis & Memcached
Neptune: Graph
DocumentDB: for Documents; supports MongoDB
What can Aurora be used for?
MySQL
PostgreSQL
What is ElastiCache?
A fully managed (Saas) in-memory datastore
Supports 2 engines: Redis and Memcached
Data can be lost
Low latency
Enables scaling and replicas to meet demand
What is Neptune and what is it good for?
A fully managed graph database.
Good for highly connected datasets like social media networks.
What would you use to migrate an on-premises Oracle database to the cloud?
RDS
What would you use to migrate an on-premises Postgres database to the cloud?
RDS or Aurora
How would you alleviate database load for data that is accessed often?
ElastiCache
How would you process large sets of user profiles and social interactions?
Neptune
Name a NOSQL database fast enough to handle millions of db requests per second.
DynamoDB
How can you operate MongoDB workloads at scale?
DocumentDB (it mimics MongoDB)
How would you do database as IaaS?
Spin up your own EC2 instance and deploy a database onto it
Which database would be PaaS?
RDS
Which databases would offer a SaaS approach?
DynamoDB
Elasticache
Redshift
RDS
- a PaaS relational database system
- can deploy across multiple AZ’s
- It launches into a VPC
- uses 2 volume types: SSD, IOPS SSD
- Platforms: MySQL, PostGres, Oracle, MariaDB, SQLServer, Amazon Aurora
What is Amazon DMS?
Database Migration Service
Moves data into AWS
Only pay for the compute time of the migration
What are the features of DynamoDB?
Fully managed SaaS database service
NoSQL, not relational
Both key-value and document
auto-scaling
More than 10 trillion requests per day; 20 million per second
What are the DynamoDB use cases?
Scale without excessive maintenance
If you want serverless applications
Low latency is key
Data Models without BLOB storage (that won’t work well)
What are use cases for ElastiCache?
You have a database like DynamoDB and want to add a cache layer
Session storage for Web apps (Redis)
What is Redshift?
Amazon’s data warehouse service
It does analytics
Petabyte scale
Can fully encrypt
Provides isolation with a VPC
What is Redshift Spectrum?
- Can query exabytes of data within S3
- Fast, complex analysis on objects stored on the AWS cloud.
- Can perform SQL queries on data stored in S3 buckets.
What is MemoryDB?
A Redis-compatible in-memory database
Good to use as a primary database
What is Timestream?
A serverless time series database service
Example: Sensor data: capturing data at specific times. Like you have a temperature gauge and want to find out the avg temp for last Wednesday
What would you suggest for a company that has a MySQL db, wants to launch a new Web App with it, but needs direct access to the virtual server that MySQL is running on?
EC2 - have an EC2 instance and add a MySQL database to it
What database would you use for a gaming system that requires low latency and up to 1 million players?
DynamoDB
