Try our new research platform with insights from 80,000+ expert users
reviewer938061 - PeerSpot reviewer
Sr. Solution Architect at a computer software company with 5,001-10,000 employees
Real User
An easy to use solution which comes with a free stable version, but should have better integrative features
Pros and Cons
  • "The solution is easy to use."
  • "Integration is a key feature in need of improvement."

What is our primary use case?

With most open source products we were building, even the language was open source, such as that which employs PHP. This is where the MySQL free version was being primarily used by many of the clients in the storing of their data. 

There have been some great shoppers which we built with the solution. We use the solution to store the transactional data that we receive from various sites or have the data stored in MySQL. 

What is most valuable?

The solution is easy to use. As the query patterns are very similar to SQL, this simplifies the use and understanding of the solution. 

What needs improvement?

Integration is a key feature in need of improvement, as we have spent hours building this just to ensure that a set of data is exposed to a different client, a different world in need of that data. Since we are dealing with open source, which we are now employing in memory databases as well, it would be nice if they were to start thinking along those lines. 

For how long have I used the solution?

I have been dealing with MySQL for around a decade. 

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

What do I think about the stability of the solution?

I have found the free version to be stable. 

How are customer service and support?

I have not made use of technical support. 

What about the implementation team?

I was not involved in either the installation or deployment strategy. 

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

While I was not involved in those projects over the past year, we do have a couple of clients who choose to use the paid, enterprise version of the solution and who take full advantage of it.

What other advice do I have?

While the solution has, nowadays, moved to the cloud, the one I have been dealing with is on-premises.

Even though the solution has not been off the market, I do not possess the exact figures of those making use of it. It is still being used by a couple of our clients. 

I would recommend the solution to those interested in using the free, stable version of the solution which incurs no licensing costs. 

I rate MySQL as a seven out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
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
Buyer's Guide
MySQL
December 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
829,634 professionals have used our research since 2012.
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
Top 20Vendor

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.

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