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.
Solution Architect at KIAN company
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?
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.
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?
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.
Manager at ANET
Easy to use, fast, and developer-friendly, but it should have better support for big data
Pros and Cons
- "MySQL is a popular database platform for businesses because it is extremely easy to use."
- "When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL."
What is our primary use case?
We developed a network monitoring software and used MySQL as a backend database.
We utilized the two most common and popular MySQL database engines, MyISAM and InnoDB.
We store collected monitoring data and configuration data on MySQL. Also, our network monitoring solution reporting module is based on the MySQL MyISAM database engine.
We use both Windows and Linux versions of MySQL, and we utilize the backup and recovery features.
To summarize, our primary use case is the embedded DB component for our network management software.
How has it helped my organization?
MySQL is a popular database platform for businesses because it is extremely easy to use. It is commonly used in combination with PHP and Java. For instance, someone with little to no knowledge of MySQL can easily establish a database connection and start programming immediately.
So MySQL improved our developing process speed. MySQL is a very popular and well-known database solution, so it is easy to find a MySQL developer.
MySQL performance also improved our NMS solution performance.
What is most valuable?
MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses.
MySQL advantages and valuable points include:
- MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
- MySQL uses a standard form of the well-known SQL data language.
- MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, Java, etc.
- MySQL works very quickly and works well, even with large datasets.
- MySQL is very friendly to PHP and Java at the same time. Both PHP and Java are our development languages.
What needs improvement?
The two most common and popular MySQL database engines are MyISAM and InnoDB. Database engines provide the underlying functionality for MySQL to work with and process data. MyISAM is the default engine for MySQL for versions earlier than 5.5.5 and functions well in most scenarios.
However, depending on your needs, there are situations where another database engine, such as InnoDB, may be the better choice. For example, InnoDB supports transactions, whereas MyISAM does not. InnoDB also provides support for foreign keys, whereas MyISAM does not.
When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL. An example of this is the Vertica DB engine (https://en.wikipedia.org/wiki/...), and offering support for it would be valuable.
For how long have I used the solution?
We have been using MySQL for more than ten years.
Which solution did I use previously and why did I switch?
Previously, we used MSSQL and switched to MySQL because of performance issues.
How was the initial setup?
After installation, the maintanence is easy for an end-user.
What's my experience with pricing, setup cost, and licensing?
MySQL is released under an open-source license, so you have nothing to pay to use it.
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.
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.
Senior Data Analyst at Charutarhealth Org
Easy to set up, stable, and good technical support
Pros and Cons
- "The replication feature is the most valuable. We are replicating our servers."
- "It should have some code analytical functions. It can also have a monitoring tool."
What is our primary use case?
We are interfacing it with MicroStrategy. There are ODBC connections. We have 10 to 12 users in our company.
We are assessing the possibilities of moving to the cloud. We are not yet sure if we are going to move to the cloud.
What is most valuable?
The replication feature is the most valuable. We are replicating our servers.
What needs improvement?
It should have some code analytical functions. It can also have a monitoring tool.
For how long have I used the solution?
I have been using MySQL for ten years.
What do I think about the stability of the solution?
It is stable. We are not dealing with a huge database. Our database is not more than 1 TB, so we didn't find any problem.
What do I think about the scalability of the solution?
I haven't seen a need for scalability.
How are customer service and technical support?
Their technical support is good.
How was the initial setup?
The initial setup is easy. We are using it on Linux, and our server is on CentOS.
What other advice do I have?
I would recommend this solution. I would rate MySQL a nine out of ten. I find it almost perfect.
Which deployment model are you using for this solution?
Private Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Information Technology Infrastructure Manager at a comms service provider with 201-500 employees
Feature-rich, cost-effective, and allows us to implement clustered solutions
Pros and Cons
- "MySQL gives us all of the critical features that we need in a database, but without the costs."
- "I would like to have features that allow us to jump between the cloud and our on-premises system."
What is most valuable?
MySQL gives us all of the critical features that we need in a database, but without the costs.
The most valuable feature is that we can implement clustered solutions.
What needs improvement?
I would like to have features that allow us to jump between the cloud and our on-premises system.
For how long have I used the solution?
I have been using MySQL for about 20 years.
What do I think about the stability of the solution?
MySQL is a very stable product.
What do I think about the scalability of the solution?
I know that it is scalable, and in fact, that is why we chose it. We always have it in mind that in some number of years, you have to scale the solution to something different in terms of architecture.
As it is now, our databases are not big. They are critical, but not large in size. We are not dealing with Big Data.
How are customer service and technical support?
We have never contacted Oracle for MySQL support.
The documentation that is available is enough for my needs.
Which solution did I use previously and why did I switch?
This was the first database solution that we used. I have used other database products such as Oracle, for example. Oracle comes at a heavy cost.
What's my experience with pricing, setup cost, and licensing?
This is an open-source product that can be used free of charge.
Which other solutions did I evaluate?
This is the product that was proposed to us and we implemented it.
What other advice do I have?
MySQL is a product that I can strongly recommend. However, it is important for you to have the in-house knowledge to support it. Some level of in-house expertise is necessary, otherwise, you will have to rely only on external opinions. In my opinion, that's not good. Sometimes they have good intentions but don't understand the reality.
I cannot give MySQL a perfect rating because we don't use all of the features. That said, I can tell you that I am totally satisfied with it. It's a very stable product and it's something that is not difficult to deal with.
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.
Vice President & Head of IT Governance at a financial services firm with 1,001-5,000 employees
Good performance, but requires better scalability and more reliable stability
Pros and Cons
- "The solution is great for small applications in particular."
- "As an open-source product, there isn't really any technical support available if you get into trouble or have issues."
What is our primary use case?
We primarily use the product for small applications.
What is most valuable?
The solution is great for small applications in particular.
The performance is good.
The solution originally was designed as an open-source product. It has a community edition that anyone can use for free.
The initial setup is simple and straightforward.
What needs improvement?
I have doubts about its overall stability. It's something that they should look at.
As an open-source product, there isn't really any technical support available if you get into trouble or have issues.
There isn't much scalability potential in the product.
For how long have I used the solution?
I've been using the solution for a very long time. It's been years at this point.
What do I think about the stability of the solution?
The stability could be better. It's not as stable as I would prefer it to be.
It was originally designed as freeware, as an open-source project, and the community wrote the solution. However, they've made it worse over time.
That said, the performance is pretty good.
What do I think about the scalability of the solution?
The solution is not that scalable. It's not something you should pick if you need something to expand significantly.
While I can't speak to how many people use the solution in our company, I can say that it is used by several departments and divisions.
How are customer service and technical support?
The solution is open-source and managed by a community. Therefore, there is no technical support available to users.
How was the initial setup?
The initial setup is very easy and quite straightforward. It's not overly difficult or complex.
That said, I was not a part of the original setup and therefore cannot speak to how long the deployment took my team.
What about the implementation team?
We didn't need any assistance from integrators or consultants. The setup was handled in-house.
What's my experience with pricing, setup cost, and licensing?
The solution is open-source and free to use. We have the community edition. We don't have to pay to use it right now.
What other advice do I have?
Right now, Oracle has taken over the business of MySQL. Now, it's standard that you have to pay money for the license. That's why we are shifting all our databases, the small, small databases, from MySQL to Oracle. We do have extra data, so we do require a license.
Currently, we are using the previous version of the solution. I can't speak to the exact version number, however.
I'd rate the solution at a five out of ten.
I wouldn't recommend it to other organizations at this time.
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.
Founder at Art World Web Solutions
Easy to integrate and reasonably priced but the memory consumption needs to be improved
Pros and Cons
- "The connectivity with PHP is quite good."
- "On the database side, it should be really lightweight, and the data structure should be like MongoDB."
What is our primary use case?
We use this solution for the database.
What is most valuable?
The connectivity with PHP is quite good.
It is easy to integrate, and the fees are less than Oracle and other services.
What needs improvement?
MySQL is good but it should be able to handle the large transaction levels that Oracle can. It should be able to manage large amounts of data. We have experienced some issues when we are handling a large amount of data in MySQL.
The memory consumption it's using is very high at times, and the default parameter settings are not quite good automatically. We need to tweak the configuration as per the requirements. This is an area that can be improved by giving some guidelines and direction.
On the database side, it should be really lightweight, and the data structure should be like MongoDB.
It should put less load on to the memory and it should be able to handle maximum data.
For how long have I used the solution?
I have been working with MySQL for approximately five years.
What do I think about the stability of the solution?
The solution is stable but there is an issue with memory consumption at times.
How are customer service and technical support?
I have not contacted technical support. I am using MySQL with Zabbix and when I have an issue, I contact Zabbix who resolves the issues on their end.
How was the initial setup?
I am a developer and I handle the other side of things. I rely on the DB team to handle the maintenance and deployment. My knowledge is very basic.
What's my experience with pricing, setup cost, and licensing?
It's cheaper than other solutions.
What other advice do I have?
For one level of data, you can use MySQL. However, for large amounts of data, you will have to find other databases.
Overall, it's a good solution.
I would rate MySQL a six 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.
Co-Founder/CEO at Grigale LTD
Dramatically improved use for several of my customers, better ROI for me
How has it helped my organization?
It dramatically improved use for several of my customers.
What is most valuable?
This depends on my customers' use.
What needs improvement?
SQL and NoSQL use.
For how long have I used the solution?
More than five years.
What do I think about the stability of the solution?
When configured correctly, no stability issues.
What do I think about the scalability of the solution?
When configured correctly, no scalability issues.
How are customer service and technical support?
Very good.
Which solution did I use previously and why did I switch?
MySQL Support Services by Percona. I switched to Oracle MySQL services because of a better ROI.
How was the initial setup?
There is no obvious answer. It depends.
What's my experience with pricing, setup cost, and licensing?
Depends on the customer's needs.
Which other solutions did I evaluate?
MariaDB, MySQL Support Services by Percona.
What other advice do I have?
Stick with the source, stick with Oracle MySQL as the leading vendor for MySQL technology.
Disclosure: My company has a business relationship with this vendor other than being a customer: Oracle Gold Partner and MySQL top reseller in Israel.
Telecommunications Engineer at a comms service provider with 1,001-5,000 employees
Offers SQL Merge, Replication, and Views. I would like to see additional side management tools and IDEs.
What is most valuable?
- SQL Merge
- Replication
- Views
- Stored Procedures
- Triggers
- Cursors
This is just like the enterprise grade Oracle DB. MySQL now supports replication (master-master or master-slave) of our DB to support our company's multiple geo-locations and PoPs.
It supports the original Oracle SQL operations such as Merge, as well as the creation of Views to your tables. This brings additional convenience to our organization.
How has it helped my organization?
The main benefit for us is that it's totally free, unless you need to pay for support.
What needs improvement?
I would like to see additional side management tools and IDEs.
For how long have I used the solution?
I used this current version for one year. I used previous versions for over ten years.
What do I think about the stability of the solution?
There were no stability issues.
What do I think about the scalability of the solution?
There were no scalability issues.
How are customer service and technical support?
We didn't need any technical support. I would guess that Oracle support is top-level.
Which solution did I use previously and why did I switch?
We did not use a solution prior to this one.
How was the initial setup?
The initial setup was straightforward, user-friendly, and easy. In most cases, if you use the Linux-based versions, it comes as a standard Linux package. You can get it installed by using AptGet, Aptitude, or Yum.
What's my experience with pricing, setup cost, and licensing?
Just pay for any license if you need some enterprise support for your project or any additional support tools that Oracle ships with the enterprise version. During the development stage of your project, you can just use the free community edition.
Which other solutions did I evaluate?
What other advice do I have?
Go with the Linux version. It is more stable and manages the system resources better.
Disclosure: My company has a business relationship with this vendor other than being a customer: We are partners, developing applications together.
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros
sharing their opinions.
Updated: October 2024
Popular Comparisons
Tableau
SQL Server
Oracle Database
Teradata
MariaDB
SAP HANA
PostgreSQL
Firebird SQL
IBM Db2 Database
Vertica
Amazon Aurora
CockroachDB
LocalDB
Faiss
SingleStore
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which solution do you recommend for embedding reporting? Why?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Why are MySQL connections encrypted and what is the biggest benefit of this?
- Considering that there is a free version of MySQL, would you invest in one of the paid editions?
- What is one thing you would improve with MySQL?
- How does MySQL compare with Firebird SQL?
- When evaluating Open Source Databases, what aspect do you think is the most important to look for?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Which database is the best for session cashing?
- Which low-code (no-code) database solution do you prefer?