Ingénieur Etude et Développement / Technical Lead Java at ATOS
Consultant
Open-source, easy to install, and has good documentation, but scaling it can be difficult
Pros and Cons
  • "The most valuable features are that it's free and the documentation is good."
  • "In the next release, I would like to see the scalability features improved to allow you to configure it and reduce the complexity with the configuration, making it easier for the end-user to scale. Make it as simple as it can be."

What is our primary use case?

MYSQL is our main database. We use it for every project.

I use it for storage procedures, SQL administration, and database administration.

We also use it for the development of reports, and projects that are deployed for our customers. It is also used to develop applications.

The majority of companies use it for their development projects.

How has it helped my organization?

It's free. I'm in a big organization, with more than 100,000 employees. If you have to buy a database management system for every project, it would be very expensive. 

Considering the cost-free option, you can use it for POCs,(proof of concept projects), and you can deploy it for customers to reduce project costs. The principal reason is that it is cheap.

What is most valuable?


Mysql is free : it's an open source project, so you can use it with no cost.

Mysql is well documented, and has a big community.

MySQL adheres to the current SQL standard, although with significant restrictions and a large number of extensions. Through the configuration setting sql-mode you can make the MySQL server behave for the most part compatibly with others like IBM DB/2 and Oracle.

There are a number of convenient user interfaces for administering a MySQL server.

MySQL has supported the storing and processing of two-dimensional geographical data. Thus MySQL is well suited for geographic information systems applications.

MySQL supports the ODBC interface.


For client programming you can use, among others, the languages C#, C, C++, Java, Perl, PHP and Python.



What needs improvement?

I would like to see a feature added to be able to handle high availability, which would allow us to scale the database or the system on many platforms.

Scalability has to be improved, as you have only one instance of the application, or two, or more instances at max that are connected on one instance of MySQL.

In the next release, I would like to see the scalability features improved to allow you to configure it and reduce the complexity with the configuration, making it easier for the end-user to scale. Make it as simple as it can be.

Add the possibility to define custom data types 

Add OLAP and backup capabilities

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

For how long have I used the solution?

I have been using MySQL for more than five years.

What do I think about the stability of the solution?

It is stable, and in fact, it's more stable than PostgreSQL. Also, recovery is faster.

What do I think about the scalability of the solution?

Scalability is difficult. You can scale it horizontally, but once you have many instances, it is difficult.

You can improve the server, resources that are available, and the processor is good but if you want to scale it on many instances than it is a bit complex.

We use it for customers. We have 10 instances of MySQL independently, on the project we are currently working with.

How are customer service and support?

It's an open-source solution. There is documentation available on the internet, that provides enough to resolve issues quickly.

How was the initial setup?

If you are a technician with practice, there is no issue, it's easy to handle. The documentation is available on the internet. You have everything you need quickly if you are autonomous.

It's easy, you just download it, install it and click next until it's complete.

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

It's an open-source database management system that can be used free of charge.

What other advice do I have?

I am not using the user interface because I'm a developer. Generally, I just try to find how to use the command-line interface to access what I want for the system.

Oracle is still the best, but it's too expensive.

Before purchasing this solution, know the needs of your environment and be sure that you don't have to scale it. If you want to scale it you will require more knowledge on the product and you will need more support for it.

If you have a little project with a thousand users connected to the instances, it will be able to be scaled. But if you are looking to be able to handle large volumes this is not a good solution for your needs.

If am comparing MySQL with other free solutions then I would rate this solution a seven out of ten.

Which deployment model are you using for this solution?

On-premises

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Google
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Managing Director at a financial services firm with 201-500 employees
Real User
Fully scalable relational database management system with good stability; setting it up was easy and straightforward
Pros and Cons
  • "Fully scalable and stable SQL-based RDBMS, with a straightforward and easy setup."
  • "Even for the best database, we always want the database to perform much better, so we wish MySQL would be much better, in terms of performance."

What is our primary use case?

We're using MySQL for data warehousing and logging.

What needs improvement?

