Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Partner at a tech services company with 51-200 employees
Reseller
Has the ability to run on any operating system

What is our primary use case?

We utilize the DB as a data-repository solution for our front-end applications. The solution gives us the ability to run numerous instances on various geographical cloud servers.

How has it helped my organization?

Yes, MySQL has improved numerous processes; it has given us the ability to create applications without absorbing major costs.

What is most valuable?

  • Its ease of use
  • It's secure.
  • It's fast.
  • It has high-end processing.
  • It can distribute across clouds.
  • It has the ability to run on any operating system.

What needs improvement?

  • I think a better front end would be a better solution (web application front end, similar to what Red Hat is doing to Fedora). 
  • Another nice solution for MySQL clustering would be the use of Webmin. 
  • Also, security measures could always be improved, and the clustering process could be enhanced as well. I recommend using UFW, iptables, and firewalld.
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.

What do I think about the stability of the solution?

The solution works extremely well. It is easy to install and works on any platform. The price is good because we utilize various versions of the software/DB.

What do I think about the scalability of the solution?

If the user sets up DB up using MySQL Cluster (creates a grid type of design), then we find the solution from a hardware perspective using NVMe, NVMe-oF, 10GE network connections, and 32-100GB of DDR4 memory (dependent upon customer requirements). 

Scalability can be initiated using high-speed connections across IPv6 connections (IPSec AES-256 ESP/AH VPN connections without purchasing VPN concentrators — this can be done at the network layer).

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

We use various versions, but most of the time this is based on the client's requirements.

How was the initial setup?

