Try our new research platform with insights from 80,000+ expert users

IBM Db2 Database vs MySQL comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 12, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

IBM Db2 Database
Ranking in Relational Databases Tools
6th
Average Rating
8.2
Reviews Sentiment
6.8
Number of Reviews
73
Ranking in other categories
No ranking in other categories
MySQL
Ranking in Relational Databases Tools
3rd
Average Rating
8.2
Reviews Sentiment
7.4
Number of Reviews
148
Ranking in other categories
Open Source Databases (1st)
 

Mindshare comparison

As of April 2025, in the Relational Databases Tools category, the mindshare of IBM Db2 Database is 7.1%, up from 6.6% compared to the previous year. The mindshare of MySQL is 8.5%, down from 8.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools
 

Featured Reviews

SimonHiggins - PeerSpot reviewer
Very scalable with high availability and excellent technical support
The good thing is that there are improvements coming with later function levels for the z/OS Db2. I'd like it if, with the operating system that we've got, z/OS, on the mainframe, it would allow us to refresh the hardware to run Linux dockers on the mainframe. This means this might give us opportunities for different ways of coming into the Db2 environment in the future. We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment. Not only have we got the premium operating systems on OS. We can run LPARs on the same mainframe footprint that is also supporting Linux. This is what has improved and made the mainframe environment more competitive. We're also looking at AI for Db2 as well, and machine learning for the future. We know that AI has come out, that we're going to get that, and we're going to evaluate that product next year for Db2. That said, I haven't got any real complaints about Db2 on the mainframe. For the most part, a lot of the problems we have nowadays are to do with communication between the various teams that you would class as stakeholders.
Muzzamil  Hussain - PeerSpot reviewer
Native encryption ensures secure data management with a simple deployment
The most valuable feature is the on-premises data encryption facilities. By default, we can provide encryption, and this feature in MySQL is why we prefer it over other databases. The native encryption in MySQL encourages us to use this database model more frequently compared to Oracle and other databases. With Oracle, we have to buy another solution for encryption and masking, but MySQL supports native encryption, which enhances our return on investment. It perfectly supports our ROI, and we have no issues with its functionality.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Some of the most valuable features are the scaling from a small very cheap installation to a very large enterprise installation. In addition, the backups and assistance are good."
"The most valuable features are the simplicity of the database and the access to Db2 and Db2 information."
"IBM Db2 Database has good performance."
"The structure is straightforward, consisting of the test file and the logical and physical files. You have one physical file and many logical files related to it."
"The solution's security is very tough and impenetrable."
"The most valuable features are with the industrial side."
"It is quite a stable solution."
"It's easy to search and extract data from the warehouse using queries."
"It is a very stable solution. I deployed the product six years ago, and it still works fine."
"It is very easy to install and has all basic database features."
"MySQL gives us all of the critical features that we need in a database, but without the costs."
"It is free, which is probably its most valuable feature. It is a pretty full-featured relational database. It really does everything we need it to do."
"The solution is very stable."
"The solution has been very easy to scale so far."
"We use it as a data store and from that perspective, we get everything we need."
"MySQL is an easy-to-use solution that provides stability, reliability, flexibility, performance, security, and high availability."
 

Cons

"IBM Db2 Database could improve the user-defined functions. There are some user-defined functions that are missing, such as the spring functions. I used to have Teradata for my projects and I was used to working in the environment. They had a good set of user-defined functions."
"They should simplify the management of Db2 as a relational database system. There should be the simplification of management. This is probably one of the most important asks for being successful in the future."
"The capabilities of this solution could improve."
"Its process of building up queries could be more accessible."
"The backup solution lacks flexibility."
"In terms of improvements, IBM Db2 can improve its interface and its functionality. Also, the embedded functions should be much richer than the current ones - the functions which are embedded in the engine itself."
"IBM Db2 Database could improve with better security."
"The solution's UI hasn't been upgraded. The solution’s UI is an area to improve because the solution was developed long ago."
"Improvements are required in character set support, scalability, and big data sets."
"The analytics features are in need of improvement."
"We want high availability and replication features, which are currently missing in this solution. It would be great if they can provide an in-built replication feature, similar to Oracle RAC, in MySQL."
"I find the Microsoft solution a bit better. But mostly in terms of the UI layout, I would say. I just find it a little bit more efficient."
"I would like to have the ability to cancel a query in SQL Developer."
"MySQL could introduce more indexing strategies."
"The user interface could be more user friendly. Mainly because most of the times we see black and white digital lines. Something like Python."
"It does not stand out regarding scalability. When the company size increases, the user base having actual experience with (very) large MySQL solutions is reduced."
 

