AWS & CloudAmazon DynamoDB là fully managed NoSQL key-value và document database với single-digit millisecond latency ở mọi scale, serverless (không quản lý server), tự động scale, tích hợp DAX (in-memory cache). DynamoDB phù hợp khi: schema flexible (JSON documents), access pattern đơn giản và predictable (query by partition key ± sort key), cần scale đến hàng triệu RPS, serverless architecture, session store, gaming leaderboard, IoT data.
Amazon RDS hỗ trợ MySQL, PostgreSQL, MariaDB, Oracle, SQL Server — managed service lo patching, backup, multi-AZ. RDS phù hợp khi: cần ACID transactions phức tạp, relationship giữa nhiều entity, ad-hoc query linh hoạt (complex JOINs), reporting, existing SQL expertise. Amazon Aurora là RDS-compatible engine tự xây dựng của AWS: Aurora MySQL/PostgreSQL nhanh gấp 3-5x so với MySQL/PostgreSQL gốc, auto-storage scaling đến 128TB, Aurora Serverless v2 scale theo fractional ACU, Aurora Global Database cho multi-region.
DynamoDB pricing: provisioned capacity (RCU/WCU) hoặc on-demand; RDS pricing theo instance size + storage. Anti-pattern cho DynamoDB: nhiều access pattern phức tạp, cần full-text search, cần reporting.
Amazon DynamoDB is a fully managed NoSQL key-value and document database with single-digit millisecond latency at any scale; it is serverless (no server management), auto-scaling, and integrates with DAX (in-memory cache). DynamoDB is a good fit when: the schema is flexible (JSON documents), access patterns are simple and predictable (query by partition key ± sort key), you need to scale to millions of RPS, or for serverless architectures, session stores, gaming leaderboards, and IoT data.
Amazon RDS supports MySQL, PostgreSQL, MariaDB, Oracle, and SQL Server — a managed service that handles patching, backups, and multi-AZ. RDS is a good fit when: you need complex ACID transactions, relationships between many entities, flexible ad-hoc queries (complex JOINs), reporting, or have existing SQL expertise. Amazon Aurora is AWS's own cloud-native relational engine: Aurora MySQL/PostgreSQL is 3-5x faster than standard MySQL/PostgreSQL, auto-scales storage to 128TB, Aurora Serverless v2 scales in fractional ACUs, and Aurora Global Database supports multi-region.
DynamoDB pricing: provisioned capacity (RCU/WCU) or on-demand; RDS pricing by instance size plus storage. Anti-patterns for DynamoDB: many complex access patterns, need for full-text search, or reporting requirements.