We performed a comparison between MySQL and Oracle Database based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: After comparing all the different parameters, users seem to be more satisfied with MySQL, mainly because it is open source and has a lot of available documentation and online resources but also because it is easy to deploy.
"The relations in the database, the dynamic workflow, and the ability to connect with all columns. It's useful for e-commerce."
"The initial setup is easy."
"The solution has been very easy to scale so far."
"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 most valuable feature of MySQL is the informative error outputs of command line interface."
"It has a remote access feature to manage the database from a remote location. This enables in-work collaboration."
"It was easy to install."
"MySQL has cross-platform support for multiple operating systems. The backups on a Linux machine can be restored on a Windows machine, and vice versa."
"It is stable, and its performance is good. Its interface is also fine."
"I have been satisfied with the technical support from Oracle."
"Oracle Database is very stable. In terms of stability and performance, Oracle is super. On the database side, Oracle is number one in our tests."
"It is user-friendly. Its performance and security are also very good. There are 300 million records for our one-year data, and we can easily query this data. You can use Oracle Database as a source for easily integrating with different databases and applications. It supports Java platforms and other applications very well. It works with SAP products better than Microsoft SQL Server."
"It gives DB consistency, supports disaster recovery (DR), is tunable, and handles large DB sizes."
"The stability has been good so far. It's reliable."
"I like that it's stable. What's good is that Oracle manages the infrastructure. We have got better because they update the server by default or whenever it's needed. They try to fix it server by server because of their own support plans."
"The tool supports a large volume of transactions compared to other databases we've used. One feature that had a significant impact is Oracle Data Integrator. It allows us to transfer data from the enterprise database to the data warehouse. This is useful for creating different data sets for finance teams and other departments."
"We want to continue using MySQL but it merged with Oracle and the scalage changed."
"MySQL's performance requires attention. For optimal performance, one should review and sometimes revise the code, particularly when using server-side scripting."
"The product is a little bit complex and it is difficult to find sufficient documentation."
"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."
"This solution needs to be improved when it comes to working with desktop applications on the developer side."
"It can have better monitoring. In addition, the enterprise manager should be able to cater to more than one virtual machine. Currently, you need one license per server. It seems a bit too much to get one license for one enterprise manager. I hope the enterprise manager for MySQL can accommodate more virtual machines for MySQL."
"In an upcoming release, there should be something added similar to EPL. For example, when using the flow diagram, we can create a schema. We have two useful features to add or create the table, but there should be some UI features to allow us to drag and drop to create other schemas. This would be very helpful."
"They should come up with a better solution than the NDB cluster for better scaling. If they could come up with a better solution for write scaling, apart from the NDB cluster, which is supported by all open source communities, that would be great. Although the NDB cluster, I believe, is an open-source tool, it's not widely supported as a solution."
"Customer support could be faster, you currently have to write your issue to them and then they will get back to you after 24-hours."
"The integration can be made much easier for the Oracle tools, for example, Oracle Database or OPI. The integration sometimes can be a little complicated for us because we have to do a number of integrations with other tools, such as Oracle computation. The integration could be more streamlined and easier to work with."
"If their database encryption features could come in bytes, that would be a major improvement. They should bring the encryption model to their standard databases as well."
"We believe that the usability could be improved, especially within the data lakehouse. We found content management to be a little bit more simpler within the GUI part."
"There are a few errors for which Oracle doesn't provide detailed information. It doesn't clearly indicate the columns or lines for which we are getting an error. It would be better if they provide more detailed information for such errors."
"Their support portal requires a person to become well-trained in how to use it. They are pretty good at handling absolute critical emergencies, but with the exception of absolute critical emergencies, getting problems solved from their support system is difficult and takes a long time."
"As of now, Oracle is branded to Oracle only, the option of migrating to other databases is not available."
"The tool's price gap is a major concern. It makes it hard for others to afford it and use it effectively. More people could benefit from its features if the pricing could be made more reasonable. Many companies choose cheaper options because of this affordability issue."
MySQL is ranked 4th in Relational Databases Tools with 142 reviews while Oracle Database is ranked 2nd in Relational Databases Tools with 283 reviews. MySQL is rated 8.2, while Oracle Database is rated 8.6. The top reviewer of MySQL writes "Good beginner base but it should have better support for backups". On the other hand, the top reviewer of Oracle Database writes "Supports a large volume of transactions compared to other databases". MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, Teradata and Percona Server, whereas Oracle Database is most compared with SAP HANA, SQL Server, MariaDB, IBM Db2 Database and CockroachDB. See our MySQL vs. Oracle Database 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.