Pricing and Cost Advice

"The total cost of the solution depends upon the PVU licensing"
"We purchase the product's yearly license."
"I would rate the pricing a five out of ten. It's not super expensive, but also not cheap."
"It's very expensive for West African countries like ours."
"If I consider the price of IBM Db2 Database, I would say there are cheaper products in the market."
"Compared to other databases, Db2 is relatively cheaper."
"It is expensive."
"The solution costs less than other products."
"I am using the Community Edition, which is available free of charge."
"I rate the solution's pricing as four out of ten, where one is cheap, and ten is expensive. For our basic needs, it's quite affordable. However, the cost increases when we need to scale up or require high availability. Our developer team of about 600 people uses MySQL without much issue. The pricing becomes more of a concern on the business side, as we have more end users and need constant database availability and scaling. In those cases, the solution gets a bit more expensive, even though it provides good value for the business."
"I don't pay for a license."
"When you know the setup will continue to grow, make sure you have the paid support."
"We are using the free version of MySQL. We prefer paying for a yearly license."
"The solution does not come with a licensing fee."
"We are using the free community version of the solution."
"We're using the open-source version right now, which is free. I do see some value in some of the more enterprise functions. We're using the open-source version right now, and I was interested in the MySQL Enterprise version really for the tools that they provide, but we decided not to make the purchase."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
844,944 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
62%
Financial Services Firm
8%
Computer Software Company
4%
Government
4%
Computer Software Company
16%
Financial Services Firm
12%
Manufacturing Company
7%
Government
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about IBM Db2 Database?
Db2 database scalability and performance capabilities match our database needs. It covers pretty much everything a database administrator or engineer might need.
What is your experience regarding pricing and costs for IBM Db2 Database?
IBM Db2 is an expensive solution. While I am not heavily involved with pricing, additional companies provide capabilities or products like those from BMC, which many installations might also purchase.
What needs improvement with IBM Db2 Database?
The user interface is old and needs to be improved. It doesn't match the responsive and suggestion-rich UI of cloud solutions. New functions don't come to mind.
Why are MySQL connections encrypted and what is the biggest benefit of this?
MySQL encrypts connections to protect your data and the biggest benefit from this is that nobody can corrupt it. If you move information over a network without encryption, you are endangering it, m...
Considering that there is a free version of MySQL, would you invest in one of the paid editions?
I may be considered a MySQL veteran since I have been using it since before Oracle bought it and created paid versions. So back in my day, it was all free, it was open-source and the best among sim...
What is one thing you would improve with MySQL?
One thing I would improve related to MySQL is not within the product itself, but with the guides to it. Before, when it was free, everyone was on their own, seeking tutorials and how-to videos onli...
 

Comparisons

 

Also Known As

DB2
No data available
 

Overview

 

Sample Customers

Knorr-Bremse, Mizuho Bank Ltd., Australian Government Department of Defence, SCHWENK Zement, Friedhelm Loh Group, YAZAKI Europe Limited, Ekornes ASA, Baldor Electric, VSN Systemen BV, Lion Brewery (Ceylon) PLC, PLANSEE Group, TE Connectivity, Hansgrohe SE, Openmatics, University of Toronto
Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.
Find out what your peers are saying about IBM Db2 Database vs. MySQL and other solutions. Updated: March 2025.
844,944 professionals have used our research since 2012.