TrustRadius: an HG Insights company

MySQL Professional, Scientific, and Technical Services Reviews & Insights

Score8 out of 10

972 Reviews and Ratings

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.

MySQL Reviews

33 Reviews
Professional, Scientific, and Technical ServicesAccounting1Information Technology & Services25Marketing & Advertising3Research1Computer & Network Security3

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

MySQL

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

I am using MySQL in various business applications (line of business internal) which aim for high availability and performance. MySQL workbench is also being used to organize the onsite and offsite backups of all my databases. There are actually two apps: One app for managing internal corporate item inventory and another application for serving as an internal knowledge base. Both these apps use MySQL as backend.

Pros

  • High availability
  • Performance
  • Security

Cons

  • Better support for Windows operating systems
  • Redesign in some areas of the MySQL workbench
  • More options for containerization and cloud deployment

Likelihood to Recommend

Small footprint line of business apps with performance being the primary goal is the ideal scenario for running MySQL 8 in a corporate environment. It is well suited even for junior developers because it has a fairly simple learning curve and can be deployed into any environment regardless of the operating system or virtualization technology being used.
Vetted Review
MySQL
5 years of experience

Reliable and easy to use database

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

It is solving the problem of efficient processing of a decent amount of data sets. Before that, all data was stored in an Excel sheet, which was difficult to manage, and the configuration system froze during processing. However, with the advent of RDBMS, it solves a very critical problem for us.

Pros

  • It is extremely easy to use.
  • It offers host based verification and password encryption which makes it very secure
  • It assures 24/7 uptime which is great relief for us

Cons

  • It lacks container types and arrays
  • It is prone to DDos attacks that slows down and possibly crashes the database
  • It is not built to tackle complex queries and huge datasets

Likelihood to Recommend

If you are looking for a database management system which is easy to use then MySQL should be the number one choice without a doubt, however, if you are looking a platform to handle large datasets and complex queries then you might have to give it a thought.
Vetted Review
MySQL
2 years of experience

MySQL - One of the best RDBMS solutions available

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

We have deployed in house MySQL cluster for our fintech application where transaction flow is around 100 read and write transactions per minute. Cluster comprises of "Master Master and Slave" structure. Masters were used to Write and Read transactions and read only slave is usually used for data dumps. Also we have a Proxy in place to load balance between DB servers.

Pros

  • Replication between instances is very spontaneous
  • Free and easy to install.
  • DB backup and restoration is easy.
  • excellent community support.

Cons

  • Tends to be getting Slow with large databases.
  • Unhelpful error messages.

Likelihood to Recommend

Scenarios where I wouldn't recommend MySQL:
*) If you have huge databases, in that case MySQL tends to get slow.

Scenarios where I would recommend MySQL:
*) If you have a medium size DB.
*) Need cost effective RDBMS solution
Vetted Review
MySQL
7 years of experience

MySQL as the Go-To Database

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

I use MySQL as a storage database in the context of machine log parsing and analysis. We have integrations between MySQL and our SIEM tool that allows us to store data in MySQL, but also access via our SIEM software for further in depth analysis. We store data across data of tables in MySQL for efficient organization and quick access.

Pros

  • Easy integration with a wide variety of software tools
  • Ease of scalability as our capacity increases
  • Very fast and efficient searching

Cons

  • Could use enhancements to the debug tools
  • Not as efficient at very large database sizes
  • Not always as stable as I would prefer

Likelihood to Recommend

The primary scenario I would not recommend MySQL is in the case of very large databases. It is commonly known that performance is lacking in this regard. Though it is well suited to those databases in the small to medium range. I would highly recommend MySQL when integrating with other software tools. Many tools, such as Tableau, have connectors that are ready to run and hook into your MySQL database. This makes accessing the data a breeze and is very helpful when integrating with other tools.

Amazing Features Of MySQL

Rating: 7 out of 10
Incentivized

Use Cases and Deployment Scope

Due to its friendly user ineterface and extensilbility with upgraded new features, we as full stack developers perfer to user it for storing and reterving our data. The main problem that it has fixed for us will be its feature of supporting large databases. Also, due to the client and utiliy programs that Mysql offers it is one of the best choices for our business needs.

Pros

  • Data storage
  • Integration
  • Scalibility

Cons

  • Error Messages
  • Query Optimization
  • Version Errors

Likelihood to Recommend

It has some great features for storing large sets of rows so it is well recommended for storing large chunks of data. As for the less suited, it may be a bit of a hassle while trying to optimise the queries for trying to achieve better performance of the retrieval of data.

A strong and secure system for your data

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

Data redundancy is controlled and duplicate data is eliminated, weaknesses between the data are reduced, a process of extracting additional information from the data can be carried out, the data is shared safely, they offer you good maintenance of standards, security is strong against access by unauthorized users, access codes are assigned that will provide security to your data and your team.

Pros

  • It is pleasing to see the visible improvement f in data accessibility since the query language is applied.
  • It is like a huge repository where we get to store huge sets of information or data.

Cons

  • Although you can add the data you require as more and more data is added, the fixity of it becomes more critical.
  • As the demand, size, and use of the system increase, you may also need to change or acquire more equipment on your servers, although this is an internal inconvenience for the company.

Likelihood to Recommend

We have obtained greater speed to perform tasks specifically related to the manipulation of information. It is convenient to remotely access company, product, and business data. Purging logs is extremely easy. Failover services are optimized thanks to backups. You just have to start running the backup, and you can move that copy with your data to other servers.

Low Footprint High value

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

Many of our applications are built on MySQL DB with different application layer platforms such as PHP web applications and java desktop applications. with stable backend relational data management options, MySQL gives robust and flexible database infrastructure to proceed with dynamic application requirements. also, MySQL's native capabilities are helpful to reduce complexity of operations.

Pros

  • DB optimizations
  • Database CRUD accuracy
  • High stability

Cons

  • More flexible replication options
  • Automated query optimizations
  • More DB engines

Likelihood to Recommend

MySQL provided very stable data base management platform to our applications with flexible management features. Also MySQL is very low footprint platform with easy database handling. when comparing with some other DBMSs, MySQL proved high storage efficiency and saving of storage space with large data sets and applications. suggest to have more native tools for replication eco systems with different locations.
Vetted Review
MySQL
11 years of experience