We changed our name from IT Central Station: Here's why
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
Systems Administrator at Dairibord
Real User
Top 5
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.
Flag as inappropriate
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
563,208 professionals have used our research since 2012.
Founder at a non-profit with 1-10 employees
Real User
Top 5
Easy to integrate and reasonably priced but the memory consumption needs to be improved
Pros and Cons
  • "The connectivity with PHP is quite good."
  • "On the database side, it should be really lightweight, and the data structure should be like MongoDB."

What is our primary use case?

We use this solution for the database.

What is most valuable?

The connectivity with PHP is quite good.

It is easy to integrate, and the fees are less than Oracle and other services.

What needs improvement?

MySQL is good but it should be able to handle the large transaction levels that Oracle can. It should be able to manage large amounts of data. We have experienced some issues when we are handling a large amount of data in MySQL.

The memory consumption it's using is very high at times, and the default parameter settings are not quite good automatically. We need to tweak the configuration as per the requirements. This is an area that can be improved by giving some guidelines and direction. 

On the database side, it should be really lightweight, and the data structure should be like MongoDB.

It should put less load on to the memory and it should be able to handle maximum data.

For how long have I used the solution?

I have been working with MySQL for approximately five years.

What do I think about the stability of the solution?

The solution is stable but there is an issue with memory consumption at times.

How are customer service and technical support?

I have not contacted technical support. I am using MySQL with Zabbix and when I have an issue, I contact Zabbix who resolves the issues on their end.

How was the initial setup?

I am a developer and I handle the other side of things. I rely on the DB team to handle the maintenance and deployment. My knowledge is very basic.

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

It's cheaper than other solutions.

What other advice do I have?

For one level of data, you can use MySQL. However, for large amounts of data, you will have to find other databases.

Overall, it's a good solution.

I would rate MySQL a six 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.
Flag as inappropriate
Ariful Mondal
Consulting Practice Partner - Data, Analytics & Artificial Intelligence at Wipro Ltd
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.
CEO at a computer software company with 11-50 employees
Real User
Top 5
Offers valuable security features and has good connectors and backup features
Pros and Cons
  • "Apart from the features that are in the enterprise part, we find the database to be valuable. The connectors and the backup features are valuable as well. We use the basic database. We don't really use the extra features. Our clients like the security features in the database."
  • "Oracle should start putting in some of the enterprise features in the standard feature. There are some key features that should be part of the standard."

What is our primary use case?

The main reason that customers pick MySQL is that it's cost-efficient.

What is most valuable?

Apart from the features that are in the enterprise part, we find the database to be
valuable. The connectors and the backup features are valuable as well. We use the
basic database. We don't really use the extra features. Our clients like the security
features in the database.

What needs improvement?

We would like to see more security.

For how long have I used the solution?

I have been using MySQL for three years. 

What do I think about the stability of the solution?

My customers haven't mentioned having any problems with stability. 

What do I think about the scalability of the solution?

Scalability is good enough.

How are customer service and technical support?

I haven't contacted Oracle in regards to MySQL but I have contacted Oracle support for other things. They're okay but from my end, the problem is that they're not proactive. From one to five, I would rate them a four. 

There's a lot of documentation on the Oracle support portal even though you must be contracted customer. There is also a lot of support information on the community portals and google search in general. This is the reason we picked MySQL from the rest.

How was the initial setup?

The initial setup isn't so complex. You have to get a lot of support from the
community. From my end, it's not so complex. You should consult with the
community.

What other advice do I have?

My experience has been open-source. Oracle should start putting in some of the enterprise features in the standard version. There are some key features that should be part of the standard. Things like replication should be part of the standard version as opposed to it being in the enterprise version.

I would rate them 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: Partner
Manager at a tech services company with 51-200 employees
Real User
Top 5Leaderboard
Has a lot of documentation and bug fixing is better in the latest version

What is our primary use case?

It is deployed on local servers, and we are using version 8. The whole company uses our database. Our users don't communicate with the database directly. They use a web interface. All programs are deployed using MySQL. We have hundreds of thousands of users accessing MySQL via the website. Two of us manage the database, but it's enough for only one person to manage daily operations. 

How has it helped my organization?

As we are using the latest version of the database, it has many functions that have improved it. There are many new features in this version, and it is more powerful in what it can achieve.

What is most valuable?

MySQL has a lot of documentation, and bug fixing is better in the latest version.

For how long have I used the solution?

What is our primary use case?

It is deployed on local servers, and we are using version 8. The whole company uses our database. Our users don't communicate with the database directly. They use a web interface. All programs are deployed using MySQL. We have hundreds of thousands of users accessing MySQL via the website. Two of us manage the database, but it's enough for only one person to manage daily operations. 

