Try our new research platform with insights from 80,000+ expert users
Ismail Yushaw - PeerSpot reviewer
Supervisor at GGoC1
Real User
Top 5Leaderboard
A tool that offers an easy setup phase along with exceptional stability
Pros and Cons
  • "It is a very stable solution. I deployed the product six years ago, and it still works fine."
  • "The performance, stability, and security are areas with shortcomings in MySQL, where improvements are required."

What is our primary use case?

I started to use MySQL at some point when I had some issues that I couldn't get around. I normally use the tool in professional opportunities and when I require support from MySQL.

Cacti is a tool for monitoring devices on a network in graphical terms, for which it uses MySQL or MariaDB. I mostly deploy Cacti with MySQL or MariaDB. Somewhere down the line, I started to have some issues with the permissions in MySQL, including its areas like superuser privileges and similar stuff, which took me a while to figure out. I think the tool is fine for me now.

What is most valuable?

The most valuable feature of the solution stems from the fact that it helps me to get my work done. I am more interested in getting my work done than any feature it comes with since, as long as it gets my work done, it can actually help me achieve my objectives.

What needs improvement?

Nowadays, I use phpMyAdmin or MySQL WorkBench to manage MySQL. I would have been in a position to comment on what requires improvement if I had spoken about the tool three years ago. There are no improvements needed in the UI of the solution since many tools in the market help the user get the job done. MySQL WorkBench belongs to Oracle.

The performance, stability, and security are areas with shortcomings in MySQL, where improvements are required.

It would be a great improvement if the product could be made affordable enough for me to be able to access support from MYSQL, especially when I deal with mission-critical applications.

For how long have I used the solution?

I have been using MySQL since 2014.

Buyer's Guide
MySQL
March 2025
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
844,944 professionals have used our research since 2012.

What do I think about the stability of the solution?

It is a very stable solution. I deployed the product six years ago, and it still works fine.

What do I think about the scalability of the solution?

I won't be able to comment on the product's scalability since I haven't deployed it in a cluster environment.

Our company has over a thousand devices, including switches and a couple of other devices, which report to MySQL for management purposes. In general, MySQL is a very robust tool.

Which solution did I use previously and why did I switch?

Somewhere down the line, I got introduced to MariaDB as well. Nowadays, I use MariaDB rather than MySQL most of the time.

How was the initial setup?

The product's initial setup phase is easy since I use package management software. I mostly take care of the deployment phase with the help of Docker and other tools. If you decide to use the default deployment settings provided by MySQL, then it is a straightforward process to deploy it.

A lot of things have changed since I have deployed the solution. The solution is like a new product nowadays since you just need an application to deploy it presently. The other area where you need to take care of the solution is knowing how to secure it very well so that it becomes less vulnerable and prevents people from taking advantage of the solution.

Mostly, I go to the MySQL website to download the binaries, and I just deploy them on a Windows machine or another system, which is just a straightforward process. The product's installation phase is not much of a problem.

The solution is deployed on an on-premises model.

Earlier in my company, there were three people who used to take care of the deployment of the solution, but presently, I don't know who handles the deployment part.

What was our ROI?

In the past, the product was free for users, which ensured that users could experience a high return on investment from the use of the solution. I don't know the licensing models attached to the solution currently, but the return on investment is very high if you use it for a very limited amount of time.

Which other solutions did I evaluate?

MySQL was one of the tools I was introduced to from the very beginning when I was in school. Though I knew about Microsoft SQL Server, the lectures in my school did not introduce me to it since more focus was placed on MySQL. I find MySQL easier to use compared to Microsoft SQL Server.

What other advice do I have?

I recommend the solution to those who plan to use it since it is a very good product that comes to my mind since it is always available. I don't know about the current licensing model of the product because it was an open-source tool earlier. I don't remember myself attempting to check what kind of license MySQL uses presently. In the past, Microsoft SQL Server used to cost a lot of money, which my company couldn't afford at that time.

I rate the overall system an eight 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.
PeerSpot user
Ertugrul Akbas - PeerSpot reviewer
Manager at ANET
Real User
Top 20
Easy to use, fast, and developer-friendly, but it should have better support for big data
Pros and Cons
  • "MySQL is a popular database platform for businesses because it is extremely easy to use."
  • "When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL."

