No more typing reviews! Try our Samantha, our new voice AI agent.
reviewer937698 - PeerSpot reviewer
Principal Software Engineer at a manufacturing company with 1,001-5,000 employees
Real User
Oct 20, 2021
Free, stable, and full-featured
Pros and Cons
  • "It is free, which is probably its most valuable feature, and it is a pretty full-featured relational database that really does everything we need it to do."
  • "The availability of tools could be improved in the MySQL open-source platform. They can provide more analytical tools. I haven't had any particularly difficult issues to troubleshoot on MySQL, but in the past, on Microsoft SQL Server, I had to troubleshoot some difficult issues, and better tools were in place to see what was going on in real-time on the server. So, that's the bit that is lacking on the MySQL open-source platform."
  • "There are certain things that it doesn't do as well as SQL Server. There are certain things that you can do to swamp the server, such as it is just not very responsive to more complicated joins and things like that."

What is our primary use case?

We're on a software development team. We develop applications.

We're currently running version 5.7 of MySQL, and we are going to be upgrading to version 8 this year.

MySQL server currently is in a co-location center. We've got a hosting provider that takes care of that for us. We are looking at moving it into AWS, but that won't happen this year. We do have a smaller MySQL RDS instance in AWS right now, but it is pretty minimal. 

What is most valuable?

It is free, which is probably its most valuable feature. It is a pretty full-featured relational database. It really does everything we need it to do. 

What needs improvement?

The availability of tools could be improved in the MySQL open-source platform. They can provide more analytical tools. I haven't had any particularly difficult issues to troubleshoot on MySQL, but in the past, on Microsoft SQL Server, I had to troubleshoot some difficult issues, and better tools were in place to see what was going on in real-time on the server. So, that's the bit that is lacking on the MySQL open-source platform.

For how long have I used the solution?

I have been using MySQL for seven years in my current company, and I have probably used it for another two or three years in a previous company.

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

What do I think about the stability of the solution?

It is very stable.

How are customer service and support?

I haven't dealt with them.

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

We're using the open-source version right now, which is free. I do see some value in some of the more enterprise functions. We're using the open-source version right now, and I was interested in the MySQL Enterprise version really for the tools that they provide, but we decided not to make the purchase.

What other advice do I have?

There are certain things that it doesn't do as well as SQL Server. There are certain things that you can do to swamp the server, such as it is just not very responsive to more complicated joins and things like that. Unfortunately, you have to try to learn what those things are, but there are certain things like correlated sub-queries and more complicated approaches that it doesn't support, and you can hang the server in doing that. So, even though it has standardized the SQL queries and other things, there are some things that it doesn't perform particularly well, such as more complicated joined scenarios. We join several tables at a time, but we tend to do that on well-known indices, primary keys, and things like that, but if you're doing something more sophisticated than that, it becomes more challenging. These things that I've mentioned are written up by people, and once you learn those things, you develop techniques to work around them. You take different approaches to solve the problem for those things. You have to do that anyway as a developer. You don't just write code and throw it out there on a production server. You certainly need a totally separate test environment and all that.

I would rate MySQL an eight out of 10.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
PeterKrall - PeerSpot reviewer
Freelance Software Engineer + Director of a company at Peter Krall Consulting
Real User
Apr 29, 2021
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."
  • "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."
  • "Its scalability can be better. It is probably not as scalable as Oracle."

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
PeerSpot user
Buyer's Guide
MySQL
October 2026
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: October 2026.
921,840 professionals have used our research since 2012.
Kevin Honde - PeerSpot reviewer
Data Solution Architect at Econet Wireless Zimbabwe
Real User
Apr 8, 2021
Free and easy to use but needs better backup functionality
Pros and Cons
  • "The solution has been very easy to scale so far."
  • "MySQL is compatible with most of the platforms."
  • "The backup methods need improvement."
  • "The backup methods need improvement. MySQL needs to improve its backup methods so that you can actually do a backup without affecting products."

What is our primary use case?

We are primarily using it as a database for our products. For internally built systems, we have MySQL. We use it internally.

What is most valuable?

It's our database due to the fact that it's cheaper and is actually free to use.

The product is very easy to use, yes.

It's quite stable.