Even for the best database, we always want the database to perform much better, so we wish MySQL would be much better, in terms of performance. When they release a new version, they mostly concentrate on scalability and performance.

For how long have I used the solution?

I've been using MySQL for seven years.

What do I think about the stability of the solution?

The stability of MySQL is good.

What do I think about the scalability of the solution?

MySQL is a fully scalable product.

How was the initial setup?

The initial setup of MySQL was easy and straightforward. You can complete the initial setup for this product within a few hours.

What about the implementation team?

It was the technical team who did the setup for MySQL. We had two or three engineers who took care of the deployment and maintenance of this product.

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

MySQL is very cheap. In fact, it could be free. They also have a yearly licensing option. I don't remember paying for additional costs, aside from the standard licensing fee.

Which other solutions did I evaluate?

I evaluated Oracle Database.

What other advice do I have?

I'm using the Enterprise version of MySQL.

MySQL is a good database. We are using it, and we'll continue to use it.

I've never contacted the technical support team for MySQL. I have no complaints.

I can recommend MySQL to others who plan to start implementing it.

We don't ask for new features on a database. When we take a database, we take it because of fixed features, e.g. its current features. It's not an application. It's a database. We are fine with whatever features MySQL offers now. We never really thought about whether we want more features on this product.

I'm rating MySQL an eight 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
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.
768,886 professionals have used our research since 2012.
Data Architect at ACPAS Loan Management Software
Real User
Easy to use, easy to deploy, and stable with useful table partitioning feature
Pros and Cons
  • "Table partitioning is most valuable. It is easy to use."
  • "I am looking for the Temporal SQL feature, which basically means that there is complete history for each table. This feature is currently available in MariaDB. PostgreSQL has something called a foreign-data wrapper, which is another way to access external data from inside. MySQL could have a similar feature."

What is our primary use case?

We are using it for RADIUS protocol, which is for network access. We are tracking the duration of user stations.

What is most valuable?

Table partitioning is most valuable. It is easy to use.

What needs improvement?

I am looking for the Temporal SQL feature, which basically means that there is complete history for each table. This feature is currently available in MariaDB.

PostgreSQL has something called a foreign-data wrapper, which is another way to access external data from inside. MySQL could have a similar feature.

For how long have I used the solution?

I have been using this solution intermittently for six months. 

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

It is scalable. We currently have six users.

How are customer service and technical support?

I don't have any experience with their technical support.

How was the initial setup?

Its initial setup was straightforward. It took 10 minutes.

What about the implementation team?

I did it myself. We have two people for its deployment and maintenance.

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

I am not paying, but I am not sure about the exact licensing requirements.

Which other solutions did I evaluate?

It is always compared with PostgreSQL and Microsoft SQL Server.

What other advice do I have?

I would recommend this solution to others. I plan to keep using it.

I would rate MySQL an eight 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
PeerSpot user
Senior Web Manager at a university with 501-1,000 employees
Real User
Support for enterprise-grade features like clustering, Sharding, in an open-source solution
Pros and Cons
  • "Support for enterprise-grade features like clustering, master-slave replication, even Sharding (to some extent) which is an advanced feature."
  • "It would be helpful if there were a graphical user interface to administer, configure, and tune it."
  • "If it had something similar to Microsoft’s DTS engine then it would be the best database system out there."

How has it helped my organization?

Due to the open source licensing model, it has allowed small businesses like ours to adopt enterprise-grade database systems without incurring significant licensing costs.

What is most valuable?

  • Open-source
  • Multi-platform
  • Lightweight
  • Simple to set up, configure and tune
  • Support for enterprise-grade features like clustering, master-slave replication, even Sharding (to some extent) which is an advanced feature

What needs improvement?

It would be helpful if there were a graphical user interface to administer, configure, and tune it.

If it had something similar to Microsoft’s DTS engine then it would be the best database system out there.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

For the scale at which my systems are operating, the software is stable. We are at most dealing with less than 10 million rows of data across all tables, and concurrent connections under 200 at our peak loads.

What do I think about the scalability of the solution?

