Try our new research platform with insights from 80,000+ expert users
reviewer1707912 - PeerSpot reviewer
System Analyst and Team Lead at a tech services company with 11-50 employees
Real User
Has good tech support, an easy setup and is stable and scalable
Pros and Cons
  • "For sure, the solution is very stable."
  • "The licensing of the solution is on the expensive side."

What is our primary use case?

We are currently using the 6.8 version and, prior to this, used the 5.3. I use the updated versions.

What needs improvement?

The licensing of the solution is on the expensive side. 

For how long have I used the solution?

I have been using MySQL since the very beginning, back in 2009. 

What do I think about the stability of the solution?

For sure, the solution is very stable. 

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,457 professionals have used our research since 2012.

What do I think about the scalability of the solution?

The solution is scalable. We have plans to increase the number of users. 

How are customer service and support?

The technical support is fine.

How was the initial setup?

The initial setup is straightforward and very simple. 

What about the implementation team?

Installation can be done on one's own. 

The entire system is simple to maintain, as it is not very big, and this can be done by one person. 

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

The price of the licensing should be cheaper. 

We pay a yearly subscription fee. 

What other advice do I have?

The solution is good for applications of small scope or for IT. It is sufficient to satisfy the needs of those with limited resources. 

Oracle is the main product in my organization.

There are 60 or 70 people making use of the solution in my organization. 

I would definitely recommend the solution to others. It is good for any solution. 

