TrustRadius: an HG Insights company
MySQL Logo

MySQL Reviews and Ratings

Rating: 8.1 out of 10
Score
8.1 out of 10

Community insights

TrustRadius Insights for MySQL are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Ease of Use: Users have found MySQL easy to get started with, lightweight, scalable, and well-supported. They appreciate its quick processing speed and flexibility in handling various tasks efficiently. The open-source licensing adds to its appeal by offering a cost-effective solution for diverse database needs.

Reliability: Reviewers acknowledge the proven reliability of MySQL over time, providing a stable foundation for their data management needs. The consistent updates and enhancements contribute to its reputation for dependability. Users trust MySQL for critical operations due to its track record of performance and stability.

Support and Resources: Customers value the accessible technical support provided for MySQL, along with the abundance of online resources available. The cost-effectiveness of using MySQL is also highlighted as a significant advantage by users. With widespread knowledge about MySQL across communities, users can easily find solutions and guidance when needed.

Reviews

146 Reviews

MySQL Shines In The Right Situations

Rating: 9 out of 10
Incentivized

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

<div>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.</div><div>

</div><div>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.</div>

Vetted Review
MySQL
15 years of experience

Exactly what I expected from a SQL database

Rating: 9 out of 10
Incentivized

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.

Vetted Review
MySQL
6 years of experience

The RDBMS you are searching for

Rating: 9 out of 10
Incentivized

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

Vetted Review
MySQL
5 years of experience

Sure its been around forever but its still that good.

Rating: 10 out of 10
Incentivized

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.

Vetted Review
MySQL
10 years of experience

MySQL is our reliable database choice.

Rating: 8 out of 10
Incentivized

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.

Vetted Review
MySQL
4 years of experience

Data consistency with MySQL

Rating: 8 out of 10
Incentivized

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.

Vetted Review
MySQL
22 years of experience

MySQL Database Review

Rating: 9 out of 10
Incentivized

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.

MySQL database for Modern Enterprise Applications

Rating: 5 out of 10
Incentivized

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.

Best database in open-source

Rating: 8 out of 10
Incentivized

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.

Vetted Review
MySQL
7 years of experience

MySQL for Database Management

Rating: 8 out of 10
Incentivized

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.

Vetted Review
MySQL
7 years of experience