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
April 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,857 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
April 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,857 professionals have used our research since 2012.
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
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
Unemployed (previous role was Solutions Specialist, System Integration)
Real User
Has different licensing options and is easy to set up
Pros and Cons
  • "The initial setup for the SQL database is not complex and it even integrates into the platform. You set up the recipe and then just follow the runbook, the build book. Then it works as long as you follow the procedures."
  • "Sometimes, not because the version is not the latest version, there are some issues with it. Sometimes there's an issue with the server which creates issues with it."

What is our primary use case?

I use MySQL as middleware to get the extracted data from the database. I work with MySQL as an administrator to set up the whole platform. And I document the recipe for setting up the MySQL database.

We are working with the latest version.

What is most valuable?

SQL is just a relational database. It is open source. It's pretty good. I have been using it for a long time.

What needs improvement?

Because I am the middleware guy I'm not the SQL database administrator. If I have any issue with it, I'm going to contact the right person. Sometimes, not because the version is not the latest version, there are some issues with it. Sometimes there's an issue with the server which creates issues with it. Then, when the administrator checks the status and makes notes, it works normally and the problem is fixed. With a big company you are not going to work directly with the MySQL database. We are the end user and not the administrator of the SQL database.

For MySQL, in terms of the usage or as the end user, I don't have much to recommend, as long as the query latency meets your requirements, it will be great. Otherwise, it's the horizontal scalability and you get more parallel in the implementation in terms of the SQL database regardless of the usage. This is probably much better than the vertical in terms of scalability.

For how long have I used the solution?

I have been using MySQL this year.

What do I think about the scalability of the solution?

If you are working in the cloud platform then you do have scalability because the cloud platform is usually AWS or GCP, and they provide this kind of scalability. If you get some issues with the query and latency or something like this, that is an issue of scalability and you can just adjust the horizontal or vertical scalability to meet your requirements.

But the company I was working with was a very big company. It's more than several thousand people and they usually have a lot of data that they are going to store in the MySQL database. They gather the data from the SQL database and then transfer it like ETL and you get data from all the different distributed systems and then put them into the centralized MySQL database. After that you're going to visualize this kind of data so that you can use the Power BI or that kind of tool to generate reports or to create a dashboard for the system. This company had its platform on-premises, but right now they are moving these technologies to cloud. That's why I'm talking about the scalability in two different ways cloud and on-prem.

How are customer service and support?

For technical support, I'm the end user so I extract data or visualize the data from the SQL database. I didn't get too into the daily maintenance of the database.

How was the initial setup?

The initial setup for the SQL database is not complex and it even integrates into the platform. You set up the recipe and then just follow the build book. Then it works as long as you follow the procedures.

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

Regarding the price, because it's the open source they have different licenses. Even for open source there's a license for the enterprise. I don't think it is expensive. Also for the scalability in the cloud, the price is based on the usage, such as, how much data you transfer.

What other advice do I have?

For the best usage right now, the trend is to move the platform from on-premise to cloud. Then, you you really have the best flexibility to scale down or scale up based on your usage. You can make full use of the resources and then pay for whatever you use. Because if you have it on-premise you always pay the same price no matter how much usage you have. So one of my suggestions is if you plan to set up the platform for MySQL, it would be best to go directly to the cloud solution.

On a scale of one to ten, in terms of the usage for the middleware team and the end user of the SQL database, I would say it's around an eight at least. I cannot say from a  database administration perspective.

To determine what would allow me to give it a 10, I would first have to get more experience using it on the cloud version.

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
Oracle Cloud Infra Architect at Wipro Limited
Real User
Open source, stable, and has a lot of features
Pros and Cons
  • "It has a lot of features. The RDBMS, consistency, and multi-user features are valuable."
  • "We want high availability and replication features, which are currently missing in this solution. It would be great if they can provide an in-built replication feature, similar to Oracle RAC, in MySQL."

What is our primary use case?

We are doing POCs for our clients in our testing lab, and if a POC is working fine, then we give it for the production release. 

What is most valuable?

It has a lot of features. The RDBMS, consistency, and multi-user features are valuable.

What needs improvement?

We want high availability and replication features, which are currently missing in this solution. It would be great if they can provide an in-built replication feature, similar to Oracle RAC, in MySQL.

For how long have I used the solution?

I have been using this solution for the last two years.

What do I think about the stability of the solution?

It is a stable RDBMS. There is no doubt about that.

What do I think about the scalability of the solution?

We have been using it for POCs. It has been consistent for a hundred users. Currently, we have three groups that use this, and each group has 20 users.

How are customer service and technical support?

I have not contacted their technical support.

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

It is open source. We prefer it for POCs because it saves the license cost.

What other advice do I have?

I would rate MySQL an eight out of ten.

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