The solution is very compatible with many versions of Linux. Most of Linux is free, so it's easy to implement with MySQL. Whether it's Ubuntu, CentOS, or different types of Linux, it's the same across other operating systems, and therefore it's very easy to use and compatible with any demand that comes from developers. At the end of the day, MySQL is compatible with most of the platforms.

The solution has been very easy to scale so far.

The installation process is very easy.

What needs improvement?

The backup methods need improvement. MySQL needs to improve its backup methods so that you can actually do a backup without affecting products. Currently, when you're doing your backup, it locks the database. When someone tries to access it during a backup, it fails to read or to update. They can improve on the backup and all the backup features in general.

For how long have I used the solution?

I've been using the solution for more than five years at this point. It may be as much as seven years or so.

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 in terms of performance.

What do I think about the scalability of the solution?

The solution is very scalable. If you want to install it in the machine and scale that machine, you can do so. Or you add more machine nodes whereby you are actually clustering items and you're clustering your database within one site. The solution will actually extend these needs to another site for replication, DR replication.

We have about 20 people using the solution currently.

We do plan to continue to use the solution in the future.

How are customer service and technical support?

All of our support is internal. We haven't subscribed to outside technical support.

That said, we haven't had any issues with the solution that would require support assistance either.

How was the initial setup?

The initial setup is not complex at all. It is very easy to install as most of the Linux comes embedded so that even if you're under a different administrator, you should be able to just click and install.

Installation doesn't take more than 10 minutes for me. It might take up to 30 minutes or an hour for someone who is new. However, for someone who is used to MySQL, doesn't take more than 10 minutes to set up.

For deployment and maintenance, basically, we would need about three engineers. The one that actually does the hardware infrastructure, the one that does the operating system, and then the one that actually does the MySQL, which is the database administrator.

What about the implementation team?

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

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

The solution is absolutely free to use. It's one of the reasons we've chosen it.

Which other solutions did I evaluate?

We do evaluate other solutions. We also use other products, such as Oracle's SQL server.

When a trace comes for MySQL, we will check mostly the cost of installation and the cost for maintaining everything. We are choosing MySQL over the others that are actually licensed solutions mostly due to the fact that MySQL is free.

What other advice do I have?

We are just customers and end-users. We don't have a business relationship with MySQL.

I'd recommend the solution to other organizations.

I would rate it at a seven out of ten overall. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1456815 - PeerSpot reviewer
Specialist Geosciences Data Consultant at a energy/utilities company with 10,001+ employees
Real User
Feb 28, 2021
Simple to use, good for data manipulation and creating views
Pros and Cons
  • "The most valuable component for me is SQL Developer, it is pretty simple to use and I don't have anything really bad to say about it."
  • "I would like to have the ability to cancel a query in SQL Developer."

What is our primary use case?

My daily tasks are related to data mining and TBICO Spotfire is one of the products that I use. We are a small group of geologists operating in a niche area who are analyzing geochemical data. Our backend database is MySQL and we use products such as Power BI, Tableau, and Spotfire to display data for the geochemists.

I perform data-related tasks such as data manipulation and creating views, then updating the database afterward, all using SQL queries. As part of this, I'm making entries as needed or corrections to data that has already been processed.

How has it helped my organization?

Essentially, I'm doing data mining with SQL queries, although I wouldn't call what I am doing Data Mining exactly, because I already know the data model. I know the geochemistry data in my head, so I already know what I'm looking for when I write an SQL query. We're not doing machine learning or AI at this point, although it may come in the future.

Every now and then, we create dashboards for the geochemists, which cover their needs from the data.

What is most valuable?

The most valuable component for me is SQL Developer. It is pretty simple to use and I don't have anything really bad to say about it. It supports multiple window displays and all of the connections are available. A lot of people use Toad for this type of work, but I have not myself.

The functionality that I use most often is querying the data model.

What needs improvement?

I would like to see an autocorrect option, where if you're typing a query and you enter a comma instead of space, or something similar, the ability for it to be able to understand based on your previous scripts would be an advantage. For example, if you were to put a comma between your AND statements then it's not going to work. Maybe a smarter application where, as you're writing queries, similar to the way that grammar and spelling are checked when you type a text message on an iPhone, it could be autocorrected.

