Try our new research platform with insights from 80,000+ expert users

MySQL vs Oracle Database In-Memory comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

MySQL
Ranking in Relational Databases Tools
3rd
Average Rating
8.2
Reviews Sentiment
7.5
Number of Reviews
148
Ranking in other categories
Open Source Databases (1st)
Oracle Database In-Memory
Ranking in Relational Databases Tools
8th
Average Rating
8.8
Reviews Sentiment
8.3
Number of Reviews
29
Ranking in other categories
Embedded Database (3rd)
 

Mindshare comparison

As of February 2025, in the Relational Databases Tools category, the mindshare of MySQL is 8.4%, down from 9.0% compared to the previous year. The mindshare of Oracle Database In-Memory is 1.4%, up from 1.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools
 

Featured Reviews

Naresh Kumar - PeerSpot reviewer
Lightweight and is available at a friendly price
In terms of our organization's data management strategy, especially if I talk about PLM software, which is about data management and can be regarded as the core data management of the products that we make. When we are designing something, specifically a new product, it is a critical area, especially considering that I am in the energy sector. In the energy sector, when we are building huge turbines and other things, the data might have intellectual property aspects attached to it. Even within the company, one region cannot see other regions to the extent to which the product offers security. In my company, we use PDM and PLM from Teamcenter effectively. MySQL is not a tool my company uses in production. When we create some small demos, we use MySQL. For production, we would use only Oracle because it is the most stable tool in the market. When we install Teamcenter, we don't need to touch the database. We just need to make some references to figure out this is the database, and it automatically creates everything. The basic thing about PDM and PLM systems is that the user should never touch the database because people may corrupt the data model or do anything that will have a very bad impact on the system. Database modifications only have to be made to the PLM system. We are not supposed to interact with the database directly. The tool is very lightweight, less expensive, and sometimes it is free. It is a very usable tool that is preferred by a lot of people. Only for production use, I may ask people not to use it. Integration of MySQL is like how we don't directly integrate PLM with Oracle. We have to use PLM's APIs to talk to the database. As a part of the best practices, we should not directly integrate anything with the PLM database. Feature-wise, the integration capabilities of the product are easy to use. It is like any other tool where if there is a table, there is a property. If you want to map a property using any middleware, then we can easily do that. I recommend the product to others. For medium-sized companies, MySQL is one of the best solutions. Medium-sized companies can choose not to go for Oracle, which is very expensive. In terms of the value or benefits derived by our company from the use of the product, I would say that it is not very expensive and provides performance along with scalability. The product can cater to the needs of customers ranging from 2,00,000 to 6,00,000 to 10,00,000 records. Even 20,00,000 records are fine, but after that, users may get into trouble. It is the best tool for mid-sized companies with a reasonable amount of data. I rate the tool an eight out of ten.
Md Al-Amin - PeerSpot reviewer
Ensures that users experience a good return on investment
Firstly, a user should prepare the operating system for installation, and then we have to copy the software to install the product. When dealing with scenarios related to Oracle Real Application Clusters, users need to add nodes and storage. The setup process is a little bit complex compared to DB2. The setup process of Oracle Database In-Memory takes around five to six hours to install Oracle Real Application Clusters, if everything is okay, apart from which the other processes will take a day. The solution is deployed on an on-premises model. The cloud-based solution is available for testing and development, and it need not be installed in your environment. A user just needs to do a few clicks and select the database, after which it automatically gets installed in the cloud. Only in the on-premises version of the product, there is a need to do some work in the tool.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"We use the basic features of MySQL. The interface that allows us to see the parameters of the server is good."
"It's a good tool, a good database platform."
"A good traditional database that supports JSON."
"The product is flexible and easy to use."
"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."
"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."
"MySQL is an open-source product and has good community support. If you encounter any problem, you can easily ask other members of the community to help. They help you a lot. On top of being free, MySQL is a cross-platform database, meaning it can work on both Windows and Linux. It is very good for us."
"The easy access to the data and the ability to sort the data with multiple methods are very valuable features."
"The solution's most valuable feature is its performance optimization within our hardware environment."
"We can integrate it with any data sources as well."
"The on-premise version is stable. We have different teams and resources for the server side, for admin, and for development. We can easily take care of all the services and applications."
"The product offers high scalability."
"We use the tool for real-time data transfer for risk management purposes. In a trading system, conversions happen fast. We use the product to handle fast transactions with low latency."
"The application development is very user-friendly."
"The most valuable aspects of this solution are the fast caching and improved performance to the database"
"The solution's ROI is excellent."
 

