MySQL serves as a foundational relational database management system across various organizations, primarily for structured data, web services, and critical business operations like transaction processing and auditing. In TrustRadius reviews, users widely adopt it to support proprietary CRM, Confluence, Jira, and Java-based applications. Reviewers frequently commend its ease of use, straightforward setup, and robust performance, especially for read-heavy operations, alongside its cost-effectiveness due to its open-source nature.

Beyond its core strengths, reviewers also value its active user community and ACID compliance with the InnoDB engine, ensuring data integrity. However, some limitations are noted, including challenges with advanced SQL features and scalability for very large or complex applications. Performance issues with intricate joins and high resource utilization are also reported by some, suggesting careful consideration for highly demanding analytical or horizontally scaled scenarios. Overall, MySQL is seen as a reliable and accessible database solution, particularly beneficial for cost-conscious environments.

Pros

Ease of setup and user-friendly interface for querying and implementation
Strong performance for read-heavy operations and large data volumes, aided by B-tree indexing
Cost-effectiveness due to its open-source nature and low licensing costs
Robust community support and flexibility for code modification
ACID compliance when utilizing the InnoDB storage engine for data integrity

Cons

Limited support for advanced SQL features, hindering complex reporting
Challenges with horizontal scalability for massive databases and complex applications
Potential for slow performance with complex joins and full table scans
High resource utilization (CPU, memory) leading to slower application performance
Weak JSON and NoSQL capabilities compared to specialized solutions

What other products like MySQL have you used or evaluated?

From 7 reviews | Last Published May 27, 2026

Summary

Reviewers frequently cited other database technologies they have used or evaluated alongside MySQL. Microsoft SQL Server and MongoDB were both mentioned by 3 of 7 reviewers, indicating their common presence in similar technology stacks or evaluation processes. These mentions suggest a landscape where users often compare or integrate various database solutions depending on their specific needs. Oracle Database was also noted by 2 of 7 reviewers, further highlighting the diversity of database systems considered by users. The consistent appearance of these alternatives points to a common practice of evaluating multiple options, often including both relational and NoSQL databases, to find the best fit for particular applications or organizational requirements. This reflects a broad consideration of database types, from traditional relational systems like SQL Server and Oracle to more flexible NoSQL options such as MongoDB, in the decision-making process for data management solutions.

Top Quotes

Microsoft SQL Server

“Microsoft SQL Server”

Oracle Database

“Oracle Database and Microsoft SQL Server”

MongoDB

“SQLite, MariaDB Platform and MongoDB”

What positive or negative impact (i.e. Return on Investment or ROI) has MySQL had on your overall business objectives?

From 7 reviews | Last Published May 27, 2026

Summary

MySQL significantly contributes to business objectives primarily through its cost efficiency, which is highlighted by six of seven reviewers. Its open-source nature and freeware availability are consistently cited as key drivers for reducing IT expenditure and offering a lower cost compared to alternative database solutions. Beyond cost, reviewers also report positive impacts related to ease of use, with three reviewers noting its straightforward setup and administration, contributing to operational efficiency. The reliability of MySQL, particularly its ACID compliance for data integrity, is also a positive factor for two reviewers, ensuring robust management of structured data. However, the product's return on investment is not universally positive, with two reviewers raising concerns about scalability limitations, particularly for growing systems with increasing data sets and concurrent users, suggesting a potential negative ROI in such scenarios. Additionally, two reviewers offer a mixed perspective on the community version, acknowledging its benefits but also pointing out potential issues when dedicated support is lacking, though the enterprise version is seen as a way to address this.

Top Quotes

Cost Efficiency

“cost is low compare to other data base software.”

Scalability Limitations

“Medium to High Negative ROI (for growing systems) for scaling limitations”

Ease of Use

“Easy to setup in on prem or in cloud”

Besides MySQL, what other software do you regularly use? How likely would you be to recommend it to a friend or colleague?

From 7 reviews | Last Published May 27, 2026

Summary

Reviewers frequently report using a range of other software tools in conjunction with MySQL, indicating diverse technology stacks and operational needs. MongoDB emerged as the most frequently mentioned alternative, cited by 4 of 7 reviewers. Other notable database systems regularly employed include Oracle Database, mentioned by 3 reviewers, and both Microsoft SQL Server and PostgreSQL, each noted by 2 reviewers. Additionally, Atlassian Jira, a project management tool, was also mentioned by 2 of 7 respondents. While these tools are consistently used by the reviewers, the provided data does not contain explicit statements regarding the likelihood of recommending them to a friend or colleague. Consequently, the sentiment for each of these tools is classified as mixed, reflecting their reported usage without specific positive or negative endorsements within the available quotes.

Top Quotes

MongoDB Usage

“MongoDB”

Oracle Database Usage

“Oracle Database”

Microsoft SQL Server Usage