I would like to have the ability to cancel a query in SQL Developer. Specifically, I would like to be able to cancel the query should I accidentally write one that's going to loop, or have a JOIN wrong, where you get millions of records joining with millions of records over and over again. The availability to hit cancel so that it doesn't keep running would be helpful because, when such a thing happens, then you have to shut down the whole application and you lose any queries that you might've typed before.

For how long have I used the solution?

I have been working with MySQL for approximately nine years.

What do I think about the scalability of the solution?

This application is pretty easy to scale.

Within my department, which is technical data management, approximately 75% of the people use MySQL.

How are customer service and technical support?

I have never had to deal with technical support from Oracle directly. We just raise tickets that go up and show operations, and in turn, they are the ones that deal with Oracle.

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

I have used several versions of Oracle MySQL including 10, 11, and 12, and I don't really see any difference between them.

How was the initial setup?

MySQL comes pre-installed with our new PCs, so I have never been involved with the initial setup.

What about the implementation team?

On the operations side, based on what I have seen in terms of people putting in tickets for issues, it seems that we have three people who support and maintain MySQL at different levels. I feel that having this number of resources assigned to maintaining a database is wasteful.

I think that a single person can be in charge of maintaining multiple databases.

Which other solutions did I evaluate?

As a data analyst, I am not in operations and don't have a say in which products we use.

What other advice do I have?

My advice for anybody who is implementing MySQL is to ask around because there are many different ways that you can create a database now. Relational databases are no longer the best way to organize your data. It really depends on what it is that you're doing. For example, you may not need a relational database, but instead just a file structure. So, look at all of your options and speak with the experts to see what kind of database is needed before assuming that you need an RDBMS.

I would rate this solution an eight out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1461639 - PeerSpot reviewer
Deputy Director General at a computer software company with 1,001-5,000 employees
Real User
Dec 13, 2020
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."
  • "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."
  • "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."
  • "We require more ease of use, scalability, and high availability."

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
PeerSpot user
Patryk Golabek - PeerSpot reviewer
CTO at Translucent Computing Inc
Real User
Aug 5, 2020
Good beginner base but it should have better support for backups
Pros and Cons
  • "This specific version of this MySQL has been battle tested for a long time. Any issues are known issues and we pretty much don't have any problems when they're in production. So it's very stable."
  • "In terms of what I'd like to see in the next release, one thing that's always missing is dash boarding. There's no real BI tool for MySQL, like there is in Yellowfin and all the different tools that you get. They all have MySQL connectors, but there's no specific BI tool for MySQL. These open source projects have sprung up, but they're more general purpose."
  • "The cluster is not the best when it comes to MySQL; that's why we switched to MariaDB, for that simple reason that the cluster there is better, more manageable, and easier to work with."

What is our primary use case?

We use multiple models here because we do full development. What we deploy on MySQL is from the Helm chart or it's a Dockerized deployment of MySQL. So we're using the Helm stable chart right now. That's sort of the easiest way to deploy it - to say just one command and it bootstraps your whole database within your classical means or cluster. You can do it locally with mini-crews or developers, for organizational use, or Kubernetes. It's single-node Kubernetes.

Also, you can just deploy MySQL locally with a Helm chart. Regarding production, we have a kind of automated process which is similar to what Spinnaker deploys, with a Helm chart as well as within the cluster. Some other solutions we don't run within the cluster, we use the Cloud version of the database which is Cloud SQL, Google Cloud, and AWS. Those are fully managed ones, of which there are two versions. We have our self-managed version which we run locally and with our DEV cluster and then there is production, as well.

We also use a self-managed version since every cloud provider offers MySQL, even AWS. It depends on the client's needs, how flexible the client is, and also how comfortable they are with MySQL.

We either go with our managed version or the Cloud version. Both are supported because today the Mica server that's actually accessing the database or the piece of software just needs a connection string, it doesn't care if it's running within the Synchronous Cloud. If it's running somewhere else in the Cloud, it's still a private connection on the same network.

So the only differences here are in terms of money costs and whether it's managed or not managed. So for local development, you don't want to have a managed database in the Cloud. You don't need to be tethered to the Cloud, you'd rather just deploy locally. And because we have the same deployment scripts that run locally in DEV and testing, we use the same Helm chart and the same Docker version with MySQL to distribute that through our DEV environment to test the bills and run the test and there is a full QA environment for teaching, as well.

What is most valuable?