Cons

"We require more ease of use, scalability, and high availability. These are some of the critical features that we use and look for in a product. It should be easier to manage clusters. Scalability is very important for us because our projects and concurrency requirements are quite big. We also require high availability of the server, application, and other things. It should also have more performance-based features or enhancements from the performance point of view. When we divide a database, it should be able to handle the queries very fast."
"I would like to see more integrations of the solution with other platforms and improve the support on different data types."
"I feel that some tools which make it easier to create queries or make it easier for other functions would be really interesting to see."
"Could use some additional JSON query support in the solution."
"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."
"Oracle should start putting in some of the enterprise features in the standard feature. There are some key features that should be part of the standard."
"If it had something similar to Microsoft’s DTS engine then it would be the best database system out there."
"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."
"The high cost of the product is an area of concern where improvements are required."
"The product could benefit from enhancements in its graphical user interface."
"It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory."
"The solution is quite expensive."
"The product could be more economical."
"We often have to find solutions on our own through the support site, so there's room for improvement in this regard."
"Oracle Database In-Memory is more expensive than Azure, and the support from the Oracle team is not very good, especially since they do not have a support team in our region."
"I would like Oracle Database In-Memory to include a data replication feature."
 

Pricing and Cost Advice

"When you know the setup will continue to grow, make sure you have the paid support."
"There is no licensing fee."
"There is no cost involved, no licensing fees."
"I don't pay for a license."
"It is an open source platform."
"It's cheaper than other solutions."
"For the on-premise version, no license is required."
"MySQL Enterprise Support is not cheap, though might still be cheaper than Oracle or SQL Server. They may not have local support depending on where you’re based, but there are many smaller agencies out there that will readily provide support. You’ll need to spend some time looking around."
"Database In-Memory is priced a bit higher than its competitors like Microsoft."
"Oracle Database In-Memory is expensive."
"There is a need to make a yearly payment towards the licensing costs, after which there is any to pay towards the support cost attached to the solution."
"I rate the pricing a zero out of ten because Database In-Memory is too costly."
"It's quite costly and it comes with a fixed price."
"The pricing is pretty good so I rate it an eight out of ten."
"The product is expensive."
"The platform's licensing cost needs improvement."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
832,138 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
15%
Financial Services Firm
11%
Manufacturing Company
7%
Government
7%
Financial Services Firm
19%
Computer Software Company
11%
Manufacturing Company
9%
Government
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Why are MySQL connections encrypted and what is the biggest benefit of this?
MySQL encrypts connections to protect your data and the biggest benefit from this is that nobody can corrupt it. If you move information over a network without encryption, you are endangering it, m...
Considering that there is a free version of MySQL, would you invest in one of the paid editions?
I may be considered a MySQL veteran since I have been using it since before Oracle bought it and created paid versions. So back in my day, it was all free, it was open-source and the best among sim...
What is one thing you would improve with MySQL?
One thing I would improve related to MySQL is not within the product itself, but with the guides to it. Before, when it was free, everyone was on their own, seeking tutorials and how-to videos onli...
What do you like most about Oracle Database In-Memory?
We can integrate it with any data sources as well.
What is your experience regarding pricing and costs for Oracle Database In-Memory?
Oracle Database In-Memory is very expensive. Additionally, there are extra costs for some features.
What needs improvement with Oracle Database In-Memory?
Oracle Database In-Memory is more expensive than Azure, and the support from the Oracle team is not very good, especially since they do not have a support team in our region.
 

Comparisons

 

Overview

 

Sample Customers

Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.
Shanghai Customs
Find out what your peers are saying about MySQL vs. Oracle Database In-Memory and other solutions. Updated: January 2025.
832,138 professionals have used our research since 2012.