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

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 highly valued for its open-source nature, allowing extensive community support and rapid development.
It is recognized for its stability and reliability, having been a mature database solution for many years.
MySQL provides strong performance and scalability, making it suitable for various scales of projects and enterprises.
Users appreciate its ease of use for setup, deployment, and management, which can be critical for projects with tight deadlines.
MySQL is praised for being cost-effective, often highlighted by its free access and robust features without additional expenses.

CONS

MySQL is not easily scalable on cost-effective consumer-grade hardware.
Documentation is often complex and insufficient for users without database experience.
There are frequent performance issues, especially with large data sets and complex queries.
Integration, security features, and monitoring tools need significant improvement.
Scalability and enhancement of high availability and replication features are necessary.
 

MySQL Pros review quotes

it_user793887 - PeerSpot reviewer
Works at Micro Focus
Dec 26, 2017
I use MySQL for employee service in an OLTP database.
it_user578346 - PeerSpot reviewer
Head of Business Technology at a tech services company with 501-1,000 employees
Jan 2, 2018
A lot of the software components have been trialed and tested for often more than 10 years.
AM
Senior Web Manager at a university with 501-1,000 employees
Jan 3, 2018
Support for enterprise-grade features like clustering, master-slave replication, even Sharding (to some extent) which is an advanced feature.
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
881,733 professionals have used our research since 2012.
it_user755235 - PeerSpot reviewer
Director at RC Ghosh Group of Companies
Jan 10, 2018
​The most valuable feature of MySQL is the informative error outputs of command line interface.​
MU
Co-Founder at Mero Reading Room
Oct 7, 2018
It creates a unified view of the entire architecture and performance factor, helping to manage the network more easily.
JohnMitchell - PeerSpot reviewer
jmitchell@natbankmw.com at NBM
Feb 10, 2020
The solution is very simple. It's easy to use. That's the most important feature.
it_user1282806 - PeerSpot reviewer
Infrastructure Platform Engineer at a cloud solution provider with 51-200 employees
Feb 13, 2020
The solution is free to use, which is its most valuable aspect.
Patryk Golabek - PeerSpot reviewer
CTO at Translucent Computing Inc
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.
reviewer1301145 - PeerSpot reviewer
CEO at a computer software company with 11-50 employees
Mar 19, 2020
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.
reviewer1139685 - PeerSpot reviewer
Business Intelligence Manager at a translation and localization position with 501-1,000 employees
Mar 23, 2020
The initial setup was pretty straightforward. I would have worked with our IT team in terms of the initial setup.
 

MySQL Cons review quotes

it_user793887 - PeerSpot reviewer
Works at Micro Focus
Dec 26, 2017
When working with a cluster wide, I have to use the MySQL cluster version.
it_user578346 - PeerSpot reviewer
Head of Business Technology at a tech services company with 501-1,000 employees
Jan 2, 2018
It does not stand out regarding scalability. When the company size increases, the user base having actual experience with (very) large MySQL solutions is reduced.
AM
Senior Web Manager at a university with 501-1,000 employees
Jan 3, 2018
It would be helpful if there were a graphical user interface to administer, configure, and tune it.
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
881,733 professionals have used our research since 2012.
it_user755235 - PeerSpot reviewer
Director at RC Ghosh Group of Companies
Jan 10, 2018
​MySQL needs improvements on its diagnostic features.​
MU
Co-Founder at Mero Reading Room
Oct 7, 2018
The only service which could be improved is its usability. The entire user experience needs to be revamped to meet the 2018 design standards.
JohnMitchell - PeerSpot reviewer
jmitchell@natbankmw.com at NBM
Feb 10, 2020
The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB.
it_user1282806 - PeerSpot reviewer
Infrastructure Platform Engineer at a cloud solution provider with 51-200 employees
Feb 13, 2020
From a user perspective, the initial setup could be simplified a bit.
Patryk Golabek - PeerSpot reviewer
CTO at Translucent Computing Inc
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.
reviewer1301145 - PeerSpot reviewer
CEO at a computer software company with 11-50 employees
Mar 19, 2020
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.
reviewer1139685 - PeerSpot reviewer
Business Intelligence Manager at a translation and localization position with 501-1,000 employees
Mar 23, 2020
I find the Microsoft solution a bit better. But mostly in terms of the UI layout, I would say. I just find it a little bit more efficient.