What is MySQL?
Until its recent acquisition by Oracle, MySQL was possibly the most renowned open source database enterprise package that could be accessed completely for free. With the merger, the server increased both its features and its price tag, but there is still a free version available to the general community to contribute ideas and suggestions.
MySQL is a fast and relatively inexpensive database management system. It can easily integrate with a wide variety of programming languages, and it is considered to be a very reliable option. One of the most prominent features that customers seem to enjoy is the easy scalability of this system.
MySQL Buyer's Guide
Download the MySQL Buyer's Guide including reviews and more. Updated: May 2021
Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.
Filter Archived Reviews (More than two years old)
- Highest Rating
- Lowest Rating
- Review Length
Showingreviews based on the current filters.
Partner at a tech services company with 51-200 employees
Apr 6, 2019
Has the ability to run on any operating system
What is our primary use case?We utilize the DB as a data-repository solution for our front-end applications. The solution gives us the ability to run numerous instances on various geographical cloud servers.
What other advice do I have?I would suggest running tests against MySQL, MariaDB, Oracle, PostgreSQL, and MS SQL to determine which one best suits your needs (cost, development, and integration should all play in your decision-making process).
Co-Founder at Mero Reading Room
Oct 10, 2018
It has a remote access feature to manage the database from a remote location
What is our primary use case?I used it to obtain insight into the entire network and the resources being utilized. The current GUI lets us see the traffic happening east to west and the total bandwidth consumed by it.
Pros and Cons
- "It creates a unified view of the entire architecture and performance factor, helping to manage the network more easily."
- "It has a remote access feature to manage the database from a remote location. This enables in-work collaboration."
- "The only service which could be improved is its usability. The entire user experience needs to be revamped to meet the 2018 design standards."
What other advice do I have?The overall service is great.
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: May 2021.
510,534 professionals have used our research since 2012.
User at Micro Focus
Jun 10, 2018
I use the tool for various purposes but sometimes the functionality is limited and I need to use other tools instead
What is our primary use case?I use MySQL for employee service in an OLTP database.
What is most valuable?I use MySQL for various purposes. Sometimes I have used MyISAM as a storage engine rather than InnoDB.
What needs improvement?When working with a cluster wide, I have to use the MySQL cluster version.
For how long have I used the solution?One to three years.
Which solution did I use previously and why did I switch?The 5.7 version has very better performance improvement over the previous version.
Mar 4, 2018
Allows us to share virtually created database instances
What is our primary use case?I'm a tester, an optimization tester. It's basically when the developers have the back-end in SQL. We go and test it out for them and check that the table updated correctly, and we do something on the front-end.
Pros and Cons
- "I feel that some tools which make it easier to create queries or make it easier for other functions would be really interesting to see."
What other advice do I have?No one tool fits the bill for every company. Do a feasibility study, and get to know what is can do before going in and developing.
Feb 28, 2018
Performance, stability, and free version are key for us
How has it helped my organization?Web portal database.
What is most valuable?Free usage Performance Community
What needs improvement?Scaling.
For how long have I used the solution?More than five years.
What do I think about the stability of the solution?There have been some problems with big table operations.
What do I think about the scalability of the solution?Some problems with big table operations, and a struggle to keep the servers responding in peak situations.
How is customer service and technical support?I don't have enough information about it, as I normally look for community support.
How was the initial setup?Straightforward, and and easy to run.
What's my experience with pricing, setup cost, and licensing?Can range from free to quite…
Feb 14, 2018
Since it has many integrations to web applications, it is very easy to install and deploy
What is our primary use case?We use MySQL and MariaDB for most part of our mission critical applications This as it is so simple to integrate with web applications, and other well known applications.
Co-Founder/CEO at Grigale LTD
Feb 4, 2018
Dramatically improved use for several of my customers, better ROI for me
How has it helped my organization?It dramatically improved use for several of my customers.
What is most valuable?This depends on my customers' use.
What needs improvement?SQL and NoSQL use.
For how long have I used the solution?More than five years.
What do I think about the stability of the solution?When configured correctly, no stability issues.
What do I think about the scalability of the solution?When configured correctly, no scalability issues.
How are customer service and technical support?Very good.
Which solution did I use previously and why did I switch?MySQL Support Services by Percona. I switched to Oracle MySQL services because of a better ROI.
How was the initial setup?There is no obvious answer. It depends.
What's my experience…
Muhammad Nurazhan Moin
Senior Web Manager at a university with 501-1,000 employees
Feb 4, 2018
Support for enterprise-grade features like clustering, Sharding, in an open-source solution
Pros and Cons
- "Support for enterprise-grade features like clustering, master-slave replication, even Sharding (to some extent) which is an advanced feature."
- "It would be helpful if there were a graphical user interface to administer, configure, and tune it."
- "If it had something similar to Microsoft’s DTS engine then it would be the best database system out there."
What other advice do I have?As long as your application supports it well, and you are familiar with the scaling options and its limitations, you can’t go very wrong with MySQL, as it is a very mature product by now. If you are fairly competent with servers and databases you could start off without subscribing to Enterprise Support, and may be able to get by quite well. If things get more complicated, or scalability starts to become a problem, then you may consider paying for help.
Jan 23, 2018
We use it for enterprise data storage as well as part of the back-end of websites and web applications
Pros and Cons
- "The most valuable feature of MySQL is the informative error outputs of command line interface."
- "We use MySQL for enterprise data storage as well as part of the back-end of websites and web applications."
- "Setup is easy. MySQL of various flavours has community editions to easily test, deploy, and run."
- "MySQL needs improvements on its diagnostic features."
- "MySQL is not easily scalable on cost effective consumer grade hardware."
What other advice do I have?One should ensure the availability of proper hardware before any optimization attempt from the software level.
Jan 23, 2018
A large amount of software modules and plugins for rapid application development are possible. However, it does not stand out regarding scalability.
What is our primary use case?Small to medium-sized business usage. The main advantage is the very large user base. This enables users to fix about any issue by answering any question. From a technical viewpoint, MySQL is on par with the other open source database solutions.
Pros and Cons
- "A lot of the software components have been trialed and tested for often more than 10 years."
- "The main advantage is the very large user base. This enables users to fix about any issue by answering any question."
- "It does not stand out regarding scalability. When the company size increases, the user base having actual experience with (very) large MySQL solutions is reduced."
MySQL? Sure, but what is the best config and how to optimize for best performance?
We could write books about MySQL and every book could have a different focus: setup, optimization, backup, etc. So, this review will be about sharing some of the experiences that I have had. So, MySQL is probably the most used RDBMS for web applications. The server is really easy to install, literally a straightforward installation. It is very fast and stable and at the same time not resource hungry compared to some other RDBMS products. For smaller projects, you will not even need to do any "after install" tweaks or configurations, just install and you are ready to go. Nevertheless, for some more demanding projects, you will need to investigate and optimize your setup to fit the requirements. What is the best configuration for a MySQL server? There is no single best configuration.…
Real UserTop 20
Dec 19, 2017
Offers a simple DBMS solution with a very low hardware footprint. Only one of the engines supports ACID transaction control.
What is our primary use case?Primary DBMS solution for web apps developed on either ASP.NET MVC or Zend / PHP for customers. The community version of MySQL only offers simple backup and restore tools, but it is OK for many web dev projects for customers that want a low budget solution.
What other advice do I have?Most small and medium enterprises require many non-critical solutions. They clearly they do not have large budgets for these kinds of solutions, so it makes a lot of sense to consider MySQL as a good option for this kind of development. The advice is to make sure that it works for your company and for your customers.
Dec 12, 2017
Its strength is in the fast connection, query and insert performance. The weakest link is replication.
What is our primary use case?Used as a data store for RESTful web services and other web applications. Was deployed to store RSS feeds, and for 100 joomla instances.
What other advice do I have?The porting code to or from MySQL is not that complicated, but the date type/format and functions are the biggest hurdles. Handling booleans data type is less efficient than the BIT type in the SQL Server.
Open Source Database Consultant
Oct 29, 2017
A high level of support due to a lot of documentation and expertise in the world
What other advice do I have?You will have a lot of work, but you will also avoid a lot of issues due to product immaturity on the database market.
Aug 23, 2017
Helps to achieve stability. Needs to improve the system so it won't lose data.
What other advice do I have?You just need to identify why and what are the requirements. Also, you need to listen to news feeds regarding the features you are getting into and the features you will to use from it. Take the time to identify and understand.
Jul 31, 2017
You can build data models both on-premises and on the cloud
What is most valuable?Open Source (It’s free) One can easily find help on the web
How has it helped my organization?You can easily build data models both on-premise and on the cloud.
What needs improvement?The work bench has some bugs that are mostly GUI related.
For how long have I used the solution?I have used this solution for three years.
What do I think about the stability of the solution?I did not encounter any issues with stability.
What do I think about the scalability of the solution?I did not encounter any issues with scalability.
How are customer service and technical support?I use the community version. There are ample “Open Source” resources on the Internet.
Which solution did I use previously and why did I switch?We used Microsoft SQL…
Jul 31, 2017
It offers all the features of a RDBMS system, including monitoring tools, backup and recovery, high availability and easy migration from other databases.
What other advice do I have?For us, MySQL is the choice for all of our projects. It is simply to use, supported by all content management systems and, of course, Open Source. We haven’t had any major issues, and since we have now developed MySQL technical skills and custom libraries, there is no reason to move on with a different RDBMS, unless circumstances change.
Jul 31, 2017
It's good and affordable
What is most valuable?It is free and bundled with cPanel.
How has it helped my organization?Cost effective.
What needs improvement?Not at the moment in my current work environment.
For how long have I used the solution?Two years, began when I started at my current workplace.
What do I think about the stability of the solution?So far, so good due to limited clients at the moment.
What do I think about the scalability of the solution?So far, so good due to limited clients at the moment.
How are customer service and technical support?There is no technical support since it is a CE.
Which solution did I use previously and why did I switch?No.
How was the initial setup?Straightforward.
What's my experience with pricing, setup cost, and licensing?…
Jul 27, 2017
Relational databse that can be used with PHP, Python, and Java.
What other advice do I have?This is a relational database tool for small to medium sized applications. However, this didn't start as a Relational DB, so if you want a truly Relational Database for an Enterprise, similar to Oracle, you may want to look into PostgreSQL, as well. However, MySQL is still a very good database for internet based applications.
Jul 19, 2017
Think about the size of the database
What is most valuable?Easy: Installation Customization Use
How has it helped my organization?Data is: More ordered Reliable Available in time and form
What needs improvement?Scalability: In large databases, they become slow.
For how long have I used the solution?12 years.
What do I think about the stability of the solution?No.
What do I think about the scalability of the solution?Yes. In large databases, response times are high.
How are customer service and technical support?10 out of 10.
Which solution did I use previously and why did I switch?We used this solution, but changed for another because the database was very large.
How was the initial setup?Configuration was easy and with much support material.
Which other solutions did…
Web Developer at a tech services company with 201-500 employees
Jul 17, 2017
The most valuable feature is its graphical interface which allows us to do the database administration
What other advice do I have?I believe that it is the ideal solution for a variety of projects with a small learning curve compared to other solutions. It allows you to be efficient quickly.
Jul 16, 2017
Several unexplained crashes caused dissatisfaction from users
What other advice do I have?Not choosing an open source software for this kind of solution. Now, we are looking at ServiceNow Express.
Jul 13, 2017
Allows us to maintain very large tables without jumping through the hoops.
What is most valuable?Simple syntax and simple administration are the most valuable features.
How has it helped my organization?It allows us to maintain very large tables without jumping through the hoops that are required by the commercial products such as Oracle.
What needs improvement?Multi-master replication could be a bit more reliable.
For how long have I used the solution?Counting the earlier versions, we are using this solution for over ten years.
What do I think about the stability of the solution?Compared to the other database solutions, there were no stability issues as such.
What do I think about the scalability of the solution?Sharding is relatively straightforward.
How are customer service and technical support?We run the Community version, so…
Software Engineer at a tech company with 51-200 employees
Jul 13, 2017
Improved our internal procedures by providing high performance, ease of use and cost savings
What other advice do I have?It can benefit any business by a straightforward way of implementing and using it.
Jul 13, 2017
Online backup can be implemented by activating a temporary storage and introducing Percona innobackupex
What is most valuable?This product is valuable because it is used in production environments. Online backup can be implemented by activating a temporary storage similar to the Oracle's flash recovery area and introducing Percona innobackupex. This is possible from version 5.6.
How has it helped my organization?It permits services such as data warehouse and retail.
What needs improvement?The online backup needs to improve.
For how long have I used the solution?I have used this solution for 15 years.
What do I think about the stability of the solution?We did encounter stability issues.
What do I think about the scalability of the solution?There were no scalability issues.
How are customer service and technical support?Not applicable because we don't purchase…
Jul 12, 2017
Owing to its speed and stability, we use it as the data store for most of our web applications
What other advice do I have?Ensure you know what you want to use it for and make sure it is the right fit for the job. Do not allow developers to tell you what your DB should look like, as that is the best way to performance problems. Use the MySQL Workbench and MySQL Monitor.
Jul 12, 2017
It is used for many projects and easy to access. Needs to get more solid for my company to rely on it.
What other advice do I have?MySQL is a good choice for startups and beginners.
Jul 8, 2017
ACID attributes are the most valuable feature. It does not understand the clustered model.
What other advice do I have?Do your research and make sure for your use case that MySQL is the best choice, before making any commitments.
Jul 3, 2017
Offers SQL Merge, Replication, and Views. I would like to see additional side management tools and IDEs.
What other advice do I have?Go with the Linux version. It is more stable and manages the system resources better.
Jun 30, 2017
It is open source and AWS provides a managed solution. I would like it to catch up with proprietary technologies.
What other advice do I have?Until you have expertise in data migrations and what you are doing with data, MySQL can be really easy and dangerous at the same time. MySQL doesn't give you a warning about data truncation if data types don't fully match. Be really careful on that front.
CEO at a tech services company with 51-200 employees
Jun 30, 2017
SQL capability, functions and ease of optimization.
What is most valuable?SQL capability, functions and ease of optimization.
What needs improvement?Software and web development.
For how long have I used the solution?15 years.
What was my experience with deployment of the solution?No issues.
What do I think about the stability of the solution?No issues.
What do I think about the scalability of the solution?Manageable.
How is customer service and technical support?Customer Service: Used open source and never needed customer service. The product is quite mature. Technical Support: NA
How was the initial setup?Straightforward.
What about the implementation team?In-house.
What was our ROI?Good.
What's my experience with pricing, setup cost, and licensing?The open source product is…
Database Administrator at a recruiting/HR firm with 1,001-5,000 employees
Oct 22, 2016
It is easy to understand the inner picture of the database from the EER model.
What other advice do I have?This product is good as it is a graphical interface. It's easy to do all MySQL database administration very easily. You just need to play around to be more familiar with it. The MySQL Workbench interface is well prepared to design a database including EER diagram, create table, and view very easily. The EER diagram allows the user to completely understand the database design, which is very important and useful for the people who are involved with the database. It’s easy to understand the inner picture of the database from the EER model.
Aug 30, 2016
It provides a low-cost, high-availability solution without complex active/standby management using Linux HA. It should provide detailed debugging with transaction IDs at the application level.
What other advice do I have?Ensure that it meets your scaling needs, and has features for handling parallelism in the application.
IT Director at a energy/utilities company with 501-1,000 employees
May 18, 2016
We chose to run JD Edwards on it because of the availability of resources for it in our region.
What other advice do I have?Choose your database based upon your ability to be able to hire people and support the product, like supporting JD Edwards with a MySQL database. Not everyone can work one database with JD Edwards as well as they can another one. So just make sure you've got the compatibility and skill-set.
Project Manager at a non-tech company with 10,001+ employees
Highly recommended open source database for small/medium sized organizations
Pros:- 1) MySQL is an open source database under the GNU General Public License, that means developers can use it at no cost as long as the associated projects are also open source. 2) MySQL is ideally suited for small/medium sized organizations for faster performance. 3) MySQL can be used in client/Server architecture as well as it can also be embedded in standalone applications. 4) MySQL is fast, east to use, highly extensible, lightweight, scalable, and reliable database. 5) MySQL supports clustering in the network for redundancy. 6) MySQL provides flexibility to modify environment variables/kernel settings to limit the amount of memory usage for increasing performance. 7) MySQL is strongly recommended for web applications, middleware and LAMP…
Feb 28, 2016
The InnoDB database allows us to store and execute procedures and roll-backs.
What other advice do I have?It helped me within my projects. For a free product, it works very well and it's easy to use and configure. Don't try the most sophisticated products, that have big names, and cost a ton. Just try this product if you need something cheap and reliable. I don't think it will disappoint, at least not in my case.
Jan 20, 2016
The privileges and command line features are the most valuable to me. But, you do need to have experience with SQL to use it.
What is most valuable?Privileges Command line
How has it helped my organization?I don't have any as this was my first time using it.
What needs improvement?I think it is where it needs to be. MySql PaaS. But, you do need to have experience with SQL to use it.
For how long have I used the solution?I've used it for 12 months.
What was my experience with deployment of the solution?There were no issues deploying it.
What do I think about the stability of the solution?It has been perfectly stable for us.
What do I think about the scalability of the solution?We've been able to scale it without issue.
How are customer service and technical support?Customer Service: 4/10 Technical Support: 7/10
Which solution did I use previously and why did I switch?MS…
Jan 5, 2016
This database enabled us to web present our content in a cost efficient way.
What is most valuable?At this time, pricing and footprint.
How has it helped my organization?This database enabled us to web present our content in a cost efficient way.
What needs improvement?I am not up to date on this issue.
For how long have I used the solution?At the time pricing and footprint.
What was my experience with deployment of the solution?This was the IT consultant's task to solve.
What do I think about the stability of the solution?No issues encountered.
What do I think about the scalability of the solution?Not really, as our DB was small. With time, we got version issues, as our DB engine was so old and not updated.
How are customer service and technical support?Customer Service: I've never used it. Technical Support: I've never used…
Oct 31, 2015
It tends to perform better on Linux and other UNIX-like systems, but it needs support for foreign keys.
What other advice do I have?From my perspective, MySQL is a product that allows you to be efficient, but the decision goes down to the situation and what you're looking to accomplish.
Oct 29, 2015
I had no problems deploying it but the MyISAM tables need to be more reliable.
What is most valuable?Reliability Security Flexibility Functionality Availability - controllability anywhere and with different methods
What needs improvement?MyISAM tables could be more reliable.
For how long have I used the solution?I've been using the Workbench Server for six years.
What was my experience with deployment of the solution?I have had no problems deploying it.
What do I think about the stability of the solution?I have no stability problems.
What do I think about the scalability of the solution?I currently do not need to scale on my network.
How are customer service and technical support?Customer Service: I only have the free version, which does not have customer service. Technical Support: I only have the free version, which does not have…
Service Operations Manager at a tech vendor with 51-200 employees
Aug 6, 2015
Its ability to scale horizontally and transactional functionality features have been valuable to us, but the configuration templates could be improved.
What other advice do I have?If you have the in-house knowledge MySQL can be a great product. If you do not I would recommend using MSSQL instead. Take a look at the environment you plan to implement including the application and traffic model.
Jan 13, 2015
It provides a low cost and effective SQL DB solution for smaller companies. Replication does need improvement though.
What other advice do I have?MySQL is a great RDBMS, but make sure it will integrate with all of the clients you will be using and the rest of your infrastructure. The problems usually have more to do with other products supporting MySQL than MySQL itself.
May 1, 2014
A fast and reliable database management system
What other advice do I have?MySQL is an open source database management system and is used by most of the most famous networking sites. It is more popular in websites and PHP integration. It can be executed under a number of operating systems like Linux, UNIX, Mac OS and Windows. MySQL supports ODBC interface which allows MySQL to be addressed by all the usual programming languages that run under Microsoft Windows.
Head of Data Center at a university with 1,001-5,000 employees
Dec 18, 2012
MySQL is undoubtedly one of the best open-source database products available. It's fast, easy to use and very reliable.
What other advice do I have?Just be ready though to work at the command line should you wish to use MySQL in its free form. It may not be the most intuitive user interfaces available, but it also makes MySQL a simple yet very reliable database for most people's needs.
Developer at a tech consulting company with 51-200 employees
Aug 4, 2012
MySQL is the most popular Open Source Data Base Management System, developed and supported by Oracle Corporation.
What other advice do I have?And if some one is looking for Database which performs simple processes like storing and displaying data only, then MySQL is the right choice.
Jul 12, 2012
One of the best Databases on the market today.
What other advice do I have?I use MySQL on a regular basis, specifically whenever I am managing or installing a Wordpress instance. Combined with PHPMyAdmin, MySQL is an excellent database solution for small to medium sized businesses or installations. I would recommend using a better supported database like Oracle or MSSQL for mission critical tasks on an enterprise level, but MySQL is completely capable of performing the same tasks as those other databases.
Developer at a tech company with 51-200 employees
Jul 2, 2012
Most Powerful Open Source Database
What other advice do I have?As a developer I have used many database engines but MySQL is by far the best known and most popular Open Source database engine.
Senior Manager of Data Center at a integrator with 51-200 employees
Jul 1, 2012
One of the best open source database for web developers and application enthusiasts
What other advice do I have?MySQL is indeed the world's most popular open source database. It has been designed on the hyper threading infrastructure and supports multi-threaded architecture for using multiple CPU's. It works on index compression with B-Tree disk tables popularly known as MyISAM. Its efficiency depends on the implementation of SQL functions with optimization of library classes.
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.