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

MySQL vs Oracle Database In-Memory comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 4, 2025

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.4
Number of Reviews
148
Ranking in other categories
Open Source Databases (1st)
Oracle Database In-Memory
Ranking in Relational Databases Tools
9th
Average Rating
8.8
Reviews Sentiment
7.9
Number of Reviews
31
Ranking in other categories
Embedded Database (3rd)
 

Mindshare comparison

As of March 2025, in the Relational Databases Tools category, the mindshare of MySQL is 8.5%, down from 8.8% 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

Muzzamil  Hussain - PeerSpot reviewer
Native encryption ensures secure data management with a simple deployment
The most valuable feature is the on-premises data encryption facilities. By default, we can provide encryption, and this feature in MySQL is why we prefer it over other databases. The native encryption in MySQL encourages us to use this database model more frequently compared to Oracle and other databases. With Oracle, we have to buy another solution for encryption and masking, but MySQL supports native encryption, which enhances our return on investment. It perfectly supports our ROI, and we have no issues with its functionality.
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

"I rate the solution's stability a ten out of ten since it has been running flawlessly."
"The solution is great for small applications in particular."
"MySQL gives us a very user-friendly workspace in which to query the database."
"MySQL's clustering features are very strong, and you can automate scripting, so that helps. We wrote a Terraform script and ran it."
"The most valuable feature of MySQL is auto-scaling."
"Apart from the features that are in the enterprise part, we find the database to be valuable. The connectors and the backup features are valuable as well. We use the basic database. We don't really use the extra features. Our clients like the security features in the database."
"The deployment process is pretty fast."
"It is a scalable solution."
"We find the dashboard and the speed of data processing very valuable in Oracle Database In-Memory."
"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."
"Normally, every database server uses hard disks. In-Memory has a feature, apart from their database, which is very good. When we start our server, all your data needs loading memory. We can use that. It's a very good feature. I think they added this feature in 2019. We can mount memory in the partition, create partitions in there, and create table space from that spot to share. It's a really good feature. We use it a lot."
"I find the performance features of Oracle Database In-Memory to be most beneficial."
"It efficiently handles low-code data and supports read-and-write operations for clustering."
"The most valuable aspects of this solution are the fast caching and improved performance to the database"
"The solution's most valuable feature is its performance optimization within our hardware environment."
"We can integrate it with any data sources as well."
 

Cons

"There are some issues with compatibility with Java environments that need to be improved. When Oracle bought this solution there were some driver changes that caused some issues with operations."
"The manuals or documentation could be better."
"MySQL could be improved by adding more automation."
"Its scalability can be better. It is probably not as scalable as Oracle. I had some issues with connectors. I used it from a C++ program, and it required some work to make it run, but finally, it worked."
"This solution needs to be improved when it comes to working with desktop applications on the developer side."
"The workbench could be improved. In particular, error messages can be improved, which are horrific and completely unhelpful. I'd like to see improved parsing of errors. When you write SQL and it crashes, it usually is something completely irrelevant and not helpful. I've started to use GPT 3.5 for finding out how to do things. I got to do something a bit different, and that I found to be very useful. If there was some way to tie it into one of the new AI tools, that would probably be a good idea."
"As for areas that could be improved, the tool is often used as a local database on laptops. But now, we're moving to cloud-based solutions that are more scalable and highly available. I think the tool should offer a cloud database option. This would let users keep a local copy of data if needed, but also have their data available across different regions through a cloud account."
"When working with a cluster wide, I have to use the MySQL cluster version."
"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."
"The dashboard requires some refreshment or configuration improvements."
"Oracle Database In-Memory could improve by better supporting generative AI challenges, such as hallucination management."
"The high cost of the product is an area of concern where improvements are required."
"We use some partitions in In-Memory. We have a very large table and a low dose. It is very expensive in data to load all of them into In-Memory. It takes up more memory slots in the server, as well as a lot of RAM. We use last partitions on the table. We always need to create a script and make a schedule that can load a last partition in In-Memory. Oracle doesn't have features to do this automatically. I would like them to allow us to load last partitions, as well as other table partitions, in In-Memory. I think a good feature would do that automatically, letting you see a table, load a large partition, and monitor loading memory. It's quite a good feature."
"They should lower the price. My customers think that it's too expensive."
"The product could benefit from enhancements in its graphical user interface."
"The platform’s pricing needs improvement."
 

Pricing and Cost Advice

"It has a community version."
"I am using the Community Edition, which is available free of charge."
"I am not paying, but I am not sure about the exact licensing requirements."
"We are using the free version of MySQL. We prefer paying for a yearly license."
"There is a licensing cost because we are going for a proprietary product. There are some other versions for which there is no licensing cost."
"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."
"We are using the free community version of the solution."
"The tool is open source."
"The product is expensive."
"The pricing is pretty good so I rate it an eight out of ten."
"It's quite costly and it comes with a fixed price."
"The platform's licensing cost needs improvement."
"The solution's pricing is high."
"Oracle Database In-Memory is expensive."
"I rate the pricing a zero out of ten because Database In-Memory is too costly."
"Database In-Memory is priced a bit higher than its competitors like Microsoft."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
842,651 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Financial Services Firm
12%
Manufacturing Company
7%
Government
6%
Financial Services Firm
19%
Computer Software Company
11%
Manufacturing Company
8%
Government
8%
 

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?
The dashboard requires some refreshment or configuration improvements. Also, the pricing could be addressed.
 

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: March 2025.
842,651 professionals have used our research since 2012.