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.

    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.
    770,394 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?

    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 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
    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
    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.
    770,394 professionals have used our research since 2012.
    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
    PeerSpot user
    Software Developer at a tech services company with 501-1,000 employees
    Consultant
    It tends to perform better on Linux and other UNIX-like systems, but it needs support for foreign keys.

    Valuable Features:

    • Excellent performance, mainly due to the format of its default table, MyISAM - low disk space, CPU, and memory
    • Flexibility offering multiple variations such as Berkely DB , InnoDB, Heap and MyISAM
    • Reliability. Although the system runs on Windows without flaws, it tends to perform better on Linux and other UNIX-like Systems.
    • Availability
    • Open-Source System, open storage database engine
    • Used by many websites (e.g. LinkedIn, Facebook, Verizon, and PayPal)
    • It's inexpensive when compared to other common databases like Microsoft SQL Server.
    • As a developer myself, I enjoy using it at no cost as long as the associated projects are also open-source.

    Room for Improvement:

    • Limited storage capacity
    • Support for foreign keys
    • Stored procedures
    • The biggest disadvantage of MySQL is MyISAM system, which doesn't support well transactions (lack of efficiency)

    Use of Solution:

    Personally, I've been using it for over 10 years, and professionally for three to four years.

    Deployment Issues:

    I had no problems deploying it.

    Stability Issues:

    With each release of MySQL Server was useful for any little problems that users detected, so I would say it's quite stable.

    Customer Service:

    Previous Solutions:

    Initial Setup:

    It was straightforward, thanks to the workbench that pulls together nearly every MySQL task, and puts them into one easy and friendly GUI.

    Cost and Licensing Advice:

    Because MySQL is an open-source , the system is under GNU Licence. The system isn't always free, but it's more affordable. If you intend to sell your software as a proprietary product, you would need to purchase a commercial license, which is quite inexpensive when compared with a Microsoft SQL license.

    Other Advice:

    From my perspective, MySQL is a product that allows you to be efficient, but the decision goes down to the situation and what you're looking to accomplish.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user333624 - PeerSpot reviewer
    it_user333624Software Developer at a tech services company with 501-1,000 employees
    Consultant

    also with the new 5.7 edition added some other fixes , update, firewall , etc. You can check the new version on their page.

    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.