MySQL

MySQL

Customer Verified
Top Rated
About TrustRadius Scoring
Score 8.6 out of 100
Top Rated
MySQL

Overview

Recent Reviews

Low Footprint High value

9 out of 10
July 08, 2022
Many of our applications are built on MySQL DB with different application layer platforms such as PHP web applications and java desktop …
Continue reading

Best DBMS

8 out of 10
July 07, 2022
I had implemented the MySQL into other organisation where also created the cluster grade environment so that it provide high availability.
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of MySQL, and make your voice heard!

Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is MySQL?

MySQL is a popular open-source relational and embedded database, now owned by Oracle.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Would you like us to let the vendor know that you want pricing?

13 people want pricing too
Return to navigation

Product Demos

Introduction to MySQL Database Service
02:23
What Do Reviewers Think of MySQL?
04:35
Comparing MySQL and NoSQL
06:17
Return to navigation

Features Scorecard

No scorecards have been submitted for this product yet..
Return to navigation

Product Details

What is MySQL?

MySQL is a popular open-source relational and embedded database, now owned by Oracle. For more information visit https://www.mysql.com

MySQL Videos

What is MySQL?
MySQL is one of the most popular database software options for businesses of all sizes. The software is open source, and highly customizable, so users can set up an instance that meets their needs.
While MySQL is a specific product, NoSQL is a type of database that includes a number of available products. Whether a NoSQL (nonrelational database) product or using MySQL (relational database) is right for you greatly depends on the data you are storing, queries, and flexibility.

MySQL Integrations

MySQL Competitors

MySQL Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

MySQL is a popular open-source relational and embedded database, now owned by Oracle.

Microsoft Access, Google Cloud SQL, and Amazon Redshift are common alternatives for MySQL.

Reviewers rate Usability highest, with a score of 10.

The most common users of MySQL are from Enterprises (1,001+ employees) and the Computer Software industry.
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

 (930)

Ratings

Reviews

(1-25 of 132)
Companies can't remove reviews or game the system. Here's why
Kendal Droddy | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • Easy integration with a wide variety of software tools
  • Ease of scalability as our capacity increases
  • Very fast and efficient searching
  • Could use enhancements to the debug tools
  • Not as efficient at very large database sizes
  • Not always as stable as I would prefer
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.
Rao Tahir | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
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.
  • Data storage
  • Integration
  • Scalibility
  • Error Messages
  • Query Optimization
  • Version Errors
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.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • A major drawback of MySQL is it cannot be used on large database sizes and slows down in such cases.
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.
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use MySQL as the backend database for vendor products that support MySQL. It is an open source product so it addresses licensing costs as compared to using MS SQL.
  • It's a very secure DB
  • Reduced TCO
  • High Performance
  • Doesn't support very large DBs efficiently
  • No stored procedures
For smaller database backends, this product works well. Our backend printer management software is using MySQL as its backend and we have not had any issues since it went live 2 years ago. It's also free so no licensing worries.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • 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.
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.
Pablo Gonzalez | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • 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.
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.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • Barrier for legacy Infrastructure.
  • Open source.
  • Unlimited Customised solutions.
  • MySQL Cloud should be more reliable and better.
  • We should get some more ETL Featured syntaxes.
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.
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • DB optimizations
  • Database CRUD accuracy
  • High stability
  • More flexible replication options
  • Automated query optimizations
  • More DB engines
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.
Rohit Goyal | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
I use Mysql in my organisation to save the data of our application and maintain historical data of our application and user data and logging data. Mysql is very compatible with all the frontend applications build in any languages, which helps us to have durability of the application data and also can perform many scheduled jobs in mysql
  • Atomicity
  • Durability
  • Consistency
  • Isolation
  • My Sql User interface
  • Message Queuing Technology
  • Generate SQL Scripts