I treat these products kind of as a throwaway versus what a DBA would be. From an organizational point of view, it's difficult to actually define the most valuable features because we have so many different databases. For some of them, Postgres for example, which uses MySQL, is just personal preference with is no real difference. Unless you get to really high volumes or through-putting. So in our case, because of legacy reasons, we started using MySQL, which was a popular database. It's not a bad database, so there was no reason for us to change it to the Postgres. We do use Postgres right now for other tools, but for a main database for application purposes, we still stick to MySQL. And I think it's just because of legacy, there's no real advantage of one over the other right now.

We built up the scripts already. Because once you start integrating the scripts into your company, your deployment scripts, test scripts, etc. you just leave it over time because it takes effort to change. But in terms of advantages or features, you can go feature by feature with any database and if you add up the totals, there's no real advantage here between Postgres or MySQL.

What needs improvement?

As for what can be improved, right now we don't use the MySQL cluster. There is a MySQL cluster that you can run in a standalone mode, like a single database or you can do it in a cluster master-slave implementation. The cluster is not the best when it comes to MySQL. That's why we switched to MariaDB. For that simple reason that the cluster there is better. It's more manageable and it's easier to work with.

We decide what to use depending on the needs. For example, if we need to mount something in a cluster mode, we use MariaDB, which again, is a Dockerized solution with a Helm chart as well, and it's very easy for us to deploy and manage, and also to scale when you just increase the number of slave versions. So MySQL doesn't have that great support when it comes to clusters. You can definitely use MySQL for that too, both support clustering, but the MariaDB is better.

Additional features that I would like to see included in the next release of this solution include better support for backups. Because if you go with the MySQL Percona version, it gives you the tools to back it up securely. The vanilla version of MySQL doesn't have that. It actually does have it, but it is just really poorly executed. I would improve the backup system as well as the encryption. To make it smoother right now takes too much work. It should be a little bit smoother to backup the encrypted data the way you want it and have the ability to push it anywhere you want. That is not part of it right now.

Now it is a database, so you don't know what you're going to do with it. It's difficult. You're just going to come up with solutions. But I think you can generalize here and come up with really simple solutions, which we have already in MySQL. That's probably the one thing that I would try and push right now for people to switch. But people are still not biting, because if you go with the managed version, then all the backups are taken care of for you by Amazon or Google or Microsoft. Then you really don't care. But for us, since we're doing it locally, self-hosted, we would like to have better tools for locking up the data.

Right now, one aspect that is also linked to backups is running things in a crosscheck with semi-managed solutions. This requires a bit of a context. Since we're running things within the clustered communities, we're kind of pushing the Cloud into the cluster. We also want to push some of the tools for the database into a cluster, as well. So these are what we call Kubernetes operators. And there's MySQL operators that were first developed by the community. Those kind give you the ability to backup data within the cluster. So now you have a fully managed solution running from your cluster. These are called MySQL Kubernetes operators.

We are looking into those right now to upgrade our solution, which would mean that we can just execute our backup natively within Kubernetes, not via special scripts. This would make it much easier to actually deal with any kind of MySQL issues within the cluster, because it would be cluster-native. That's what the operators are for.

I think Oracle just created a really good one. It surprised me that they have this. It's not because of Oracle, but they got pushed by the community and actually created the MySQL Operator for Kubernetes, and that's what we're moving towards.

This is going to give you an ability to have a cloud-managed solution within the cluster. And then you can ask the MySQL Operator for the database. They'll partition the database and give it to you. So it will change the nature from you deploying it to you just asking the cluster to give you a database. It's a fully managed solution right from the cluster.

So that's what we're heavily looking into right now. We'll be switching to using Kubernetes MySQL Operators. It's a high-availability cluster running within the Kubernetes cluster.

Right now we're pretty good with that. It's working fine. We're trying to find some time to actually release that globally everywhere. That's where I am right now.

But in terms of technology, if you give up Oracle, you just go to a MySQL operator. That's the one we're using, what we're actually looking at - to create, operate and scale mySQL and sell it within the cluster. This idea of having a cognitive MySQL becomes much easier to manage within the cluster, as well. So you don't have to go with the cloud solution with AWS or Google cloud or Amazon MySQL or the Microsoft version.

