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.
"A good traditional database that supports JSON."
"The connectivity with PHP is quite good."
"SKIP LOCKED is a valuable feature."
"MySQL is easy and convenient for me. I don't need to rely on anyone. I can write the code and extract the information. It is fast if you know how to use it. The solution is not expensive, and most of the developers know how to use it. It is easy to create tables. The solution is stable and has good performance. The connection with AWS gives regular updates, which is manual otherwise and a nightmare."
"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."
"I like MySQL's feature that helps to automate things."
"MySQL is a light database. It's not very complex. It's easy to develop, easy to maintain, and easy to back up and restore."
"The product is flexible and easy to use."
"Oracle Database has many useful functions and features suitable for big programs and complex business models."
"Oracle Database is the best based on stability and high performance."
"We find technical support to be very responsive. They briefly describe everything on phone and we handle the operations. I'd say we've been more than satisfied with their level of service. They're quite helpful and knowledgeable."
"Offers a lot of backup security and is very powerful."
"The reliability is the solution's most valuable feature. We've had great success with the solution."
"You can install Oracle Database software, patching, and create/configure Oracle databases in silent using scripts"
"Especially with VMs, the solution can scale well."
"The solution is very easy to use in general."
"Security is a concern. MySQL could have better security features."
"Stability needs improvement and the backup needs to be enhanced."
"Rather than going in-depth about the technical features, which a technical person can directly tell, I would say that MySQL should be able to adapt to the next framework. The 5G framework means an unstructured framework. So if MySQL becomes smoother and more adaptable, it'll be easier."
"I am looking for the Temporal SQL feature, which basically means that there is complete history for each table. This feature is currently available in MariaDB. PostgreSQL has something called a foreign-data wrapper, which is another way to access external data from inside. MySQL could have a similar feature."
"MySQL's performance requires attention. For optimal performance, one should review and sometimes revise the code, particularly when using server-side scripting."
"The solution could improve by having better performance and security."
"The user interface could be more user friendly. Mainly because most of the times we see black and white digital lines. Something like Python."
"The documentation is pretty weak and should be improved."
"The interface is not reliable because the GUI is old."
"It should have flexible licensing across different platforms. It has got different licensing models for Intel Power and SPARC servers."
"I believe that the simplicity of installation and configuration for logging in to Microsoft and PostgreSQL could be improved."
"The software really doesn't need any improvement, but the way they do the billing should be improved. They charge by all the chips on the server, whether you use them or not. If you have a server that has 64 chips on it and you use one chip, they charge you for 64, and that's a terrible business model."
"More integration, in my opinion, would be beneficial."
"I'm in Indonesia. From what I know, Ali Cloud has already built a center in Indonesia, and Google also has a data center in Indonesia. I have heard that Amazon will also build a data center in Indonesia, and the same will be with Azure if they deal with the Indonesian government. I'm quite appreciative of what Amazon has done by deciding to have a local data center. I expect Oracle to do the same, but Oracle doesn't seem to have plans to build a data center in Indonesia. This is something that needs to be improved. Oracle should follow all the other cloud providers who see a potential market in Indonesia. It would be better for Oracle to be equal to other cloud providers and have a data center in Indonesia so they can compete. Having a local data center means that they can avoid performance issues, the latency of the network, and all the things that are related to the network for internet-based solutions. Customers in Indonesia expect a local data center."
"Its administration side is very difficult. To install Oracle Database, you need to have some prior knowledge. You must learn their commands. I was new to this, so I found some difficulty in it. Its installation should be easier. It is expensive, and it should be cheaper."
"On the ERP side, they do not seem to be improving the on-premises version. They seem to want to push the cloud option on users."
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.