Mysql is recommended when we have budget issues in our application and we need to spend less money in backend of the application as this is a open source tool and can give may functionalities, where as if our applications have need for scheduling jobs and scheduling tasks and creating queues mysql is less appropriate
John Ramírez | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
MySQL is used on one side of our organization, where the need for a strong and free database engine is mandatory. It covers all the needs we have related to efficiency and database handling, as many others paid engines, and we are happy with the performance and availability of the data stored on it. Due to customs restrictions, we choose MySQL as the most convenient engine, and we are very pleased with our choice.
  • Availabilty of the data
  • Complex queries
  • Data storage and maintenance
  • Optimization
  • Support
  • Connection witout plug-ins
It is perfectly suited for a company, that has a limited budget to pay for a database engine, and needs all of the capabilities of a paid service. Also needs complex data structures as well as connection with most of the data mining or business intelligence. Also great for open-source operating systems, because of their simplicity to install and maintain.
July 07, 2022

Best DBMS

Score 8 out of 10
Vetted Review
Verified User
Review Source
I had implemented the MySQL into other organisation where also created the cluster grade environment so that it provide high availability.
We used it on the Solaris and Windows Environment and it is really cost effective solution and its community edition nearly all the major features like to support the GIS based data types and etc. In our case we are looking the robust Database Management System which should allow our applications to work smoothly and fastly.
  • Clustering Feature is amazing
  • Well support for GIS datatypes
  • Query language is really fantastic and very powerful
  • need more improvement on supporting large database
  • improvement on partitioning
  • Debugging Tool should be improved
Well suited for the SMB environment and cost effective solution or anyone can use the community edition.
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • PHP's ability to be programmed.
  • Relational data querying.
  • Relational database storage.
  • Enhanced diagnostic capabilities would be beneficial.
  • Data view tabs may greatly facilitate the process of data merging.
  • Memory utilization adjustment can be difficult.
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.
Score 8 out of 10
Vetted Review
Verified User
Review Source
A client needed MySQL as part of a local server and app (Decisions) for their investment department for day to day analysis. We're required to set up MySQL with each user who needs this set up on their workstation and ensure it's being accessed and used successfully by the Decisions app.
  • Easy Setup
  • Relative Stability
  • Secure
  • Not as efficient with large databases
  • Takes time to get some features up and running
  • Can be hard to scale
MySQL has worked great when it's tied into other business apps and/or databases that aren't too large. Once the databases become too large, it starts becoming more inefficient and has issues at times with file corruption. I don't see MySQL being as scalable as others which can be a problem as growth occurs.
Jeffrey Lange | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
I use MySQL for the database that handles surveys. It allows me to store all the data for survey results, over 300,000 records.
  • Connect to database(s)
  • Store data into those databases
  • Query data from different or multiple tables
  • Unions are often hard to do at beginner level
  • Joins are often hard to do for beginners
  • I'm honestly not sure what else can be improved
MySQL has been my go-to for making dynamic info using a database. Every site nowadays has data. It's very reliable and fast. I recently bought a book to learn more about optimization and recommend that to improve my skills.
Alok Pabalkar | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.





  • 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
  • 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
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
Kees-Jan Koster | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Many of our internal web applications use MySQL to store their data. It is a great relational database engine and works great for storing all kinds of relational data. It runs well on our Ubuntu servers and works great from PHP. And we can use it without paying huge amounts for licensing.
  • Storing relational data
  • Querying relational data
  • Programmability from PHP
  • Finetuning for memory consumption can be tricky
  • Some improvement in diagnostics could be helpful
MySQL works great as a relational database server for web applications. It is has good programmability from PHP and runs well in any linux environment. The performance is generally good and it can run on all kinds of servers. It does not need an excessive amount of memory to run well.
December 23, 2021

MYSQL review

Tanika Chhabra | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
It was earlier difficult to manage a large amount of data on excel and it was time-consuming to maintain a spreadsheet. But with the use of SQL, all our job has become so easy and we are able to manage everything so easily. We just have to use some simple DML queries and we could easily fetch a good amount of data so easily.
  • Easy to use the queries
  • Superfast in fetching the data
  • Easy to learn and apply
  • Data joining can become lot more easier with data view tabs
