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 a stable, reliable choice for small to medium businesses, popular for being open-source with no licensing costs. It offers excellent performance with lightweight design, high scalability, and strong clustering. However, it struggles with large table operations and performance under heavy load. Scalability and high availability are concerns, especially compared to competitors. Documentation, community support, and security need improvement to aid efficient troubleshooting and ensure safe data handling.

Buyer's Guide

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

Prominent pros & cons

PROS

MySQL is a stable and reliable choice, popular for small to medium-sized businesses due to its open-source nature and absence of licensing costs.

It offers excellent performance with a lightweight design that is easy to install, configure, and use.

MySQL provides high scalability and strong clustering features, supporting growth for various organizational needs.

The remote access and replication capabilities enhance collaboration and data management across different locations.

MySQL's rich feature set, including strong security and cross-platform compatibility, makes it a versatile tool for developers and businesses alike.

CONS

MySQL struggles with large table operations and performance issues under heavy load, often seen in complex queries.

Scalability is a major concern, as MySQL is less scalable compared to competitors like Oracle and SQL Server, especially with large databases and high concurrency requirements.

High availability and replication features are lacking, making it less reliable for enterprise-level applications where consistent uptime and data distribution are critical.

Documentation and community support are weak and need significant improvement to help users troubleshoot more efficiently.

Security features and integration capabilities with other systems need enhancement to ensure safe data handling and seamless connectivity across different platforms.

MySQL Pros review quotes

Senior Software Developer at NIT

Jun 21, 2026

MySQL is a great tool for using in data-consistent applications; it is a highly mature, reliable, and practical database, and its consistency, ecosystem, and proven track record make it an excellent choice for transactional and business-critical applications.

Read full review

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

Free Report: MySQL Reviews and More

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

902,894 professionals have used our research since 2012.

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

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

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

Senior Software Developer at NIT

Jun 21, 2026

Regarding MySQL improvements, a pain point is horizontal scalability.

Read full review

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

Free Report: MySQL Reviews and More

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

902,894 professionals have used our research since 2012.

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

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

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

InfluxDB vs MySQL

ClickHouse vs MySQL

MariaDB 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

InfluxDB vs MySQL

ClickHouse vs MySQL

MariaDB vs MySQL

IBM Db2 Database vs MySQL

Qdrant vs MySQL

Milvus vs MySQL

OpenSearch vs MySQL

CockroachDB vs MySQL

See all alternatives

Related questions

131

Which solution do you recommend for embedding reporting? Why?

189

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

153

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

186

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

164

What is one thing you would improve with MySQL?

129

How does MySQL compare with Firebird SQL?

195

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

175

Why is Open Source Databases important for companies?

189

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

280

Which database is the best for session cashing?