The Oracle SuperCluster is the Oracle MySQL operator. That's what we we are looking into a lot right now. Mainly because it does backups on demand - it's so easy to backup. You can just tell Kubernetes to backup and you don't have to run special scripts or special extra software or codes to back it up. You can make the backup as you would do anything else. Send a backup or some other data source or insert an Elasticsearch into it here. Just say "Kubernetes, back it up" and you know Oracle has this adapters within the cluster to back it up for you taking increments or different companies. So that makes it really nice and easy to use and to deploy.

With that kind of solution you can ask to class or petition the database how you want. So again, it changed the nature of the kind of push-to-pull second nature system. Are you pushing your containers to a cluster? You just say cluster, "give me a database" and the class gives you the base partition database, creates a database in a secure manner, gives the connection to the database, and you're done. Then you can back it up on a schedule on to any backup switches. It's much easier. So once this goes, it is going to be widely adopted, which it should be. But I think people might not have the tech skills right now. But once it's adaptive, maybe in a few more months, it's going to be the number one solution for everybody.

In terms of what I'd like to see in the next release, one thing that's always missing is dash boarding. There's no real BI tool for MySQL, like there is in Yellowfin and all the different tools that you get. They all have MySQL connectors, but there's no specific BI tool for MySQL. Open source projects have sprung up, but they're more general purpose, like Postgress, a MySQL kind of database, a relational database. I don't see any really nice tool like Cabana for elastic searches that I can tell clients to use because it would be too technical for them. They would have to have more technical engagement with writing the course, drag and drop, and creating a graph like in Power BI where you just connect with DIA.

So I'd like to see the grab and drag and drop tables, nice beautiful graphics, and pie charts. You don't necessarily have that with MySQL like you have other solutions, which are really cost prohibitive for some clients. It'd be nice to have an open source solution for that. Decent solutions. I mean decent that I can take to clients. It's so technical. They want to drag and drop.

For how long have I used the solution?

I have been using MySQL now for five or six years.

What do I think about the stability of the solution?

This specific version of this MySQL has been battle tested for a long time. Any issues are known issues and we pretty much don't have any problems when they're in production. So it's very stable. When we picked simple switch demand, again, these things came up. But it was quickly resolved. So I guess that's the benefit of going with open source and seeing all those problems ahead of time in source code and having the ability to fix them.

What do I think about the scalability of the solution?

Since we have MySQL specifically, and we have to use it in many different environments, dev, testing, and production. All those different people are using it. Developers, QAs, automated testings running against that. In production we have many different users, so we have different meaningful products that are already running. For example, gotoloans.com. It's a loan application site in Canada that is serving a lot of users daily and is backed by MySQL and Elastic SQL databases. So we're using it for high volume and low volume. We have it in many different projects and many different environments.

We use it in different environments, the production also, and many different products as well.

We do have plans to run everything as a cluster, and probably will slowly switch to MetaDB. That is something we're doing right now. We also have plans to switch it to the managed version as well for production deployments, for the simple reason that we're trying to offload as much as we can from the DevOps people. So if offloading that management database from them will help them, then we'll do it.

Also, there are clients that have preferences when it comes to where the database should be running. For example, one of our major clients wants to run specifically in our database because we built it for them and they're comfortable managing it. You're always more comfortable having a managed version. So if you have a small team with a managed DBA, even though it's more expensive and there's always some issues coming up with it, you can just let Amazon manage it for you, and you don't even have to think about it. You could do the backups and if something happens, they can restore it. And you can scale as much as you want, as well.

In terms of cost, there are different flavors of it. It depends on the solution. Locally, as I said, MySQL is going to stay the way it is right now. We're not going to have a cluster version, because for development we just need a database. You need to have a scalable database or clustered.

So MySQL is going to change. We're in the process of transitioning the production versions to cluster versions for some of the projects because they have more volume. We can see that because of the volume of users, and how many queries they do on a daily basis, they would benefit from having a cluster versus a SQL database. So you can have a master to master cluster, which you can have separately. You can actually manage your read and write separately, and then optimize. So you can give more power to people, to certain queries, spreading across the cluster. So all those sorts of things come with the cluster database. That's going to improve performance.