“Microsoft SQL Server”

Describe how you use MySQL in your organization. What are the business problems the product addresses and what is the scope of your use case?

From 7 reviews | Last Published May 27, 2026

Summary

MySQL is widely adopted across organizations primarily as a core relational database management system for diverse applications. All 7 reviewers highlighted its fundamental role in data storage and management, emphasizing its utility for structured data, web services, and critical business operations such as transaction and account data handling, KYC verification, and auditing trails. Reviewers frequently noted its application in supporting proprietary CRM software, Confluence, Jira, and other Java-based systems. Beyond its primary function, 4 of 7 reviewers also commended MySQL for its ease of use and setup, performance and scalability, and cost-effectiveness due to its open-source nature. These attributes collectively position MySQL as a robust and accessible solution for managing essential organizational data.

Top Quotes

Data Storage and Management

“We use MySQL mostly for relational data base system for our core data base related work. It work as a tool for storing structured data and many web services dependency on MySQL for retrieval and storage.”

Ease of Use and Setup

“For web application MySQL database had been preferred choice in the past which provides both open source and licensed feature. Among other reason MySQL DB is easy to setup , simpler feature set, fewer advanced features, but lightweight, stable, and fast for read-heavy workloads.”

Performance and Scalability

“MySQL DB is easy to setup , simpler feature set, fewer advanced features, but lightweight, stable, and fast for read-heavy workloads.”

Please provide some detailed examples of areas where MySQL has room for improvement.

From 7 reviews | Last Published May 27, 2026

Summary

Reviewers identified several key areas where MySQL presents opportunities for improvement, primarily concerning its advanced capabilities and operational demands. A notable concern, raised by 3 of 7 reviewers, is the database's limited support for advanced SQL features, which can hinder complex reporting and analytical queries. Similarly, 3 of 7 reviewers pointed to challenges with scalability, particularly when attempting to horizontally scale massive databases or achieve high scalability for intricate applications. Beyond these core functional limitations, 2 of 7 reviewers expressed concerns about MySQL's performance, noting it can be slow with complex joins and full table scans, making it less suitable for certain OLTP and analytics workloads. This performance issue is sometimes linked to high resource utilization, as 2 of 7 reviewers mentioned that MySQL can demand significant processing power, memory, and storage, potentially leading to slower application performance and out-of-memory errors for memory-intensive searches. Additionally, 2 of 7 reviewers highlighted weak JSON and NoSQL capabilities, suggesting limitations for applications requiring flexible document storage.

Top Quotes

Advanced SQL Features

“For complex reporting or analytical queries it has limited advanced SQL features.”

Scalability

“partitioning challenges for horizontally scaling a massive database”

JSON Capabilities

“Weak JSON and NoSQL capabilities for applications that require flexible document storage.”

Please provide some detailed examples of things that MySQL does particularly well.

From 7 reviews | Last Published May 27, 2026

Summary

MySQL is widely regarded by reviewers as a highly accessible and efficient database solution, particularly excelling in ease of use and performance. All 7 reviewers cited its straightforward setup and user-friendly interface, making it easy to learn, query, and implement within applications. This accessibility is complemented by strong performance capabilities, highlighted by 5 of 7 reviewers, who noted its effectiveness in handling read-heavy operations and large data volumes, often attributed to its B-tree indexing. Beyond technical merits, MySQL's open-source nature and low licensing costs were appreciated by 3 of 7 reviewers, who valued its affordability for development and testing, and the flexibility to modify its code. Furthermore, a substantial and active user community, mentioned by 3 of 7 reviewers, provides robust support. For critical transactional systems, 2 of 7 reviewers specifically lauded MySQL's full ACID compliance when utilizing the InnoDB storage engine, underscoring its reliability for maintaining data integrity.

Top Quotes

Ease of Use and Setup

“MySQL usability is easier compare to other database.”

Performance and Speed

“Performance of SQL read operations”

Cost and Licensing

“Very low license cost”

View All Reviews

MySQL Reviews

146 Reviews

MySQL Shines In The Right Situations

Rating: 9 out of 10

Incentivized

October 31, 2025

Use Cases and Deployment Scope

We use MySQL to run the database back end of our company websites and a handful of OLTP applications. It provides a lightweight relational database system that is easy to manage and low in cost. Because we use the free version, support can be iffy, but, generally, it just runs without issue.

Pros

Read heavy operations
Simple setup
Cross-platform support
Large community
Cloud integration

Cons

Write heavy workloads
Horizontal scalability
Analytic workloads
Lack of advanced features

Likelihood to Recommend

High read/low write applications such as websites is where MySQL's ease of setup and general usage really shine. It is open source and coupled with it's cross-platform availability allowing it to run on Linux makes for an extremely low-cost RDBMS solution.

