We changed our name from IT Central Station: Here's why

IBM Db2 Database vs MySQL comparison

Cancel
You must select at least 2 products to compare!
IBM Db2 Database Logo
8,565 views|5,637 comparisons
MySQL Logo
Read 55 MySQL reviews.
9,728 views|8,092 comparisons
Featured Review
Find out what your peers are saying about IBM Db2 Database vs. MySQL and other solutions. Updated: January 2022.
564,143 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"It has a good feature called pureScale, which is just for scalability. It is a perfect solution for environments where scalability is going to be an issue.""We are dealing with millions of transactions a month and the performance is very good.""Its robustness, scalability, availability, and performance are valuable. All these are the major attributes of a relational database for supporting a very high-volume business, and Db2 is very good in all those areas and in all those attributes.""The solution has very good data compression of up to 50%. For example, if you have 50 terabytes of data, it can be reduced to 25 terabytes.""IBM Db2 Database has good performance.""The most valuable feature is PowerPC support.""Very good for performance and scalability.""Reliable, robust with great features."

More IBM Db2 Database Pros →

"We use the basic features of MySQL. The interface that allows us to see the parameters of the server is good.""What I've been most pleased with is the cost point, performance, and ease of use.""It is easy to use. It is simple to implement, which makes it suitable for our projects because we have deadlines. MySQL is also open-source, which is another plus point.""The one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support.""Apart from the features that are in the enterprise part, we find the database to be valuable. The connectors and the backup features are valuable as well. We use the basic database. We don't really use the extra features. Our clients like the security features in the database.""The solution is very simple. It's easy to use. That's the most important feature.""The feature that I have found most valuable is its ubiquity. MySQL is everywhere, so if I need to find a developer to do things to it that I don't know, it's very easy to find someone who has expertise in it.""One of the most valuable features is MySQL's ability to run our email system. We use a system called Colab."

More MySQL Pros →

Cons
"The GUI interface is not particularly friendly for those who do not have experience with the product.""It would be ideal if the solution offered backup functionality. Many similar tools already do, which means Db2 is somewhat behind the curve in terms of what a customer might expect from it.""The only drawback that we see in Db2 Database is the crash recovery. When there is a crash and somebody has to do the recovery, Db2 Database first stops, and then it does any crash recovery. In Oracle Database, crash recovery happens within the database. The database is not shut down.""The application development requires a Java developer and not every company has these resources.""Microsoft SQL Server is comparatively very simple to use. I wish IBM would move towards making Db2 easy to use for both basic and advanced users. This is where I see room for advancement. Db2 is also more expensive than Microsoft SQL Server, and its price can be reduced. The replication feature needs to be there in Db2. Microsoft provides similar functionality in SQL Server. IBM also has similar functionality, but it exists in a different product. So, to have the replication ability, you have to buy a different product. It makes sense to have this functionality within Db2 instead of a different product. It will also be helpful in terms of competition. In Africa, the problem for Db2 is competition. Oracle Database and Microsoft SQL Server have been in this market for a very long time. These companies have built the ecosystem and the brand within this market for a very long time. So, they are very popular with users. Db2 or IBM came a little later in the game, and that's where the problem lies. They also don't do a lot of marketing for it, which is also a problem.""The solution could improve by providing more integration.""We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment.""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."

More IBM Db2 Database Cons →

"It could be a little bit simpler to use.""Integration is a key feature in need of improvement.""It is not as powerful as SQL Server. It can be more powerful. It is not scalable and has certain limitations, which is not the case with SQL Server.""The GUI interface probably can be improved. Let us say I want to see the relationships in the database. In the query analyzer, I would like to go and drop the tables and create relationships between the tables. I haven't found a feature like that in MySQL. It was a shortcoming even in SQL Server. MySQL can have more performance monitoring tools. I know Google has these tools, but within MySQL, there are not that many tools to monitor things like performance and database locking. They might be in there, and I might not be familiar enough to know where they are. I am a pretty new user of MySQL.""MySQL could be improved by adding more automation.""Could use some additional JSON query support in the solution.""There are some issues with compatibility with Java environments that need to be improved. When Oracle bought this solution there were some driver changes that caused some issues with operations.""Its scalability can be better. It is probably not as scalable as Oracle. I had some issues with connectors. I used it from a C++ program, and it required some work to make it run, but finally, it worked."

More MySQL Cons →

