TrustRadius: an HG Insights company

MySQL Information Reviews & Insights

Score8 out of 10

972 Reviews and Ratings

Get a Demo

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

51 Reviews
InformationComputer Software24Computer Networking1Internet13Telecommunications5Information Services5Online Media1Music1Media Production1

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.
MK
Manidipa Kundu
Data Analyst in Quality Assurance at Gfactors (Information Services, 11-50 employees)
Vetted Review
MySQL
3 years of experience
View profile

Useful data storage management system

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

Effectively MySQL is an electronic filing cabinet for data management. It organizes data in the same way one would in a filing cabinet. It is very useful and easy to use. We find it useful for accessing information such as past documents.

Pros

  • Stores documents in an ordered way
  • Allows for quick access
  • Stable system

Likelihood to Recommend

Our business requires keeping clearance records such as stock footage and music licenses, clearances and contracts with individuals, payments and contact information etc. It is called a production bible that can be referenced. An example is years after we completed work we will get a call asking where we got a photo and can it be used for another purpose.
VU
Verified User
Consultant in Corporate (Media Production company, 11-50 employees)
Vetted Review
MySQL
5 years of experience

Open source RDBMS that meets everyones needs.

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

We are a service-based company so we have multiple projects running simultaneously and many times the projects can be of different domains as well. We needed a system that could be used for multiple domains easily so that our teams do not have to learn a new technology every time they work on a new project and also be cost-effective. when choosing the DBMS system we opted for MySQL as it is lite weight, efficient, and open source. Thus reducing the cost as well as increasing our productivity.

Pros

  • We use MySQL in the development of our Client specific E-COmmerce website, as it is an efficient and easy-to-manage System with a lot of features.
  • Backup and restore functions are really good so if anything goes wrong on client-server it is easy to restore our data.

Cons

  • A major drawback of MySQL is it cannot be used on large database sizes and slows down in such cases.

Likelihood to Recommend

MySQL is best when used for client-specific projects with medium size databases. Whereas if the data is going to be extensive Mysql is not as suited as compared to MSSQL or Postgre.
VU
Verified User
Team Lead in Information Technology (Information Services company, 11-50 employees)
Vetted Review
MySQL
3 years of experience

A robust and reliable relational database solution - MySql

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

MySQL is a relational database solution. It is being used as a durable backend database for almost all of our internal applications. Every PROD grade application requires a robust database, which is highly available and robust. MySQL has all of those features and is proven one of the best in the industry. Nowadays, new database solutions are available that store data in JSON, key-value format. MySql stores data in a tabular format which is one of the best ways to store information. It also increases the read speed exponentially if stored in a tabular form, just like MySQL.

Pros

  • Security: is embedded at each level in MySQL. Authentication mechanisms are in place for configuring user access and even service account access to applications. MySQL is secure enough under the hood to store your sensitive information. Also, additional plugins are available that sit on top of MySQL for even tighter security.
  • Widely adopted: MySQL is used across the industry and is trusted the most. Therefore, if you face any problems, simply Google it and you shall land in plenty of forums. This is a great relief as when you are in a need of help, you can find it right in your browser.
  • Lightweight application: MySQL is not a heavy application. However, the data you store in the database can get heavy with time, but as in the configuration and MySql application files, those are not very heavy and can easily be installed on legacy systems as well.

Cons

  • Learning curve: is big. Newbies will face problems in understanding the platform initially. However, with plenty of online resources, one can easily find solutions to problems and learn on the go.
  • Backup and restore: MySQL is not very seamless. Although the data is never ruptured or missed, the process involved is not very much user-friendly. Maybe, a new command-line interface for only the backup-restore functionality shall be set up again to make this very important step much easier to perform and maintain.

Likelihood to Recommend

If you are looking for a relational database solution, that stores data in tabular format and with high read/write speeds, MySql shall be your choice. MySql has proven its worth for many years and still the same level of effort is going into the product for new features. In case your requirements are for a key-value pair database or graph databases, then MySql would not be an appropriate choice.
VU
Verified User
Advisor in Information Technology (Computer Software company, 10,001+ employees)
Vetted Review
MySQL
2 years of experience

MySQL Is a superb relational database management system

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

MySQL is used for a variety of smaller applications. Adopting MySQL has provided tremendous flexibility for applications of all sizes within our firm, particularly those whose data needs are less demanding. In addition, MySQL has a big community that has helped us out countless times when we ran into issues. And it can be put to use with minimal effort.

Pros

  • PHP's ability to be programmed.
  • Relational data querying.
  • Relational database storage.

Cons

  • Enhanced diagnostic capabilities would be beneficial.
  • Data view tabs may greatly facilitate the process of data merging.
  • Memory utilization adjustment can be difficult.

Likelihood to Recommend

When compared to other SQL programs available today, MYSQL is both easier to use and more user-friendly in terms of its interface. I think it's great since it's easy to use for everybody, from SQL novices to seasoned pros. However, it probably isn't the best choice if you need very sophisticated features or massive scalability. You may use it on any server type, and the performance is satisfactory overall. For optimal performance, it does not require a lot of RAM.
VU
Verified User
Engineer in Engineering (Computer Software company, 201-500 employees)
Vetted Review
MySQL
4 years of experience

Mysql - A developers delight

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

