Amazon RDS Database Engines Flashcards
What database engines are available?
- Amazon Aurora
- PostgreSQL
- MySQL
- MariaDB
- Oracle Database
- Microsoft SQL Server
What is Amazon Aurora?
Enterprise-class relational database.
- Compatible w/ MySQL & PostgreSQL
- 5x faster than MySQL
- 3x faster than PostgreSQL
- Consider if you require high availability
- Replicates data across 3 Availability Zones.
- Continuously backs up data to Amazon S3.
What is Amazon DynamoDB?
NoSQL database service that is key-value based.
- Delivers single-digit millisecond performance
- Serverless: no need to provision, patch, or manage servers.
- Do not have to install, maintain, or operate software.
- Scales to adjust to changes
- Suitable for workloads that require high performance while scaling.
What is Amazon Redshift?
Data warehousing service for big data analytics.
Offers ability to collect data from many sources.
What is Amazon Database Migration Service (Amazon DMS)?
Let’s you migrate relational, non-relational, & other types of data stores.
During migration source database remains operational.
What are cases for AWS DMS?
- Lets developers test applications against production data w/out affecting production users.
- Consolidating databases into 1 database.
- Continuous replication (sending to other target database instead of 1-time migration).
What is Amazon DocumentDB?
Document Database service that supports MongoDB (NoSQL).
What is Amazon Neptune?
Graph database service.
- Useful for applications with highly connected datasets.
- Ex: recommendation engines, fraud detection, & knowledge graphs.
What is Amazon Quantum Ledger Database (Amazon QLDB)?
Ledger database service.
- Review a complete history of all changes made to your application data.
What is Amazon Managed Blockchain?
Lets you create & manage blockchain networks w/ open-source frameworks.
What is Amazon DynamoDB Accelerator
In-memory cache for DynamoDB.
Helps improve response times from single-digit milliseconds to microseconds.
