MySQL Review

Lightweight with good performance, but deployment with clustering needs to be simplified

What is our primary use case?

I am a senior manager of the infrastructure team and MySQL is one of the products that I work with. We use it in an e-commerce portal. The database is light and everything works smoothly.

What is most valuable?

The performance is great.

This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge.

What needs improvement?

We faced some details in clustering, although this may have been because we did not have enough knowledge about MySQL clustering. In general, an easier implementation for clustering would be an improvement.

The product is a little bit complex and it is difficult to find sufficient documentation.

For how long have I used the solution?

We have been using MySQL for approximately six months.

What do I think about the stability of the solution?

We have not had any problems with stability.

What do I think about the scalability of the solution?

MySQL is easy to scale.

How are customer service and technical support?

We have dealt with Oracle support regarding other products such as Oracle Database and Oracle WebLogic. I believe that it will be of the same standard, although I'm not sure.

I am not a technical person but my understanding is that they are competent.

My complaint about them is that when we have a problem, we have to explain the same thing many different times to different engineers. Every time we engage with a new engineer, we have to start all over again. This is a nightmare that we chased three months ago.

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

In addition to MySQL, we use Oracle and Microsoft SQL Server.

Oracle is an enterprise-level product but it is very straightforward to install and it has sufficient documentation and guides, which we did not easily find for MySQL.

How was the initial setup?

Implementing clustering depends on a few different layers or different components. The clustering layer handles requests from the applications, and it is all a bit more complex than Microsoft SQL Server or Oracle.

The design, review, and deployment took approximately one week.

What other advice do I have?

At the moment, because of the issue that we are having with the clustering, I may not recommend MySQL. It would first need to have the clustering problem fixed and then have a sufficient deployment guide. 

I would rate this solution a seven out of ten.

Which deployment model are you using for this solution?

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More MySQL reviews from users
...who work at a Computer Software Company
...who compared it with SQL Server
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: August 2021.
534,057 professionals have used our research since 2012.
Add a Comment
ITCS user