No more typing reviews! Try our Samantha, our new voice AI agent.

MySQL pros and cons

Vendor: Oracle

4.1 out of 5

152 reviews
91% willing to recommend

Pros & Cons summary

MySQL is highly valued for its open-source nature, offering extensive community support, stability, and reliability. It provides strong performance and scalability suitable for various projects. Users appreciate its ease of use and cost-effectiveness. However, it faces challenges with scalability on consumer-grade hardware and has complex documentation. Performance issues with large datasets, integration, security features, and monitoring tools require improvement, along with enhancements in high availability and replication features.

Buyer's Guide

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

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

Prabir Kumar Kundu

SR AVP–Presales Cloud & Platform Management Services at Path Infotech ltd

Aug 21, 2025

MySQL has helped my customers' database management by providing better RTO and RPO; the RPO can be less, RTO can be less, using this replication software, which is an inbuilt feature of the database itself, and you don't have to purchase an additional license for the replication.

Read full review

reviewer2599590

Student at a university with 10,001+ employees

Dec 9, 2025

MySQL is a very useful database which is used by a lot of companies, so it should be really good.

Read full review

Muzzamil Hussain

Assistant Vice President at National Bank of Pakistan

Jan 20, 2025

The most valuable feature is the on-premises data encryption facilities.

Read full review

Free Report: MySQL Reviews and More

Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.

893,244 professionals have used our research since 2012.

Founder & Director at Hiindsight Group

Jul 18, 2024

It is a stable solution.

Read full review

Data Engineer | Developer at Team Computers

Jul 29, 2024

I find MySQL's relational data storage format very useful for data management. Our structure is well-defined and easy for end users and business stakeholders to read. I appreciate the tool's simplicity and ability to integrate with our backend tools.

Read full review

Software Engineer / Team Lead at Techfriar

Jul 30, 2024

MySQL is the best option for the Laravel PHP framework.

Read full review

Associate Cloud Engineer at Rishabh Software

Apr 1, 2024

MySQL gives us a very user-friendly workspace in which to query the database.

Read full review

RU

Ravi Upadhyayula

Senior Consultant at Tata Consultancy

Mar 11, 2024

While MySQL offers strong basic functionality.

Read full review

Shivaprasad C S

Programmer at Ministry of Interior

Mar 19, 2024

I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures.

Read full review

Lead Data Analyst at Ernst & Young

Mar 22, 2024

The initial setup is easy.

Read full review

Show 10 more reviews (out of 143)

MySQL Cons review quotes

Prabir Kumar Kundu

SR AVP–Presales Cloud & Platform Management Services at Path Infotech ltd

Aug 21, 2025

Documentation is definitely required when running multiple databases on a cluster system.

Read full review

reviewer2599590

Student at a university with 10,001+ employees

Dec 9, 2025

I do not think MySQL's data security features were at an industrial level for my project, so I did not make use of them.

Read full review

Muzzamil Hussain

Assistant Vice President at National Bank of Pakistan

Jan 20, 2025

The data masking functionality should be improved as well as the native encryption functionality in the MySQL database.

Read full review

Free Report: MySQL Reviews and More

Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.

893,244 professionals have used our research since 2012.

Founder & Director at Hiindsight Group

Jul 18, 2024

The performance issues in the product can be considered as an area where improvements are required.

Read full review

Data Engineer | Developer at Team Computers

Jul 29, 2024

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.

Read full review

Software Engineer / Team Lead at Techfriar

Jul 30, 2024

In MySQL, we need to define every table beforehand.

Read full review

Associate Cloud Engineer at Rishabh Software

Apr 1, 2024

We have encountered some performance issues, and the solution takes time for performing complex queries.

Read full review

RU

Ravi Upadhyayula

Senior Consultant at Tata Consultancy

Mar 11, 2024

MySQL lacks a feature akin to Oracle's Real Application Clusters, which ensures continuous database availability within the same data center or nearby data centers.

Read full review

Shivaprasad C S

Programmer at Ministry of Interior

Mar 19, 2024

MySQL's performance needs to be improved for enterprise-level applications compared to Oracle and Postgres.

Read full review

Lead Data Analyst at Ernst & Young

Mar 22, 2024

The user interface could be more user friendly. Mainly because most of the times we see black and white digital lines. Something like Python.

Read full review

Show 10 more reviews (out of 143)

Product Categories

Product Categories

Open Source Databases

Relational Databases Tools

Popular Comparisons

Popular Comparisons

Teradata vs MySQL

SQL Server vs MySQL

Oracle Database vs MySQL

PostgreSQL vs MySQL

MongoDB Enterprise Advanced vs MySQL

SAP HANA vs MySQL

Firebird SQL vs MySQL

MariaDB vs MySQL

ClickHouse vs MySQL

InfluxDB vs MySQL

IBM Db2 Database vs MySQL

Qdrant vs MySQL

Milvus vs MySQL

OpenSearch vs MySQL

CockroachDB vs MySQL

See all alternatives

Product Categories

Product Categories

Open Source Databases

Relational Databases Tools

Popular Comparisons

Popular Comparisons

Teradata vs MySQL

SQL Server vs MySQL

Oracle Database vs MySQL

PostgreSQL vs MySQL

MongoDB Enterprise Advanced vs MySQL

SAP HANA vs MySQL

Firebird SQL vs MySQL

MariaDB vs MySQL

ClickHouse vs MySQL

InfluxDB vs MySQL

IBM Db2 Database vs MySQL

Qdrant vs MySQL

Milvus vs MySQL

OpenSearch vs MySQL

CockroachDB vs MySQL

See all alternatives

Related questions

84

Which solution do you recommend for embedding reporting? Why?

141

Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?

97

Why are MySQL connections encrypted and what is the biggest benefit of this?

132

Considering that there is a free version of MySQL, would you invest in one of the paid editions?

117

What is one thing you would improve with MySQL?

94

How does MySQL compare with Firebird SQL?

136

When evaluating Open Source Databases, what aspect do you think is the most important to look for?

141

Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?

218

Which database is the best for session cashing?

119

Why is Open Source Databases important for companies?