Skip to main content
TrustRadius
MySQL

MySQL

Overview

What is MySQL?

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

Read more
Recent Reviews

Reliable and easy to use database

9 out of 10
November 20, 2023
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, …
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
Return to navigation

Product Demos

E-Commerce Website using PHP and MySQL || Project Demo || Part -1

YouTube

Small CRM Project using PHP and MySQL (Free Download)

YouTube

User Registration Form with PHP and MySQL Tutorial 5 - Add Form Validation + Final Demo

YouTube

MySQL database WinForms CRUD Demo. (CREATE,READ,SELECT,UPDATE,DELETE) | C#

YouTube

MySQL Enterprise Edition [Newer Version Available]

YouTube

C# MySQL database WinForms CRUD Demo. (CREATE,READ,SELECT,UPDATE,DELETE)

YouTube
Return to navigation

Product Details

What is MySQL?

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

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 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).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(966)

Attribute Ratings

Reviews

(1-25 of 134)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
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.
  • 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
  • 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
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.
Score 5 out of 10
Vetted Review
Verified User
Incentivized
We use MySql to store our long time storage data and a backup place for our OpenSearch indexes so if any index is corrupted or delted we can easily use the backup from he db and also we use it as a single source of truth for all of our operations and data and stuff
  • Storing data for long term storage
  • More Intutuitve Worbench than orcale sql workbench
  • Easy to Learn for a new Comer
  • Community Support is excellent
  • Old Battle Test TEch not like som enew software
  • The workbench is old caould use some impovement
  • Need support for different type of indexing
From me as a long-term storage user perspective it's good, it's not good if you need lighting fast response time it's just not made for it u can use other NoSQL databases but for relational i think MySQL is the most newbie-friendly database in the market
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use MySQL primarily for the backend database to our corporate intranet. In this case, it powers all the apps that run on this web-based system, including user details (matched against and extending our ldap directory), technical document retrieval, IT helpdesk tickets, and our design change request system.

MySQL allows us to implement an enterprise-grade database in a cost-effective and easily supportable way - we don't have to depend upon proprietary database formats, it has great performance, scales as we need it to, runs on a variety of operating systems, can be easily migrated to new hardware and is easy to securely backup.

Because it is easily and widely connected to, we can also use it in a variety of other apps and as a repository for large amounts of structured data.
  • Stable - it just runs, with minimal downtime or errors
  • Fast - well-structured data is quickly written and read
  • Secure - MySQL is easy to keep data secure from people and applications that shouldn't see it
  • Easy to use - SQL is industry standard so no problems with adding, editing and reading data stored in MySQL
  • Free it from Oracle's grasp! Bring back the old days...
From my own perspective and the tasks that I perform on a daily basis, MySQL is perfect. It has a reasonable footprint, is fast enough and offers the security and flexibility I need.

Everyone has their preferred applications and, no doubt, for larger data warehouses or more intensive applications, MySQL may have its limits, but for the area that I operate in, it's a great match.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We have at least 15 databases with MySQL We have solved our performance and response issues by getting queries fast
  • Great performance in our servers
  • fastly response in our system
  • takes up less disk space and db compre
  • I like because can be used in front of any query at the beginning with select, insert, replace, delete and update.
  • Also, it is a profiling tool for queries that shows information about where MySQL spends time on query.
It is a profiling tool for queries that shows information about where MySQL spends time on query, its performance and response problems by getting queries fast and takes up less disk space,
Score 9 out of 10
Vetted Review
Verified User
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.
  • Replication between instances is very spontaneous
  • Free and easy to install.
  • DB backup and restoration is easy.
  • excellent community support.
  • Tends to be getting Slow with large databases.
  • Unhelpful error messages.
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
Kendal Droddy | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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
Incentivized
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
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
Incentivized
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
Incentivized
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
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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.
Rishabh Khanna | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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.
Return to navigation