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

MySQL vs Oracle MySQL Cloud Service comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

MySQL
Ranking in Open Source Databases
1st
Ranking in Relational Databases Tools
3rd
Average Rating
8.2
Reviews Sentiment
7.5
Number of Reviews
147
Ranking in other categories
No ranking in other categories
Oracle MySQL Cloud Service
Ranking in Open Source Databases
7th
Ranking in Relational Databases Tools
12th
Average Rating
8.2
Reviews Sentiment
8.5
Number of Reviews
17
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of December 2024, in the Open Source Databases category, the mindshare of MySQL is 14.4%, down from 20.8% compared to the previous year. The mindshare of Oracle MySQL Cloud Service is 0.4%, down from 0.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Open Source Databases
 

Featured Reviews

Patryk Golabek - PeerSpot reviewer
Good beginner base but it should have better support for backups
As for what can be improved, right now we don't use the MySQL cluster. There is a MySQL cluster that you can run in a standalone mode, like a single database or you can do it in a cluster master-slave implementation. The cluster is not the best when it comes to MySQL. That's why we switched to MariaDB. For that simple reason that the cluster there is better. It's more manageable and it's easier to work with. We decide what to use depending on the needs. For example, if we need to mount something in a cluster mode, we use MariaDB, which again, is a Dockerized solution with a Helm chart as well, and it's very easy for us to deploy and manage, and also to scale when you just increase the number of slave versions. So MySQL doesn't have that great support when it comes to clusters. You can definitely use MySQL for that too, both support clustering, but the MariaDB is better. Additional features that I would like to see included in the next release of this solution include better support for backups. Because if you go with the MySQL Percona version, it gives you the tools to back it up securely. The vanilla version of MySQL doesn't have that. It actually does have it, but it is just really poorly executed. I would improve the backup system as well as the encryption. To make it smoother right now takes too much work. It should be a little bit smoother to backup the encrypted data the way you want it and have the ability to push it anywhere you want. That is not part of it right now. Now it is a database, so you don't know what you're going to do with it. It's difficult. You're just going to come up with solutions. But I think you can generalize here and come up with really simple solutions, which we have already in MySQL. That's probably the one thing that I would try and push right now for people to switch. But people are still not biting, because if you go with the managed version, then all the backups are taken care of for you by Amazon or Google or Microsoft. Then you really don't care. But for us, since we're doing it locally, self-hosted, we would like to have better tools for locking up the data. Right now, one aspect that is also linked to backups is running things in a crosscheck with semi-managed solutions. This requires a bit of a context. Since we're running things within the clustered communities, we're kind of pushing the Cloud into the cluster. We also want to push some of the tools for the database into a cluster, as well. So these are what we call Kubernetes operators. And there's MySQL operators that were first developed by the community. Those kind give you the ability to backup data within the cluster. So now you have a fully managed solution running from your cluster. These are called MySQL Kubernetes operators. We are looking into those right now to upgrade our solution, which would mean that we can just execute our backup natively within Kubernetes, not via special scripts. This would make it much easier to actually deal with any kind of MySQL issues within the cluster, because it would be cluster-native. That's what the operators are for. I think Oracle just created a really good one. It surprised me that they have this. It's not because of Oracle, but they got pushed by the community and actually created the MySQL Operator for Kubernetes, and that's what we're moving towards. This is going to give you an ability to have a cloud-managed solution within the cluster. And then you can ask the MySQL Operator for the database. They'll partition the database and give it to you. So it will change the nature from you deploying it to you just asking the cluster to give you a database. It's a fully managed solution right from the cluster. So that's what we're heavily looking into right now. We'll be switching to using Kubernetes MySQL Operators. It's a high-availability cluster running within the Kubernetes cluster. Right now we're pretty good with that. It's working fine. We're trying to find some time to actually release that globally everywhere. That's where I am right now. But in terms of technology, if you give up Oracle, you just go to a MySQL operator. That's the one we're using, what we're actually looking at - to create, operate and scale mySQL and sell it within the cluster. This idea of having a cognitive MySQL becomes much easier to manage within the cluster, as well. So you don't have to go with the cloud solution with AWS or Google cloud or Amazon MySQL or the Microsoft version. The Oracle SuperCluster is the Oracle MySQL operator. That's what we we are looking into a lot right now. Mainly because it does backups on demand - it's so easy to backup. You can just tell Kubernetes to backup and you don't have to run special scripts or special extra software or codes to back it up. You can make the backup as you would do anything else. Send a backup or some other data source or insert an Elasticsearch into it here. Just say "Kubernetes, back it up" and you know Oracle has this adapters within the cluster to back it up for you taking increments or different companies. So that makes it really nice and easy to use and to deploy. With that kind of solution you can ask to class or petition the database how you want. So again, it changed the nature of the kind of push-to-pull second nature system. Are you pushing your containers to a cluster? You just say cluster, "give me a database" and the class gives you the base partition database, creates a database in a secure manner, gives the connection to the database, and you're done. Then you can back it up on a schedule on to any backup switches. It's much easier. So once this goes, it is going to be widely adopted, which it should be. But I think people might not have the tech skills right now. But once it's adaptive, maybe in a few more months, it's going to be the number one solution for everybody. In terms of what I'd like to see in the next release, one thing that's always missing is dash boarding. There's no real BI tool for MySQL, like there is in Yellowfin and all the different tools that you get. They all have MySQL connectors, but there's no specific BI tool for MySQL. Open source projects have sprung up, but they're more general purpose, like Postgress, a MySQL kind of database, a relational database. I don't see any really nice tool like Cabana for elastic searches that I can tell clients to use because it would be too technical for them. They would have to have more technical engagement with writing the course, drag and drop, and creating a graph like in Power BI where you just connect with DIA. So I'd like to see the grab and drag and drop tables, nice beautiful graphics, and pie charts. You don't necessarily have that with MySQL like you have other solutions, which are really cost prohibitive for some clients. It'd be nice to have an open source solution for that. Decent solutions. I mean decent that I can take to clients. It's so technical. They want to drag and drop.
Raghuram K M - PeerSpot reviewer
Ideal, stable, good support and it helps with the developer console
I have used MongoDB, MySQL, and Oracle. MongoDB is entirely different. It's a NoSQL platform database, so it's totally different. It is a little bit hard to work with. The way it is organized and structured is different. But between Microsoft Azure MySQL and Oracle, they are pretty similar. * Cost: Microsoft is not a preferred platform. Their licensing is very complex and expensive. Oracle is much better. * AI: In terms of data analytics and AI, Microsoft is better. Certain complex transformations are easier to do in MSSQL. So, if you have to analyze data from a lot of different data sources, it becomes much easier. However, the usage of the particular product depends on the project. Personally, I would like to work on MySQL. But in certain cases where the application scale is very large, and custom models from certain regions of the globe prefer Microsoft, then we have to go with MSSQL. But technically, there is not much difference.

