Need advice about which tool to choose?Ask the StackShare community!
Amazon Aurora vs Amazon DynamoDB: What are the differences?
Developers describe Amazon Aurora as "MySQL and PostgreSQL compatible relational database with several times better performance". 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. On the other hand, Amazon DynamoDB is detailed as "Fully managed NoSQL database service". 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.
Amazon Aurora belongs to "SQL Database as a Service" category of the tech stack, while Amazon DynamoDB can be primarily classified under "NoSQL Database as a Service".
Some of the features offered by Amazon Aurora are:
- High Throughput with Low Jitter
- Push-button Compute Scaling
- Storage Auto-scaling
On the other hand, Amazon DynamoDB provides the following key features:
- Automated Storage Scaling – There is no limit to the amount of data you can store in a DynamoDB table, and the service automatically allocates more storage, as you store more data using the DynamoDB write APIs
- Provisioned Throughput – When creating a table, simply specify how much request capacity you require. DynamoDB allocates dedicated resources to your table to meet your performance requirements, and automatically partitions data over a sufficient number of servers to meet your request capacity
- Fully Distributed, Shared Nothing Architecture
"MySQL compatibility " is the top reason why over 12 developers like Amazon Aurora, while over 61 developers mention "Predictable performance and cost" as the leading cause for choosing Amazon DynamoDB.
According to the StackShare community, Amazon DynamoDB has a broader approval, being mentioned in 836 company stacks & 2072 developers stacks; compared to Amazon Aurora, which is listed in 279 company stacks and 318 developer stacks.
Pros of Amazon Aurora
- MySQL compatibility14
- Better performance12
- Easy read scalability10
- Speed8
- Low latency read replica7
- High IOPS cost2
- Good cost performance1
Pros of Amazon DynamoDB
- Predictable performance and cost62
- Scalable56
- Native JSON Support35
- AWS Free Tier21
- Fast7
- No sql3
- To store data3
- Serverless2
- No Stored procedures is GOOD2
- ORM with DynamoDBMapper1
- Elastic Scalability using on-demand mode1
- Elastic Scalability using autoscaling1
- DynamoDB Stream1
Sign up to add or upvote prosMake informed product decisions
Cons of Amazon Aurora
- Vendor locking2
- Rigid schema1
Cons of Amazon DynamoDB
- Only sequential access for paginate data4
- Scaling1
- Document Limit Size1