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.
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.
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)
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)
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)
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)
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
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.
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.
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)
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.