AWS Services Summary - Database
DynamoDB
Main features
- NoSQL database
Configuration
DynamoDB Accelerator (DAX) used to significantly improve the in-memory read performance of your database
A DynamoDB stream is an ordered flow of information about changes to items in an Amazon DynamoDB table. When you enable a stream on a table, DynamoDB captures information about every modification to data items in the table to process further tasks
Amazon Kinesis Client Library (KCL) is a coding module to write an application that leverages on DynamoDB Streams Kinesis Adapter that will fetch data from the DynamoDB Streams endpoint.
Point-in-Time Recovery (PITR) is a backup features:
- Take snapshot at any point of time
- Store short-term snapshots
- Optimized solution for RPO/RTO metric.
Redshift
Main features
- Data warehousing solution
- Built on a relational database model
RDS
Main features
- Multi-AZ failover: Decrease failover rate beside solely using Multi-AZ deployment.
Configuration
Configuration
Enhanced Monitoring: monitor how the different processes or threads on a DB instance use the CPU, including the percentage of the CPU bandwidth and total memory consumed by each process.
Amazon Aurora
A cluster of DB instances
Main features
- Provide “Connection” mechanism:
- Each connection is handled by a specific DB instance
- When connecting to an Aurora cluster, the host name and port that you specify point to an intermediate handler called an “endpoint” => Abstract these connections
- Advantages:
- Don’t have to hardcode hostnames or write logic for load-balancing and rerouting connections when DB instances aren’t available.
- Different instances or groups perform different roles: Heavy-workload tasks will be redirected to high-capacity endpoints and vice versa.
ElastiCache
Configuration
- Encryption at rest: Encrypt stored data in DB.
- Encryption in transit: Encrypt transfered data, sent command, delivered metadata, …
- AUTH default user access: Enable redis AUTH to authenticate with database when executing commands. Only enable through command.