After the initial training, the installation worked pretty well. I would suggest setting it up in a lab. This gives the user room to test the installation and configuration process. It is recommended to use PhpMySQLadmin — (https://www.phpmyadmin.net) — after the installation process is completed.

What about the implementation team?

It was implemented in-house. Most of the applications are tested in our cloud and on-premise servers.

What was our ROI?

60% ROI (There are DLs — direct labor costs and overhead costs, but once it is set up, we image the configuration and deploy our designs in docker).

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

I would suggest testing MariaDB before jumping in. This will give the user the ability to test the DB before using it. It is very easy to set up. MariaDB is free, and licensing is based on GNU.

Which other solutions did I evaluate?

N/A.

What other advice do I have?

I would suggest running tests against MySQL, MariaDB, Oracle, PostgreSQL, and MS SQL to determine which one best suits your needs (cost, development, and integration should all play in your decision-making process).

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
QA Lead at a logistics company with 1,001-5,000 employees
Vendor
Allows us to share virtually created database instances
Pros and Cons
    • "I feel that some tools which make it easier to create queries or make it easier for other functions would be really interesting to see."

    What is our primary use case?

    I'm a tester, an optimization tester. It's basically when the developers have the back-end in SQL. We go and test it out for them and check that the table updated correctly, and we do something on the front-end.

    How has it helped my organization?

    To give you an example, initially we didn't have a database server as such, and we had to make use of some database. Now we use something where we can share the instances of the database which were created virtually, which is a very good feature, which I felt has improved our organization.

    What is most valuable?

    The most important features would be querying, the query language where you have the data definition or data modification language, as well. In some cases, we have to create our own tables for testing purposes. In that case, having SQL Server is much easier compared to what's available.

    What needs improvement?

    I feel that some tools which make it easier to create queries or make it easier for other functions would be really interesting to see.

    For how long have I used the solution?

    More than five years.

    What do I think about the stability of the solution?

    Pretty much since we have our own in-house SQL branch, the administrators are there, so they take care of the stability with the product. As far as I've seen, there really hasn't been much of an issue with stability.

    What do I think about the scalability of the solution?

     It's pretty scalable.

    How are customer service and technical support?

    I haven't contacted them, so I have no experience with them. We generally have an internal team which would work on it. So our point of contact is an internal team, rather than going to MySQL.

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

    I've used a lot of different solutions. MySQL is one of the top among them. Usability and scalability are some of the reasons we went with MySQL.

    How was the initial setup?

    It was pretty straightforward. No hassles with the setup. 

    Usually the setup is done by the IT admin guys, but it was pretty straightforward. The IT admin guys had to come in and give us the rights to install it.

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

    I'm not sure about pricing, I don't deal with the pricing. It's an organization decision.

    Which other solutions did I evaluate?

    There were many options.

    What other advice do I have?

    No one tool fits the bill for every company. Do a feasibility study, and get to know what is can do before going in and developing.

    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.
    Vendor
    Helps to achieve stability. Needs to improve the system so it won't lose data.

    What is most valuable?

    Usually, we use the application for our team to ensure the data is correct.

    How has it helped my organization?

    We majorly use the application now. We can use MySQL to read for our select queries. This helps us to achieve stability.

    What needs improvement?

    In MySQL, you can only have one master. The master's scalability was always a problem.

    The cost towards the locking and the patent. What happens, we will be running the MySQL network, and what happens sometimes in some cases, the master go down. Thus, we have to theoretically play the whole thing. The chances are quite high that you are going to lose some important data.

    If we can make them implement the system so we are not losing our data, then magically you could say the system would be better.

    For how long have I used the solution?

    12 years.

    What do I think about the stability of the solution?

    No. Not on the MySQL site.

    What do I think about the scalability of the solution?

    No. Not so far. I didn't see any problems in its scalability.

    How are customer service and technical support?

    We are using the community portal technical support, but when we are reaching them, the support is always awesome.

    I can give them a 10 out of 10. The best.

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

    Yeah, we used to cheat off MySQL. But in the end, it was somebody else's design. So, we migrated to MySQL. We just migrated from there to here.

    How was the initial setup?

    It always depends on the use case. The first case was complex where we ended up rewriting all of the test code better than MySQL.

    Which other solutions did I evaluate?

    It always depends on the scenarios of the requirement - what all the current scenarios come from. Are these application teams or is that someone who is just getting the product? If someone majorly bunt because they don't want to use a single point of data, we may end up choosing any other solution.

    Usually, we would pick a MySQL because of our DBS, because we know how we can boot up or pick on a use case.

    What other advice do I have?

    You just need to identify why and what are the requirements. Also, you need to listen to news feeds regarding the features you are getting into and the features you will to use from it. Take the time to identify and understand.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    PeerSpot user
    Data Scientist / Consultant with 501-1,000 employees
    Vendor
    You can build data models both on-premises and on the cloud

    What is most valuable?

    • Open Source (It’s free)
    • One can easily find help on the web

    How has it helped my organization?

    You can easily build data models both on-premise and on the cloud.

    What needs improvement?

    The work bench has some bugs that are mostly GUI related.

    For how long have I used the solution?

    I have used this solution for three years.

    What do I think about the stability of the solution?

    I did not encounter any issues with stability.

    What do I think about the scalability of the solution?

    I did not encounter any issues with scalability.

    How are customer service and technical support?

    I use the community version. There are ample “Open Source” resources on the Internet.

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

    We used Microsoft SQL and Postgres.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Deputy Manager at a university with 1,001-5,000 employees
    Real User
    A good tool for learning about networked databases
    Pros and Cons
    • "This product is a good teaching tool for students who want to learn about networked databases."
    • "The documentation is pretty weak and should be improved."

    What is our primary use case?

    I use MySQL to teach students about databases. They implement projects using this product.

    How has it helped my organization?

    MySQL is lacking some of the features that you find in a commercial product, but it is sufficient for basic functions.

    What is most valuable?

    This product is a good teaching tool for students who want to learn about networked databases.

    What needs improvement?

    The documentation is pretty weak and should be improved.

    The GUI for PHP MySQL Admin can be improved because it is not very flexible and sometimes difficult to use.

    For how long have I used the solution?

    I have been using MySQL for more than five years.

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

    I have experience with other full-scale databases, such as PostgreSQL. For use cases where I need full functionality, I would use another product.

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

    I am using the Community Edition, which is available free of charge.

    What other advice do I have?

    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
    PeerSpot user
    Director at RC Ghosh Group of Companies
    Real User
    ​We use it for enterprise data storage as well as part of the back-end of websites and web applications
    Pros and Cons
    • "​The most valuable feature of MySQL is the informative error outputs of command line interface.​"
    • "​We use MySQL for enterprise data storage as well as part of the back-end of websites and web applications.​"
    • "Setup is easy. MySQL of various flavours has community editions to easily test, deploy, and run.​"
    • "​MySQL needs improvements on its diagnostic features.​"
    • "​MySQL is not easily scalable on cost effective consumer grade hardware.​"

    How has it helped my organization?

    We use MySQL for enterprise data storage as well as part of the back-end of websites and web applications.

    What is most valuable?

    The most valuable feature of MySQL is the informative error outputs of command line interface.

    What needs improvement?

    MySQL needs improvements on its diagnostic features.

    For how long have I used the solution?

    More than five years.

    What do I think about the stability of the solution?

    No issues.

    What do I think about the scalability of the solution?

    MySQL is not easily scalable on cost effective consumer grade hardware.

    How are customer service and technical support?

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

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

    Not applicable. No previous solution.

    How was the initial setup?

    Setup is easy. MySQL of various flavours has community editions to easily test, deploy, and run.

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

    Enterprise editions and support are definitely needed for the heavy users who need direct support. 

    Which other solutions did I evaluate?

    No.

    What other advice do I have?

    One should ensure the availability of proper hardware before any optimization attempt from the software level.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user755103 - PeerSpot reviewer
    Open Source Database Consultant
    Vendor
    A high level of support due to a lot of documentation and expertise in the world

    What is most valuable?

    • Vertical scalabity on hardware
    • Better hardware usage
    • Access performance
    • Addressing consistency, scalability and performance issues

    How has it helped my organization?

    Storage and searching quickly on data is no longer an issue facing us using Excel.

    What needs improvement?

    Hardware scalability and parallel treatment can and will be improved in the next few years.

    For how long have I used the solution?

    For 15 years now.

    What do I think about the stability of the solution?

    No, there are only strategies applied by a data scale interval (less than 200 go, less than 1 to, and more than 15 to).

    What do I think about the scalability of the solution?

    Always due to architecture, data storage, and data requesting irrelevant strategies.

    How are customer service and technical support?

    High. There is a lot of documentation, a lot of expertise, and a lot of projects in the world.

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

    We switched to a different solution because of data access issues, speed, and consistency.

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

    Don't use the license version. Open source is enough.

    Which other solutions did I evaluate?

    There are a lot of alternative to paid features. It's very hard to find support for this feature.

    What other advice do I have?

    You will have a lot of work, but you will also avoid a lot of issues due to product immaturity on the database market.

    Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
    PeerSpot user
    PeerSpot user
    Director of Information Technology at a tech services company
    Real User
    Several unexplained crashes caused dissatisfaction from users

    What is most valuable?

    Installation, because in a few seconds, the product was up and running.

    How has it helped my organization?

    It was the first step of the Service Desk.

    What needs improvement?

    ITIL implementation:

    GLPI has a poor ITIL implementation in the sense that not all ITIL processes are implemented, e.g., no Service Catalog is present.

    For how long have I used the solution?

    I've used this solution for two years.

    What do I think about the stability of the solution?

    Yes, several unexplained crashes caused dissatisfaction from users.

    What do I think about the scalability of the solution?

    Yes.

    How are customer service and technical support?

    Zero. No support at all. Only forums with no response.

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

    I have not used a solution like this before.

    How was the initial setup?

    Straightforward.

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

    It was open source and license-free.

    Which other solutions did I evaluate?

    Yes, but commercial ones (ManageEngine, EasyVista, Remedyforce).

    What other advice do I have?

    Not choosing an open source software for this kind of solution. Now, we are looking at ServiceNow Express.

    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.