IT Central Station is now PeerSpot: Here's why
Vice President & Head of IT Governance at a financial services firm with 1,001-5,000 employees
Real User
Top 5
Good performance, but requires better scalability and more reliable stability
Pros and Cons
  • "The solution is great for small applications in particular."
  • "As an open-source product, there isn't really any technical support available if you get into trouble or have issues."

What is our primary use case?

We primarily use the product for small applications.

What is most valuable?

The solution is great for small applications in particular. The performance is good. The solution originally was designed as an open-source product. It has a community edition that anyone can use for free. The initial setup is simple and straightforward. 

What needs improvement?

I have doubts about its overall stability. It's something that they should look at. As an open-source product, there isn't really any technical support available if you get into trouble or have issues. There isn't much scalability potential in the product.

For how long have I used the solution?

I've been using the solution for a very long time. It's been years at this point.
Buyer's Guide
MySQL
June 2022
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
610,812 professionals have used our research since 2012.

What do I think about the stability of the solution?

The stability could be better. It's not as stable as I would prefer it to be.  It was originally designed as freeware, as an open-source project, and the community wrote the solution. However, they've made it worse over time. That said, the performance is pretty good.

What do I think about the scalability of the solution?

The solution is not that scalable. It's not something you should pick if you need something to expand significantly. While I can't speak to how many people use the solution in our company, I can say that it is used by several departments and divisions.

How are customer service and support?

The solution is open-source and managed by a community. Therefore, there is no technical support available to users. 

How was the initial setup?

The initial setup is very easy and quite straightforward. It's not overly difficult or complex.  That said, I was not a part of the original setup and therefore cannot speak to how long the deployment took my team.

What about the implementation team?

We didn't need any assistance from integrators or consultants. The setup was handled in-house.

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

The solution is open-source and free to use. We have the community edition. We don't have to pay to use it right now.

What other advice do I have?

Right now, Oracle has taken over the business of MySQL. Now, it's standard that you have to pay money for the license. That's why we are shifting all our databases, the small, small databases, from MySQL to Oracle. We do have extra data, so we do require a license. Currently, we are using the previous version of the solution. I can't speak to the exact version number, however. I'd rate the solution at a five out of ten. I wouldn't recommend it to other organizations at this time.

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.
Haitham Elwany - PeerSpot reviewer
IT Infrastructure & Data Platform Sr. Manager at a financial services firm with 1,001-5,000 employees
Real User
Top 20
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.
Buyer's Guide
MySQL
June 2022
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
610,812 professionals have used our research since 2012.
Sr. Solution Architect at a computer software company with 5,001-10,000 employees
Real User
Top 5Leaderboard
An easy to use solution which comes with a free stable version, but should have better integrative features
Pros and Cons
  • "The solution is easy to use."
  • "Integration is a key feature in need of improvement."

What is our primary use case?

With most open source products we were building, even the language was open source, such as that which employs PHP. This is where the MySQL free version was being primarily used by many of the clients in the storing of their data. 

There have been some great shoppers which we built with the solution. We use the solution to store the transactional data that we receive from various sites or have the data stored in MySQL. 

What is most valuable?

The solution is easy to use. As the query patterns are very similar to SQL, this simplifies the use and understanding of the solution. 

What needs improvement?

Integration is a key feature in need of improvement, as we have spent hours building this just to ensure that a set of data is exposed to a different client, a different world in need of that data. Since we are dealing with open source, which we are now employing in memory databases as well, it would be nice if they were to start thinking along those lines. 

For how long have I used the solution?

I have been dealing with MySQL for around a decade. 

What do I think about the stability of the solution?

I have found the free version to be stable. 

How are customer service and support?

I have not made use of technical support. 

What about the implementation team?

I was not involved in either the installation or deployment strategy. 

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

While I was not involved in those projects over the past year, we do have a couple of clients who choose to use the paid, enterprise version of the solution and who take full advantage of it.

What other advice do I have?

While the solution has, nowadays, moved to the cloud, the one I have been dealing with is on-premises.

Even though the solution has not been off the market, I do not possess the exact figures of those making use of it. It is still being used by a couple of our clients. 

