We performed a comparison between IBM Db2 Database and MySQL based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: MySQL is easy to use and free to download. In contrast, some reviewers feel that IBM Db2 is costly and not intuitive.
"The solution has many beneficial features, such as security, support, and stability."
"The most valuable features of this solution are security and stability."
"The solution is a very stable relational database and has integration with legacy systems. It is a great product."
"IBM DB2 pureScale Feature is valuable."
"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."
"Db2 Database has given us good results since we have started to use it. We predominantly use IBM hardware, and this is one of the reasons why we started to use Db2 Database. Db2 Database has a very good HADR capability. High availability resilience is also good in this solution. It also has pureScale, which allows you to upgrade one node to get very good and high-level resilience. If you are using a database on five nodes, you can take one node down, upgrade that, and let that node up. You can then bring the second node down, upgrade that, and so on."
"We had a crash of the backup system and the IBM DB2 was always up and consistent. It's robust, and for us, it was always up and running."
"The solution can scale."
"I like the simplistic view of MySQL to build custom queries and things like that as compared to SQL Server, which seems more cluttered. SQL Server has a query analyzer. MySQL pretty much does the same, and performance-wise, it has less overhead for connecting to our ERP system. It seems more responsive and cleaner. With MySQL, you get what you need without any overbloating, for which Microsoft is known. That's why they have so many constant security patches for everything because there is so much stuff, which degrades performance."
"The connectivity with PHP is quite good."
"The initial setup for the SQL database is not complex and it even integrates into the platform. You set up the recipe and then just follow the runbook, the build book. Then it works as long as you follow the procedures."
"It is very easy to install and has all basic database features."
"The solution is very simple. It's easy to use. That's the most important feature."
"The way that MySQL has improved my organization is that it comes free and also works fine on the technical side."
"We use MySQL for enterprise data storage as well as part of the back-end of websites and web applications."
"Like other databases, it has a rich set of functions, such as stored procedures and its own procedural language, which is akin to Oracle SQL. It also has trigger and cursor commands you would expect with a good database language."
"The solution's UI hasn't been upgraded. The solution’s UI is an area to improve because the solution was developed long ago."
"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."
"IBM's products tend to be quite costly, especially given the availability of free, open-source alternatives."
"It would be helpful to have more querying tools and more development tools for us to work easily with Microsoft."
"It would be helpful to have a hybrid data storage facility that includes NoSQL technologies."
"The command line part of this solution could be much better."
"The tool is not easy to use. It needs to improve scale computing so that the tool can be scaled vertically. The product needs to enhance pre-engine optimization and it needs to be more efficient in completing queries. The documentation should be updated to include different scenarios of deployment."
"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."
"Some problems with big table operations, and a struggle to keep the servers responding in peak situations."
"MySQL is not easily scalable on cost effective consumer grade hardware."
"MySQL could be improved by adding more automation."
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"It isn't as reliable as an SQL Server."
"At times, the autoscaling does not happen when there is a surge in load."
"This solution needs to be improved when it comes to working with desktop applications on the developer side."
"MySQL lacks a feature akin to Oracle's Real Application Clusters, which ensures continuous database availability within the same data center or nearby data centers."
IBM Db2 Database is ranked 6th in Relational Databases Tools with 66 reviews while MySQL is ranked 4th in Relational Databases Tools with 142 reviews. IBM Db2 Database is rated 8.2, while MySQL is rated 8.2. 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 SQL Server, Oracle Database, SAP HANA, Teradata and Oracle Database In-Memory, whereas MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, Teradata and CockroachDB. See our IBM Db2 Database vs. MySQL report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools 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.