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.
"MySQL is open-source. There are a lot of open-source communities trying to come up with their own patches, and to come up with their own features, which help MySQL develop faster than traditional databases like Oracle, which is closed source."
"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's a mature solution that's been around for decades."
"I rate the solution's stability a ten out of ten since it has been running flawlessly."
"MySQL is easy to use, has fast performance, and it is comfortable for end-user to use. The schema level and structure we are using are very simple and easy to understand. Additionally, packaging tool development is straightforward and the data is presented in a way that is very simple to understand."
"It is a scalable solution."
"For sure, the solution is very stable."
"The deployment process is pretty fast."
"Oracle Database is highly scalable."
"The technical support from Oracle is good and responsive. I used them for security updates and patches."
"It is stable, and its performance is good. Its interface is also fine."
"Oracle is somewhat user-friendly, and most customization or integration with Oracle-related projects is simple."
"One of the most valuable features is the stability."
"The most valuable feature of Oracle Database is its stability - one can trust that the database is always working."
"A really large and very useful language to process data."
"The best features of Oracle Database Server are the security, high availability, and the Disaster Recovery solutions with the Data Guard. Specifically, on Autonomous Databases, the most valuable features are the automatic scaling and CPU scaling depending on the database workload. Today, the workload is normal and then suddenly the workload gets a spike."
"I would like to see the automatic backup feature in the solution as well. Data is very important and we need to preserve it in a safe place. It would be good if MySQL can back up the data automatically."
"It could be a little bit simpler to use."
"I would like to improve the solution’s pricing for licenses."
"Sometimes, not because the version is not the latest version, there are some issues with it. Sometimes there's an issue with the server which creates issues with it."
"There should be an arrangement for end-users to get trained to use the tool...Improvement-wise, a graphical interface could be added for new users, eliminating the need to memorize the complex syntax."
"It isn't as reliable as an SQL Server."
"Sometimes, I get lost in the toggles and buttons, and a better visual design would be nice. The layout is not user-friendly or efficient."
"Security is a concern. MySQL could have better security features."
"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."
"In my opinion, the pricing of all the additional tools that Oracle provides is very complicated. The pricing model is very unfriendly for the user, and for the web vendors."
"The initial setup was very complex - best case, it takes between four and six hours to set up."
"When you try to tell customers that you can critically patch their system, they always complain about the cost."
"The connection can be slow due to the distance from the provider."
"Oracle support is helpful, and they resolve all our issues, but sometimes the response to our clients isn't as prompt as we'd like."
"The solution could improve security."
"They should be putting more emphasis on the Windows platform. Usually, they run very well on the Linux platform, however, their performance on Windows is a little bit lower quality."
MySQL is an open-source relational database management system (RDBMS) owned by Oracle. Before Oracle acquired the product, it was completely free for users. After the merge, the solution started offering paid services with more features, alongside a free version. MySQL can easily integrate with a wide variety of programming languages, which makes it one of the most flexible and reliable products among its competitors. This cost-effective solution helps users deliver high-performance and scalable database applications through several products. They include:
My SQL Features
The characteristics of each MySQL edition differ depending on what it offers and what clients it is catered towards. But the main features of the product include the following:
MySQL brings many benefits to organizations that use it for their data. The most common ones include:
Reviews from Real Users
According to a database engineer at a retailer with more than 10,000 employees, MySQL is a great open-source product that offers great scalability and compatibility.
Yong S., a solutions specialist, system integration, appreciates this product because it has different licensing options and is easy to set up.
Oracle Database is a top-ranking multi-model database management system by Oracle Corporation. Through Oracle database services and products, clients receive cost-optimized and high-performing versions of Oracle Database, as well as in-memory, NoSQL, and MySQL databases. The solution is available by several service providers on premises, in the cloud, or as a hybrid installation. It can be run on vendor servers as well as on Oracle hardware, including Exadata on-premise, Oracle Cloud, or Cloud at Customer.
Users can select from various types of Oracle Database solutions, depending on what they aim to do with this product. Based on their specific needs, they can choose among options that include:
Part of this product is a fully automated database service called Oracle Autonomous Database, which facilitates the development and deployment of application workloads for organizations. It is built on Oracle Database as well as on Oracle Exadata. This service supports various data types and simplifies application development and deployment from modeling and coding to extract, transform, load process (ETL), data analysis, and database optimization. The service achieves high results in:
Oracle Database Features
Oracle Database has various features which users can utilize in their work with the solution. Among these features are the following:
Oracle Database Benefits
Oracle Database offers its users various benefits. Some of these include:
Reviews from Real Users
Paul S., president at Advance Consulting Enterprise, likes Oracle Database because it gets the job done, doesn't fail, and suitable for massively scalable applications.
An Oracle DBA at a computer software company describes Oracle Database as reliable with good performance and very good stability.
MySQL is ranked 4th in Relational Databases Tools with 35 reviews while Oracle Database is ranked 2nd in Relational Databases Tools with 70 reviews. MySQL is rated 8.6, while Oracle Database is rated 8.6. The top reviewer of MySQL writes "A great open-source product that offers great scalability and compatibility". On the other hand, the top reviewer of Oracle Database writes "Performs well, easy to use, and the technical support is quite good". MySQL is most compared with Firebird SQL, MariaDB, SQL Server, PostgreSQL and Teradata, whereas Oracle Database is most compared with SAP HANA, SQL Server, IBM Db2 Database, MariaDB and Amazon Aurora. 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.