Try our new research platform with insights from 80,000+ expert users
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.

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

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 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
Director at BAB
MSP
Top 20
A stable and flexible product that is easy to use and can be deployed quickly
Pros and Cons
  • "The product is flexible and easy to use."
  • "The interface could be improved."

What is our primary use case?

I use the product as a backend to my application.

What is most valuable?

The product is flexible and easy to use.

What needs improvement?

The interface could be improved.

For how long have I used the solution?

I have been using the solution for seven to ten years. I am using the latest version of the solution.

What do I think about the stability of the solution?

I rate the tool’s stability a nine out of ten. The stability is good.

What do I think about the scalability of the solution?

I rate the tool’s scalability a seven out of ten. We have four direct users and more than 1000 indirect users. We use the tool twice a week.

How was the initial setup?

I rate the ease of setup an eight out of ten. The deployment took a few minutes. We need two system administrators to maintain the tool.

What about the implementation team?

The deployment was done in-house. We need one system administrator to deploy the tool.

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

I rate the pricing a seven or six out of ten on a scale of one to ten, where one is cheap and ten is expensive.

What other advice do I have?

We used different solutions before, but I do not know why we switched to MySQL. I recommend the solution to others. Overall, I rate the product an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
MySQL
December 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
829,634 professionals have used our research since 2012.
Senior System Administrator at Debre Markos University
Real User
A stable, scalable, easily installable solution which boasts ease of use and good performance
Pros and Cons
  • "I am totally satisfied with MySQL."
  • "The solution could have better integration and security features."

What is our primary use case?

We use the solution for our applications, as a management system. We utilize it as an operator or relational database. 

What is most valuable?

I am totally satisfied with MySQL. I like its performance, ease of use, stability and scalability. 

What needs improvement?

The solution could have better integration and security features. 

For how long have I used the solution?

I have been using MySQL for more than five years.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

The solution is scalable. 

How are customer service and technical support?

I have no experience with tech support. 

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

We did not use another solution prior to the current one. 

How was the initial setup?

Installation is easy. It takes about 20 minutes.

What about the implementation team?

One can do the installation on his own. 

Our team involved 15 people. 

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

There is no licensing fee. 

What other advice do I have?

I believe there are 100 users making use of the solution in our organization.

I would recommend this solution to others. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Solution Architect at KIAN company
Real User
Ease to use, high performance, and has quick startup times
Pros and Cons
  • "When comparing MySQL to other solutions it is easier to use and boots up faster. Additionally, when you want to query a lot of data, MySQL is better in performance."
  • "The solution could improve the monitoring. At the present time, you need to use third-party monitoring solutions."

What is our primary use case?

In our company, we are providing an application in PHP language and we need to use another database and we made the decision to use MySQL.

What is most valuable?

When comparing MySQL to other solutions it is easier to use and boots up faster. Additionally, when you want to query a lot of data, MySQL is better in performance.

What needs improvement?

The solution could improve the monitoring. At the present time, you need to use third-party monitoring solutions.

For how long have I used the solution?

I have been using this solution for approximately one year.

What do I think about the stability of the solution?

When it comes to stability SQL server is better than MySQL. This is an area they could improve.

What do I think about the scalability of the solution?

We have approximately five users using this solution in my organization.

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

I have previously used SQL Server.

What other advice do I have?

I would recommend this solution to others.

I rate MySQL an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
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
reviewer1489614 - PeerSpot reviewer
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
reviewer1301145 - PeerSpot reviewer
CEO at a computer software company with 11-50 employees
Real User
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
PeerSpot user
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.
Updated: December 2024
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.