No scalability issues at the scale at which my systems are operating. One thing I did encounter with an earlier version of MySQL 5 – the mysql process will not automatically use available CPU cores on the server, even if it was a dual or quad core CPU. I was troubleshooting a scalability issue when I saw this, it maxed out just a single core and left the other three (in my quad core CPU server) idle. There was a specific condition / trigger that will make the mysql process span the other available cores (I can’t recall now but a quick googling likely will uncover this).

How are customer service and technical support?

We did not subscribe to professional support from MySQL AB or Oracle. However, the wealth of community support is outstanding. Most of the issues faced could be resolved by knowledge shared by the MySQL community.

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

I’ve used SQL Server and Oracle for database systems. SQL Server is an excellent solution, in particular the DTS (Data Transformation System) which is not available for MySQL. Switching to MySQL for two reasons: 1) licensing costs 2) the application supports MySQL primarily, and has poor support for SQL Server.

How was the initial setup?

Very easy to set up, relatively easy to configure, tune, and use the conf file, as long as you are comfortable mucking around in Linux conf text files and working from the command line (I am).

You could use the installer which would be the easiest way, but setting up by hand is not too difficult either – instructions can be found online and following them step by step usually works fine.

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

MySQL Enterprise Support is not cheap, though might still be cheaper than Oracle or SQL Server. They may not have local support depending on where you’re based, but there are many smaller agencies out there that will readily provide support. You’ll need to spend some time looking around.

Which other solutions did I evaluate?

I’d been using other database systems like Microsoft’s SQL Server and Oracle Database before trying out MySQL. There are forks of MySQL maintained outside of Oracle, like MariaDB and Aurora (by Amazon Web Services). I have not really tried them but I don’t expect very big differences; in fact, for most use cases you may not observe any difference. There would be the few unique features in MariaDB and Aurora that are not present in the original MySQL feature set (I know there are but don’t remember the specifics).

What other advice do I have?

As long as your application supports it well, and you are familiar with the scaling options and its limitations, you can’t go very wrong with MySQL, as it is a very mature product by now. If you are fairly competent with servers and databases you could start off without subscribing to Enterprise Support, and may be able to get by quite well. If things get more complicated, or scalability starts to become a problem, then you may consider paying for help.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Director at BAB
MSP
Top 20
A stable and flexible product that is easy to use and can be deployed quickly
Pros and Cons
  • "The product is flexible and easy to use."
  • "The interface could be improved."

What is our primary use case?

I use the product as a backend to my application.

What is most valuable?

The product is flexible and easy to use.

What needs improvement?

The interface could be improved.

For how long have I used the solution?

I have been using the solution for seven to ten years. I am using the latest version of the solution.

What do I think about the stability of the solution?

I rate the tool’s stability a nine out of ten. The stability is good.

What do I think about the scalability of the solution?

I rate the tool’s scalability a seven out of ten. We have four direct users and more than 1000 indirect users. We use the tool twice a week.

How was the initial setup?

I rate the ease of setup an eight out of ten. The deployment took a few minutes. We need two system administrators to maintain the tool.

What about the implementation team?

The deployment was done in-house. We need one system administrator to deploy the tool.

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

I rate the pricing a seven or six out of ten on a scale of one to ten, where one is cheap and ten is expensive.

What other advice do I have?

We used different solutions before, but I do not know why we switched to MySQL. I recommend the solution to others. Overall, I rate the product an eight 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.
Flag as inappropriate
PeerSpot user
Lead Project Manager, Owner at a tech services company with 11-50 employees
Real User
Ubiquitous solution for a wide variety of uses.
Pros and Cons
  • "The feature that I have found most valuable is its ubiquity. MySQL is everywhere, so if I need to find a developer to do things to it that I don't know, it's very easy to find someone who has expertise in it."
  • "It could be a little bit simpler to use."

What is our primary use case?

We use it for my clients. Basically any website that uses WordPress uses MySQL, so we use that to manage and run our WordPress websites. Some we have on a cloud, some we have at hosted servers.