What is our primary use case?

We developed a network monitoring software and used MySQL as a backend database.

We utilized the two most common and popular MySQL database engines, MyISAM and InnoDB.

We store collected monitoring data and configuration data on MySQL. Also, our network monitoring solution reporting module is based on the MySQL MyISAM database engine.

We use both Windows and Linux versions of MySQL, and we utilize the backup and recovery features.

To summarize, our primary use case is the embedded DB component for our network management software.

How has it helped my organization?

MySQL is a popular database platform for businesses because it is extremely easy to use. It is commonly used in combination with PHP and Java. For instance, someone with little to no knowledge of MySQL can easily establish a database connection and start programming immediately.

So MySQL improved our developing process speed. MySQL is a very popular and well-known database solution, so it is easy to find a MySQL developer.

MySQL performance also improved our NMS solution performance.

What is most valuable?

MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses.

MySQL advantages and valuable points include:

  • MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
  • MySQL uses a standard form of the well-known SQL data language.
  • MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, Java, etc.
  • MySQL works very quickly and works well, even with large datasets.
  • MySQL is very friendly to PHP and Java at the same time. Both PHP and Java are our development languages.

What needs improvement?

The two most common and popular MySQL database engines are MyISAM and InnoDB. Database engines provide the underlying functionality for MySQL to work with and process data. MyISAM is the default engine for MySQL for versions earlier than 5.5.5 and functions well in most scenarios.

However, depending on your needs, there are situations where another database engine, such as InnoDB, may be the better choice. For example, InnoDB supports transactions, whereas MyISAM does not. InnoDB also provides support for foreign keys, whereas MyISAM does not.