Larger companies with higher budgets may want to look at more enterprise level solutions (SQL Server, Oracle, etc...) for larger OLTP and OLAP workloads for their scalability and support.

Verified User

Strategist in Information Technology (1001-5000 employees)

Vetted Review

15 years of experience

Exactly what I expected from a SQL database

Rating: 9 out of 10

Incentivized

October 27, 2025

Use Cases and Deployment Scope

Our proprietary CRM software uses MySQL as one of the databases. Its relational capabilities allow us to maintain data coherently even on a large scale, and making it possible to create the complex representation that is a customer and all the relative data about addresses, billing, preferences and so on.

Pros

Connect several data through relations
Keep data coherent with constraint
Fast searches through indexes

Cons

Error debug: it's hard to track down problems with deadlocks or timeouts
Parameters: it's not always easy to understand what values should database parameters have
Storage and memory: indexes occupy a lot of data, and some searches require the DB to have a lot of memory to prevent out of memory errors

Likelihood to Recommend

Applications requiring persistent data that need to be related to other data are a perfect use cases for MySQL. On the other hand, when the amount of data is really high, and the "relation" or connected data is not always the same, or when the relations are not so strict, then other databases would be better suited.

Verified User

Employee in Research & Development (51-200 employees)

Vetted Review

6 years of experience

The RDBMS you are searching for

Rating: 9 out of 10

Incentivized

October 27, 2025

Use Cases and Deployment Scope

MYSQL is used as a backend database for multiple inhouse products . Its used to store data ranging from 5 G to 2TB in multiple environments such as DEV ,QA and staging . It can easily handle any amount of data and processes it very fast . We also use to test some security related items .

Pros

Ease of Setup
Minimal Administration
Query Execution is decent
Can handle large data sets

Cons

Concurrency Control
Parelle execution capabilities are limited

Likelihood to Recommend

It can be used for applications were the number of concurrent users are less or there is separation of schemas so that there is no database contention. It can handle large datasets but how big it can be , is a question mark , there were scenarios this can be less suited for Analytical workloads

Verified User

Employee in Information Technology (5001-10,000 employees)

Vetted Review

5 years of experience

Sure its been around forever but its still that good.

Rating: 10 out of 10

Incentivized

October 27, 2025

Use Cases and Deployment Scope

I use MySQL to manage our customer data within our applications. This also allows me to easily query this data to check usage, spot trends, and confirm client issues when they contact us. Since it's ubiquitous within the SaaS realm, it's easy to find tools that can visualize MySQL data.

Pros

Easy to query
Easy to maintain
Easy to implement within applications

Cons

It's not easy for novices
DB locks are a pain

Likelihood to Recommend

It's great for querying large amounts of data. If you're running a very basic application, it might not be the best option.

Verified User

Manager in Information Technology (51-200 employees)

Vetted Review

10 years of experience

MySQL is our reliable database choice.

Rating: 8 out of 10

Incentivized

October 13, 2025

Use Cases and Deployment Scope

MySQL is important to critical aspect of my organizations software product experience. It helps us with transaction management, account data management , know your customer verification documentations and auditing trails etc
Overall, MySQLas our RDBMS of choice for key applications goes beyond merely being a backend infrastructure tool, it helps shape a trustworthy and reliable experience for users of our products.

Pros

Strong Query performance as a result of its B-tree indexing capabilities.
MySQL functions with minimal maintenance
Large and active user community.
Proven ACID ( atomicity, consistency , isolation , durability ) compliance.

Cons

Limited JSON capabilities.
Basic text search capability.
Slow with complex joins and full table scans.

Likelihood to Recommend

MySQL performs well with applications that require security of data which is critical for a finance organization like mine. For example, a core part of our backend infrastructure is built on MySQL, because of its strong ACID ( atomicity, consistency , isolation and durability ) compliance . Its InnoDB engine ensures that user initiated actions on our applications either finish or do not happen at all and this is very important for a platform like ours where people initiate financial transactions.
For scenarios where MySQL is not appropriate, I wouldn't recommend it for analytics-heavy applications or tasks because these require full table scans, which is not a strong part of MySQL and usually will lead to a halt of other concurrent workloads.

Verified User

Engineer in Research & Development (501-1000 employees)

Vetted Review

4 years of experience

Data consistency with MySQL

Rating: 9 out of 10

Incentivized

September 16, 2025

Use Cases and Deployment Scope

I use MySQL as a core relational database management system to support a variety of business-critical applications. We leverage MySQL for both internal and customer-facing systems, including web applications, reporting dashboards, content management systems, and data pipelines. Its reliability, performance, and open-source nature make it a strong fit for many of our workloads.

Pros

Scalability
Data consistency
Reporting
Rapid development

Cons

Intégration with AI

Likelihood to Recommend

Dynamic web site.

Verified User

Consultant in Information Technology (10,001+ employees)