Quotes from Members

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

Pros

"What I really like about MySQL is the opportunity to search for information and organize it any way I like."
"The fact that it is free is what appeals to me the most."
"MySQL's clustering features are very strong, and you can automate scripting, so that helps. We wrote a Terraform script and ran it."
"When comparing MySQL to other solutions it is easier to use and boots up faster. Additionally, when you want to query a lot of data, MySQL is better in performance."
"I rate the solution's stability a ten out of ten since it has been running flawlessly."
"I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures."
"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."
"This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge."
"The stability of the solution is very good. I wouldn't have used it for the past seven years if I was not satisfied."
"The solution overall is very, very good. It's got good integration with other databases and adds new features often."
"The most valuable aspect of the product is data migration."
"The product is easy to learn."
"The access to a suite of management and administration tools that simplify tasks such as database provisioning, configuration, and monitoring."
"The solution's performance is good."
"The most valuable features of the solution stem from the fact that it is flexible and is an open-source product."
"MySQL is a centralized RDBMS in itself, and you don't have the overkill of having the full Oracle or Microsoft SQL Server. It's ideal, and it helps with the developer console. It has three versions for developers. It's a very good tool for open source."
 

Cons

"The availability of tools could be improved in the MySQL open-source platform. They can provide more analytical tools. I haven't had any particularly difficult issues to troubleshoot on MySQL, but in the past, on Microsoft SQL Server, I had to troubleshoot some difficult issues, and better tools were in place to see what was going on in real-time on the server. So, that's the bit that is lacking on the MySQL open-source platform."
"It requires a training platform."
"MySQL tutorials and guides could be improved. Often they are too complex for someone with no database experience to understand."
"The GUI could improve to make MySQL better."
"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."
"MySQL has some unique exchange problems when it comes to migration projects."
"MySQL could introduce more indexing strategies."
"The GUI could improve in MySQL."
"MySQL should have some kind of native query browser. If it could come with a built-in connector."
"The support is not that great. They're not really supporting directly anymore and relying on experts to figure out technical issues."
"Sometimes MySQL does upgrades on the server. When we are still using the old server and when they integrate the upgrade, they don't carry along some of the old syntaxes. The versions don't sync."
"The user interface is not simple."
"The tool’s stability must be improved."
"It requires a significant amount of expertise and effort to manage, especially when dealing with substantial volumes of data."
"Sometimes, we face syntax issues with the solution."
"There could be improvements, particularly in Firebird, where the indexing is limited to just a single B-tree index, leading to poor performance for large-scale queries."
 

Pricing and Cost Advice

"The pricing is not much expensive, it's cheap."
"We're using the open-source version right now, which is free. I do see some value in some of the more enterprise functions. We're using the open-source version right now, and I was interested in the MySQL Enterprise version really for the tools that they provide, but we decided not to make the purchase."
"For the on-premise version, no license is required."
"It has a community version."
"I rate the solution's pricing as four out of ten, where one is cheap, and ten is expensive. For our basic needs, it's quite affordable. However, the cost increases when we need to scale up or require high availability. Our developer team of about 600 people uses MySQL without much issue. The pricing becomes more of a concern on the business side, as we have more end users and need constant database availability and scaling. In those cases, the solution gets a bit more expensive, even though it provides good value for the business."
"I use the open-source free community version."
"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."
"We are using the licensed version of MySQL."
"The product is expensive."
"The solution’s paid plans are expensive."
"The license is expensive."
"The product is free since it is an open-source tool."
"It is an open-source product."
"While the core solution itself is not exorbitant, the support services are associated with a significant maintenance fee, often ranging from twenty to thirty percent."
"Oracle has a better licensing model compared to its competitors."
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
824,053 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Financial Services Firm
11%
Manufacturing Company
7%
Government
7%
Computer Software Company
18%
Financial Services Firm
18%
University
14%
Real Estate/Law Firm
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 MySQL Cloud Service?
Oracle MySQL Cloud Service handles data easily.
What needs improvement with Oracle MySQL Cloud Service?
MySQL should have some kind of native query browser. If it could come with a built-in connector, then the relationship... We are just able to fix it. Right now, we have to install it separately. So...
 

Comparisons

 

Learn More

 

Overview

 

Sample Customers

Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.
Omnis, Naveex, Rehash Technologies
Find out what your peers are saying about MySQL vs. Oracle MySQL Cloud Service and other solutions. Updated: December 2024.
824,053 professionals have used our research since 2012.