One of the things that we're doing is looking at the short version of MySQL, which is a new thing. This means a shared database. Elasticsearch is made up of shards. This is a different way of thinking about relational databases like MySQL. Traditionally, MySQL or relational databases, have been crafted by having an instance of equal slave to equal master. You have many slaves and many masters, as well. Now the sharding makes the database a little bit different, and it's more usable for us in terms of the way we deploy things. So we're looking right now at MySQL sharding as well, and a few of the different flavors of that so that we can scale it horizontally. Instead of actually creating an instance of MySQL, we can actually spread across multiple different shards across many instances.

And it's also cheaper as well. Once you start getting into the shard world, it's really cheaper to deal with some of these issues, like clustering issues. So it's more cost-effective.

How are customer service and technical support?

I have not been in touch with support because any issues that came up, we really just resolve them because it's open-source, so if you look at the code, then you can solve it. There's also lots of community engagement in these databases. There are millions and millions of forums online. So if there's a problem, everybody will be on it trying to fix it. So there are no real major issues here.

How was the initial setup?

The initial setup is straightforward because we're using Docker. So we Dockerize not only our database but the applications, as well, because it's really easy to play as a Docker container, and then tour them to the Kubernetes cluster. It's very easy for us to manage it. And also, we have backups on top of that. So we have a schedule, and a job running, always backing up the system with secure backups. So it's actually very straightforward to get it up and running.

Deployment takes seconds. That's why we can include some of the companies, because we figure a way to do it simply, and you don't have to deal with all the complicated SQL servers, and you can bend a lot into Microsoft.

So for us, deployment is trivial, especially when you use the cloud version. For example, for our database, or cloud SQL, again that's trivial, just a simple deployment. You're up and running within less than a minute, five minutes maximum. Locally, people just deploy those databases every day when they build stuff. Again it takes a few seconds to get that going.

What was our ROI?

Since we’re running it ourselves, it's our own flavor of MySQL, for dev, and QA, staging, production environments, that cost is basically a part of their running between this cluster. So I can't give you a fixed cost, but I can give you the cost of the entire cluster. There are many nodes in a cluster, and there's many different parts continuously running it. So to fully utilize the cluster, we put everything in it and just try to maximum each node.

So you can have a MySQL database beside a Java Microservice and Angular applications on the same node, and using the same kind of resources. So it would be difficult for me to kind of break it down. Obviously I'll do a deep dive, and I'll look at it, in terms of, what percentage of the CPU is being used by MySQL.

Now when it comes to the Cloud versions, obviously there's a fixed cost with that. So for example, one of the clients uses our database, they chose to go with the extra large version of the ECQ's, and there's a price for that. And you can just get a price quickly, and there's a whole chart of pricing there.

So that's based on clients and their comfort level. We can tell them exactly what performance we're requiring here, and then say, what is the minimal thing we need here, in terms of CPU resources and connections? So that's what you really need for just a cloud version of it. Once we define that, then we tell the client, this is what you really need. You can get away with a smaller version of the virtual machine by using something bigger. To be comfortable they decide to do it. So I'm dealing with the pricing, and the pricing is transparent.

I have all the separate pricing for the databases as well. And from that, you can figure out what the cost is.

There's no licensing fees here because it's open source. So the only fees are really just for using the Cloud resources, even if you go with managed or non-managed, you're still using the Cloud resources. You can be more frugal if you're running it yourself, versus what Google or Amazon will do for you. It'll be a little more pricey to go with them, but because it's a  managed solution, you do have that peace of mind, because they're managing it for you. You just connect with it and just talk with it.

But in our cases, we deploy it, we manage it, we back it up, we do all that stuff. So there's more work that we have to do, but a lot of time we eat up the cost because it's not an expensive thing to do. So it can be more cost effective running within the Coud, than in a non-managed version, self-hosted version. 

At the end of the day, Google and Amazon are still making money, because it doesn't matter if you're running it yourself or it's managed, it's still using the Cloud. It's the same CPU and same RAM. 

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

So we jumped from version 5.6 to 5.7. That's not the latest version. The latest version is 5.8. We didn't move to eight for the simple reason that there's lots of code-based on 5.7 and there's no incentive for us to change right now. So a lot in the industry have not migrated to version eight yet. Oracle is having difficulty committing people to actually go with that version right now.

MySQL has been battle-tested for years and years. So people were comfortable from 5.6 to 5.7. It wasn't just a minor change, it was actually a major change in terms of the databases. Now, once Oracle started managing MySQL, they didn't do a good enough job. That's when MariaDB was invented when they jumped from version five to eight.

