AWS - Database family

Posted on |

Use the right Tool for the right job

Aurora benefit :

  • 5x throughput vs MySQL and 3x to Postgres

  • Max 15 read replica

  • six copies of data across 3 AZ and continuous backup to S3

  • AWS DMS (Data Migration Service)

New Tools

Data tools are not competing each other, they are complementing each other.
Pick the use case then apply the corresponding tech

  • RDB
  • Key-value
  • Document
  • In-memory
  • Graph (Nepture)
  • Time-Series
  • Ledger

RDB Key-value Graph

RDB: data integrity ; transaction
Key-value: partitioned by keys, consistent performance at scale
Graph: Vertices and Edges

Case Study

  • Airbnb

    • Dynamo for use search history
    • ElastiCache : caching
    • RDS : transaction data

  • A book store

    • Used DynamoDB (key-value) to put book information
    • ElastiSearch — Steam dynamodb change to trigger lambda to put into elastisearch index
    • leader board — use elasticache ; (???) sorting
    • Recommendation engine – use graph db to record people with book and purchases

Ledger Database

Industry: Healthcare, Government, Manufactures, HR&Payroll

  • I want the data to be immutable, can be tracked back, can be Cryptographically Verifiable
  • Blockchain is hard to maintain
  • Amazon QUantum Ledger Database: Immutable, Cryptographically verifiable, High scalable, Easy to use

Time Series Data – AWS Timestream

What kind of data is tiem series data,

  • weather ; IoT ; DevOps data
  • Time-series data will only have x axis as time , y can be changed in-flight and be flexible
  • Change to data from hot->warm->cold storage
  • millions of inserts (10M/sercond); serverless ; Trillions of daily events

Reference

Databases on AWS: The Right Tool for the Right Job ( good PRZ)
https://youtu.be/-pb-DkD6cWg

Reward Makes Perfect
0%