Post

AWS Services Summary - Database

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.
This post is licensed under CC BY 4.0 by the author.