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

(965)

Attribute Ratings

Reviews

(26-50 of 134)
Companies can't remove reviews or game the system. Here's why
Balázs Kiss | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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.
April 16, 2021

MySQL--Best RDBMS

Score 9 out of 10
Vetted Review
Verified User
Incentivized
In my team, we are using MySQL as a relational database management system for internal software development projects. It helps us to store data in a well organized and systematic format, which, in return, results in better management, less utilization of resources, and time savings.










  • Very easy and simple to learn and apply
  • Robust and secure
  • Compatible with almost all types of programming languages, like C#, Java, and PHP, which provides flexibility to deploy databases for different applications
  • Not suitable for large data management
  • User interface can be improved
  • Support for non-relational data will be an added advantage
  • Security updates are not that frequent
MySQL can be used easily for web applications and small to medium-sized desktop applications for data management. It is fast, secure, and reliable, which offers easy data management.
Yaniv Vararu | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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
  • 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
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.
April 12, 2021

MySQL is useful

Score 8 out of 10
Vetted Review
Verified User
Incentivized
MySQL gets used for the most part in our infrastructure. If it is a website, an API, or something else, MySQL is the most used. It's used for data storage and user management. Our MySQL instance is available to every developer who needs to save something in a database, which is one of the reasons why it has so many use cases for us.
  • MySQL is very fast, so a request doesn't take long
  • MySQL has many configuration options
  • We had never any problems like a destroyed database
  • MySQL has a problem when databases are getting too big
  • Support for NoSQL
I recommend MySQL for everyone who needs a fast database for use cases like user management, APIs, and some data storages, but I don't recommend MySQL for large data and projects with very special use cases or if you don't have any clue about SQL language because it can be hard to get into sometimes.
April 12, 2021

MySQL works well

Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • Very quick to get up and running - easy to use.
  • It can run on very small virtual machines
  • It performs well and is flexible
  • 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.
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.
Manav Goel | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
  • 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.
MySQL is best suited in extracting and storing data in different databases and I feel this is a very easy-to-use tool.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used by our department to interact with the database. We basically use it for database manipulation and security. Since there are large database, this software really comes in handy. Coding is very straightforward and new team members are easily able to grasp things. Also helps in working with big data.
  • Data security
  • Data manipulation
  • Data management
  • Insecurity at some instances
  • Data loss in some cases
  • Data mismanagement for larger data
It is efficient and capable of handling large datasets in the form of tables, which comprise of rows and columns. Data can easily be retrieved. Provides a smooth workflow and reduces the workload because of its data manipulation abilities. It is easy to configure and manage. You also get few custom tools to manage the database.
Maria Cristina Dela Pena | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
MySQL engine is currently being used in some of the business unit systems in my current organization. This is being considered as the first option when creating new applications or systems if there are low-budget projects and if the application is web-based driven.
  • Cost constraints
  • Web based applications deployments
  • Small to mid-enterprise projects
  • Tools for performance insights.
  • Easy to do the manual failover.
  • Easy detection of errors.
  • Easy to check index fragmentations.
Being with huge cloud migration projects, one of the tops concerns is the cost of using the right database engine for the right application to run in a cost-efficient way.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use MySQL as our primary database system for all of our application backends.
  • MySQL has the ability to place a breakpoint with the debugger which is a huge feature
  • It offers a reliable data store
  • MySQL Workbench works extremely well as a GUI for MySQL
  • Replication is easy to configure
  • It could benefit from wider adoption and more forums with answers to questions
  • It doesn't have the same level of support as Microsoft
Well suited for a free to use database storage system as well as enterprise level
Score 9 out of 10
Vetted Review
Verified User
MySQL is a great Open Source Relational Database Management System(RDBMS). It has a lot of features. It is very stable. It provides an easy to use GUI with options for DDL, DML and DCL operations. One can easily create/alter tables, views, procedures, triggers, functions, indexes and much more. Writing queries, sub queries and joins are easily possible with MySQL.
  • MySQL is compatible to run on many OS like Windows, Unix, Linux.
  • MySQL allows transactions to be rolled back, commit, and crash recovery.
  • MySQL is very secure as it keeps passwords encrypted
  • MySQL does not support a very large database size as efficiently as other databases do.
  • Transaction handling is not very efficient.
  • SQL check constraint is not supported by MySQL.
MySQL will be most suited when the database size is not going to be very large. MySQL is a very fast, reliable, secure and stable database. When it comes to commercials, MySQL is open-source and free software under the GNU license. It is free to use, we can download it from MySQL official website without any cost. MySQL provides high performance when compared to other databases.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used within the whole organization as one of the two primary RDMBS. It is the underlying RDBMS database for the internal and external company records, hosted on Oracle PaaS.
  • Best in breed in open-source RDBMS databases.
  • Portability with our secondary database Oracle Database without much scheme changes.
  • Scales well with IaaS.
  • Some restrictions on the table sizes and schemes (unlike IBM DB2, Oracle DB, etc).
  • Issues with some of the SQL operations ( merge join, hash join, etc) that degrades the overall performance of the queries.
  • Licensing from Oracle for MySQL use can be improved.
MySQL is best suited for environments where the datasets are not large and there are no critical performance constraints. It is less appropriate for extremely large relational datasets and/or where performance guarantees are needed in the applications.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used in my company to store transactional data of modern applications that have been developed with an SOA architecture oriented to services and microservices, since these require multiple databases that are stable, light and have high availability.
  • Excellent response times when consulting data
  • Easy to learn, use and manage
  • It is necessary to invest time and effort to implement additional functionalities that are required in business environments, such as data replication.
  • When acquired by Oracle, its innovation speed has decreased, which opens the way for other competitors.