There wasn't enough confidence in that. Because there's so much time invested in it. Because MySQL is not just MySQL, they give it in a cluster mode, when you have huge databases with lots of master-slave nodes. So it's just not a trigger for a DBA to move to a new version that hasn't been battle-tested like their 5.7.

So 5.7 is a good database. That's 1418 right now or something like that. I think that's the one we use in production. So for most DBAs it's difficult for them to change. Also with Google and Amazon, you can choose not to go back for 5.7. It is very easy to create a fully scalable solution with 5.7. So, there's no incentive for people to actually switch.

What other advice do I have?

The biggest lesson I would tell others is regarding the backups. Once you start doing it yourself, backing up becomes a thing. When we sign up the clients, we'll give them a set amount of backups daily and we always give them a little verbiage about how much data can be lost if the thing goes down.

Or for example, if you get hit somewhere, what is the last backup you did? How much are you willing to lose? Backups can become quite complicated, and that's something that you have to manage yourself. We have to come up with clever solutions to do runs within our Dockerized environments in production, which you usually don't get from the community. So we have to do it ourselves.

That became a thing quickly once we started going. But that was years ago. We resolved these issues on the way and we are still making them better over time - how we back up the data, the business, the compliance, where did the issue live, who should have access to that? All that stuff.

So backups are usually the thing that people don't think about. And that can bite you in the ass kind of quickly.

On a scale of one to ten, I'd probably give MySQL a seven. There's definitely room for improvement here in terms of tools that come with the product, the way we deploy it, and the way we back it up. In essence, it's a good beginner base. It's just, the tooling around the database needs a little bit more work. You just need to be fair because it is a good database. It's also an open-source database. You know you can get commercial products that Percona for a commercial version of MySQL or Aurora database MySQL. So if you go with that, then you would probably give a much higher score because you really don't see it at all. It's just close your eyes and click a button and it's there. You don't have to touch it at all.

For us, since we deal with it every day and try to compete with the companies, the small DevOps team tries to be as efficient as they can, and sometimes you have to build too many things around the solution.

The commercial products only have that because they put 20 to 30 people on JSON and they can give it to you faster. That's what Google can do because they're good at the tooling around the database. In the current requests of the work, MySQL Workbench is the default tool to interact with the database. Again, MySQL Workbench is an open-source tool that it gets directly from Oracle. It's okay. It's not the greatest. It gets the job done. It's not a finesse tool. It just gets the job done.

If you hide it behind a main service and you don't see it, it's great. You're good to go.  People talk about Amazon RDS and how great it is. But that's a managed product. If you peel the layers and look at the SQL in there, they put a lot of work around that. It's fully scalable. The money used and the way they restructured that SQL database to actually give you that performance took a lot of work for the AWS people. So they're not going to share that IP with you. And they're definitely not going to release it because other people can pick it up, like Google. Then Google has Cloud SQL, as well. So they also have a MySQL version in there and they don't show you how the backup is, or how they actually manage it or scale it. You don't get that information.

So that's the trade-off between managed and non-managed or self-hosting. It's always that kind of battle, that fight. It depends on the money, depends on the client. If it's for a healthcare issue or one of the hospitals, you just have to decide what they want, what's the best for them and how they're going to be protected. So there are many variables that come into play. It depends on your use case. In general, it’s a good database, I have no problem with it.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Marco Ismael González Rangel - PeerSpot reviewer
Solutions Architect at Teravision Technologies
Real User
May 5, 2023
Useful auto-scaling, helpful support, and reliable
Pros and Cons
  • "The most valuable feature of MySQL is auto-scaling."
  • "The GUI could improve to make MySQL better."

What is most valuable?

The most valuable feature of MySQL is auto-scaling.

What needs improvement?

The GUI could improve to make MySQL better.

For how long have I used the solution?

I have been using MySQL for approximately four 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 can scale well.

How are customer service and support?

I have used the support and level three support is great.

How was the initial setup?

The initial setup of MySQL was straightforward.

What was our ROI?

We have not seen a return on investment.

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

The price of the solution is good because we have a good partner.

What other advice do I have?

The solution is good at scaling.