Vetted Review

22 years of experience

MySQL Database Review

Rating: 9 out of 10

Incentivized

June 12, 2025

Use Cases and Deployment Scope

We use MySQL mostly for relational data base system for our core data base related work. It work as a tool for storing structured data and many web services dependency on MySQL for retrieval and storage.Business problems we solve using MySQL includes data management and reporting ,Data warehousing and analytics.

Pros

MySQL usability is easier compare to other database.
MySQL supports many SQL features to handle light analytical workloads.
MySQL with the InnoDB storage provides full ACID compliance which is suitable for transactional systems where data integrity is critical.

Cons

For complex reporting or analytical queries it has limited advanced SQL features.
Weak JSON and NoSQL capabilities for applications that require flexible document storage.
partitioning challenges for horizontally scaling a massive database

Likelihood to Recommend

MySQL is best suited for applications on platform like high-traffic content-driven websites, small-scale web apps, data warehouses which regards light analytical workloads. However its less suited for areas like enterprise data warehouse, OLAP cubes, large-scale reporting, applications requiring flexible or semi-structured data like event logging systems, product configurations, dynamic forms.

Manidipa Kundu

Data Analyst in Quality Assurance at Gfactors (11-50 employees)

Vetted Review

3 years of experience

View profile

MySQL database for Modern Enterprise Applications

Rating: 5 out of 10

Incentivized

May 26, 2025

Use Cases and Deployment Scope

For a customer onboarding web application, we have used MySQL database. For web application MySQL database had been preferred choice in the past which provides both open source and licensed feature. Among other reason MySQL DB is easy to setup , simpler feature set, fewer advanced features, but lightweight, stable, and fast for read-heavy workloads.

Pros

Performance of SQL read operations
Easy of setup
Open source
Very low license cost

Cons

Scalability options
Backup and Recovery options
Limited extensibility, fewer user-defined functions and plugins
Enterprise grade High Availability feature

Likelihood to Recommend

MySQL Database has been well suited for our web based application used for customer onboarding. It efficiently handles data storage, retrieval, and management of customer onboarding. So good for lightweight application, with moderate for performance requirement and cost efficient solution.

MySQL database cannot be the replacement of large scale enterprise database. Oracle database, MSSQL or Postgres would be go to option. Another reason could be MySQL does not support many modern extensions/features like NoSQL support, JSON data type, limited support for modern and complex SQL query features.

Sharang Dwivedi

Database Engineer in Information Technology at Infosys Ltd. (10,001+ employees)

Vetted Review

5 years of experience

View profile

Best database in open-source

Rating: 8 out of 10

Incentivized

May 23, 2025

Use Cases and Deployment Scope

We use the MySQL database for applications like Confluence, Jira, and a few other Java-based applications. As it is Open source, we have also been using it for application development and testing purposes.
MySQL is a very lightweight database, which makes it faster and easier to manage and our applications run smoothly on the MySQL database.

Pros

As its open source, we can modify the code as per our need.
For developing and testing purposes, we can extensively use it without thinking about cost as its free to download
As it's lightweight, we don't have to worry much about resources like CPU, memory, etc.

Cons

As it's open source, there is a lack of support when it's required.
Its good for small scale applications, but for large scale operation, there still needs some improvements in feature and performance.
MySQL is not very suitable for OLTP and analytics-based applications.

Likelihood to Recommend

In my experience, the MySQL database is well-suited for the development and testing of small-scale applications. The database is easy to configure and doesn't require much maintenance, so it can be handled by a few DBA resources.
However, I think MySQL is not suitable for large datasets and OLTP because of scalability challenges.

Verified User

Professional in Information Technology (1001-5000 employees)

Vetted Review

7 years of experience

MySQL for Database Management

Rating: 8 out of 10

Incentivized

May 19, 2025

Use Cases and Deployment Scope

MySQL is being used for a few projects in our organization for storing master data used in the applications. MySQL is easy to learn and use for delivering high performance and also supports scalability based on the requirements.
We are using MySQL in all the environments including Development and Production environments. It is cost effective to use MySQL as it is open source product.

Pros

High performance is achieved even with large volumes of data
It is easy to learn and use
Data security
Good support for scalability, making it go to product for large and complex applications

Cons

MySQL requires high processing power, memory and storage which can make applications slow due to high resource utilization
Achieving scalability can be challenging for complex applications
Limited support for advanced SQL features

Likelihood to Recommend

MySQL is ideal for small to mid-size organizations where data volumes are not too high. Being an open source product, it can help to save cost associated with acquiring licensed products. It is not recommended for large organizations as managing large volumes of data using MySQL will not be easy and large volumes of storage, memory and processing will be required with increase in data volumes.

Verified User

Employee in Information Technology (5001-10,000 employees)

Vetted Review

7 years of experience