Pricing and Cost Advice
  • "Db2 is less expensive than Oracle."
  • "We did not buy it. It came with our hardware without any complimentary maintenance. If I compare Db2 Database with Oracle Database, its price is lower than Oracle Database."
  • "There is a license for this solution and we pay every three years."
  • "Among Microsoft SQL Server, Oracle, and Db2, Microsoft SQL Server is the cheapest one, and Oracle is the most expensive one. Db2 is in the middle. As compared to SQL Server, its price could go down. It will be good for customers."
  • "We normally handle large size businesses and as far as I am aware, the license is negotiable based on the number of users and the quantitative data."
  • "It is expensive."
  • More IBM Db2 Database Pricing and Cost Advice →

  • "I am using the Community Edition, which is available free of charge."
  • "This is an open-source product that can be used free of charge."
  • "It's an open-source database management system that can be used free of charge."
  • "Microsoft licensing for SQL Server is probably ten times more expensive. I used to work for the government, and I remember when we were looking into upgrading to the enterprise version of SQL Server 2019, the licensing was going to cost 350,000. To get the equivalent in the cloud, it was going to be about four grand to get the same processing power and everything else. With MySQL, it was going to be about 300 for the same licensing. Cost-wise, for sure, there is a huge difference. Would you prefer to pay 300 a month or 3,000 to have the same amount of data resources? You might lose a few options that you need, but it isn't worth the price difference."
  • "This product has a good price point."
  • "There is a licensing cost because we are going for a proprietary product. There are some other versions for which there is no licensing cost."
  • "It has a community version."
  • "It is open-source."
  • More MySQL Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
    564,143 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 
    DB2 versus Oracle: - Table structure is different - Data structures - there are some differences including the data type, format and length.
    Top Answer: 
    I like that its true active-active. For example, if there are two instances within a cluster, we can take one of them down and there's no failover or switch over. There's no primary and secondary… more »
    Top Answer: 
    In the 90s, there was a big problem with the IBM mainframe environment and there was a big push to move the middleware off the mainframe and put it on cheaper distributed hardware. What happened then… more »
    Top Answer: 
    One of the most valuable features is MySQL's ability to run our email system. We use a system called Colab.
    Top Answer: 
    We are using the free version of MySQL. We prefer paying for a yearly license.
    Top Answer: 
    MySQL could be improved by adding more automation. There are no additional features I would like to see that I can think of at the moment.
    Ranking
    5th
    Views
    8,565
    Comparisons
    5,637
    Reviews
    15
    Average Words per Review
    772
    Rating
    8.0
    3rd
    Views
    9,728
    Comparisons
    8,092
    Reviews
    52
    Average Words per Review
    505
    Rating
    7.9
    Comparisons
    Also Known As
    DB2
    Learn More
    Overview
    DB2 Enterprise for Linux, UNIX, and Windows is the ideal data server for the most demanding workloads. New XML support is designed to help firms minimize the time and effort it takes to persist and use their XML data reducing development costs and improving business agility.

    Until its recent acquisition by Oracle, MySQL was possibly the most renowned open source database enterprise package that could be accessed completely for free. With the merger, the server increased both its features and its price tag, but there is still a free version available to the general community to contribute ideas and suggestions.

    MySQL is a fast and relatively inexpensive database management system. It can easily integrate with a wide variety of programming languages, and it is considered to be a very reliable option. One of the most prominent features that customers seem to enjoy is the easy scalability of this system.

    Offer
    Learn more about IBM Db2 Database
    Learn more about MySQL
    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.
    Top Industries
    REVIEWERS
    Financial Services Firm43%
    Insurance Company13%
    Computer Software Company9%
    University9%
    VISITORS READING REVIEWS
    Computer Software Company28%
    Comms Service Provider17%
    Financial Services Firm10%
    Insurance Company7%
    REVIEWERS
    Computer Software Company21%
    University10%
    Comms Service Provider8%
    Manufacturing Company8%
    VISITORS READING REVIEWS
    Comms Service Provider30%
    Computer Software Company26%
    Financial Services Firm6%
    Government5%
    Company Size
    REVIEWERS
    Small Business27%
    Midsize Enterprise10%
    Large Enterprise63%
    REVIEWERS
    Small Business48%
    Midsize Enterprise15%
    Large Enterprise38%
    Find out what your peers are saying about IBM Db2 Database vs. MySQL and other solutions. Updated: January 2022.
    564,143 professionals have used our research since 2012.

    IBM Db2 Database is ranked 5th in Relational Databases with 15 reviews while MySQL is ranked 3rd in Relational Databases with 55 reviews. IBM Db2 Database is rated 8.0, while MySQL is rated 8.0. The top reviewer of IBM Db2 Database writes "Very scalable with high availability and excellent technical support". On the other hand, the top reviewer of MySQL writes "Good beginner base but it should have better support for backups". IBM Db2 Database is most compared with Oracle Database, SQL Server, SAP HANA, Teradata and IBM Netezza Performance Server, whereas MySQL is most compared with Firebird SQL, SAP HANA, Oracle Database, Teradata and Oracle Java DB. See our IBM Db2 Database vs. MySQL report.

    See our list of best Relational Databases vendors.

    We monitor all Relational Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.