Technology Databases Flashcards
Database
- Allow us to collect, store, retrieve, sort, graph, and manipulate data
- Is an organized collection of various forms of data
- Used by many applications: web, mobile, services, and more
- Necessary to persist data through runs of an application
- You accesss the data stored in a database by querying it
- Databases are typically controlled by a dtabase mgmt system
Guess the service
Amazon Relational Database Service (RDS)
Easy to launch & manage relational databases
High availability and fault tolerance using multi AZ deployment
AWS manages the DB with automatic software patching, backups, op system maintenance and more.
Launch read replicas across regions in order to provide enhanced perf and durability
Guess the service
Amazon Aurora
5x faster than normal MySQL & 3x faster than PostgreSQL
Scales automatically while providing durability and high availability
Managed by RDS
Guess the service
Amazon Dynamo DB
Fully Managed NoSQL key value and document DB
Fully managed and serverless
Non relational
Scales automatically to massive workloads with fast perf
Guess the service
Amazon Document DB
Fully managed document DB that supports MongoDB
Fully managed and serverless
Non relational
Guess the service
Amazon ElastiCache
Fully managed in-memory datastore compatible with Redis & Memcached
Data can be lost
Offers high performance and low latency
Guess the service
Amazon Neptune
Fully managed graph DB that supports highly connected datasets
Graph DB service
Support highly connected datasets like social media networks
Fully managed serverless
Fast and reliable
Migrate an on premises Oracle database to the cloud
RDS
Migrate an on premises PostgreSQL database to the cloud
RDS
Aurora
Alleviate DB load for data that is accessed often
ElastiCache
Process large sets of user profiles and social interactions
Neptune
NoSQL database fast enough to handle millions of request per second
Dynamo DB
Operate MongoDB workload at scale
DocumentDB
RDS
Service that makes it easy to launch and manage relational databases
Aurora
Relational database compatible with MySQL and PostgreSQL that was created by AWS
DynamoDB
Fully managed NoSQL key-value and document database
Neptune
Fully managed graph database that supports highly connected datasets
DocumentDB
Fully managed document database that supports MongoDB
Data Migration and Transfer
A lot of companies are migrating to the cloud, they need inexpensive, fast, and secure ways to move their on premises data to AWS
Guess the service
Database Migration Service (DMS)
Helps you migrate databases to or within AWS
Continuous data replication
Supports homogeneous and heterogeneous migrations
Virtually no downtime
DMS in the real world
Provide 3 use cases
- Oracle to Aurora MySQL. Migrate on prem Oracle DB to Aurora MySQL
- Oracle to Oracle.- Migrate on prem Oracle DB to Oracle on EC2
- RDS Oracle to Aurora MySQL.- Migrate an RDS Oracle DB to Aurora MySQL
Guess the service
Server Migration Service (SMS)
Allows you to migrate on prem servers to AWS
Server saved as a new Amazon Machinge Image (AMI)
Use AMI to launch servers as EC2 instances
AWS Snow Family
Snow Family allow you to transfer large amounts of on premises data to AWS using a physical device
Guess the service
Snowcone
Smallest member of data transport services
8 Terabytes of usable storage
Offline shipping
Online with DataSync
Guess the service
Snowball & Snowball Edge
Petabyte scale data transport solution
Transfer data in and out
Cheaper than internet transfer
Snowball Edge supports EC2 & Lambda
Guess the service
Snowmobile
Multi petabte or exabyte scale
Data loaded to S3
Securely transported
Guess the service
DataSync
Allow for online data transfer from on prem to AWS storage services like S3 or EFS
Copy data over Direct Connect or the internet
Copy data between AWS storage services
Replicate data cross-Region or cross-account