I rate MySQL a ten out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Technical Director at Metrofibre Networx
Real User
May 2, 2023
An easy-to-install solution that is used for customer management authentication
Pros and Cons
  • "I rate the solution's stability a ten out of ten since it has been running flawlessly."
  • "The licensing cost of the solution is expensive, which MySQL needs to consider improving."

What is our primary use case?

We use MySQL for customer management authentication in our company.

What is most valuable?

The use of MySQL is really dictated by the software we use. So we have put software that dictates the use of MySQL and MongoDB. We think we've found the goal of the company related to strengthening its business systems.

What needs improvement?

Since we started the development, like, three years ago, it's just been improving, so there are no areas that need to improve. It is easy to use.

The licensing cost of the solution is expensive, which MySQL needs to consider improving.

For how long have I used the solution?

I have been using MySQL for three years. It's based on the call systems or based on the console.

What do I think about the stability of the solution?

I rate the solution's stability a ten out of ten since it has been running flawlessly.

What do I think about the scalability of the solution?

It works well. So, I rate its scalability a ten out of ten. Our company is managing hundreds to thousands of clients, but we use MySQL for different projects. So, around 50 users work on it.

In terms of increasing the solution's usage, I think we've done enough, like, stabilizing MySQL.

How are customer service and support?

Our company has contacted the technical support of MySQL. It was very easy to get connected to them. However, it cost us a fortune. For SMBs in South Africa, a thousand or ten thousand dollars an hour is a lot of money. It was expensive, but it was worth it.

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

We have previously used a solution for location and mapping-related stuff. Our choice to move to MySQL was dictated by software. So, we use different programs for applications.

How was the initial setup?

The initial setup is straightforward. The deployment process takes a few seconds.

What about the implementation team?

We had to seek the help of some consultants to implement the product since there was some difficult stuff. But that was long ago. Nowadays, we avoid seeking help from consultants since it has become pretty simple. So, better experienced and well-trained people would do it for us. It's not a problem.

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

I believe we have a few cluster solutions. I think that MySQL is a premium product. But I don't manage that part.

What other advice do I have?

The solution's documentation and support are awesome. Also, its speed has increased in the last few years. So, we have never had any issues with it. If there were any errors, then they were human errors.

Today with many other options, we stick with MySQL and recommend it to others. There are so many other things that are more suitable for different purposes, and I will have to do research to know more about them. MySQL has been around for a decade, so something cannot go wrong. Its big support communities make it easy to resolve problems since there is always somebody who can help.

I rate the solution a ten out of ten.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Anays Micolod - PeerSpot reviewer
Programmeuse Python 3 at Université Grenoble Alpes
Real User
May 25, 2022
Has easy access to data, is easy to grasp, and has good documentation
Pros and Cons
  • "The easy access to the data and the ability to sort the data with multiple methods are very valuable features."
  • "Sometimes, I get lost in the toggles and buttons, and a better visual design would be nice. The layout is not user-friendly or efficient."

What is our primary use case?

I'm using it to create a small database for a project that I'm working on.

What is most valuable?

The easy access to the data and the ability to sort the data with multiple methods are very valuable features.

It's quite easy to grasp and is really well documented, which are huge plus points.

What needs improvement?

Sometimes, I get lost in the toggles and buttons, and a better visual design would be nice. The layout is not user-friendly or efficient.

I would like to be able to sort the data easily without having to do a request to get the table out of the database into the web page. At present, I can't do it directly inside MySQL; I have to do a request and print out my request into a web page.

What do I think about the stability of the solution?

The stability is really good. I haven't had any issues with it.

What do I think about the scalability of the solution?

The scalability is good.

How was the initial setup?

The initial setup is easy.

I learned to use it in class, and the setup was quite fast because the teacher really helped us to gain access and take the first few steps. The setup took a few hours at most.

What about the implementation team?

I installed it myself.

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

I use a free version at present.

What other advice do I have?

Plan how the data will be constructed. I had to delete an entire database and start over because I didn't organize it properly. That was a huge block.

I would rate MySQL at eight on a scale from one to ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1788699 - PeerSpot reviewer
Managing Director at a financial services firm with 201-500 employees
Real User
Mar 11, 2022
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."
  • "MySQL is a good database; we are using it, and we'll continue to use it."
  • "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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.
Updated: October 2026
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.