MySQL vs. Oracle Database

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
MySQL
Score 8.3 out of 10
N/A
MySQL is a popular open-source relational and embedded database, now owned by Oracle.N/A
Oracle Database
Score 8.1 out of 10
N/A
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build graph applications with SQL using existing SQL development tools and frameworks.N/A
Pricing
MySQLOracle Database
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
MySQLOracle Database
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
MySQLOracle Database
Considered Both Products
MySQL
Chose MySQL
MySQL offers some of the features as Oracle Database 12c, however, there are many crucial ones that are missed. Features such as OLAP, really make Oracle Database 12c a clear winner here. We use both databases in our organization for separate reasons, MySQL for prototyping, and …
Chose MySQL
Of course compare to no SQL databases it's slower but there is a completely different use case for them... In my opinion it is better than PostgreSQL, it's easier to configure and has the same performance, or approximately the same. Of course Oracle Database is a way bigger …
Chose MySQL
As I have been commenting in our company, we have solved our performance problems and responses obtaining speed in the queries occupies less disk space, in addition to its price and all the tools of great Scope it possesses.
Chose MySQL
Having used both PostgreSQL and Microsoft SQL Server, I can tell that MySQL performs admirably in a Linux setting. When compared to Microsoft SQL Server, the extra benefit is the minimal or nonexistent licence fee. We find that MySQL's programming interface is particularly …
Chose MySQL
Before MySQL, our team was exploring and evaluating different options for a good RDMS (relational database management system) service. We explored Oracle, MSSQL, and Google BigQuery. Most of these are costly and not easy to maintain in the long run in terms of price especially …
Chose MySQL
MySQL has most of the functionality of other, very costly, alternatives without the big price tag. It is open-source with improvements coming at a relatively good rate. It is not as robust as those other offerings and can have some challenging points at scale for large …
Chose MySQL
Microsoft SQL can be considered as an enterprise level software since it is recommended for large businesses. Microsoft SQL has some unique categories like big data processing, DBMS, etc. whereas MySQL is not capable of handling such features. I guess this is how these both …
Chose MySQL
I would choose Oracle 11g, 12c for more complex ventures which require financials and complex logic. I would choose MySQL for simpler applications which simply need to interface data to a backend. I selected MySQL in this case because it is free and much simpler to install—it …
Chose MySQL
Familiarity: With MySQL, I know what to expect, and that goes a long way. Also, since it adheres fairly close to SQL '92, It's relatively easy to construct queries, views, etc. without a steep learning curve. Also, RAM usage is important (this is true of any RDBMS …
Chose MySQL
We have used Oracle as our clinical databases that stores patient records. In this project we didn't used Oracle but separately built MySQL based data infrastructure as this is an independent scientific research project. Oracle is great overall, with most of functionalities …
Chose MySQL

I've used both Oracle and MySQL. I like both database technologies. Both of them provide great solutions. Each one has their own benefits based on the requirement and right environment. The point is to find the right environment to use and compare price/performance/scalability.

  • M…
Oracle Database
Chose Oracle Database
MySQL: I used MySQL as part of an old CRM. I think that's also light. But, Oracle seems to have better speed and reliability.
DB2: I used DB2 mainly on mainframe and z/OS. I always felt that it's cumbersome to access and write queries on DB2.
Chose Oracle Database
MySQL does not provide anywhere near the user interface or features that Oracle Database 12c provides. Building REST endpoints on MySQL is a much more challenging process and integrating it with a web app is much more complicated than building an ORDS endpoint within the Oracle …
Chose Oracle Database
We currently use all of the above database technologies in different applications, but where the application is mission-critical we use Oracle. Microsoft SQL Server is good for canned applications such as back-office or HR. MySQL does not have the same level of logging or …
Chose Oracle Database
It depends on the use case. Oracle database is for everyone, but if it's a lightweight application, MySQL might be an easier choice.
Chose Oracle Database
IBM DB2 is extremely heavy as compared to Oracle and is expensive for the price we pay for the product. MySQL doesn’t have most of the features that Oracle has.
Chose Oracle Database
Oracle Database is best in business, consistent, and robust. Even the standard version is sufficient for the best performance. The main thing is I have never seen corruption and in my opinion, it is best when used with Linux.
Chose Oracle Database
Microsoft SQL is just as stable and almost as sellable with a much lower cost of ownership (staff and licensing). But as our primary application doesn't support Microsoft SQL we had to license Oracle.
Chose Oracle Database
Exadata is expensive and we decided to switch to 12c for the sake of consolidating and keep up with Oracles initiative to move towards cloud. Maybe in the future.
Chose Oracle Database
Oracle 12c is good for all business applications but still consider Microsoft SQLServer for internal/other applications to save on cost.
Chose Oracle Database
Oracle is more of an enterprise-level database than Access and SAP Adaptive Server Enterprise isn't getting developed much (some people wonder how close it is to end of life) but SQL Server is miles ahead of Oracle IMO in terms of user experience and comparable in terms of …
Chose Oracle Database
Oracle Database 12c has more support from Oracle, and it is more scalable.
Chose Oracle Database
Oracle comes with a sequence generator.
Chose Oracle Database
Oracle 12c is able to support daily operations that might be required. Of course, Exadata is a powerful machine that is definitely fit for big scale but requires high demand of both CPU, IO, and memory processing. Also the one engineered system saves lots of time to build the …
Chose Oracle Database
It's the Oracle Support that beats everything else, and a solid contract. Also, all the other features that support Oracle are way ahead of other products.
Chose Oracle Database
Oracle is, I believe, the most expensive, but also the most feature-rich of the group. For in-house development, it stands apart from the pack.
Chose Oracle Database
Oracle completed solution and support is of cause better than open source solutions, we also choose other NoSQL database and Graph database, to address some very particular business use cases
Chose Oracle Database
It's easy to scale an Oracle database compared to any others, it's easy to manage many Oracle databases together with lots of administrative and security features.
Chose Oracle Database
1. The commercial application required an Oracle database running at the back end
2. Existing Oracle expertise makes it easy to manage an Oracle database
3. Confidence in Oracle databases: No need to worry about performance, scalability.
Chose Oracle Database
For some implementations in my company, Oracle Database was selected because all the support, experience, features, continuing development, etc that the product and Oracle's company has been providing so far, but also, it was selected by the system's company that my …
Top Pros
Top Cons
Best Alternatives
MySQLOracle Database
Small Businesses
Redis™*
Redis™*
Score 9.0 out of 10
SingleStore
SingleStore
Score 9.7 out of 10
Medium-sized Companies
Redis™*
Redis™*
Score 9.0 out of 10
SingleStore
SingleStore
Score 9.7 out of 10
Enterprises
Redis™*
Redis™*
Score 9.0 out of 10
SingleStore
SingleStore
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
MySQLOracle Database
Likelihood to Recommend
8.2
(134 ratings)
9.1
(178 ratings)
Likelihood to Renew
9.9
(4 ratings)
9.0
(6 ratings)
Usability
10.0
(6 ratings)
7.4
(5 ratings)
Support Rating
8.6
(2 ratings)
10.0
(4 ratings)
Implementation Rating
8.0
(1 ratings)
9.6
(3 ratings)
User Testimonials
MySQLOracle Database
Likelihood to Recommend
Oracle
From my own perspective and the tasks that I perform on a daily basis, MySQL is perfect. It has a reasonable footprint, is fast enough and offers the security and flexibility I need. Everyone has their preferred applications and, no doubt, for larger data warehouses or more intensive applications, MySQL may have its limits, but for the area that I operate in, it's a great match.
Read full review
Oracle
I believe Oracle Database is still the best RDBMS database which is the database to consider for OLTP applications and for Adhoc requests. They are good in Datawarehousing in certain aspects but not the best. Oracle is also a great database for scaling up with their Clusterware solution which also makes the database highly available with services moving to the live instance without much trouble.
Read full review
Pros
Oracle
  • Security: is embedded at each level in MySQL. Authentication mechanisms are in place for configuring user access and even service account access to applications. MySQL is secure enough under the hood to store your sensitive information. Also, additional plugins are available that sit on top of MySQL for even tighter security.
  • Widely adopted: MySQL is used across the industry and is trusted the most. Therefore, if you face any problems, simply Google it and you shall land in plenty of forums. This is a great relief as when you are in a need of help, you can find it right in your browser.
  • Lightweight application: MySQL is not a heavy application. However, the data you store in the database can get heavy with time, but as in the configuration and MySql application files, those are not very heavy and can easily be installed on legacy systems as well.
Read full review
Oracle
  • Best thing about it is that it supports PL/SQL which is helpful in writing complex quarries easily.
  • Its storage capacity , backup and recovery features make it the best database storage tool available.
  • Other thing I like about this software is its interface is so good.
Read full review
Cons
Oracle
  • Although you can add the data you require as more and more data is added, the fixity of it becomes more critical.
  • As the demand, size, and use of the system increase, you may also need to change or acquire more equipment on your servers, although this is an internal inconvenience for the company.
Read full review
Oracle
  • The memory demand and management makes it impossible to run it in a container.
  • It is hard to perform local unit testing with Oracle even using the personal edition (aggressive all the available memory grab for itself).
  • Lack of built in database migrations (e.g. as Flyway).
  • The need to install the Oracle client in addition to its drivers.
  • The cost of running it, especially in the Cloud.
  • Comes with very spartan community grade client/management tools whereas the commercial offerings tend to demand a premium price.
Read full review
Likelihood to Renew
Oracle
For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.
Read full review
Oracle
There is a lot of sunk cost in a product like Oracle 12c. It is doing a great job, it would not provide us much benefit to switch to another product even if it did the same thing due to the work involved in making such a switch. It would not be cost effective.
Read full review
Usability
Oracle
I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.
Read full review
Oracle
Many of the powerful options can be auto-configured but there are still many things to take into account at the moment of installing and configuring an Oracle Database, compared with SQL Server or other databases. At the same time, that extra complexity allows for detailed configuration and guarantees performance, scalability, availability and security.
Read full review
Support Rating
Oracle
The support staff is friendly, knowledgeable, and efficient. I only had to get part way through my explanations before they had a solution. They will walk you through a fix or actually connect in and fix the problem for you--or would if you can allow it. I've done it both ways with them. They are always forthcoming with 'how to do this if it happens again' information. I love working with MySQL support.
Read full review
Oracle
1. I have very good experience with Oracle Database support team. Oracle support team has pool of talented Oracle Analyst resources in different regions. To name a few regions - EMEA, Asia, USA(EST, MST, PST), Australia. Their support staffs are very supportive, well trained, and customer focused. Whenever I open Oracle Sev1 SR(service request), I always get prompt update on my case timely. 2. Oracle has zoom call and chat session option linked to Oracle SR. Whenever you are in Oracle portal - you can chat with the Oracle Analyst who is working on your case. You can request for Oracle zoom call thru which you can share the your problem server screen in no time. This is very nice as it saves lot of time and energy in case you have to follow up with oracle support for your case. 3.Oracle has excellent knowledge base in which all the customer databases critical problems and their solutions are well documented. It is very easy to follow without consulting to support team at first.
Read full review
Implementation Rating
Oracle
1. Estimate your data size. 2. Test, test, and test.
Read full review
Oracle
Overall the implementation went very well and after that everything came out as expected - in terms of performance and scalability. People should always install and upgrade a stable version for production with the latest patch set updates, test properly as much as possible, and should have a backup plan if anything unexpected happens
Read full review
Alternatives Considered
Oracle
MongoDB has a dynamic schema for how data is stored in 'documents' whereas MySQL is more structured with tables, columns, and rows. MongoDB was built for high availability whereas MySQL can be a challenge when it comes to replication of the data and making everything redundant in the event of a DR or outage.
Read full review
Oracle
Oracle is more of an enterprise-level database than Access and SAP Adaptive Server Enterprise isn't getting developed much (some people wonder how close it is to end of life) but SQL Server is miles ahead of Oracle IMO in terms of user experience and comparable in terms of performance AFAIK. As stated, a vendor forced our hand to use Oracle so we did not have a choice. If you are looking for help with an issue you are having, there are lots of SQL Server articles, etc. on the web and the community of SQL Server developers and DBA's is very strong and supportive. Oracle's help on the web is much more limited and often has an attitude that goes with it of superiority and lacking in compassion, IMO. For instance, check out the Ask Tom Oracle blog - a world of difference. If you choose Oracle, go into it with eyes wide open.
Read full review
Return on Investment
Oracle
  • As it is an open source solution through community solution, we can use it in a multitude of projects without cost license
  • The acquisition by Oracle makes you need to contract support for the enterprise version
  • If you have knowledge about oracle databases, you can get more out of the enterprise version
Read full review
Oracle
  • Oracle Database 12c has had a very positive impact on our ability to build strong and robust custom applications in house without the need to come up with our own methods of data storage and management.
  • Oracle Database 12c has the strongest user interface of any database I have worked with and continuously is improving its strength with the addition of support for JSON and XML type objects in the database.
  • Oracle Database 12c is sometimes very heavy and DBA intensive, but the benefits far outweigh the costs, which we need to spend on DBA support for enabling security and access features.
Read full review
ScreenShots