Dynamodb Cheatsheet

What is Dynamodb

  • Key / Value store

  • No SQL

  • Schemaless

  • Cloud Native, AWS Managed, low Ops

  • Highly Available

  • Easy to integrate with other AWS Service, suche as AWS

  • Support Transaction, Strong Consistent Read

Dynamodb Pricing

Data Modeling

  • Hash Key and Range Key

  • Partition and Data Distribution

  • Global Secondary Indexes

  • Local Secondary Indexes

  • One to One Relationship

  • One to Many Relationship

  • Many to Many Relationship

Design:

  • Versioned document

  • Cumulated value

CRUD

  • Read
    • Scan

    • Query

    • Use index

  • Write
    • single vs batch

  • Transaction

  • Delete

DBA Ops

  • Backup
    • On-demand AWS Backup

    • On-demand Dynamodb Backup

    • Point-in-time Backup

Security

  • Data Protection
    • Encryption at Rest

    • Inter Network traffic privacy
      • between AWS service and on-premises: option1, AWS Site-to-Site VPN; option2, AWS Direct Connect

      • between AWS resources in the same region: VPC endpoint

  • Authentication
    • IAM role based access

In-memory Acceleration with DAX