As a RDBMS Transaction DB. We use it to store:-
1. User Profile
2. Transaction Data
3. Final Report related Data
4. Product Information
And Veriety of other information can be stored.





Pros

  • Provides different types of engines like MyISM, InnoDB, CSV etc (about 16 types) to store & read that information as per the requirement.
  • Storing Transaction Data because it is ACID Compliant
  • It is inbuilt functions for encryption, enciding, datetime operations, arithmetic operations, bin,hex,etc conversions, string operations etc
  • Very efficient in sorting, aggregations, full-text, partial-text searching

Cons

  • Should have a Column Based storage engine for a analytical & reporting data.
  • Can have a improved document storage
  • MySQL doesn't have many tools to monitor performance and fix issues easily

Likelihood to Recommend

Mysql is Fantastic for:-
1. User Management
2. Transactional Data
3. Final Reporting Data as it can be very quickly accessed and displayed on graphs

Not to be used for:-- It cannot be horizontally scaled so not suitable for very high data volumes- Should not be used for storing unstructured data- Should not be used real-time analytics, content management, document intensive storage
AP
Alok Pabalkar
Co-Founder & CTO in Research & Development at Mini Venture Lab Private Limited (Internet, 1-10 employees)
Vetted Review
MySQL
15 years of experience
View profile

My review of MySQL

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

Most of our internal applications use MySQL as their database. For example, our team owns a JVM tuning & testing platform will need to store each request coming to the platform and their status. We choose MySQL as our database.

Pros

  • Easy to set up
  • Easy to learn for beginners
  • Multi-language support

Cons

  • Scalability.
  • Not efficient to handle big data sets.

Likelihood to Recommend

MySQL is the best choice when you are not dealing with big data.
XZ
Xialin Zhu
Engineering Manager in Engineering at LinkedIn (Internet, 10,001+ employees)
Vetted Review
MySQL
10 years of experience
View profile

MySQL--Great RDBMS for non-huge DB needs

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

MySQL is serving more than one department in our organization. In the R&D department, it's being used as part of our software development. Other departments such as product, customer success, support, business development, and more are using it for managing the customers, for getting analytics, for creating reports and dashboards, and acting by this data.

Pros

  • Since MySQL is open source, it is free to use under the GNU license
  • Before any update to data, it pops up a summary for approval, which lowers the risk of making a mistake
  • Performance is great if you need a relatively small DB
  • Compatible with many operating systems and integrates with many development tools

Cons

  • If you need a big/huge RDBMS, MySQL is probably not for you (performance-wise)
  • Complex joins/transaction handling causes temp hangs and performance issues--this can be improved
  • Fine tuning is not that easy--you'll probably need an expert (in-house or outsourced) for it

Likelihood to Recommend

MySQL is best suited for us in managing our customers' definitions, accounts' structures, configurations, etc.--anything that is being set up once and updated only once in a while (and grown at low scales). The data of our customers' actions in the system is not saved in the MySQL DB since this changes in real time every second and this type of DB is less suited for so much data and such frequent changes.
YV
Yaniv Vararu
Director, Quality & Processes in Research & Development at Wochit (Computer Software, 51-200 employees)
Vetted Review
MySQL
9 years of experience
View profile

MySQL works well

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

MySQL is used as our relational data store for information in support of our software platform - software as a service for internal communications and employee experience. It is used across the entire product offering for frequently accessed and transactional data with multiple instances including master, failover, and read replicas.

Pros

  • Very quick to get up and running - easy to use.
  • It can run on very small virtual machines
  • It performs well and is flexible

Cons

  • MySQL always consumes all the memory available on a box and sometimes releasing resources can be an issue.
  • There are certain commands that can get you into trouble and create corruption which is not easily remedied.
  • Transaction handling is not the most efficient and larger databases can take some performance hits.

Likelihood to Recommend

MySQL is well suited for anyone who needs a relational database and is working within a budget. Since it is open source, it is free to use and has most of the features of something like Oracle or MS SQL Server. MySQL can struggle a little with larger applications and storing the data cache in RAM requires fairly robust machines.
VU
Verified User
C-Level Executive in Information Technology (Computer Software company, 11-50 employees)
Vetted Review
MySQL
10 years of experience

MySQL is best database structure tool

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

MySQL is used by the whole company. This is a very useful structured database managing tool which helps us in our day-to-day data mining and creating excel with this huge data. The best part of it is if we accidentally make any wrong inputs while capturing any of the data details in our day-to-day activity it can be very easily fixed for a long list of sheets in a single go with a set of queries. MySQL provides the best way to interact with the SQL database. It offers the best available security toward SQL database and maintenance also it takes care of large databases to be optimised and responsive to every action.

Pros

  • Data security- MySQL provides a very high-level of security.
  • High performance-MySQL provides very high performance in terms of data mining . A huge amount of data can be easily extracted in couple of seconds.
  • Easy management - This is very easy to manage and easy to demo to employees so they can get hands on quicly.

Cons

  • I would say it has few stability issues. It crashed for me, but this is very rare.
  • Another thing is definitely a user cannot start using this right away without any training.

Likelihood to Recommend

MySQL is best suited in extracting and storing data in different databases and I feel this is a very easy-to-use tool.
MG
Manav Goel
Business Analyst in Information Technology at OATI (Computer Software, 501-1000 employees)
Vetted Review
MySQL
5 years of experience
View profile