Amazon Aurora vs Amazon DynamoDB

Need advice about which tool to choose?Ask the StackShare community!

Amazon Aurora

+ 1
Amazon DynamoDB

+ 1
Add tool

Amazon Aurora vs Amazon DynamoDB: What are the differences?


This Markdown code provides a comparison between Amazon Aurora and Amazon DynamoDB, focusing on their key differences.

  1. Performance and Scalability:

    • Amazon Aurora is designed as a relational database service compatible with MySQL and PostgreSQL, providing high performance and scalability for applications that require traditional relational databases.
    • Amazon DynamoDB, on the other hand, is a fully-managed NoSQL database service, optimized for high scalability and fast performance for applications that need flexible data models.
  2. Data Model:

    • Amazon Aurora is based on a relational data model, providing structured data storage with support for ACID (Atomicity, Consistency, Isolation, Durability) transactions and complex joins.
    • Amazon DynamoDB utilizes a NoSQL data model, offering a key-value store with the ability to store semi-structured data in the form of JSON-like documents. It allows flexible schema and is schema-less.
  3. Architectural Approach:

    • Amazon Aurora is built as a distributed database system, using a combination of shared storage and high-performance replication across multiple Availability Zones to ensure high availability and durability.
    • Amazon DynamoDB is designed as a key-value store, offering built-in multi-AZ replication and automatic scaling capability to handle millions of requests per second without manual intervention.
  4. Pricing Model:

    • In Amazon Aurora, pricing is based on a combination of database instance size and storage capacity. Customers are billed for the compute resources (e.g., CPU, memory) and storage they utilize.
    • Amazon DynamoDB employs a pay-per-usage model, where customers are billed for the provisioned throughput capacity (read and write operations per second), indexed data storage, and additional features like on-demand capacity.
  5. Query Flexibility:

    • Amazon Aurora supports complex SQL queries, including joins, subqueries, and advanced analytics functions. It allows traditional relational database query processing and is suitable for applications that heavily rely on SQL.
    • Amazon DynamoDB offers limited querying capabilities, primarily focusing on simple key-value lookups and queries based on primary key attributes. It is geared towards applications that require fast data retrieval but do not rely heavily on complex querying.
  6. Data Consistency:

    • Amazon Aurora provides strong consistency within each Availability Zone, ensuring that any read operation always returns the latest committed data. It supports read replicas for high availability and scalability.
    • Amazon DynamoDB offers eventual consistency by default, which means that read operations may sometimes return stale data. However, it also provides an option to choose strong consistency for specific requests, ensuring that read operations always return the most up-to-date data.

In Summary, Amazon Aurora is a performant and scalable relational database service, ideal for applications relying on structured data, complex queries, and transaction support. On the other hand, Amazon DynamoDB is a highly scalable NoSQL database service, designed for flexible data models, fast performance, and automatic scaling.

Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Amazon Aurora
Pros of Amazon DynamoDB
  • 14
    MySQL compatibility
  • 12
    Better performance
  • 10
    Easy read scalability
  • 9
  • 7
    Low latency read replica
  • 2
    High IOPS cost
  • 1
    Good cost performance
  • 62
    Predictable performance and cost
  • 56
  • 35
    Native JSON Support
  • 21
    AWS Free Tier
  • 7
  • 3
    No sql
  • 3
    To store data
  • 2
  • 2
    No Stored procedures is GOOD
  • 1
    ORM with DynamoDBMapper
  • 1
    Elastic Scalability using on-demand mode
  • 1
    Elastic Scalability using autoscaling
  • 1
    DynamoDB Stream

Sign up to add or upvote prosMake informed product decisions

Cons of Amazon Aurora
Cons of Amazon DynamoDB
  • 2
    Vendor locking
  • 1
    Rigid schema
  • 4
    Only sequential access for paginate data
  • 1
  • 1
    Document Limit Size

Sign up to add or upvote consMake informed product decisions

What is Amazon Aurora?

Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora provides up to five times better performance than MySQL at a price point one tenth that of a commercial database while delivering similar performance and availability.

What is Amazon DynamoDB?

With it , you can offload the administrative burden of operating and scaling a highly available distributed database cluster, while paying a low price for only what you use.

Need advice about which tool to choose?Ask the StackShare community!

What companies use Amazon Aurora?
What companies use Amazon DynamoDB?
See which teams inside your own company are using Amazon Aurora or Amazon DynamoDB.
Sign up for StackShare EnterpriseLearn More

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with Amazon Aurora?
What tools integrate with Amazon DynamoDB?

Sign up to get full access to all the tool integrationsMake informed product decisions

Blog Posts

DockerAmazon EC2Scala+8
GitHubDockerAmazon EC2+23
What are some alternatives to Amazon Aurora and Amazon DynamoDB?
JavaScript is most known as the scripting language for Web pages, but used in many non-browser environments as well such as node.js or Apache CouchDB. It is a prototype-based, multi-paradigm scripting language that is dynamic,and supports object-oriented, imperative, and functional programming styles.
Git is a free and open source distributed version control system designed to handle everything from small to very large projects with speed and efficiency.
GitHub is the best place to share code with friends, co-workers, classmates, and complete strangers. Over three million people use GitHub to build amazing things together.
Python is a general purpose programming language created by Guido Van Rossum. Python is most praised for its elegant syntax and readable code, if you are just beginning your programming career python suits you best.
jQuery is a cross-platform JavaScript library designed to simplify the client-side scripting of HTML.
See all alternatives