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.
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.
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.
My Organisation holds legacy infrastructure, and to make it compatible with other systems, we used MySQL as a barrier, and the solution worked well for us. Moreover, being open-source, it is more financially compatible and has many customized solutions in MySQL.
Pros
Barrier for legacy Infrastructure.
Open source.
Unlimited Customised solutions.
Cons
MySQL Cloud should be more reliable and better.
We should get some more ETL Featured syntaxes.
Likelihood to Recommend
We do have an interaction between Linux and Windows systems. MySQL played a vital role in connecting across different platforms. MySQL Cannot support huge data and doesn't have many debugging features.
VU
Verified User
Manager in Engineering (Real Estate company, 5001-10,000 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)
We use MySQL Database multiple departments across the organization as an RDMS(relational database management system) for small-medium projects, easy to implement, cost-effective, easy to make changes, easy test, and supports millions of records. MySQL supports multiple database engines and we use mostly InnoDB to store the data, organize the data, and reporting purposes.
Pros
Multiple database engines.
Open source
Supports millions of records.
Cons
User interface to manage DB.
Data replica or auto sync between two servers.
Likelihood to Recommend
MySQL is free to use under the GNU license so most of the open-source, non-profit organizations can use it for free, it is easy to adapt and implement, and most cost savings compare with other SQL providers in the market. It is most suitable for small to medium projects and not recommend for banking and enterprise projects.
VU
Verified User
Engineer in Engineering (Marketing & Advertising company, 201-500 employees)
MySQL has helped me to excel in my field of
deploying cloud-native applications and provided me a smooth route to carry
on my everyday work. I did not face any difficulty getting started, and it
offers a customizable interface so that one cannot get stuck in the high burden of
the programs. This tool is providing me better data integrity along with better
customer service. It is helping me in my online business to a
great extent, as I never faced any difficulty in any transaction and it provides
a high-speed transactional processing system.
Pros
It has hit every nook and corner of my entire organization and I am very much satisfied with its high availability, self-healing, provisioning, monitoring, and much more.
It works faster and gives effective services.
My team is at ease to work on such a reliable platform that is concerned with security. It provides me full control over all aspects of MySQL through its comprehensive set of advanced features, management tools, and technical support as well.
It is the most reliable database management tool that collaborates really well with WordPress, Drupal, Joomla!, etc., and equips me with all the necessary tools that could be beneficial to meet database challenges of next-generation web and cloud services.
Cons
This is a very costly tool that really does not fit well with small business setups.
There are still many complications (e.g., I faced difficulty in its licensing and its UI/UX could be improved too). Also, it is complicated in understand, as too much of the information is available--it becomes difficult to understand.
Likelihood to Recommend
There are
different plans available, so it offers you diversity to choose the one that
fits your needs. Furthermore, I believe that through this tool, you will have a transparent idea about the entire processing of your daily work. For me, it’s a universal platform and provides
you great security along with data management, so I will recommend you to
use it, especially if you deal in e-commerce. This superb tool gives you a clear-cut idea about the processing of your work.
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.
As I know, we use it only in a department of our company. Most of the time we use this database as a development database. We store less complex data structures in it, small and few tables, as we know it's better to store small amount of data then other relation databases.
Pros
Data Security, MySQL is globally renowned for being the most secure and reliable database management system used in popular web applications like WordPress, Drupal, Joomla, Facebook and Twitter. The data security and support for transactional processing that accompany the recent version of MySQL, can greatly benefit any business especially if it is an eCommerce business that involves frequent money transfers.
High Performance, Whether it is an eCommerce website that receives a million queries every single day or a high-speed transactional processing system, MySQL is designed to meet even the most demanding applications while ensuring optimum speed, full-text indexes and unique memory caches for enhanced performance.
Complete Workflow Control, With the average download and installation time being less than 30 minutes, MySQL means usability from day one.
Cons
It’s Got A Few Stability Issues
It Suffers From Relatively Poor Performance Scaling
Its Functionality Tends To Be Heavily Dependant On Addons
Likelihood to Recommend
As I said before we use it as a test database, with small amount of data. It has a nice performance with it, so i recommend it, however i if you should handle large amount of data you are probably find another database with better performance. So it's well suited in small apps. :)
VU
Verified User
Employee in Engineering (Information Technology and Services company, 51-200 employees)
We use it from time-to-time, as the database solution for our smaller projects which requires a relational database. Usually used by the whole team, integrated into the production chain, and nearly everybody uses it for testing, smaller modifications in the data model, or when installing for a localized development environment.
Pros
Storing relational data.
Quick management.
Integration with different development tools, for instance with IntelliJ Idea.
Cons
I had some stability issues in the past.
SQL requirement.
Hard to find support for special cases.
Likelihood to Recommend
When a classic, small relational database (I mean small as a small number of tables, not records necessary) needs easy to install database with easy to find tutorials, that's free, robust, and very well documented.
MySQL is one of the powerful database management in the world. that very easy to use and because it's an opensource project. That's make it very special, because lot of developer work on it and make it powerful each day. MSQL is really the best alternative for startup, because they do not have to much budget. That a great technology for free.
Pros
Opensource.
Flexibility.
Accessibility.
Cons
I have never used another database system in the past, so I cannot compare it with others.
I have no improvements that I can give because MySQL is only the one I have ever used.
Likelihood to Recommend
MySQL is very powerful web application because it is very easy to use. Also, we can use the mobile app. I always use MySQL on both the mobile and the web application. It is very easy to host an application using MySQL because it is the most used database system in the world.
VU
Verified User
Engineer in Engineering (Computer Software company, 1-10 employees)