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

MySQL pros and cons

Vendor: Oracle
4.1 out of 5
Badge Ranked 1
4,452 followers
Post review

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

MySQL is easy to use and install, with features that support rapid deployment and straightforward management.
It is an open-source database, allowing for extensive customization and supports from a large community.
MySQL is widely recognized for its high performance, reliability, and scalability, meeting the needs of diverse applications and user bases.
Users value MySQL's strong security features, robust data protection capabilities, and efficient data handling.
MySQL integrates well with various programming languages and platforms, enhancing its versatility for different software environments.

CONS

Replication needs improvement and better write scaling solutions beyond the NDB cluster are required.
Initial setup process should be simplified for user convenience.
Lack of specialized BI tools and performance monitoring tools for MySQL compared to competitors.
Stability, backup methods, and documentation need enhancement.
Scalability and high availability features are critical but currently lacking.
 

MySQL Pros review quotes

Patryk Golabek - PeerSpot reviewer
Aug 5, 2020
This specific version of this MySQL has been battle tested for a long time. Any issues are known issues and we pretty much don't have any problems when they're in production. So it's very stable.
AG
Oct 20, 2020
The one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support.
reviewer1378032 - PeerSpot reviewer
Dec 29, 2021
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.
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,192 professionals have used our research since 2012.
reviewer1432350 - PeerSpot reviewer
Oct 19, 2020
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.
Naresh Kumar - PeerSpot reviewer
Jul 18, 2024
It is a stable solution.
reviewer1769190 - PeerSpot reviewer
Jan 26, 2022
MySQL is easy to use, has fast performance, and it is comfortable for end-user to use. The schema level and structure we are using are very simple and easy to understand. Additionally, packaging tool development is straightforward and the data is presented in a way that is very simple to understand.
Ismail Yushaw - PeerSpot reviewer
Nov 29, 2023
It is a very stable solution. I deployed the product six years ago, and it still works fine.
reviewer1456815 - PeerSpot reviewer
Feb 25, 2021
It is pretty simple to use and I don't have anything really bad to say about it.
YT
Nov 13, 2021
The initial setup for the SQL database is not complex and it even integrates into the platform. You set up the recipe and then just follow the runbook, the build book. Then it works as long as you follow the procedures.
LM
Oct 12, 2020
The most valuable features are that it's free and the documentation is good.
 

MySQL Cons review quotes

Patryk Golabek - PeerSpot reviewer
Aug 5, 2020
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. These open source projects have sprung up, but they're more general purpose.
AG
Oct 20, 2020
If the customer is already using or has already used Oracle for a long time they will know the look and feel and the character of this database that can fit into their business.
reviewer1378032 - PeerSpot reviewer
Dec 29, 2021
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.
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,192 professionals have used our research since 2012.
reviewer1432350 - PeerSpot reviewer
Oct 19, 2020
The GUI interface probably can be improved. Let us say I want to see the relationships in the database. In the query analyzer, I would like to go and drop the tables and create relationships between the tables. I haven't found a feature like that in MySQL. It was a shortcoming even in SQL Server. MySQL can have more performance monitoring tools. I know Google has these tools, but within MySQL, there are not that many tools to monitor things like performance and database locking. They might be in there, and I might not be familiar enough to know where they are. I am a pretty new user of MySQL.
Naresh Kumar - PeerSpot reviewer
Jul 18, 2024
The performance issues in the product can be considered as an area where improvements are required.
reviewer1769190 - PeerSpot reviewer
Jan 26, 2022
In an upcoming release, there should be something added similar to EPL. For example, when using the flow diagram, we can create a schema. We have two useful features to add or create the table, but there should be some UI features to allow us to drag and drop to create other schemas. This would be very helpful.
Ismail Yushaw - PeerSpot reviewer
Nov 29, 2023
The performance, stability, and security are areas with shortcomings in MySQL, where improvements are required.
reviewer1456815 - PeerSpot reviewer
Feb 25, 2021
I would like to have the ability to cancel a query in SQL Developer.
YT
Nov 13, 2021
Sometimes, not because the version is not the latest version, there are some issues with it. Sometimes there's an issue with the server which creates issues with it.
LM
Oct 12, 2020
In the next release, I would like to see the scalability features improved to allow you to configure it and reduce the complexity with the configuration, making it easier for the end-user to scale. Make it as simple as it can be.