Try our new research platform with insights from 80,000+ expert users
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.

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 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 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
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.
reviewer1399998 - PeerSpot reviewer
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.

it_user1065 - PeerSpot reviewer
Senior Manager of Data Center at a integrator with 51-200 employees
Vendor
One of the best open source database for web developers and application enthusiasts

Valuable Features:

The best features in MySQL, making it one of the most used databases globally, are- 1) Multi-threaded architecture for multiple CPU utilization and kernel threading 2) Use of triggers and crash recovery techniques 3) Indexed Conditional Pushdown 4) Integration with LAMP/WAMP 5) Easy setup with Memcached for increasing performance and scalability

Room for Improvement:

Few cons in MySQL are 1) Increased complexity in InnoDB 2) Slower performance when using InnoDB as compared to MyISAM for using simple queries 3) Only identical MyISAM tables can be merged. 4) No active directory integration as in SQL server 5) It does not support check constraints

Other Advice:

MySQL is indeed the world's most popular open source database. It has been designed on the hyper threading infrastructure and supports multi-threaded architecture for using multiple CPU's. It works on index compression with B-Tree disk tables popularly known as MyISAM. Its efficiency depends on the implementation of SQL functions with optimization of library classes.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user2652 - PeerSpot reviewer
it_user2652Project Manager at a non-tech company with 10,001+ employees
Vendor

MySQL is platform independent and can be installed on windows, linux and other OS too. It is an open source database under the GNU General Public License, that means developers can use it at no cost as long as the associated projects are also open source.

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.