Amazon DynamoDB vs MySQL | TrustRadius

What users are saying about

Score 8.5 out of 10

Based on 102 reviews and ratings

Score 8.5 out of 10

Based on 839 reviews and ratings

Feature Rating Comparison

Amazon DynamoDB

MySQL

Performance

Availability

Concurrency

Security

Scalability

Data model flexibility

Deployment model flexibility

Pros

It's very easy to get started, creating a table with a partition/sort key and you're on your way.
You can scale up and down your read/write IO as needed.
You can store structured and unstructured data.
It works great with Web Development as it's JSON based.

Read full review

Founder, Owner

CodeLinguists LLCComputer Software, 1-10 employees

View all 34 answers on this topic

The Community Server edition remains a strong candidate for a SQL-based database solution that supports a wide array of data structures.
It scales well for both small business and enterprise use.
It performs very well provided your database schema is well-planned and carefully considered (which is the case for any database solution).
It has a number of interface solutions including GUI-based ones such as phpMyAdmin and MySQL Workbench that allow for easy management of your databases.

Read full review

Software Engineer

Lockpath, Inc.Computer Software, 51-200 employees

View all 114 answers on this topic

Cons

Complex searching (no support for case-insensitive or full-text search).
Only supports up to two-key indexes.
Requires choosing the indexes up-front when doing searches.
Does not have an SQL compatible query front-end.
No join-table support (requires putting all data into one table).

Read full review

VP of Technology

NewstexComputer Software, 1-10 employees

View all 34 answers on this topic

MySQL doesn't provide good data wrangling functionalities, such as parsing JSON or XML. We had to transform them outside MySQL on the web application server side using JSP.
As we move forward to adopt more genomics information, MySQL may lack of dealing with "big data" functionalities.
It is a freely available S/W and easy to manage budget, but there are possibilities to spend cost for additional technical support.

Read full review

Verified User

Team Lead in Research & Development

Hospital & Health Care Company, 10,001+ employees

View all 114 answers on this topic

Likelihood to Renew

Amazon DynamoDB 8.7

Based on 34 answers

We will most likely continue to use DynamoDB for certain use-cases. If we stopped using DynamoDB as often, it would likely be because we started using Aurora Serverless more. Aurora Serverless may offer similar availability, management and cost benefits while allowing developers to use their MySQL tools and experience.

Read full review

Verified User

Engineer in Engineering

Research Company, 11-50 employees

View all 34 answers on this topic

MySQL 9.9

Based on 4 answers

For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.

Read full review

Verified User

Employee in Information Technology

Higher Education Company, 501-1000 employees

View all 4 answers on this topic

Usability

No score

No answers yet

No answers on this topic

MySQL 8.2

Based on 5 answers

I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.

Read full review

Senior Systems Analyst

CymSTAR, LLCDefense & Space, 201-500 employees

View all 5 answers on this topic

Support Rating

No score

No answers yet

No answers on this topic

MySQL 8.6

Based on 2 answers

The support staff is friendly, knowledgeable, and efficient. I only had to get part way through my explanations before they had a solution. They will walk you through a fix or actually connect in and fix the problem for you--or would if you can allow it. I've done it both ways with them. They are always forthcoming with 'how to do this if it happens again' information. I love working with MySQL support.

Read full review

Senior Systems Analyst

CymSTAR, LLCDefense & Space, 201-500 employees

View all 2 answers on this topic

Implementation Rating

No score

No answers yet

No answers on this topic

MySQL 8.0

Based on 1 answer

1. Estimate your data size.2. Test, test, and test.

Read full review

Verified User

Engineer in Engineering

Entertainment Company, 5001-10,000 employees

View all 1 answers on this topic

Alternatives Considered

We evaluated using MongoDB or Amazon DyanmoDB. For us, the biggest advantage is that there's no maintenance cost for Amazon DynamoDB. Mongo gets complicated when you setup sharding. With Amazon DynamoDB, it's literally a push of button to increase throughput. This saves time and money on DevOps resources.

Read full review

Verified User

Engineer in Engineering

Computer Software Company, 11-50 employees

View all 34 answers on this topic

After Oracle bought MySQL, I have pivoted some projects to use MariaDB instead, which is a fork of MySQL and maintained by the community and original developers of MySQL. This is free under the GNU GPL, and is not impacted by decisions Oracle makes for MySQL. RDS has the ability to run managed MySQL instances which make it even easier to setup and configure a database. RDS also has support for MariaDB.InfluxDB is a great Time Series DB Platform which was designed to collect measurements with timestamps, and works more efficiently than MySQL for this type of data. I would recommend InfluxDB for anyone who is on the fence about implementing a collection agent and having the stats go into MySQL or another Database system

Read full review

Verified User

Engineer in Engineering

Internet Company, 51-200 employees

View all 114 answers on this topic

Return on Investment

Since the Amazon manages the instance, the amount of time a developer needs to spend configuring the database is less. For comparison, if we were to manage the same instance manually, we need to set up EC2 instance, install the DB, setup backup scripts, track backup failures, which is a great overhead for the dev. Using DynamoDB this overhead is reduced and hence having a great ROI.
Great documentation and easy setup makes an easy learning curve to transition to DynamoDB. Only caveat is as with any database, the data structure should be thoroughly analyzed for types of querying because there are limitations with the DynamoDB API.
Ties very well with rest of the Amazon eco system. Having rest of the applications in Amazon allows managing the application security a breeze.

Read full review

Anudeep Palanki

Application Developer

Monsanto CompanyFarming, 10,001+ employees

View all 34 answers on this topic

Since MySQL is a free database package, if you have someone on staff that understands databases and how to use them, the ROI is very high when using MySQL.
If you need to hire a MySQL developer to implement and manage your database then it can be quite costly to manage and that will negatively impact your ROI when using this product.
Since there are some very expensive alternatives in the SQL database space, if you compare the overall costs of using MySQL to those other products, I think you will find your ROI is always better when using MySQL

Read full review

Digital Services Manager

Packaging & Distribution ResourcesEducation Management, 11-50 employees

View all 114 answers on this topic

Screenshots

—

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Amazon DynamoDB Editions & Modules

Edition

On-Demand - Write Operation	$1.25¹
On-Demand Read Operation	$0.25¹
On-Demand Data Stored	$0.25²
On-Demand Point-in-Time Recovery	$0.20²
On-Demand Snapshot	$0.10²
On-Demand Restoring a Backup	$0.15³
On-Demand Global Tables	$1.875⁴
On-Demand Streams	$0.02⁵
On-Demand Data Requests Outside AWS Regions	$0.09⁶
Provisioned - Write Operation	$0.00065⁷
Provisioned - Read Operation	$0.00013⁷
Provisioned - Data Stored	$0.25⁸
Provisioned - Point-in-Time Recovery	$0.20⁸
Provisioned - Snapshot	$0.10⁸
Provisioned - Restoring a Backup	$0.15⁹
Provisioned - Global Tables	$0.000975¹⁰
Provisioned - Streams	$0.02¹¹
Provisioned - Data Requests Outside AWS Regions	$0.09¹²

per million requests
per GB per month
per GB
per million write operations replicated
per 100,000 read operations
per GB
capacity unit per hour
per GB per month
per GB
per Read Capacity
per 100,000 read operations
per GB

Additional Pricing Details

—

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

MySQL Editions & Modules

—

Additional Pricing Details

—

Rating Summary

Amazon DynamoDB

MySQL

Amazon DynamoDB

MySQL

Amazon DynamoDB

MySQL

Amazon DynamoDB

MySQL

Amazon DynamoDB

MySQL

Add comparison