Try our new research platform with insights from 80,000+ expert users
Senior Data Analyst at Charutarhealth Org
Real User
Easy to set up, stable, and good technical support
Pros and Cons
  • "The replication feature is the most valuable. We are replicating our servers."
  • "It should have some code analytical functions. It can also have a monitoring tool."

What is our primary use case?

We are interfacing it with MicroStrategy. There are ODBC connections. We have 10 to 12 users in our company.

We are assessing the possibilities of moving to the cloud. We are not yet sure if we are going to move to the cloud.

What is most valuable?

The replication feature is the most valuable. We are replicating our servers.

What needs improvement?

It should have some code analytical functions. It can also have a monitoring tool.

For how long have I used the solution?

I have been using MySQL for ten years.

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

What do I think about the stability of the solution?

It is stable. We are not dealing with a huge database. Our database is not more than 1 TB, so we didn't find any problem.

What do I think about the scalability of the solution?

I haven't seen a need for scalability.

How are customer service and support?

Their technical support is good.

How was the initial setup?

The initial setup is easy. We are using it on Linux, and our server is on CentOS.

What other advice do I have?

I would recommend this solution. I would rate MySQL a nine out of ten. I find it almost perfect.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Information Technology Infrastructure Manager at a comms service provider with 201-500 employees
Real User
Feature-rich, cost-effective, and allows us to implement clustered solutions
Pros and Cons
  • "MySQL gives us all of the critical features that we need in a database, but without the costs."
  • "I would like to have features that allow us to jump between the cloud and our on-premises system."

What is most valuable?

MySQL gives us all of the critical features that we need in a database, but without the costs.

The most valuable feature is that we can implement clustered solutions.

What needs improvement?

I would like to have features that allow us to jump between the cloud and our on-premises system.

For how long have I used the solution?

I have been using MySQL for about 20 years.

What do I think about the stability of the solution?

MySQL is a very stable product.

What do I think about the scalability of the solution?

I know that it is scalable, and in fact, that is why we chose it. We always have it in mind that in some number of years, you have to scale the solution to something different in terms of architecture.

As it is now, our databases are not big. They are critical, but not large in size. We are not dealing with Big Data.

How are customer service and technical support?

We have never contacted Oracle for MySQL support.

The documentation that is available is enough for my needs.

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

This was the first database solution that we used. I have used other database products such as Oracle, for example. Oracle comes at a heavy cost.

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

This is an open-source product that can be used free of charge.

Which other solutions did I evaluate?

This is the product that was proposed to us and we implemented it.

What other advice do I have?

MySQL is a product that I can strongly recommend. However, it is important for you to have the in-house knowledge to support it. Some level of in-house expertise is necessary, otherwise, you will have to rely only on external opinions. In my opinion, that's not good. Sometimes they have good intentions but don't understand the reality.

I cannot give MySQL a perfect rating because we don't use all of the features. That said, I can tell you that I am totally satisfied with it. It's a very stable product and it's something that is not difficult to deal with.

I would rate this solution an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
MySQL
November 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
817,354 professionals have used our research since 2012.
reviewer1620885 - PeerSpot reviewer
Vice President & Head of IT Governance at a financial services firm with 1,001-5,000 employees
Real User
Good performance, but requires better scalability and more reliable stability
Pros and Cons
  • "The solution is great for small applications in particular."
  • "As an open-source product, there isn't really any technical support available if you get into trouble or have issues."

What is our primary use case?

We primarily use the product for small applications.

What is most valuable?

The solution is great for small applications in particular.

The performance is good.

The solution originally was designed as an open-source product. It has a community edition that anyone can use for free.

The initial setup is simple and straightforward. 

What needs improvement?

I have doubts about its overall stability. It's something that they should look at.

As an open-source product, there isn't really any technical support available if you get into trouble or have issues.

There isn't much scalability potential in the product.

For how long have I used the solution?

I've been using the solution for a very long time. It's been years at this point.

What do I think about the stability of the solution?

The stability could be better. It's not as stable as I would prefer it to be. 

It was originally designed as freeware, as an open-source project, and the community wrote the solution. However, they've made it worse over time.

That said, the performance is pretty good.

What do I think about the scalability of the solution?

The solution is not that scalable. It's not something you should pick if you need something to expand significantly.

While I can't speak to how many people use the solution in our company, I can say that it is used by several departments and divisions.

How are customer service and technical support?

The solution is open-source and managed by a community. Therefore, there is no technical support available to users. 

How was the initial setup?

The initial setup is very easy and quite straightforward. It's not overly difficult or complex. 

That said, I was not a part of the original setup and therefore cannot speak to how long the deployment took my team.

What about the implementation team?

We didn't need any assistance from integrators or consultants. The setup was handled in-house.

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

The solution is open-source and free to use. We have the community edition. We don't have to pay to use it right now.

What other advice do I have?

Right now, Oracle has taken over the business of MySQL. Now, it's standard that you have to pay money for the license. That's why we are shifting all our databases, the small, small databases, from MySQL to Oracle. We do have extra data, so we do require a license.

Currently, we are using the previous version of the solution. I can't speak to the exact version number, however.

I'd rate the solution at a five out of ten.

I wouldn't recommend it to other organizations at this time.

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
Founder at Art World Web Solutions
Real User
Easy to integrate and reasonably priced but the memory consumption needs to be improved
Pros and Cons
  • "The connectivity with PHP is quite good."
  • "On the database side, it should be really lightweight, and the data structure should be like MongoDB."

What is our primary use case?

We use this solution for the database.

What is most valuable?

The connectivity with PHP is quite good.

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

What needs improvement?

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

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

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

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

For how long have I used the solution?

I have been working with MySQL for approximately five years.

What do I think about the stability of the solution?

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

How are customer service and technical support?

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

How was the initial setup?

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

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

It's cheaper than other solutions.

What other advice do I have?

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

Overall, it's a good solution.

I would rate MySQL a six out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Co-Founder/CEO at Grigale LTD
Reseller
Dramatically improved use for several of my customers, better ROI for me

How has it helped my organization?

It dramatically improved use for several of my customers.

What is most valuable?

This depends on my customers' use.

What needs improvement?

SQL and NoSQL use.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

When configured correctly, no stability issues.

What do I think about the scalability of the solution?

When configured correctly, no scalability issues.

How are customer service and technical support?

Very good.

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

MySQL Support Services by Percona. I switched to Oracle MySQL services because of a better ROI.

How was the initial setup?

There is no obvious answer. It depends.

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

Depends on the customer's needs. 

Which other solutions did I evaluate?

MariaDB, MySQL Support Services by Percona.

What other advice do I have?

Stick with the source, stick with Oracle MySQL as the leading vendor for MySQL technology.

Disclosure: My company has a business relationship with this vendor other than being a customer: Oracle Gold Partner and MySQL top reseller in Israel.
PeerSpot user
PeerSpot user
Telecommunications Engineer at a comms service provider with 1,001-5,000 employees
Real User
Offers SQL Merge, Replication, and Views. I would like to see additional side management tools and IDEs.

What is most valuable?

  • SQL Merge
  • Replication
  • Views
  • Stored Procedures
  • Triggers
  • Cursors

This is just like the enterprise grade Oracle DB. MySQL now supports replication (master-master or master-slave) of our DB to support our company's multiple geo-locations and PoPs.

It supports the original Oracle SQL operations such as Merge, as well as the creation of Views to your tables. This brings additional convenience to our organization.

How has it helped my organization?

The main benefit for us is that it's totally free, unless you need to pay for support.

What needs improvement?

I would like to see additional side management tools and IDEs.

For how long have I used the solution?

I used this current version for one year. I used previous versions for over ten years.

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?

There were no scalability issues.

How are customer service and technical support?

We didn't need any technical support. I would guess that Oracle support is top-level.

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

We did not use a solution prior to this one.

How was the initial setup?

The initial setup was straightforward, user-friendly, and easy. In most cases, if you use the Linux-based versions, it comes as a standard Linux package. You can get it installed by using AptGet, Aptitude, or Yum.

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

Just pay for any license if you need some enterprise support for your project or any additional support tools that Oracle ships with the enterprise version. During the development stage of your project, you can just use the free community edition.

Which other solutions did I evaluate?

We evaluated MSSQL, Oracle DB, Informix, and MariaDB.

What other advice do I have?

Go with the Linux version. It is more stable and manages the system resources better.

Disclosure: My company has a business relationship with this vendor other than being a customer: We are partners, developing applications together.
PeerSpot user
PeerSpot user
Engineer with 51-200 employees
Vendor
It provides a low cost and effective SQL DB solution for smaller companies. Replication does need improvement though.

What is most valuable?

  • Speed
  • Cost

How has it helped my organization?

MySQL provides a low cost and effective SQL Database solution for smaller companies that don’t require the overhead and cost associated with RDBMS tools like Oracle

What needs improvement?

Replication and HA features, but that is to be expected at this entry point

For how long have I used the solution?

10 years.

What was my experience with deployment of the solution?

No, the deployment of MySQL is very easy as it is usually a part of Linux distributions and most hosting services provide a MySQL database as a part of their hosting service.

What do I think about the stability of the solution?

No, MySQL has always been a stable database. If there are sufficient resources on the server to run the database it will do fine.

What do I think about the scalability of the solution?

None that I have run into. For really big databases I have always used Oracle.

How are customer service and technical support?

Customer Service:

There is plenty of support available on the internet. I have never really needed to use or activate a support contract for MySQL

Technical Support:

There is plenty of support available on the internet. I have never really needed to use or activate a support contract for MySQL.

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

Before using MySQL I used Oracle and Informix for RDBMS.

How was the initial setup?

The initial setup was easy as there is usually a version distributed as a part of the Linux distribution.

What about the implementation team?

I have always implemented MySQL through and in house team.

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

The initial setup cost and maintenance costs are built into the OS costs for all of my implementations and are insignificant.

Which other solutions did I evaluate?

I usually look at MySQL, PostgreSQL and Oracle.

What other advice do I have?

MySQL is a great RDBMS, but make sure it will integrate with all of the clients you will be using and the rest of your infrastructure. The problems usually have more to do with other products supporting MySQL than MySQL itself.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer938061 - PeerSpot reviewer
Sr. Solution Architect at a computer software company with 5,001-10,000 employees
Real User
An easy to use solution which comes with a free stable version, but should have better integrative features
Pros and Cons
  • "The solution is easy to use."
  • "Integration is a key feature in need of improvement."

What is our primary use case?

With most open source products we were building, even the language was open source, such as that which employs PHP. This is where the MySQL free version was being primarily used by many of the clients in the storing of their data. 

There have been some great shoppers which we built with the solution. We use the solution to store the transactional data that we receive from various sites or have the data stored in MySQL. 

What is most valuable?

The solution is easy to use. As the query patterns are very similar to SQL, this simplifies the use and understanding of the solution. 

What needs improvement?

Integration is a key feature in need of improvement, as we have spent hours building this just to ensure that a set of data is exposed to a different client, a different world in need of that data. Since we are dealing with open source, which we are now employing in memory databases as well, it would be nice if they were to start thinking along those lines. 

For how long have I used the solution?

I have been dealing with MySQL for around a decade. 

What do I think about the stability of the solution?

I have found the free version to be stable. 

How are customer service and support?

I have not made use of technical support. 

What about the implementation team?

I was not involved in either the installation or deployment strategy. 

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

While I was not involved in those projects over the past year, we do have a couple of clients who choose to use the paid, enterprise version of the solution and who take full advantage of it.

What other advice do I have?

While the solution has, nowadays, moved to the cloud, the one I have been dealing with is on-premises.

Even though the solution has not been off the market, I do not possess the exact figures of those making use of it. It is still being used by a couple of our clients. 

I would recommend the solution to those interested in using the free, stable version of the solution which incurs no licensing costs. 

I rate MySQL as a seven 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: November 2024
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.