Mostly, we're using it as a database behind a machine learning application.
Managing Director at NaMax Limited
A reliable, free, and easy-to-use solution
Pros and Cons
- "For starters, it's free, which is always nice, and it's also pretty straightforward to use. It's a nice conventional database."
- "The workbench could be improved. In particular, error messages can be improved, which are horrific and completely unhelpful. I'd like to see improved parsing of errors. When you write SQL and it crashes, it usually is something completely irrelevant and not helpful. I've started to use GPT 3.5 for finding out how to do things. I got to do something a bit different, and that I found to be very useful. If there was some way to tie it into one of the new AI tools, that would probably be a good idea."
What is our primary use case?
What is most valuable?
For starters, it's free, which is always nice, and it's also pretty straightforward to use. It's a nice conventional database. We don't need the sort of flexibility that you get with most SQL databases and stuff like that, so we are happy with a good old-fashioned relational database. It's totally good for that.
It works. It's reliable. We haven't done any configuration management for probably about two years, but as far as I remember, that was pretty straightforward as well. It's doing what it needs to do as far as we're concerned.
What needs improvement?
The workbench could be improved. In particular, error messages can be improved, which are horrific and completely unhelpful. I'd like to see improved parsing of errors. When you write SQL and it crashes, it usually is something completely irrelevant and not helpful. I've started to use GPT 3.5 for finding out how to do things. I got to do something a bit different, and that I found to be very useful. If there was some way to tie it into one of the new AI tools, that would probably be a good idea. There were a couple of things that I've found difficult to do in the past, and I remember they were fiddly. I set them into ChatGPT, which is GPT 3.5, and it gave first-class answers.
I find it clunky. It just doesn't feel very modern. It feels as if you have to go through multiple steps to get to places, and it's not clear, but operationally, I find it fine.
For how long have I used the solution?
I've been using this solution for about five years.
Buyer's Guide
MySQL
December 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
829,541 professionals have used our research since 2012.
What do I think about the stability of the solution?
It's reliable. I never lost any data, which you anyways shouldn't. I'd rate it a ten out of ten in terms of stability because we never had the slightest problem. We are not in a challenging environment, but I haven't had any problems.
What do I think about the scalability of the solution?
We've had absolutely no limitations. However, we haven't got enormous data. It's not very vast, so scalability hasn't been an issue. At our level, it's not even a question. It's absolutely perfect. I'd rate it an eight out of ten in terms of scalability, which I describe as very good
How are customer service and support?
I've never contacted them, but technical support within the environment itself isn't good. I'd rate it a three out of ten, but now if I can use my own technical support with GPT 3.5, it comes up to about an eight out of ten. It's a kind of hybrid support.
Which solution did I use previously and why did I switch?
We weren't using a similar solution previously. We would prototype from things like Excel or straight-off .TXT files. I had some experience and so did my business partner, and we just decided this looked like the right answer.
How was the initial setup?
That was pretty straightforward as I remember. It was a while ago now, but I don't remember any difficulties at all. I'd rate it a nine out of ten in terms of the ease of setup.
What's my experience with pricing, setup cost, and licensing?
It's free.
Which other solutions did I evaluate?
We did look at MongoDB, but it wasn't what we needed, so we decided we go with something a little more conventionally established, and MySQL absolutely fitted the bill. We didn't need anything else. We got some colleagues who used Oracle, but it's expensive and quite difficult to use.
What other advice do I have?
If you don't have any unusual requirements or absolutely vast databases, it's ideal. We certainly have no problems at all. It just works.
Overall, I'd rate it a nine out of ten. Nothing is perfect, but it's as good as we could have asked for.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
RPA Developer at Dimiour India Private Limitied
Efficient data loading, beneficial for data manipulation, and strong support
Pros and Cons
- "MySQL's most significant attribute is its capability to create, modify, and maintain databases. This is crucial and advantageous in procedures, such as SOAR. Therefore, all SQL functions are beneficial to any backend developer or developer who requires data storage."
- "Improvements to MySQL depend on the specific use case. For example, in my scenario, I frequently need to maintain and store data, which can then be utilized to generate reports. On the other hand, others may suggest incorporating a feature that allows for easier visualization of the data, such as what is available in Power BI or other similar tools."
What is our primary use case?
Below are a few instances where MySQL is utilized. Typically, I have worked on RPA projects. To preserve or update data from the database, I must create a database and data tables, which can be used again in the future or by other processes. Additionally, the data can be shared. I need to store and manage the data for reporting and management purposes.
The tasks I perform, mostly involve sorting, patching, and maintaining data, as well as creating stored procedures.
What is most valuable?
MySQL's most significant attribute is its capability to create, modify, and maintain databases. This is crucial and advantageous in procedures, such as SOAR. Therefore, all SQL functions are beneficial to any backend developer or developer who requires data storage.
The solution is easy to use and the user interface has worked well in my usage.
What needs improvement?
Improvements to MySQL depend on the specific use case. For example, in my scenario, I frequently need to maintain and store data, which can then be utilized to generate reports. On the other hand, others may suggest incorporating a feature that allows for easier visualization of the data, such as what is available in Power BI or other similar tools.
For how long have I used the solution?
I have been using MySQL for approximately five years.
What do I think about the stability of the solution?
I rate the stability of MySQL an eight out of ten.
What do I think about the scalability of the solution?
We have four to five people using this solution.
I rate the scalability of MySQL an eight out of ten.
How are customer service and support?
I rate the support of MySQL a nine out of ten.
How would you rate customer service and support?
Positive
How was the initial setup?
The initial setup of MySQL is simple. Anyone can do it.
I rate the initial setup of MySQL a nine out of ten.
What about the implementation team?
I can implement the solution by reading the documentation.
What other advice do I have?
We have been looking into another solution called Microsoft Dataverse but it's not accessible to all the processes for our use cases. Additionally, we are evaluating Amazon AWS. We are finding solutions to fit our client's needs.
If an individual is not currently utilizing MySQL, I would advise them to investigate its efficacy in managing and modifying data. Its numerous features can streamline these tasks significantly. For those interested in starting with MySQL, it provides an all-in-one solution for their needs, allowing them to complete numerous tasks with ease. Moreover, I would suggest using available tools to learn how to use MySQL effectively.
I rate MySQL a ten out of ten.
MySQL is user-friendly, making it easy to maintain and modify data. It offers robust security features that enable restricted access based on user permissions. Additionally, it's efficient in loading data and performs faster than many other databases. Users can expect speedy results without encountering significant delays.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
MySQL
December 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
829,541 professionals have used our research since 2012.
CEO at TMentors
Open-source and easy to implement but needs a lot of updating
Pros and Cons
- "It's a mature solution that's been around for decades."
- "It isn't as reliable as an SQL Server."
What is our primary use case?
We use the product for database management, as a database engine.
What is most valuable?
We use it for different projects, mainly when we have lots of data and the customer can't afford to pay the license of SQL Server, which is not a cheap one.
That's the main reason you use MySQL or Postgres or other databases. It's less expensive.
The solution is stable.
The scalability is very good.
It's a mature solution that's been around for decades.
It is very easy to set up the product.
What needs improvement?
The support in MySQL is horrible.
It isn't as reliable as an SQL Server.
I don't see MySQL being improved at all, like in the last 10 years. It has been at the same level for a long time.
What do I think about the stability of the solution?
Its stability is quite good. There are no bugs or glitches. it doesn't crash or freeze.
What do I think about the scalability of the solution?
The solution is scalable, however, sometimes you might have issues. You need to have the knowledge to make sure that you can scale. That said, there are a lot of used MySQL implementations all around the world, which shows that it's a proven product. It has been there for more than 20 years or so.
How are customer service and support?
The support is not ideal. It could be better. It runs under Oracle, and Oracle support is not the best company when it comes to supporting - especially since MySQL used to be a free, open-source solution, and remains free. Oracle doesn't have this approach in its DNA. It's an enterprise and they're not into open-source ways of working. That's why sometimes we move from MySQL to Postgres, which is similar yet has the support in the community.
Which solution did I use previously and why did I switch?
I've also used Postgre and SQL Server.
This product is not as solid as SQL Server. It's not like it's a lesser quality thing, however, it's not as reliable as SQL Server. The engine is a whole different engine. SQL Server is a full-featured database engine, and MySQL is based on what we call a file-based database. It's like flat files as a database engine, so it's an underdog, if you can call it that, when it comes to database engines. That said, it works fine.
How was the initial setup?
The initial setup is not that complex. It's simple and straightforward for the most part.
What's my experience with pricing, setup cost, and licensing?
The solution is open-source. We don't pay for it.
There are options to get professional support from Oracle and, for that, the pricing really comes up, therefore, it's not competitive anymore. For that reason, it might be even wiser to get Oracle Database than get MySQL and pay for the premium support.
What other advice do I have?
We are just end-users. However, we are happy to work with them.
With Microsoft, we are a customer, partner, and vendor. We aren't partners with Oracle.
I would rate the solution at a six out of ten.
They just need to assign a great team to MySQL, basically, and Oracle should just leave them alone to improve the product as the product hasn't been improved in the last 10 years. Since Oracle acquired it, it has been in decline. They need to do a lot, not in terms of features. In terms of the mindset.
I would recommend Postgres which is similar to MySQL, over this product. Even the clients are coming to us with such requests. They will flat-out tell us: "we hear that MySQL is having issues and we don't want to deal with Oracle and all that kind of stuff, so let's use Postgres." It's easy to migrate over. It's almost seamless, which makes it a very attractive option.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Executive Officer at Midland Bank Plc
Robust relational database management system offering flexibility and efficient data management for diverse applications
Pros and Cons
- "The installation process for the most scalable solution is remarkably quick, taking only a short amount of time."
- "While utilizing a comparable algorithm, is noted to be sensitive, especially when configuring the inner device."
What is our primary use case?
We use it for building web applications and managing data.
How has it helped my organization?
It is quite efficient and performs well, especially when compared to MSCS. While traditional scaling methods can occasionally lead to slowdowns, I haven't encountered similar performance issues with MySQL scaling.
What is most valuable?
The installation process for the most scalable solution is remarkably quick, taking only a short amount of time. While restoration may theoretically take longer, I've achieved rapid setup with my system, often within a minute.
What needs improvement?
While utilizing a comparable algorithm, is noted to be sensitive, especially when configuring the inner device. If DCDR is not properly recovered from NDC, it can lead to system slowdowns. There is a need for enhancements in the InnoDB cluster, specifically the capability to support more than two nodes in MySQL. Additionally, the inclusion of data nodes would be a valuable improvement. For users new to the system, it might pose a bit of a learning curve.
For how long have I used the solution?
I have been working with it for one year.
What do I think about the stability of the solution?
I would rate its stability capabilities eight out of ten.
What do I think about the scalability of the solution?
I would rate the scalability eight out of ten.
How are customer service and support?
When facing support issues with your server, the level of assistance is generally high. However, in certain technical support instances, when issues are raised and a ticket is generated, the support team sometimes provides a link for further information. From a customer perspective, this approach is not ideal, especially when dealing with critical problems such as database downtimes. The expectation is for more direct and personalized support rather than reliance on knowledge-base resources in urgent situations.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
I utilize Microsoft SQL Server (MSSQL) and MySQL for most of my databases. However, there are certain limitations in the new versions that impact support for certain functionalities. Due to these limitations, I have turned to MySQL as an alternative.
How was the initial setup?
The initial setup was straightforward. I would rate it eight out of ten.
What about the implementation team?
The deployment process, which took an hour, involves understanding various versions, especially the enterprise version, and confirming compatibility with the required features. Installation includes accessing the Oracle site, downloading MySQL, and dealing with complex considerations due to multiple business packages. Challenges may arise during the download of the DVD packet, requiring a careful assessment of the business needs for MySQL installation. The subsequent steps involve uploading MySQL VPN, reinstalling, and following a step-by-step approach, taking about five minutes. Despite the relatively swift deployment, managing dependencies and collecting necessary packets can be time-consuming and pose challenges for users. Maintenance requires only one person, especially if that person has knowledge of system administration. However, incorporating a software manager or other managing tools can be beneficial. Configuring and monitoring these tools doesn't necessarily require constant attention solely from the individual responsible for maintenance.
What's my experience with pricing, setup cost, and licensing?
It is an open source platform. While the free version of MySQL offers comprehensive features, it does come with limitations.
What other advice do I have?
Overall, I would rate it nine out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Consultant at a tech vendor with 10,001+ employees
A powerful tool that can perform multiple analyses and reveal hidden insights in datasets to its users
Pros and Cons
- "MySQL is a scalable tool. Scalability-wise, I rate the solution a nine out of ten...The solution's technical support is good. I rate the technical support a nine out of ten."
- "There should be an arrangement for end-users to get trained to use the tool...Improvement-wise, a graphical interface could be added for new users, eliminating the need to memorize the complex syntax."
What is most valuable?
MySQL can handle multiple rules of a database within seconds and extract required information for the business case, especially with well-optimized queries.
What needs improvement?
There should be an arrangement for end-users to get trained to use the tool. End-users don't know many things which MySQL offers to its users. So, there is a need for the end-users to upgrade themselves. Also, the tool is already good the way it is currently owing to its features like multithreading which helps with the queries quickly. In short, if one goes for the complex part, if one uses it for a very specialized case, then that person needs to write a very complex query involving multiple tables, multiple joints, and multiple conditions based on whatever scenario one uses.
Improvement-wise, a graphical interface could be added for new users, eliminating the need to memorize the complex syntax.
For how long have I used the solution?
I have used MySQL for five and a half years in my company, but I have used the tool for around ten years.
What do I think about the stability of the solution?
MySQL is a stable tool. Stability-wise, I rate the solution a nine out of ten.
What do I think about the scalability of the solution?
MySQL is a scalable tool. Scalability-wise, I rate the solution a nine out of ten. My whole company directly or indirectly uses the tool since we are involved in analytics. My company is an enterprise-sized one.
How are customer service and support?
The solution's technical support is good. I rate the technical support a nine out of ten.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
Since everyone in the industry we are a part of uses MySQL servers, we have also used the same.
How was the initial setup?
The solution's initial setup depends upon the use cases. If you're using it for a simple thing, it's a simple process. But, my problems and statements are quite complex, and I use them to get information, like how the customers perform based on cohort analysis. Also, my use cases are complex, so I have to write complex queries. Overall, the setup process depends upon the scenario.
The installation process is not difficult since it gets pre-installed in all the machines after it is done once. Since the installation process is neither very easy nor difficult, I can rate it somewhere around seven out of ten.
The IT Department handled the deployment process in my current company. Based on my experience deploying the solution in my previous company, its deployment was not difficult. Since everything was already deployed in my current company, we are using the tool as front-end users. When planning to start using the solution, we need to launch SQL server before using it. Also, based on whatever datasets are there, we need to get the permissions for those data sets, after which we are good to go.
MySQL requires maintenance, while the IT department handles the maintenance of SQL server. I am not involved in managing the upgrading part of the tool. Every year, MySQL keeps releasing new versions with new functionalities.
What other advice do I have?
My suggestion to those planning to use the solution is to learn about it and utilize it for their specific scenarios. It is a powerful tool that can perform multiple analyses and reveal hidden insights within multi-million or billion-row datasets that may not be immediately visible to the human eye. The tool also offers many use cases for machine learning. I encourage users to plan and explore the tool to discover its full potential. I rate the overall product a nine out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data Solution Architect at Econet Wireless Zimbabwe
Great cluster setup; works fine on the technical side
Pros and Cons
- "The way that MySQL has improved my organization is that it comes free and also works fine on the technical side."
- "The integration with other systems can be improved as can the integration between other databases."
What is our primary use case?
Our primary use case for MySQL is for our internally-built system. When our developers are doing the assistance, usually we provision them with the MySQL driver.
How has it helped my organization?
The way that MySQL has improved my organization is that it comes free and also works fine on the technical side.
What is most valuable?
The feature I found most valuable was the cluster setup.
What needs improvement?
The integration with other systems can be improved as can the integration between other databases. We have a workaround to integrate it with other systems but that can be improved.
In the next release, I would like to see better day-to-day support in case we face any issues.
For how long have I used the solution?
I have been using MySQL since 2008.
What do I think about the stability of the solution?
I would rate the stability of this solution an eight, on a scale from one to 10, with one being the worst and 10 being the best. We have a team of three DBAs supporting and maintaining this product.
What do I think about the scalability of the solution?
I would rate the scalability of this solution an eight, on a scale from one to 10, with one being the worst and 10 being the best. I believe MySQL very scalable.
How are customer service and support?
I would rate the technical support an eight, on a scale from one to 10, with one being the worst and 10 being the best.
How would you rate customer service and support?
Positive
How was the initial setup?
I would rate the initial setup process a nine, on a scale from one to 10, with one being the worst and 10 being the best. I would say that this process has been quite easy.
The deployment of this solution was done by an in-house team and it took around 30 minutes to one hour.
What's my experience with pricing, setup cost, and licensing?
I would rate the pricing of this solution a two, on a scale from one to 10, with one being not expensive and 10 being very expensive.
What other advice do I have?
I would recommend this solution to other people.
Overall, I would rate MySQL solution a nine, on a scale from one to 10, with one being the worst and 10 being the best.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Project Manager at Unimity Solutions
The performance is optimal, the speed is very good, and there are no delays in fetching data
Pros and Cons
- "The speed is very good."
- "At times, the autoscaling does not happen when there is a surge in load."
What is our primary use case?
We use the tool in projects with customer records in the database. There will be a front-end application to search and find specific data from the tool. In another project, there are product listings, and the front end fetches data from the tool and shows it in a gallery or list view on the web page or mobile application.
How has it helped my organization?
We used MySQL in a project for a nonprofit museum. They have a lot of donors. They have a large repository of customers who give donations. They categorize the customers based on the money they give, such as steward level, platinum level, and diamond level. The client may send out an invite for an event for a certain group of customers, such as the patrons who donate the most. MySQL helped us in that project.
What is most valuable?
The optimized process is valuable. I have seen websites that take ages to load and show the data. Many web applications with lakhs and lakhs of data will take forever to show specific results. The database performance is optimal for the application we developed. The speed is very good. There were no delays in fetching data from the back end and showing it on the front end.
What needs improvement?
At times, the autoscaling does not happen when there is a surge in load. We had to depend on manual scaling. It led to website crashes in the past.
For how long have I used the solution?
We have been using the solution for projects running for the past five years.
What do I think about the scalability of the solution?
Scalability is one area in which we are very cost-sensitive. We always closely monitor the charges to increase the server scale. It will help us use more space in the DB if there is an economical way for us to pick up larger servers. We have more than six lakh end users.
How was the initial setup?
Most of our projects are on the cloud. A very small number are on the client's premises.
What was our ROI?
We are continuing to use the tool because it's been cost-effective. It's producing revenue for us. It's a beneficial solution.
What's my experience with pricing, setup cost, and licensing?
The tool is open source. We choose open-source software mostly. We integrate a very limited number of licensed software.
What other advice do I have?
I have not seen any incident with a security violation or data breach. I have not contacted the technical support team. The infrastructure team contacts the technical support team regarding server-related issues. There is a LAMP stack. The Linux, Apache, MySQL, and PHP combination seems to be working well for enterprises' modern web applications.
Overall, the integration works well. However, initially, we worked with a third-party integration team to fix the APIs, query, and response code. Initially, some technical work will be needed. Once it is done, the integration turns seamless.
Overall, I rate the product an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
CEO at Les Roches International School of Hotel Management
An easy and convenient solution with good performance
Pros and Cons
- "MySQL is easy and convenient for me. I don't need to rely on anyone. I can write the code and extract the information. It is fast if you know how to use it. The solution is not expensive, and most of the developers know how to use it. It is easy to create tables. The solution is stable and has good performance. The connection with AWS gives regular updates, which is manual otherwise and a nightmare."
- "The tool needs to improve table visualization."
What is most valuable?
MySQL is easy and convenient for me. I don't need to rely on anyone. I can write the code and extract the information. It is fast if you know how to use it. The solution is not expensive, and most of the developers know how to use it. It is easy to create tables. The solution is stable and has good performance. The connection with AWS gives regular updates, which is manual otherwise and a nightmare.
What needs improvement?
The tool needs to improve table visualization.
For how long have I used the solution?
I have been using the solution for three years.
What do I think about the stability of the solution?
MySQL is stable and fast.
What do I think about the scalability of the solution?
The tool is scalable. Around 15-20 developers use the tool in my company.
How are customer service and support?
MySQL's technical support is good.
How was the initial setup?
The tool's installation is easy. You must download the app and log in using a password and username.
What other advice do I have?
I rate the product a ten out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros
sharing their opinions.
Updated: December 2024
Popular Comparisons
MariaDB
PostgreSQL
Firebird SQL
Faiss
OpenSearch
EDB Postgres Advanced Server
SQLite
Percona Server
YugabyteDB
Oracle MySQL Cloud Service
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which solution do you recommend for embedding reporting? Why?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Why are MySQL connections encrypted and what is the biggest benefit of this?
- Considering that there is a free version of MySQL, would you invest in one of the paid editions?
- What is one thing you would improve with MySQL?
- How does MySQL compare with Firebird SQL?
- When evaluating Open Source Databases, what aspect do you think is the most important to look for?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Which database is the best for session cashing?
- Which low-code (no-code) database solution do you prefer?