How has it helped my organization?

As we are using the latest version of the database, it has many functions that have improved it. There are many new features in this version, and it is more powerful in what it can achieve.

What is most valuable?

MySQL has a lot of documentation, and bug fixing is better in the latest version.

For how long have I used the solution?

We have been using MySQL for about 20 years.

What do I think about the stability of the solution?

It is very stable.

What do I think about the scalability of the solution?

MySQL is scalable. We didn't scale it via the database tools provided but on the program side. However, it is easy to scale it using the functions provided with the product.

How are customer service and technical support?

The support is fast and helps to find faster fixes to existing bugs. They recently advised us to downgrade to fix one particular bug, which resolved the problem we were having.We only use technical support for bug fixes, and the calls are usually closed quickly.

How was the initial setup?

I was able to install it myself in about half an hour.

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

MySQL is free.

Which other solutions did I evaluate?

We have also used PhpStorm and DataGrip.

What other advice do I have?

I would recommend that others use MySQL. I would rate it 10 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
Freelance Software Engineer + Director of a company at a outsourcing company with 1-10 employees
Real User
Top 5
Easy to install, easy to handle, and suitable for a limited amount of data
Pros and Cons
  • "My main reason for using MySQL for this small customer database company and for some kinds of scientific projects was that I had to do the installation myself. I didn't have a database administration team behind me. Therefore, I was looking for something very easy to handle. MySQL is easy to install, connect, and do all such things."
  • "Its scalability can be better. It is probably not as scalable as Oracle. I had some issues with connectors. I used it from a C++ program, and it required some work to make it run, but finally, it worked."

What is our primary use case?

I used it for a small customer database company in England with 20 employees. They didn't have that much data, and we needed something easy to install and easy to run. This was my use case for it.

What is most valuable?

My main reason for using MySQL for this small customer database company and for some kinds of scientific projects was that I had to do the installation myself. I didn't have a database administration team behind me. Therefore, I was looking for something very easy to handle. MySQL is easy to install, connect, and do all such things.

What needs improvement?

Its scalability can be better. It is probably not as scalable as Oracle. 

I had some issues with connectors. I used it from a C++ program, and it required some work to make it run, but finally, it worked.

For how long have I used the solution?

I have been using this solution for two or three years.

What do I think about the scalability of the solution?

I used it for a small customer database company in England with 20 employees. There were only two people using it. It was really a small solution. For this purpose, it was perfect, but I'm not sure how it scales. It was just not an issue in this case because we had very little data. 

How are customer service and technical support?

Their technical support is fine.

How was the initial setup?

It is easy to install. It takes just a few hours.

What other advice do I have?

I will probably keep on using this solution. If you have a limited amount of data you want to store in the database, and you don't want to spend a lot of time on administration, it is certainly fine. 

I would rate MySQL a ten out of ten. It was perfect for our use case. 

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Flag as inappropriate
Hector Cuna
Sysad Database Administrator Lead at USSC
Real User
Top 20
A stable solution with a community version, but the enterprise manager license should cover more virtual machines
Pros and Cons
  • "It has a community version. When I have to create a new database, I have no problems with licenses."
  • "It can have better monitoring. In addition, the enterprise manager should be able to cater to more than one virtual machine. Currently, you need one license per server. It seems a bit too much to get one license for one enterprise manager. I hope the enterprise manager for MySQL can accommodate more virtual machines for MySQL."

What is our primary use case?

We use it for financial transactions such as money remittance.

What is most valuable?

It has a community version. When I have to create a new database, I have no problems with licenses.

What needs improvement?

It can have better monitoring. In addition, the enterprise manager should be able to cater to more than one virtual machine. Currently, you need one license per server. It seems a bit too much to get one license for one enterprise manager. I hope the enterprise manager for MySQL can accommodate more virtual machines for MySQL.

For how long have I used the solution?

I have been using this solution for a decade.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

We have categorized the amount of data we have as big data, although we haven't really been using it much.

We have 2,000 people in our company, and we have over 100 virtual machines installed with MySQL.

How are customer service and technical support?

Because we are using the community version, we haven't had the chance to contact the technical support of MySQL.

How was the initial setup?

It is easy for us. After a few trials or installing it a few times, we have benchmarked and created best practices for installing it.

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

It has a community version.

What other advice do I have?

If you are not into command-line usage, I don't think MySQL is for you. I found MySQL easier to use by using the command line rather than by using the workbench. The workbench is comparatively slow, especially when exporting.

I would rate MySQL 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
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.