I would recommend the solution to those interested in using the free, stable version of the solution which incurs no licensing costs. 

I rate MySQL as a seven out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Flag as inappropriate
Deputy Director General at a computer software company with 1,001-5,000 employees
Real User
Top 20
It is very easy to install and has all basic database features
Pros and Cons
  • "It is very easy to install and has all basic database features."
  • "We require more ease of use, scalability, and high availability. These are some of the critical features that we use and look for in a product. It should be easier to manage clusters. Scalability is very important for us because our projects and concurrency requirements are quite big. We also require high availability of the server, application, and other things. It should also have more performance-based features or enhancements from the performance point of view. When we divide a database, it should be able to handle the queries very fast."

What is our primary use case?

I have been working for 25 to 30 years in this domain, and during this time, I have used various products such as MySQL, SQL Server, and PostgreSQL. Currently, in my product, I am using PostgreSQL, and in some projects, I am using MySQL. We are using the latest version of this solution.

We do projects for various government departments. We have used this solution for the transport department for vehicle registration, driving license, and all such things. We have also used it for port projects, depots, educational counseling projects, school databases, higher education, and health registry. As an organization, we have a lot of use cases of this solution.

What is most valuable?

It is very easy to install and has all basic database features.

What needs improvement?

We require more ease of use, scalability, and high availability. These are some of the critical features that we use and look for in a product. It should be easier to manage clusters. Scalability is very important for us because our projects and concurrency requirements are quite big. We also require high availability of the server, application, and other things.

It should also have more performance-based features or enhancements from the performance point of view. When we divide a database, it should be able to handle the queries very fast.

How are customer service and technical support?

Whenever required, we also take support, but our people are quite experienced. They are able to manage it most of the time.

How was the initial setup?

Its installation is quite easy.

What about the implementation team?

We have our own people who do the deployment. We have various teams for various projects, and the size of the deployment team depends on the project. We have people who basically look after the DB activities, installation, and consolidation.

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

There is a licensing cost because we are going for a proprietary product. There are some other versions for which there is no licensing cost.

What other advice do I have?

I would recommend this solution depending on the project. If a project requires the kind of features that are available in this solution, I would recommend this solution.

I would rate MySQL an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
ARJUNMarya - PeerSpot reviewer
Enterprise Architect at a computer software company with 1,001-5,000 employees
Real User
I can meet the RPO in almost real-time
Pros and Cons
  • "MySQL's clustering features are very strong, and you can automate scripting, so that helps. We wrote a Terraform script and ran it."
  • "Rather than going in-depth about the technical features, which a technical person can directly tell, I would say that MySQL should be able to adapt to the next framework. The 5G framework means an unstructured framework. So if MySQL becomes smoother and more adaptable, it'll be easier."

What is our primary use case?

Our main use case for MySQL is for applications and seamless migration to the DR site. And the application in this case is an airport application.

How has it helped my organization?

I can meet the RPO in almost real-time. This changes the customer experience. That testing still needs to happen, but that is one of the advantages of MySQL. We have found MySQL to be a very sturdy and strong database. And I have run it in a solution where it's almost real-time, so it runs very efficiently.

What is most valuable?

MySQL's clustering features are very strong, and you can automate scripting, so that helps. We wrote a Terraform script and ran it. 

What needs improvement?

Rather than going in-depth about the technical features, which a technical person can directly tell, I would say that MySQL should be able to adapt to the next framework. The 5G framework means an unstructured framework. So if MySQL becomes smoother and more adaptable, it'll be easier. In terms of new features, automation is always the biggest demand from our customers.

For how long have I used the solution?

I've been doing pre-sales and working with MySQL since 2007.

What do I think about the stability of the solution?

I would say that MySQL is definitely stable, but its scalability has yet to be tested. I cannot say right now.

How was the initial setup?

We follow an agile strategy, so deployment is done in parallel. In comparison to other databases, I have always found MySQL to be the most efficiently managed. Of course, I don't discount Postgres, but MySQL deployment always has gone smoothly. I've never had an issue during migration, even on the granular level. UID numbers, which we commonly face in Microsoft SQL, have never been a problem with MySQL.

What about the implementation team?

We use the implementation partners for OEM. 

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