The strengths of MySQL can be exploited when it is necessary to store relational data in small, medium-sized applications or those in which its architecture is service oriented. I see it less appropriate for it to be used in monolithic applications with complex database structures.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used at the organization level but mainly for web applications in the organization.
  • Very good for basic to enterprise-level needs.
  • Cost-effective
  • MySQL has some limitation with complex data types.
  • Limitations with common table expressions.
MySQL is the best and simple open source Relational Database Management System that provides ease of use. MySQL supports many interfaces and programming languages, and also it is easier to learn for a newbie.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
MySQL is being used for many software in my company development for specific departments and software for all employees across the organization like human resources forms, Content Management Systems for website and intranet, health forms, satisfaction survey software.
  • Easy to learn.
  • Easy to use and manage.
  • Easy to backup and restore.
  • Have a community version open source.
  • More documentation.
  • Efficiently manage big amount of data.
I recommend MySQL for small and medium companies. MySQL is a strong database and you can store your company data, and connect your software easily.
November 04, 2019

MySQL - Old User's Review

Holman Cárdenas, M.Eng, TOGAF®, ITIL® | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I have used MySQL across different companies, mainly as a DB for web pages (along with Apache and PHP) and web-based applications (internal and external). It provides a fast, reliable and efficient DB solution.
  • Very fast and reliable DB
  • Innodb tables are a huge improvement
  • Works very good with the open-source ecosystem, even though it was adquired by Oracle
  • InnoDB tables performance could be improved
  • Tuning is a little bit complex
  • InnoDB tables do not support full-text searches
MySQL is well suited when you are using web pages or web applications in an open-source ecosystem (i.e. Php, Apache) and/or CMS as Joomla, Drupal, WordPress, etc. Not recommended for core or critical-mission applications (it stills need a higher maturity level).
October 11, 2019

mysql review

Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
  • It’s Got A Few Stability Issues
  • It Suffers From Relatively Poor Performance Scaling
  • Its Functionality Tends To Be Heavily Dependant On Addons
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. :)
October 08, 2019

I like MySql

Score 8 out of 10
Vetted Review
Verified User
Incentivized
It was used across the whole organization internally. It was picked because of the easy integration, great support, and stability. For internal usage, they needed a cost-effective but trustworthy solution. Also from experience, the developers are familiar with MySql the most, they would able to use the juniors to work on the internal solutions first and learn the way.
  • Easy to get started.
  • Lightweight, but scalable.
  • Well known, well supported.
  • Owned by oracle.
  • Limitations of fine-tuning.
  • Lack of failover.
For internal usage for medium-size companies, for startups, and for demo projects, it is more than well suited. However, as it is scalable to a point, it is no match after a point to Oracle DB or IBM/2 as they were created to provide huge performance and to support big company's needs.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Yes, it is being used by a department to retrieve information as per customer needs.
  • Excellent market penetration.
  • Easy to get started.
  • Open-source license for most users.
  • I have only two years experience so I have not found any improvement but everything so far I used was good to me.
As per my experience, MySQL is best to use as an inventory management system, where based on different conditions, users need to retrieve data for analysis. Also, it is easy to learn so, a user can quickly become comfortable with it.
September 26, 2019

MySQL is my SQL

Score 9 out of 10
Vetted Review
Verified User
Incentivized
Used as a Relational data store across the organization.
  • Quick processing.
  • Proven reliability.
  • Ease and flexibility of use.
  • Adding web hooks.
  • Support for CHECK constraints.
  • Hot Standby/Streaming Replication.
MySQL is the first choice for those web-based projects which require a database merely for data transactions.
MySQL will start underperforming once it is stressed with heavy loads or complex queries.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used in the whole organization, for variety of engineering and business purposes. Examples of uses:
  • DevOps pipelines data
  • Software artifact data and metadata
  • Test results
  • Validation results
  • Users and their associated data
  • Extracts from Big Data systems
MySQL is a data store many users are familiar with, and that makes for easy adoption. The infrastructure teams have experience in running it reliably.
  • Popular
  • Improving capabilities over time
  • Widespread knowledge
  • Reactive APIs
  • NoSQL support
  • Graph data models
  • Conventional relational data model
  • Small and medium data sets work well
  • For large data sets consider enhancements like Vitesse
  • The new JSON document support is an excellent addition. This enables us to eliminate some NoSQL document stores (for example, MongoDB or CouchDB, Couchbase) and instead use only one database for various uses.
  • The development and support team are familiar with RDBMS.
September 18, 2019

I love MySQL

Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • Opensource.
  • Flexibility.
  • Accessibility.
  • 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.
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.
September 18, 2019

I like data.

Score 10 out of 10
Vetted Review
Verified User
Incentivized
MySQL is mostly for vetting out developers to make sure they had enough knowledge to accomplish specific job duties. I created a bunch of tables and relationships, and populated a couple hundred rows of data across all of the tables. Then I gave developers a test asking them to send me back SQL scripts to perform various SQL, DDL, DML tasks and I would validate everything to make sure it worked as it ought to.
  • Easy to spin up a database instance.
  • Fast.
  • Not great for dealing with large amounts of data.
  • Limited capabilities for stored procedures.
MySQL is good for simple databases for small projects.
Return to navigation