When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL. An example of this is the Vertica DB engine (https://en.wikipedia.org/wiki/...), and offering support for it would be valuable.

For how long have I used the solution?

We have been using MySQL for more than ten years.

Which solution did I use previously and why did I switch?

Previously, we used MSSQL and switched to MySQL because of performance issues.

How was the initial setup?

After installation, the maintanence is easy for an end-user.

What's my experience with pricing, setup cost, and licensing?

MySQL is released under an open-source license, so you have nothing to pay to use it.

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.
PeerSpot user
Buyer's Guide
MySQL
March 2025
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
844,944 professionals have used our research since 2012.
PeerSpot user
Global Data Architecture and Data Science Director at FH
Real User
ExpertModerator
Open-source, good documentation, and the multiplatform support includes Linux, Windows and Mac
Pros and Cons
  • "It's a good tool, a good database platform."
  • "It could be more secure."

What is our primary use case?

I used MySQL for academic purposes. I use it for learning purposes.

You can start anything with MySQL.

You can build your own app, and store your data.

It's a free solution for development purposes.

What is most valuable?

It's a good tool, a good database platform. Everything you can do, you can do for free.

I like that it's open-source and that it's free. 

What needs improvement?

Typically security will be on a security layer. I haven't really looked into the security of it, but it should be good.

It could be more secure.

For how long have I used the solution?

I have been using MySQL for 16 or 17 years.

What do I think about the stability of the solution?

It's a stable solution.

What do I think about the scalability of the solution?

We have trained hundreds of users.

I will continue to use this solution for learning purposes.

How are customer service and technical support?

We have not contacted technical support.

How was the initial setup?

You can download it and start using it.

It's very easy to install. It's a one-click Windows installation.

You can install and configure everything in a half-hour to one hour.

There is a lot of documentation available.

The maintenance can be done by anyone who has installed and used it.

What's my experience with pricing, setup cost, and licensing?

I have never used the enterprise level of MySQL. 

I use the open-source free community version.

I am sure that the Enterprise version of MySQL is cheaper than Microsoft SQL Server, or IBM and Oracle.

It's cheaper than other tools. 

What other advice do I have?

For anyone who wants to learn SQL, MySQL is free on Linux, Windows, or Mac Operating Systems.

MySQL can be deployed anywhere on the cloud or on a PC.

I would rate MySQL an eight out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Systems Administrator at Dairibord
Real User
Great performance and useful for running email system
Pros and Cons
  • "One of the most valuable features is MySQL's ability to run our email system. We use a system called Colab."
  • "MySQL could be improved by adding more automation."

What is our primary use case?

Our primary use case for MySQL is for running applications on our Linux boxes. We have very few applications that run online, but we use MySQL on those boxes, primarily for our email system. We haven't considered working on cloud, so all our solutions are on-premises. 

What is most valuable?

One of the most valuable features is MySQL's ability to run our email system. We use a system called Colab. 

What needs improvement?

MySQL could be improved by adding more automation. There are no additional features I would like to see that I can think of at the moment. 

For how long have I used the solution?

I have been using MySQL for a few years. 

What do I think about the stability of the solution?

This product is stable. I'm very satisfied with the performance. 

What do I think about the scalability of the solution?

Since MySQL is running our email system, there are around 200 users. It's installed on one of the servers and the admins are the ones who interact with the system itself if the need arises. 

How are customer service and support?

I have never contacted Oracle's technical support. If we have any issues, we've got some recommended support people here in Zimbabwe that we contact. 

Which solution did I use previously and why did I switch?

I didn't use any other solution before implementing MySQL. We also use MariaDB, but not on a very big scale.

How was the initial setup?

The installation was a very straightforward process. It took about a day and we did it ourselves. 

What about the implementation team?

We implemented through an in-house team. One person, the admin, can handle it. 

What's my experience with pricing, setup cost, and licensing?

We are using the free version of MySQL. We prefer paying for a yearly license. 

Which other solutions did I evaluate?


What other advice do I have?

I rate this solution an eight out of ten. I would recommend this solution to others and I'm very satisfied with its performance. 

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.
PeerSpot user
reviewer936300 - PeerSpot reviewer
Director Of Sales Marketing at a energy/utilities company with 10,001+ employees
Real User
Quick to deploy, stable, and scalable
Pros and Cons
  • "The deployment process is pretty fast."
  • "When I run into issues, I really have to research how to fix them."

What is our primary use case?

The solution is primarily used for mobile applications and IoT-based services. It's a good choice for development. 

What is most valuable?

The solution is very stable.

The scalability has been great.

The deployment process is pretty fast.

What needs improvement?

It would be ideal if the solution had more references available in terms of helping me find answers to issues or problems. When I run into issues, I really have to research how to fix them. 

The installation process could be better.

I would like the product to have even better stability and scalability.

For how long have I used the solution?

I've been using the solution for a couple of years.

What do I think about the stability of the solution?

The solution is very stable. There are no bugs or glitches. It doesn't crash or freeze. It's reliable. 

What do I think about the scalability of the solution?

The solution is scalable. If a company needs to expand it, it can do so. It's easy.

We have 500 users on the solution at this time. We are likely to increase usage in the future. 

How are customer service and support?

We don't really have access to technical support. Our engineers have to spend time looking for answers on Google. 

Which solution did I use previously and why did I switch?

Previously, we only used Oracle databases, which were expensive. We've moved away to other DBs and have begun to use MySQL.

How was the initial setup?

The installation process didn't take very long. It took about three or four hours.

We have five people, who are engineers, that can handle setup and maintenance tasks. 

What about the implementation team?

I handled the implementation myself. I did not need the assistance of any integrators or consultants. 

What's my experience with pricing, setup cost, and licensing?

You do need a license in order to use MySQL.

What other advice do I have?

The solution can be deployed both on the cloud and on-premises. 

I'd rate the solution at an eight out of ten.

I would recommend the solution to other users and organizations. 

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.
PeerSpot user
IT Infrastructure & Data Platform Sr. Manager at a financial services firm with 1,001-5,000 employees
Real User
Lightweight with good performance, but deployment with clustering needs to be simplified
Pros and Cons
  • "This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge."
  • "The product is a little bit complex and it is difficult to find sufficient documentation."

What is our primary use case?

I am a senior manager of the infrastructure team and MySQL is one of the products that I work with. We use it in an e-commerce portal. The database is light and everything works smoothly.

What is most valuable?

The performance is great.

This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge.

What needs improvement?

We faced some details in clustering, although this may have been because we did not have enough knowledge about MySQL clustering. In general, an easier implementation for clustering would be an improvement.

The product is a little bit complex and it is difficult to find sufficient documentation.

For how long have I used the solution?

We have been using MySQL for approximately six months.

What do I think about the stability of the solution?

We have not had any problems with stability.

What do I think about the scalability of the solution?

MySQL is easy to scale.

How are customer service and technical support?

We have dealt with Oracle support regarding other products such as Oracle Database and Oracle WebLogic. I believe that it will be of the same standard, although I'm not sure.

I am not a technical person but my understanding is that they are competent.

My complaint about them is that when we have a problem, we have to explain the same thing many different times to different engineers. Every time we engage with a new engineer, we have to start all over again. This is a nightmare that we chased three months ago.

Which solution did I use previously and why did I switch?

In addition to MySQL, we use Oracle and Microsoft SQL Server.

Oracle is an enterprise-level product but it is very straightforward to install and it has sufficient documentation and guides, which we did not easily find for MySQL.

How was the initial setup?

Implementing clustering depends on a few different layers or different components. The clustering layer handles requests from the applications, and it is all a bit more complex than Microsoft SQL Server or Oracle.

The design, review, and deployment took approximately one week.

What other advice do I have?

At the moment, because of the issue that we are having with the clustering, I may not recommend MySQL. It would first need to have the clustering problem fixed and then have a sufficient deployment guide. 

I would rate this solution a seven 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.
PeerSpot user
Waqar Malik - PeerSpot reviewer
System Analyst at National University of Sciences and Technology
Real User
Top 10
There are no costs involved in its use
Pros and Cons
  • "The tool is open-source and there is no cost involved in its use."
  • "I would like to see some improvements in the solution’s integration aspects."

What is our primary use case?

We use MySQL for storing data on the web server. It is a competitor of Apache. The solution can also be used for analytics, warehousing, and Big Data.

What is most valuable?

The tool is open-source and there is no cost involved in its use.

What needs improvement?

I would like to see some improvements in the solution’s integration aspects.

For how long have I used the solution?

I have been using MySQL for ten years.

What do I think about the stability of the solution?

We have optimized and stabilized the solution over a period of eight to six months.

What do I think about the scalability of the solution?

There are around 60 plus users for the tool in our company.

How was the initial setup?

There is a 25 member team involved in the tool’s maintenance and deployment.

What other advice do I have?

I would rate the solution a seven out of ten. The solution’s users have the liberty of custom management. We can implement the solution in Azure, which is Microsoft’s advanced version.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1788699 - PeerSpot reviewer
Managing Director at a financial services firm with 201-500 employees
Real User
Fully scalable relational database management system with good stability; setting it up was easy and straightforward
Pros and Cons
  • "Fully scalable and stable SQL-based RDBMS, with a straightforward and easy setup."
  • "Even for the best database, we always want the database to perform much better, so we wish MySQL would be much better, in terms of performance."

What is our primary use case?

We're using MySQL for data warehousing and logging.

What needs improvement?

Even for the best database, we always want the database to perform much better, so we wish MySQL would be much better, in terms of performance. When they release a new version, they mostly concentrate on scalability and performance.

For how long have I used the solution?

I've been using MySQL for seven years.

What do I think about the stability of the solution?

The stability of MySQL is good.

What do I think about the scalability of the solution?

MySQL is a fully scalable product.

How was the initial setup?

The initial setup of MySQL was easy and straightforward. You can complete the initial setup for this product within a few hours.

What about the implementation team?

It was the technical team who did the setup for MySQL. We had two or three engineers who took care of the deployment and maintenance of this product.

What's my experience with pricing, setup cost, and licensing?

MySQL is very cheap. In fact, it could be free. They also have a yearly licensing option. I don't remember paying for additional costs, aside from the standard licensing fee.

Which other solutions did I evaluate?

I evaluated Oracle Database.

What other advice do I have?

I'm using the Enterprise version of MySQL.

MySQL is a good database. We are using it, and we'll continue to use it.

I've never contacted the technical support team for MySQL. I have no complaints.

I can recommend MySQL to others who plan to start implementing it.

We don't ask for new features on a database. When we take a database, we take it because of fixed features, e.g. its current features. It's not an application. It's a database. We are fine with whatever features MySQL offers now. We never really thought about whether we want more features on this product.

I'm rating MySQL an eight 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.
PeerSpot user
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2025
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.