Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Head of Business Technology at a tech services company with 501-1,000 employees
Real User
A large amount of software modules and plugins for rapid application development are possible. However, it does not stand out regarding scalability.
Pros and Cons
  • "A lot of the software components have been trialed and tested for often more than 10 years."
  • "The main advantage is the very large user base. This enables users to fix about any issue by answering any question."
  • "It does not stand out regarding scalability. When the company size increases, the user base having actual experience with (very) large MySQL solutions is reduced."

What is our primary use case?

Small to medium-sized business usage. The main advantage is the very large user base. This enables users to fix about any issue by answering any question. From a technical viewpoint, MySQL is on par with the other open source database solutions.

How has it helped my organization?

Due to the large user base, a large amount of software modules and plugins for rapid application development are possible. From an operational viewpoint, this is also a very big advantage.

What is most valuable?

The large user base and the amount of available plugins and modules. A lot of the software components have been trialed and tested for often more than 10 years. It is rock solid from that viewpoint.

What needs improvement?

It does not stand out regarding scalability. When the company size increases, the user base having actual experience with (very) large MySQL solutions is reduced.

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

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

No, it is rock solid.

What do I think about the scalability of the solution?

Yes, other solutions have better features and better performance.

How are customer service and support?

Not applicable.

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

No.

How was the initial setup?

The initial setup is very easy with very good online support.

What about the implementation team?

Implementation was done in-house.

What was our ROI?

Not applicable.

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

When you know the setup will continue to grow, make sure you have the paid support. 

Which other solutions did I evaluate?

MariaDB/Galera.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Ruben Conti - PeerSpot reviewer
Owner at Intersoftware sas
Real User
Top 10
Easy to set up and integrate, works with most languages
Pros and Cons
  • "MySQL is easy to integrate. It works with just about every language."
  • "Security is a concern. MySQL could have better security features."

What is our primary use case?

We use MySQL for internet applications. 

What is most valuable?

MySQL is easy to integrate. It works with just about every language. 

What needs improvement?

Security is a concern. MySQL could have better security features. 

For how long have I used the solution?

I've been using MySQL for several years. 

How are customer service and support?

I've never contacted technical support. It is done on the internet. You have all the support there.

How was the initial setup?

Setting up MySQL is no problem at all. I can do it by myself, and it's deployed almost instantly.

What other advice do I have?

I would rate MySQL nine out of 10. 

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
MySQL
October 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,649 professionals have used our research since 2012.
it_user1392807 - PeerSpot reviewer
Manager at a tech services company with 51-200 employees
Real User
Has a lot of documentation and bug fixing is better in the latest version
Pros and Cons
  • "However, it is easy to scale MySQL using the functions provided with the product."

    What is our primary use case?

    It is deployed on local servers, and we are using version 8. The whole company uses our database. Our users don't communicate with the database directly. They use a web interface. All programs are deployed using MySQL. We have hundreds of thousands of users accessing MySQL via the website. Two of us manage the database, but it's enough for only one person to manage daily operations. 

    How has it helped my organization?

    As we are using the latest version of the database, it has many functions that have improved it. There are many new features in this version, and it is more powerful in what it can achieve.

    What is most valuable?

    MySQL has a lot of documentation, and bug fixing is better in the latest version.

    For how long have I used the solution?

    We have been using MySQL for about 20 years.

    What do I think about the stability of the solution?

    It is very stable.

    What do I think about the scalability of the solution?

    MySQL is scalable. We didn't scale it via the database tools provided but on the program side. However, it is easy to scale it using the functions provided with the product.

    How are customer service and technical support?

    The support is fast and helps to find faster fixes to existing bugs. They recently advised us to downgrade to fix one particular bug, which resolved the problem we were having.We only use technical support for bug fixes, and the calls are usually closed quickly.

    How was the initial setup?

    I was able to install it myself in about half an hour.

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

    MySQL is free.

    Which other solutions did I evaluate?

    We have also used PhpStorm and DataGrip.

    What other advice do I have?

    I would recommend that others use MySQL. I would rate it 10 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
    Data Architect at ACPAS Loan Management Software
    Real User
    Easy to use, easy to deploy, and stable with useful table partitioning feature
    Pros and Cons
    • "Table partitioning is most valuable. It is easy to use."
    • "I am looking for the Temporal SQL feature, which basically means that there is complete history for each table. This feature is currently available in MariaDB. PostgreSQL has something called a foreign-data wrapper, which is another way to access external data from inside. MySQL could have a similar feature."

    What is our primary use case?

    We are using it for RADIUS protocol, which is for network access. We are tracking the duration of user stations.

    What is most valuable?

    Table partitioning is most valuable. It is easy to use.

    What needs improvement?

    I am looking for the Temporal SQL feature, which basically means that there is complete history for each table. This feature is currently available in MariaDB.

    PostgreSQL has something called a foreign-data wrapper, which is another way to access external data from inside. MySQL could have a similar feature.

    For how long have I used the solution?

    I have been using this solution intermittently for six months. 

    What do I think about the stability of the solution?

    It is stable.

    What do I think about the scalability of the solution?

    It is scalable. We currently have six users.

    How are customer service and technical support?

    I don't have any experience with their technical support.

    How was the initial setup?

    Its initial setup was straightforward. It took 10 minutes.

    What about the implementation team?

    I did it myself. We have two people for its deployment and maintenance.

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

    I am not paying, but I am not sure about the exact licensing requirements.

    Which other solutions did I evaluate?

    It is always compared with PostgreSQL and Microsoft SQL Server.

    What other advice do I have?

    I would recommend this solution to others. I plan to keep using it.

    I would 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
    Business Intelligence Manager at a translation and localization position with 501-1,000 employees
    Real User
    Enables us to query and analyze data types and data structures within the database itself but the UI should be improved
    Pros and Cons
    • "The initial setup was pretty straightforward. I would have worked with our IT team in terms of the initial setup."
    • "I find the Microsoft solution a bit better. But mostly in terms of the UI layout, I would say. I just find it a little bit more efficient."

    What is our primary use case?

    I'm not involved from the database side as much. I primarily use it for reviewing the data structure as the architecture before I build a data model in our BI tools.

    General querying is pretty much what I do, and also analyzing data types and data structures within the database itself. I review the data structure within them. And I use that to build the data model, which we have in our reporting environment. That's primarily all I use it for.

    What needs improvement?

    What it would compare it to, from my point of view would be, Microsoft SQL Studio. I find the Microsoft solution a bit better. But mostly in terms of the UI layout, I would say. I just find it a little bit more efficient. But to be honest, I can work equally as well with both.

    For how long have I used the solution?

    I've been working with MySQL for two and a half years. 

    What do I think about the scalability of the solution?

    We haven't experienced any issues with scalability.

    How are customer service and technical support?

    I haven't directly contacted their technical support. 

    I haven't gotten feedback from the IT team.

    How was the initial setup?

    The initial setup was pretty straightforward. I would have worked with our IT team in terms of the initial setup. In terms of connecting to the database and to the data sources, it is pretty straightforward.

    What other advice do I have?

    I would rate MySQL a seven out of ten. 

    To make it a perfect ten, they should improve the UI. It's got quite a narrow range, and there's a lot more obvious to the database side than what I deal with. The UI is not quite as sharp I would say as the Microsoft solution. In some cases, I find that there are better shortcuts available in Microsoft solutions.

    If I was choosing, I would probably lean towards Microsoft. That may be just a purely personal preference. My use of MySQL has primarily been from a data integration point of view, a data architecture point of view, and reviewing the database itself, and the data structure, data types. In my role, I don't define data and I don't build the database, I'm purely on the interrogation and the analytics side. I probably would find the Microsoft solution slightly better. But MySQL does absolutely provide what I require from that point of view. So I would recommend it, yes.

    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
    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.

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