I rate MySQL as a nine 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
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
    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,457 professionals have used our research since 2012.
    PeerSpot user
    CEO at a computer software company with 1-10 employees
    Vendor
    We can now have many standalone databases where every developer can perform local tests

    What is most valuable?

    The most valuable feature is the fact that the product is cross-platform, because it reduces server TCO, for my small company. This is very important.

    How has it helped my organization?

    Without MySQL, we used a single centralized database.

    With MySQL, we can now have many standalone databases where every developer can perform local tests.

    What needs improvement?

    Improvement areas are Security and ORM, for example:

    It may be interesting to check the user-level access rights at the row level and a robust support to JSON model object (like NoSQL database).

    For how long have I used the solution?

    I've used MySQL for 12 years, since 2005. I chose it after using MS SQL for years. It is more suitable for the projects that we make.

    What do I think about the stability of the solution?

    No, never.

    What do I think about the scalability of the solution?

    Yes, the many index restrictions in case of partitioning the tables.

    How are customer service and technical support?

    I do not know yet. I've never used technical support services, only the community

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

    Yes, I first used Microsoft SQL Server, then I went to MySQL because the cost is lower.

    How was the initial setup?

    The initial setup is straightforward, especially in a Windows environment.

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

    There is no cheap commercial license for standalone applications.

    Which other solutions did I evaluate?

    Yes, I have evaluated other database solutions. I have evaluated PostgreSQL and MongoDB.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Charlita Dalebjörk - PeerSpot reviewer
    Charlita DalebjörkActing CFO with 1-10 employees
    Real User

    Thanks for a good review
    Many developers wants to have micro servers with micro sized databases. But that doesn't necessarily means that these micro sized databases will be a unique MySQL instance.

    PeerSpot user
    Member of Technical Staff at a tech company with 501-1,000 employees
    Vendor
    Allows us to maintain very large tables without jumping through the hoops.

    What is most valuable?

    Simple syntax and simple administration are the most valuable features.

    How has it helped my organization?

    It allows us to maintain very large tables without jumping through the hoops that are required by the commercial products such as Oracle.

    What needs improvement?

    Multi-master replication could be a bit more reliable.

    For how long have I used the solution?

    Counting the earlier versions, we are using this solution for over ten years.

    What do I think about the stability of the solution?

    Compared to the other database solutions, there were no stability issues as such.

    What do I think about the scalability of the solution?

    Sharding is relatively straightforward.

    How are customer service and technical support?

    We run the Community version, so technical support doesn't apply.

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

    We tried Oracle for a while but it was too much of a resource hog.

    Which other solutions did I evaluate?

    We looked at Oracle and PostgreSQL.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    PeerSpot user
    SENIOR DEVELOPER at a tech services company with 51-200 employees
    Consultant
    During the billing process, if one server fails then we switch to the other transparently.

    What is most valuable?

    The multiple engine replication is the most valuable feature. This neuralgic process for billing needs high availability and that is where we need this robust, but simple solution. If one server fails, we switch to the other transparently.

    How has it helped my organization?

    It facilitated fast processing of the millions of records for billing of the the call detail records in the Telecom company. The company needed to recover calls, in addition to immediately detecting frauds in the telephone calls so as to block the line and generate large losses. With the help of stored procedures, functions and triggers, we created an engine to recover most of the calls with a single transaction. Thanks to MySQL.

    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?

    I would rate the technical support as a five out of 10.

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

    We were using PostgreSQL. The reason why we switched to this solution was that of the easy administration.

    How was the initial setup?

    The setup was easy.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    PeerSpot user
    DevOps Lead Engineer at a tech services company with 51-200 employees
    Consultant
    It is open source and AWS provides a managed solution. I would like it to catch up with proprietary technologies.

    What is most valuable?

    It is open source and AWS provides a managed solution.

    How has it helped my organization?

    Amazon has come up with Aurora, a MySQL hybrid that has helped us get up to speed without actually thinking about MySQL underlying optimizations.

    What needs improvement?

    Catching up with proprietary technologies like Oracle and PostgreSQL is the challenge right now.

    For how long have I used the solution?

    We have used this solution for over four years.

    What do I think about the stability of the solution?

    There have been no stability issues yet.

    What do I think about the scalability of the solution?

    We code for horizontal scaling and hence the only thing that becomes important is the number of connections. The data can be easily replicated in real time on Amazon replicas themselves. We have a dynamic solution to read data from replicas and not from a master instance. That is how we scale.

    How are customer service and technical support?

    I would give technical support a rating of 10/10.

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

    We did not use a different solution before.

    How was the initial setup?

    The initial setup was straightforward.

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

    Keeping something similar to AWS, and as easy as Amazon, will be the best thing for any small business like mine.

    Which other solutions did I evaluate?

    I did evaluate other solutions, but MySQL stood out because of its ease of use. Perhaps my prior experience has made me be biased towards MySQL.

    What other advice do I have?

    Until you have expertise in data migrations and what you are doing with data, MySQL can be really easy and dangerous at the same time. MySQL doesn't give you a warning about data truncation if data types don't fully match. Be really careful on that front.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    reviewer1650315 - PeerSpot reviewer
    Senior Java Developer at a computer software company with 11-50 employees
    Real User
    Supports JSON, but some of the queries are slow in the upgraded version
    Pros and Cons
    • "I like the JSON stuff."
    • "Since we upgraded from 8.0.12 to 8.0.22, it has had some slowness-related issues. Some of the queries that were fast previously are quite slow now. I did some research, and I found many people complaining about it."

    What is our primary use case?

    We are basically using it for our applications.

    What is most valuable?

    I like the JSON stuff.

    What needs improvement?

    Since we upgraded from 8.0.12 to 8.0.22, it has had some slowness-related issues. Some of the queries that were fast previously are quite slow now. I did some research, and I found many people complaining about it.

    For how long have I used the solution?

    I've been working with this for two and a half years, and they have been using it for 10 to 15 years.

    What do I think about the scalability of the solution?

    We are using a cluster now, but I don't administrate that. There are thousands of users.

    What other advice do I have?

    I would rate it a seven 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
    PeerSpot user
    Co-Founder at Mero Reading Room
    Real User
    It has a remote access feature to manage the database from a remote location
    Pros and Cons
    • "It creates a unified view of the entire architecture and performance factor, helping to manage the network more easily."
    • "It has a remote access feature to manage the database from a remote location. This enables in-work collaboration."
    • "The only service which could be improved is its usability. The entire user experience needs to be revamped to meet the 2018 design standards."

    What is our primary use case?

    I used it to obtain insight into the entire network and the resources being utilized. The current GUI lets us see the traffic happening east to west and the total bandwidth consumed by it.

    How has it helped my organization?

    • It provides visibility, where something was either broken or in pieces only.
    • It creates a unified view of the entire architecture and performance factor, helping to manage the network more easily.
    • It has a remote access feature to manage the database from a remote location. This enables in-work collaboration.

    What is most valuable?

    I have found the following features valuable:

    • NetFlow of the whole system
    • Information flow and scaling
    • Communication between multiple collaborators and stakeholders
    • Its user-friendly features.

    What needs improvement?

    The only service which could be improved is its usability. The entire user experience needs to be revamped to meet the 2018 design standards.

    For how long have I used the solution?

    Less than one year.

    What other advice do I have?

    The overall service is great. 

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