It is part of WordPress and some clients are using it for eCommerce, and others are just using it as part of the website to give information.

What is most valuable?

The feature that I have found most valuable is its ubiquity. MySQL is everywhere, so if I need to find a developer to do things to it that I don't know, it's very easy to find someone who has expertise in it.

What needs improvement?

In terms of what could be improved, there is not anything that I can think of offhand.

Everything related to automation or improvements are external tools that are brought into it, so it has nothing to do with the robustness of the system itself - it is the developers and implementations that touch it. Those can be improved, but MySQL itself is fine as is. 

I would just say that it could be a little bit simpler to use.

For how long have I used the solution?

I've been using MySQL off and on for about seven years.

Different hosting systems have different iterations of it. Whenever possible, I try to use the latest version, but usually I'm using a model or two back. But I'm not using the original, not by any stretch.

What do I think about the stability of the solution?

Everything that works with MySQL is stable. If it's a bug, it's due to the developer who has miswritten a piece of code. The code itself is perfect. It's the application of people who attempt to make changes where the issues come in.

What do I think about the scalability of the solution?

In terms of scalability, I have not done anything bigger than a couple hundred people a day on a site, so I really couldn't tell you about that.

Our clients are small businesses, almost all of them with less than 50 employees.

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

Previously, and I am talking almost 20 years ago, we would have used Microsoft Access, which is not a relational database and it's not iterative, so you can't have multiple people working on it, whereas MySQL is a system-based database, so multiple people can access it at the same time.

How was the initial setup?

In terms of the initial setup, you definitely need to know what you're doing, but it's not illogical. The database rules and how they work are very clear and concise. To execute MySQL is fairly straightforward.

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

MySQL is open source so it's free.

What other advice do I have?

My advice to anyone considering MySQL is to check the forums and do your homework.

On a scale of one to ten, I would give MySQL a 9. It would be a 10 if it was simpler to use, but as it is, it's about a 9.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior System Administrator at Debre Markos University
Real User
Top 20
A stable, scalable, easily installable solution which boasts ease of use and good performance
Pros and Cons
  • "I am totally satisfied with MySQL."
  • "The solution could have better integration and security features."

What is our primary use case?

We use the solution for our applications, as a management system. We utilize it as an operator or relational database. 

What is most valuable?

I am totally satisfied with MySQL. I like its performance, ease of use, stability and scalability. 

What needs improvement?

The solution could have better integration and security features. 

For how long have I used the solution?

I have been using MySQL for more than five years.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

The solution is scalable. 

How are customer service and technical support?

I have no experience with tech support. 

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

We did not use another solution prior to the current one. 

How was the initial setup?

Installation is easy. It takes about 20 minutes.

What about the implementation team?

One can do the installation on his own. 

Our team involved 15 people. 

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

There is no licensing fee. 

What other advice do I have?

I believe there are 100 users making use of the solution in our organization.

I would recommend this solution to others. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Solution Architect at KIAN company
Real User
Ease to use, high performance, and has quick startup times
Pros and Cons
  • "When comparing MySQL to other solutions it is easier to use and boots up faster. Additionally, when you want to query a lot of data, MySQL is better in performance."
  • "The solution could improve the monitoring. At the present time, you need to use third-party monitoring solutions."

What is our primary use case?

In our company, we are providing an application in PHP language and we need to use another database and we made the decision to use MySQL.

What is most valuable?

When comparing MySQL to other solutions it is easier to use and boots up faster. Additionally, when you want to query a lot of data, MySQL is better in performance.

What needs improvement?

The solution could improve the monitoring. At the present time, you need to use third-party monitoring solutions.

For how long have I used the solution?

I have been using this solution for approximately one year.

What do I think about the stability of the solution?

When it comes to stability SQL server is better than MySQL. This is an area they could improve.

What do I think about the scalability of the solution?

We have approximately five users using this solution in my organization.

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

I have previously used SQL Server.

What other advice do I have?

I would recommend this solution to others.

I rate MySQL an eight 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
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.