We get the standard packages, but mostly MySQL is freeware. You pay for a license to get the upgrades. We pay for an enterprise license if that is required, but that's not in every case. It depends.

What other advice do I have?

I would rate MySQL nine out of 10.

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.
Flag as inappropriate
Information Technology Infrastructure Manager at a comms service provider with 201-500 employees
Real User
Leaderboard
Feature-rich, cost-effective, and allows us to implement clustered solutions
Pros and Cons
  • "MySQL gives us all of the critical features that we need in a database, but without the costs."
  • "I would like to have features that allow us to jump between the cloud and our on-premises system."

What is most valuable?

MySQL gives us all of the critical features that we need in a database, but without the costs.

The most valuable feature is that we can implement clustered solutions.

What needs improvement?

I would like to have features that allow us to jump between the cloud and our on-premises system.

For how long have I used the solution?

I have been using MySQL for about 20 years.

What do I think about the stability of the solution?

MySQL is a very stable product.

What do I think about the scalability of the solution?

I know that it is scalable, and in fact, that is why we chose it. We always have it in mind that in some number of years, you have to scale the solution to something different in terms of architecture.

As it is now, our databases are not big. They are critical, but not large in size. We are not dealing with Big Data.

How are customer service and technical support?

We have never contacted Oracle for MySQL support.

The documentation that is available is enough for my needs.

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

This was the first database solution that we used. I have used other database products such as Oracle, for example. Oracle comes at a heavy cost.

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

This is an open-source product that can be used free of charge.

Which other solutions did I evaluate?

This is the product that was proposed to us and we implemented it.

What other advice do I have?

MySQL is a product that I can strongly recommend. However, it is important for you to have the in-house knowledge to support it. Some level of in-house expertise is necessary, otherwise, you will have to rely only on external opinions. In my opinion, that's not good. Sometimes they have good intentions but don't understand the reality.

I cannot give MySQL a perfect rating because we don't use all of the features. That said, I can tell you that I am totally satisfied with it. It's a very stable product and it's something that is not difficult to deal with.

I would rate this solution an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Director Of Sales Marketing at a energy/utilities company with 10,001+ employees
Real User
Top 5Leaderboard
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.
Flag as inappropriate
Project Manager at a tech services company with 51-200 employees
Real User
Top 5Leaderboard
A lightweight database that's easy to maintain and develop
Pros and Cons
  • "MySQL is a light database. It's not very complex. It's easy to develop, easy to maintain, and easy to back up and restore."
  • "We want to continue using MySQL but it merged with Oracle and the scalage changed."

What is our primary use case?

We use MySQL as a light database engine to provide database service to our web application. 

Almost all of our software engineers use MySQL.

We want to continue using MySQL but it merged with Oracle and the scalage changed. After they merged, we tried MariaDB. 

For two years, we tried MongoDB and prepared for application migration; all because the scalability changed when MySQL merged with Oracle. 

What is most valuable?

This solution is very easy to use. It's stable and very quick. MySQL is a light database. It's not very complex. It's easy to develop, easy to maintain, and easy to back up and restore. 

For how long have I used the solution?

Our software team has been using MySQL for more than eight years.

What do I think about the scalability of the solution?

It's hard to say if MySQL is scalable as we've never tried to scale it. 

How are customer service and technical support?

We have never had to contact support. 

How was the initial setup?

We installed MySQL Database on our server. It took roughly 12 to 13 minutes to install it. 

What about the implementation team?

Installation was done by our software team's engineers — seven to eight of them.

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

We've never bought a commercial license. We just use the open-source community edition. 

Which other solutions did I evaluate?

We evaluated other databases and products, including EnterpriseDB and PostgreSQL. The latter was scalable, but it wasn't easy to use. MySQL is much easier to use and install. Before MySQL merged with Oracle, our software engineers were very satisfied.

What other advice do I have?

We recommend MySQL to our customers and other partners. The only problem relates to the business strategy from Oracle. For this reason, most MySQL users are considering migrating to MariaDB.

Overall, on a scale from one to ten, I would give this solution a rating of nine. We're very satisfied with MySQL. If we could scale-out further, I would give it a ten. We need a database cluster or a scalable database solution for our future applications.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator