it_user1282806 - PeerSpot reviewer
Infrastructure Platform Engineer at a cloud solution provider with 51-200 employees
Real User
Free to use, stable and scalable
Pros and Cons
  • "The solution is free to use, which is its most valuable aspect."
  • "From a user perspective, the initial setup could be simplified a bit."

What is our primary use case?

We are an IT services provider, so the solution is for our customers. I can't answer for the customers in terms of how they use it. 

Typically, customers are running applications that need to connect MySQL and to store some of the data.

What is most valuable?

The solution is free to use, which is its most valuable aspect.

The interface is quite good.

The stability and scalability are very good.

Overall, it's an excellent solution. We don't have to implement anything else.

What needs improvement?

We haven't noticed and features that are lacking.

From a user perspective, the initial setup could be simplified a bit.

For how long have I used the solution?

I've been using the solution since 2000. It's been about 20 years now since I first was introduced to MySQL.

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

What do I think about the stability of the solution?

The stability is good. Neither we or our clients have had to deal with bugs, glitches or crashes. Everyone's been satisfied with it. Stability is one of its best features.

What do I think about the scalability of the solution?

The scalability of the solution is good. We haven't had trouble scaling at all.

How are customer service and support?

We're using the community version of the solution. I don't have any complaint with the level of support, however, it is online and there isn't a support line.

How was the initial setup?

The initial setup isn't always straightforward. Sometimes it is complex. For example, if you are doing a database expansion. For database expansion, you have to configure it and you have to know SQL quite well. You have to juggle a few things, which makes it complicated. However, from an IT perspective, it's a good tool, so it's worth the effort.

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

The solution doesn't cost anything to use. It's absolutely free.

What other advice do I have?

We are IT services provider, and provide this solution to our customers. It's typically installed on a dedicated server.

When we are working with it, we are doing SQL queries, and on top of that, we are using MySQL to do some reporting as well. It does what we want it to do and our clients are also happy with the results they get. It's a fine solution.

I'd advise those considering working with the solution to be patient.

We don't have any partnership MySQL. We are mostly a Microsoft partner. We mainly use the solution because of the community and the SQL server that's different from Oracle's server. From time to time we have to use MySQL.

I'd rate the solution eight out of ten. From our perspective, it's free to use, it's stable and it's fast and scalable. It makes it a good option for many organizations.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user702249 - PeerSpot reviewer
Web Developer at a tech services company with 201-500 employees
Consultant
The most valuable feature is its graphical interface which allows us to do the database administration

What is most valuable?

MySQL is strongly recommended for web applications and LAMP architecture systems. The most valuable feature of this product for me is its graphical interface which allows me to do the database administration easily. Another important feature is its reliability, the decent performance, and the fact it is an open source product.

How has it helped my organization?

It gives us the opportunity to create backups of our databases easily and loop through them with minimum effort.

What needs improvement?

I think that the stored procedures and the development tools to write and debug large queries could be improved.

For how long have I used the solution?

I have used MySQL for about 10 years.

What do I think about the stability of the solution?

There were no issues with stability.

What do I think about the scalability of the solution?

There was no issue with scalability.

How are customer service and technical support?

We have not used technical support. The community is large enough to find the solution when something comes up.

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

We used many SQL database solutions like PostgreSQL and SQLite and NoSQL databases like MongoDB. The choice depends on the project.

How was the initial setup?

The initial setup was straightforward.

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

I think that the Open Source product would cover the needs of most projects. In some cases, the advanced features are needed. They could use the enterprise edition, which is reasonably priced.

Which other solutions did I evaluate?

We have evaluated and used different products like SQLite. It depends on the requirements and the needs of the project.

What other advice do I have?

I believe that it is the ideal solution for a variety of projects with a small learning curve compared to other solutions. It allows you to be efficient quickly.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
MySQL
April 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,479 professionals have used our research since 2012.
Senior Java Developer at a computer software company with 11-50 employees
Real User
Supports JSON, but some of the queries are slow in the upgraded version
Pros and Cons
  • "I like the JSON stuff."
  • "Since we upgraded from 8.0.12 to 8.0.22, it has had some slowness-related issues. Some of the queries that were fast previously are quite slow now. I did some research, and I found many people complaining about it."

What is our primary use case?

We are basically using it for our applications.

What is most valuable?

I like the JSON stuff.

What needs improvement?

Since we upgraded from 8.0.12 to 8.0.22, it has had some slowness-related issues. Some of the queries that were fast previously are quite slow now. I did some research, and I found many people complaining about it.

For how long have I used the solution?

I've been working with this for two and a half years, and they have been using it for 10 to 15 years.

What do I think about the scalability of the solution?

We are using a cluster now, but I don't administrate that. There are thousands of users.

What other advice do I have?

I would rate it a seven 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.
PeerSpot user
PeerSpot user
Academic application support at a university with 1,001-5,000 employees
Vendor
Owing to its speed and stability, we use it as the data store for most of our web applications

What is most valuable?

Speed and stability of the MySQL DB are the most valuable features since we use it as the data store for most of our web applications.

How has it helped my organization?

Before we used MySQL, we used to access the data used for the dynamic web pages directly from our enterprise data stores and that was a massive performance bottleneck. With MySQL, the data can be accessed much faster. This allowed us to create more complicated web systems, such as the corporate message system and a credit card paying system.

What needs improvement?

From where we are, most of the improvements are being handled. With the new improvements that were introduced in MySQL 5.7 and with the testing that we have done to this point, we are looking at updating our web development environment to make better use of the new features.

With the push from MySQL to implement database engines which can provide the same functionality as PostgreSQL and MongoDB, we are looking at application development that leverages this functionality on our current MySQL production database. Seeing that MySQL can provide noSQL document storage the same way MongoDB can and still have a SQL data source next to it creates the possibility of using the best features of both to achieve the desired application result without changing our current infrastructure drastically.

It must be noted that we are still in the process of experimentation to find the best ways of utilizing these data technologies in our current enterprise applications, but not having to move to other database providers to have the functionality means we can experiment without the need to change our base processes. So when I say that the improvements are being handled the MySQL development team have given us access to functionality which we started to look at about two years ago.

For how long have I used the solution?

I have used this solution for around seven years with upgrades.

What do I think about the stability of the solution?

There were no stability issues.

What do I think about the scalability of the solution?

We did experience a few scalability issues, but we decided to rather go for a bigger server than creating a cluster and that worked out very well.

How is customer service and technical support?

The technical support is very good

How was the initial setup?

The setup was very straightforward since the out-of-the-box MySQL's performance is already very good.

We had to do some tweaking over time, but nothing too major.

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

The enterprise version has a number of extra components that makes it worth the price, but if all you want is a stable DB for web applications, then stick to the open version.

We use enterprise because we use the PAM connector and the DB firewall, if you are looking at the pricing for implementing a separate data firewall, it is more than what you will pay for this solution.

Which other solutions did I evaluate?

There were not a lot of other options open to us.

What other advice do I have?

Ensure you know what you want to use it for and make sure it is the right fit for the job.

Do not allow developers to tell you what your DB should look like, as that is the best way to performance problems. Use the MySQL Workbench and MySQL Monitor.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
DevOps SRE at a tech services company with 51-200 employees
Consultant
ACID attributes are the most valuable feature. It does not understand the clustered model.

What is most valuable?

ACID attributes are the most valuable feature, as data reliability is a top concern.

How has it helped my organization?

The backend of the production traffic happens at this level.

What needs improvement?

The dynamic scalability, clustering, dynamic replicas safeguard against failures, ease of setup and use all need to be improved.

  • MySQL was originally meant for a single server; now with the 5.7 version, they have introduced the multi-master model but it is on the user to ensure that there is no conflict of data. Also, to add/remove a server from the cluster requires downtime and MySQL won't scale load on its own as it has scaled up/down (the load distribution has to be done on a separate layer).
  • MySQL does not understand the clustered model, it is not aware of others in the cluster and won't act as a player in the cluster.
  • Data corruption or two different updates to the same record are not sorted in the replicas and needs manual intervention.
  • The cluster setup is complex and so is its maintenance.
  • It is not equipped to take advantage of the Cloud (AWS, Azure etc) and their pricing models (go as you use).

For how long have I used the solution?

I have used this solution for two years.

What do I think about the stability of the solution?

We have seen the corruption of data in replication when used with filters and also, with the growing data response time dwindles.

What do I think about the scalability of the solution?

A lot of manual effort is needed to scale the solution; a lot of room for improvement is there.

How was the initial setup?

The setup was of mid-level complexity.

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

It is a GPL license, only the support is priced but as there is a good community so buying support is optional.

Which other solutions did I evaluate?

I wasn't involved as this predates me at the organization, but today if this re-happens MySQL won't be the best choice.

What other advice do I have?

Do your research and make sure for your use case that MySQL is the best choice, before making any commitments.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Project Manager at a computer software company with 1,001-5,000 employees
Real User
An easy to install and stable solution, but could be more secure
Pros and Cons
  • "The solution is very stable."
  • "The solution could be more secure."

What is our primary use case?

I do not recall which version I am using. 

Although we do not use it for the main core system, the solution acts as a database which is useful for login applications, data warehousing. 

What is most valuable?

The solution is so stable. I have encountered no problems. 

What needs improvement?

The solution could be more secure.

For how long have I used the solution?

I have been using MySQL for a year. 

What do I think about the stability of the solution?

The solution is very stable. 

What do I think about the scalability of the solution?

The solution is not scalable at present. 

How are customer service and technical support?

I do not have experience with technical support. 

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

Previously, we used Microsoft database.

How was the initial setup?

The solution is easy to install.

I cannot state how long implementation took. 

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

The solution does not come with a licensing fee. 

What other advice do I have?

I do not know the number of users who are using the solution in my organization. 

I would absolutely recommend this solution to others. 

I rate MySQL as a seven out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Director IP led Services (PES) at a computer software company with 1,001-5,000 employees
Real User
A very good traditional database; simple, easy to use and provides decent service
Pros and Cons
  • "A good traditional database that supports JSON."
  • "Could use some additional JSON query support in the solution."

What is our primary use case?

We store mostly the metadata-related information and that's our primary use case for MySQL, storing a transactional database. 

What is most valuable?

This is a good traditional database, it supports JSON and it is whatever you need for a simple solution. It fits well, is easy to use and provides good service.

What needs improvement?

I'd like to see some additional JSON query support in the solution. 

What do I think about the stability of the solution?

The stability is fine. 

What do I think about the scalability of the solution?

The scalability of the solution is fine although we haven't tested it too much. 

How are customer service and technical support?

There is no need to contact technical support. 

How was the initial setup?

The initial setup is very easy, it's not a big installation and there's no effort required with maintenance-related issues because it's a whole product and is more stabilized. So I don't recall any issues and getting issues on the database side.

What other advice do I have?

I would recommend this product if it suits your needs. 

I rate this solution an eight out of 10.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
SVP Technology and Head of India at a financial services firm with 201-500 employees
Real User
A stable and effective data store, but technical support should be available worldwide
Pros and Cons
  • "We use it as a data store and from that perspective, we get everything we need."
  • "The technical support should be more knowledgeable and available worldwide."

What is our primary use case?

We are an asset management product company. Our product is deployed on the cloud and the backend database for it is MySQL.

What needs improvement?

The technical support should be more knowledgeable and available worldwide.

For how long have I used the solution?

We have been using MySQL for the past five to six years.

What do I think about the stability of the solution?

So far, it has been pretty stable and I haven't had any problems. We plan to continue using it in the future.

What do I think about the scalability of the solution?

MySQL is very scalable, so I don't expect any challenges.

How are customer service and technical support?

We have a contract with a third-party for support. So far, it has been working fine for us and I don't see any challenges. That said, having worldwide support is something that would be an improvement.

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

Prior to MySQL, we did not use another database for this purpose. We built our core product directly on top of MySQL.

How was the initial setup?

The initial setup seemed pretty decent, so I don't see any challenge in that regard.

What about the implementation team?

Our in-house DBA team installed it. We have one DBA and one junior.

What other advice do I have?

This is a good product and I recommend it to others.

We use it as a data store and from that perspective, we get everything we need. We don't have any complaints about features such as analytics, reports, or dashboards.

I would rate this solution 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.
PeerSpot user
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.