It is well suited for Organizations relying on large data sets or big spreadsheets. One can easily use a few queries and get desired output so easily. MYSQL is much easier and has better interphase than many of the other SQL applications which are present. I would highly recommend it to new learners and also people with SQL knowledge, as it is so easy to use
Rishabh Khanna | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
It is being used by 90% of products that my organization has developed. All the products that are in the development phase or in production are using MySQL. The project that I'm working on is an IoT-based ERP system and we are using MySQL to store the machine data coming from the production site.
  • It is easy to understand.
  • It works well with most of the popular programming languages.
  • It is better and cheaper than other relational database services available in market.
  • I would love to see some updates in the UI part of it.
  • They should work on their documentation. Make it more readable by changing fonts.
It is a great product. It can be used with many types of web applications. However, it is not suitable for data analytics. We are using it with an IoT-based ERP system. In case if you decide to move to cloud, oracle provides full support to use MySQL as a cloud database service.
Score 8 out of 10
Vetted Review
Verified User
Review Source
We are using MySQL in a few of our microservices application databases. We chose MySQL because its easy to use, has a lot of documentation both official and non official, has a large userbase, os easy to maintain and quick to install with fairly minimal configuration. The last bit is arguably most important for us since at the mooment, we need something that can be done quickly to make our application available to the user.
  • Beginner friendly
  • Quick and easy to set up
  • Has a massive userbase
  • Lack of advanced features compared to PostgreSQL or SQL Server
  • Doesn't scale as well as PostgreSQL or SQL Server for large databases
MySQL is really suited for a beginner who wants to use an RDBMS-type database that doesn't need any advanced features. It's also great if you want to spin up something quickly with only a few steps of installation and security configuration.

It might not be for you if you need something that needs to be massively scalable or if you need advanced features.
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • Multiple database engines.
  • Open source
  • Supports millions of records.
  • User interface to manage DB.
  • Data replica or auto sync between two servers.
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.
Alena Burda | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • 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.
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.
Balázs Kiss | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • Storing relational data.
  • Quick management.
  • Integration with different development tools, for instance with IntelliJ Idea.
  • I had some stability issues in the past.
  • SQL requirement.
  • Hard to find support for special cases.
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.
May 01, 2021

My review of MySQL

Xialin Zhu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • Easy to set up
  • Easy to learn for beginners
  • Multi-language support
  • Scalability.
  • Not efficient to handle big data sets.
MySQL is the best choice when you are not dealing with big data.
Jose Manuel Ortega | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
We use MySQL mainly as a database management system for small applications oriented to the management of resources of the different projects that store information related to the employees, either for the management of tasks or to allocate the hours that each employee registers in the project. We generally use it together with the PHP programming language and Apache Web Server using the LAMP distribution (Linux + Apache + MySQL + PHP).
  • Easy integration with development tools and environments, as well as connection with different programming languages
  • The support for handling transactions allows recovering from failures in operations and thus maintain data integrity.
  • Efficient use of resources at the memory and CPU level
  • Cross-platform support for different operating systems
  • Lack of documentation for a large percentage of MySQL utilities, for example the aspect of data replication for certain cases there is no documentation.
  • Some experience is required to configure and tune it to the project requirements.
  • Migration from standard SQL is sometimes not automatic and requires manual migration.
  • It is a suitable database for web applications where we have a large size of users. It is also easily scalable and provides good user management and access controls at the security level.
  • MySQL is a very fast database to read when using the non-transactional MyISAM engine, but it can cause integrity problems in high-concurrency environments when modifying. Thus, for applications with many parallel transactions and modifications, MySQL is probably not the best solution
Adolfo Maltez | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use MySQL as a RDBMS in a variety of web systems across the entire organization. It's very easy to use, install, and support multiple configurations for a variety of use cases. MySQL has helped us to improve our response time in providing database infrastructure to a wide variety of projects.
  • Easy of use
  • Fast installation
  • Support for replication and backups
  • Free software
  • Standard GUI
  • Blueprints of configuration
  • Better tutorials
MySQL fits use cases that require fast responses, like transactional websites when the user requires a response in no time. Another use case is when we need replications master/slave or multi-master.

The use cases I don't recommend it for are when we need a strong relational database. In that case, MySQL can be a little slow.
Return to navigation