No more typing reviews! Try our Samantha, our new voice AI agent.
reviewer1514799 - PeerSpot reviewer
Project Business Analyst RPA at a consultancy with 11-50 employees
Real User
Feb 22, 2021
An open-source relational database management system with a useful search feature
Pros and Cons
  • "What I really like about MySQL is the opportunity to search for information and organize it any way I like."
  • "It should provide better customer experiences."
  • "MySQL needs to be more accessible and user-friendly."

What is our primary use case?

We use MySQL to organize data, analyze information, and make decisions for the company. We also use it to process information from different areas in the company.

What is most valuable?

What I really like about MySQL is the opportunity to search for information and organize it any way I like. If you know the queries and you add the code, you can organize information any way you like.

What needs improvement?

MySQL needs to be more accessible and user-friendly. The person working with it needs to be trained in MySQL to have the necessary skills to control the database and analyze data. It should provide better customer experiences.

For how long have I used the solution?

I have been using MySQL for one year.

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

How was the initial setup?

The initial setup depends on your knowledge. If you know the principles, except when it comes to queries, it's easy. But if you don't know anything about MySQL or SQL, you can't do it. It took us about six months to set up and deploy MySQL.

What other advice do I have?

I would tell potential users that people in production have to be trained to use MySQL. They should take some courses, and get certificated. This will show them how to use the principal tools and provide some context about how MySQL works. 

On a scale from one to ten, I would give MySQL an eight.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
PeerSpot user
reviewer1489614 - PeerSpot reviewer
SVP Technology and Head of India at a financial services firm with 201-500 employees
Real User
Jan 28, 2021
A stable and effective data store, but technical support should be available worldwide
Pros and Cons
  • "We use it as a data store and from that perspective, we get everything we need."
  • "The technical support should be more knowledgeable and available worldwide."

What is our primary use case?

We are an asset management product company. Our product is deployed on the cloud and the backend database for it is MySQL.

What needs improvement?

The technical support should be more knowledgeable and available worldwide.

For how long have I used the solution?

We have been using MySQL for the past five to six years.

What do I think about the stability of the solution?

So far, it has been pretty stable and I haven't had any problems. We plan to continue using it in the future.

What do I think about the scalability of the solution?

MySQL is very scalable, so I don't expect any challenges.

How are customer service and technical support?

We have a contract with a third-party for support. So far, it has been working fine for us and I don't see any challenges. That said, having worldwide support is something that would be an improvement.

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

Prior to MySQL, we did not use another database for this purpose. We built our core product directly on top of MySQL.

How was the initial setup?

The initial setup seemed pretty decent, so I don't see any challenge in that regard.

What about the implementation team?

Our in-house DBA team installed it. We have one DBA and one junior.

What other advice do I have?

This is a good product and I recommend it to others.

We use it as a data store and from that perspective, we get everything we need. We don't have any complaints about features such as analytics, reports, or dashboards.

I would rate this solution a six out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
MySQL
October 2026
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: October 2026.
921,840 professionals have used our research since 2012.
reviewer1442025 - PeerSpot reviewer
Senior Database Administrator Engineer at a comms service provider with 10,001+ employees
Real User
Dec 6, 2020
Easy to set up but the stability needs to be improved
Pros and Cons
  • "It was easy to install."
  • "We plan to continue using this product; it's good, and I can recommend it to others."
  • "Stability needs improvement and the backup needs to be enhanced."

What is our primary use case?

We only support the backend and only carry it as a database. You can do what you want on the database to create the schema and to manage the rest of the organization.

What needs improvement?

Errors that come from MySQL need to be more clear. In Oracle, for example, you have the aura and you have numbers, you can easily find the error. MySQL should follow the same as in Oracle.

Stability needs improvement and the backup needs to be enhanced.

For how long have I used the solution?

We have been using MySQL for years.

We are using the latest version. Normally we do upgrades and we follow the upgrade path.

What do I think about the stability of the solution?

It could be more stable.

What do I think about the scalability of the solution?

We have 15 customers, but I am not sure of the number of users we have.

How are customer service and technical support?

I have not dealt with technical support.

How was the initial setup?

It was easy to install. It only took ten minutes.

We have a huge database team as we are supporting many regions.

What about the implementation team?

We implemented this solution ourselves.

What other advice do I have?

We plan to continue using this product. It's good, and I can recommend it to others.

I would rate this solution a seven out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
PeerSpot user
IT Consultant at Woohoogeeks
Real User
ModeratorTop 5
Nov 12, 2020
Free, cost-effective, with a powerful plethora of tools
Pros and Cons
  • "Like other databases, it has a rich set of functions, such as stored procedures and its own procedural language, which is akin to Oracle SQL. It also has trigger and cursor commands you would expect with a good database language."
  • "MySQL is easy to configure, use, and implement; it is free, cost-effective, and has a powerful plethora of tools."
  • "MySQL tutorials and guides could be improved. Often they are too complex for someone with no database experience to understand."

What is our primary use case?

It is an ideal database to use online learning environments and SMEs. It works well with  Moodle, the open-source learning solution, and is the defacto standard for that product as Moodle is written in PHP which generally goes hand-in-hand with MySQL. As it is an open-source and free solution it is an economical method of storing important companies or small business data. At the same time, it offers a rich set of functions comparable to other large-scale enterprise solutions such as SQL Server and Oracle. 

How has it helped my organization?

MySQL is easy to configure, use, and implement. It is free, and cost-effective, with a powerful plethora of tools. It has improved my organization for my clients using Moodle and MySQL databases, as problems are usually easier to fix quickly, and the database resources can be optimized, easily. Even though it is not as sophisticated as SQL Server and Oracle solutions, it is the database of choice for most Moodle implementations. It has a history of reliability, which is always useful in a business environment.

What is most valuable?

The Cross-platform support for MySQL is great, as you don't need to worry about which platform or operating system you need to install the platform. This allows for interoperability.

Like other databases, it has a rich set of functions, such as stored procedures and its own procedural language, which is akin to Oracle SQL. It also has trigger and cursor commands you would expect with a good database language.

Views are updateable, which is useful when you need to amend a specific view of data for different circumstances.

It has it's own Data Definition Language (DDL), and provides an Information Schema, to view what is "under the bonnet" of your database.

What needs improvement?

MySQL tutorials and guides could be improved. Often they are too complex for someone with no database experience to understand. 

It is not an easy database to learn for the novice, and very often users need to take a course, employ the use of an online tutor, or IT professional to assist. Also, it is known that it is often difficult to locate guides for specific functions for developers.

It might be good to have some way of creating web services easier, rather than having to write a User Defined Function (UDF) in PHP.

For how long have I used the solution?

I have been using MySQL for about 10 years.

What do I think about the stability of the solution?

MySQL has a reputation for stability, and that is one of the reasons it is so popular. Because it is easily available, just works, and can be integrated reasonably easily into other software, it is often the default platform of choice. 

It has been around for years, and chances are it will be around for the next 10 years or so, as new versions continue to evolve.

What do I think about the scalability of the solution?

MySQL is scalable for SMEs and works on a number of different operating systems.

How are customer service and technical support?

I have not had many issues with MySQL in the past, so I rarely use the support service.

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

I have used various databases in the past, but for my current business needs, MySQL is ideal.

How was the initial setup?

It was a simple setup, as it was included in the Moodle installation process for implementing learning sites.

What was our ROI?

ROI is not applicable, as MySQL is open source and is free, so you could say it is only the investment of implementing the database in your environment.

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

Pricing depends on the size of your business. For an individual to SME sized business the MySQL solution should be adequate for your needs. Setup costs are minimal.

Which other solutions did I evaluate?

Yes, but for Moodle Learning sites, SQL Server is more complex, and is not multi-platform, Oracle is not recommended for Moodle, but the nearest to MySQL is ProstgreSQL. MySQL is reliable and easy to use. 

What other advice do I have?

You do need to have technical knowledge of databases in general, but MySQL is not too difficult to learn if used alongside PHPMyAdmin, but there are other tools you could consider, such as MySQL Workbench.

Which deployment model are you using for this solution?

Private Cloud

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

Other
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Senior Data Analyst at Charutarhealth Org
Real User
Oct 31, 2020
Easy to set up, stable, and good technical support
Pros and Cons
  • "The replication feature is the most valuable, and 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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1252344 - PeerSpot reviewer
COO at a tech vendor with 1-10 employees
Real User
Oct 24, 2020
Cost-effective, good performance, easy to use, and the cross-platform capabilities are nice
Pros and Cons
  • "What I've been most pleased with is the cost point, performance, and ease of use."
  • "The analytics features are in need of improvement."
  • "The analytics features are in need of improvement. They aren't as far along as the capabilities that you have in terms of analytics for SQL Server and Oracle."

What is our primary use case?

The primary use case is as a reporting solution, data collection, data manipulation, and similar tasks. We install MySQL on Linux and Windows machines for testing our enterprise application.

We are a solution provider and this product is part of our offering to our clients.

How has it helped my organization?

MySQL hasn't really affected our organization, specifically because we primarily use it in a consulting model.

What is most valuable?

All of the databases basically have the same set of features.

What I've been most pleased with is the cost point, performance, and ease of use.

It is very easy to configure, it's easy to deploy, and it's cross-platform capabilities are quite nice.

What needs improvement?

The analytics features are in need of improvement. They aren't as far along as the capabilities that you have in terms of analytics for SQL Server and Oracle.

For how long have I used the solution?

I have been using MySQL for about five years.

What do I think about the stability of the solution?

I've had no problems with stability and its recovery processing, error processing, and things along those lines have been fine.  We always use Java applications and the JDBC drivers work fine.

I haven't had any issues at all with its reporting or its transaction processing, or anything else. 

What do I think about the scalability of the solution?

For our use-cases, the scalability is fine. We haven't seen any issues and we're processing probably hundreds of millions of rows each day. We're not into the billions or tens of billions, so we're probably a medium-to-low use case.

Most of our instances are single-instance databases, so I haven't had to deal with its clustering capabilities or distributed database feature set.

Our clients vary in size, although we generally operate as a small system inside a major organization.

How are customer service and technical support?

I have never had to utilize technical support. There was never an issue that I had to call in.

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

I use a lot of databases including MySQL, Microsoft SQL Server, Oracle, and PostgreSQL. 

The performance of SQL Server and Oracle is better than MySQL. The two alternatives have other features, as well.

How was the initial setup?

The initial set up very straightforward. MySQL is easy to deploy and very easy to configure. We can literally bring up instances in minutes.

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

This product has a good price point.

Which other solutions did I evaluate?

We had been on SQL Server and Oracle, and a subset of our customers wanted us to switch and use MySQL. We explored what that transition would take and then implemented it.

What other advice do I have?

My advice for anybody who is looking into implementing MySQL is to start by carefully evaluating their use cases. One of the things that we found is that MySQL didn't necessarily have all of the flexibility for JSON and XML processing at the time. I know that they've improved it, although it's not quite the same as what you see specifically in Oracle. So, the customer has to evaluate that. For straight-on basic transaction processing, it's worked out just as well with few issues from SQL Server to MySQL or from Oracle to MySQL.

For my use, I'm fine with what they have. I'll be interested in what they'll provide in analytics, as well as JSON and XML processing if that's even on their roadmap. For right now, it's really not an impact on my use case.

If I were rating SQL Server or Oracle then I would rate either one a nine out of ten. The only difference is that they do perform better than MySQL, although they don't perform so much better than it's relevant.

I would rate this solution an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Product manager at Metrodata Electronics Tbk PT
Real User
Oct 22, 2020
Has a simple and user-friendly installation
Pros and Cons
  • "The one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support."
  • "MySQL comes from open-source so it means it's a cost-effective solution, but the important thing is this product has its own principle that is supporting this product."
  • "If the customer is already using or has already used Oracle for a long time they will know the look and feel and the character of this database that can fit into their business."
  • "Mostly they will just choose the Oracle database. Why? Because of Oracle database's capability to handle the big workload for enterprise businesses. I think that will become their priority and MySQL will not be an option for them."

What is our primary use case?

We sell MySQL to customers who need to build second tier applications, not their core application. For some of our customers, when they are planning to build their second tier application, they will choose MySQL rather than Oracle which is more expensive.

What is most valuable?

The one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support. Therefore, for a senior level product like MySQL it is different than a product like MariaDB or MongoDB which are also open source databases but they depend on the community for support. 

People just assume it is less expensive. The product is not expensive. But they also have a strong principle behind data backup and supporting that product. That's why it's quite interesting, because it's open source but it has a principle behind it.

What needs improvement?

In terms of what could be improved, some of the features that Oracle has, MySQL also has. Like if a customer is looking for a high availability solution, a security solution, a monetary solution, they can have all that in an expensive product like Oracle but they can also have it when they're using MySQL.

Every product has their own pros and cons, and also has their own market. So if the customer is already using or has already used Oracle for a long time they will know the look and feel and the character of this database that can fit into their business.

They will not choose MySQL over Oracle if they already know about Oracle. But if they start to build a new application before they are creating a secondary application then they may not be familiar with Oracle and they will try MySQL. Maybe they will like it because they will see that this database also has complete features. If they try Oracle they find the same features but different pricing. In certain things, MySQL cannot have the same benefits as Oracle but for some customers who are already using Oracle, you're not going to move to another product even if it's more expensive.

And MySQL is a cheaper product.

That's why I say that MySQL has many of the same features as Oracle. Both of them have high security.

The customer that comes from a small or medium business will prefer to choose MySQL rather than the Oracle database because they already know that this product is best for their business because it is not expensive compared to Oracle. 

Oracle does have different versions with different prices. The cheaper is called the Standard Edition. And the most expensive is the Enterprise Edition.

MySQL is comparable to the Oracle Standard Edition if we compare peer to peer. But the difference is that the Standard Edition doesn't have features like the Enterprise edition. But the high security and the high probability are not in the Standard Edition. But MySQL will have it. It will have all those kinds of features with a lower price. Because the Standard Edition is more expensive than MySQL.

Every kind of enterprise company has a core application on which their business depends. Mostly they will just choose the Oracle database. Why? Because of Oracle database's capability to handle the big workload for enterprise businesses. I think that will become their priority and MySQL will not be an option for them.

But someday I would like to see the enterprise companies changing their mindset. If you are talking about core applications related to the high workload in the future, they can choose MySQL as well. Maybe not now, because right now they still see MySQL as for small/medium business and not for the enterprise business. But I hope in the future MySQL can be seen as on the same level for their database.

That will mean that all enterprise companies can have two options when they are choosing a database solution for their core application; either Oracle database or MySQL.

For how long have I used the solution?

I'm a reseller of MySQL. I've been selling this product for one or two years.

What do I think about the stability of the solution?

In terms of stability I think MySQL is categorized as a stable product. We have customers who are using MySQL as its database as an online application and it's like an online store. So it means that the work is quite heavy but we are using MySQL for it. 

What do I think about the scalability of the solution?

In terms of scalability, because the application is online, MySQL grows when their business grows and expands with the system. They may need to add more servers, but when they add more servers it means MySQL also expands.

MySQL has that kind of capability - when the servers grow they have some kind of clustering method or clustering concept, which makes it scalable onto several servers. So it will follow the growth of the servers to cover the business.

How are customer service and technical support?

I have been handling Oracle products for more than 10 years so I know about their kind of technical support characteristics.

For MySQL, when the customer has a problem they get their support from the Oracle portal. That means, the manual of support is online and the customer needs to register on the portal and if they have some issue or some problem using the product they need to create a ticket, and escalate or submit the ticket to the portal. Later on, they will get support from Oracle support which is worldwide.

They have their own SLA for giving support because they apply a severity level depending on how you categorize the error.

The highest severity is severity one. I think there are three or four levels. When the problem is not income to the business, you can categorize as a level three, it's a normal error. But if the error or the condition is impacting the business you can assume that is a severe one. So if you create a ticket and mark it as severe one then Oracle will directly contact Oracle support. They will contact you to help you to solve the problem within five minutes.

How was the initial setup?

The initial setup is categorized as a simple and user-friendly installation. It is not complex.

I have experience installing Oracle, and if you just do the default install without too many customization, you can finish it in about one or two hours. For MySQL I think it is one hour to complete the installation.

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

In terms of license cost, I think the one that we are selling for MySQL is not a perpetual license like we are selling for the Oracle database.

The Oracle database license we are selling is on a perpetual basis. MySQL has that too, but for MySQL we are selling only the support.

That means that the subscription we are selling for one year consists of software support for MySQL.

That's the difference between Oracle and MySQL.

What other advice do I have?

My message to our customers out there is that you want to get a good product. A good product in terms of the cost and an effective solution. But you also need some guarantee that this product will be supported by the principle.

Because there are so many cheaper products out there but they don't have principles to support the product. They rely on the community for the troubleshooting.

So I recommend to the customers to try this product. MySQL comes from open-source so it means it's a cost-effective solution. But the important thing is this product has its own principle that is supporting this product. It means you don't have to worry as long as you have a bit of a principle behind you to cover and support you. So you can use this product with less worry because you have a principle behind you. That is my message to the customers.

On a scale of one to ten, I would give MySQL an eight.

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. Reseller
PeerSpot user
reviewer1432350 - PeerSpot reviewer
Computer & Information Systems Manager at a real estate/law firm with 51-200 employees
Real User
Oct 20, 2020
Provides a simplistic view for building custom queries and has less performance overhead
Pros and Cons
  • "I like the simplistic view of MySQL to build custom queries and things like that as compared to SQL Server, which seems more cluttered. SQL Server has a query analyzer. MySQL pretty much does the same, and performance-wise, it has less overhead for connecting to our ERP system. It seems more responsive and cleaner. With MySQL, you get what you need without any overbloating, for which Microsoft is known. That's why they have so many constant security patches for everything because there is so much stuff, which degrades performance."
  • "MySQL installation is more straightforward and streamlined; it is just a database engine that gives you what you need, and I like it."
  • "The GUI interface probably can be improved. Let us say I want to see the relationships in the database. In the query analyzer, I would like to go and drop the tables and create relationships between the tables. I haven't found a feature like that in MySQL. It was a shortcoming even in SQL Server. MySQL can have more performance monitoring tools. I know Google has these tools, but within MySQL, there are not that many tools to monitor things like performance and database locking. They might be in there, and I might not be familiar enough to know where they are. I am a pretty new user of MySQL."
  • "The GUI interface probably can be improved. MySQL can have more performance monitoring tools."

What is most valuable?

I like the simplistic view of MySQL to build custom queries and things like that as compared to SQL Server, which seems more cluttered.

SQL Server has a query analyzer. MySQL pretty much does the same, and performance-wise, it has less overhead for connecting to our ERP system. It seems more responsive and cleaner. With MySQL, you get what you need without any overbloating, for which Microsoft is known. That's why they have so many constant security patches for everything because there is so much stuff, which degrades performance.

What needs improvement?

The GUI interface probably can be improved. Let us say I want to see the relationships in the database. In the query analyzer, I would like to go and drop the tables and create relationships between the tables. I haven't found a feature like that in MySQL. It was a shortcoming even in SQL Server.

MySQL can have more performance monitoring tools. I know Google has these tools, but within MySQL, there are not that many tools to monitor things like performance and database locking. They might be in there, and I might not be familiar enough to know where they are. I am a pretty new user of MySQL.

For how long have I used the solution?

I have been using MySQL for three months.

What do I think about the stability of the solution?

It has very good stability. We haven't had any issues with it.

What do I think about the scalability of the solution?

It has good scalability. You can use the Google interface to build it on the cloud. If you start noticing performance issues or you see it taking up memory or resources, you can add another processor. It is pretty easy to do. Right now, we are in beta. We haven't rolled it out completely to the people.

How are customer service and technical support?

I haven't had to use their technical support. They have plenty of online resources. If you have any problem, you can just search for it and find the answer. Somewhere, someone has done it before.

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

The ERP company that we work with is moving away from SQL to MySQL. From my understanding, it is because of the cost. MySQL is also more streamlined and gives them what they need. 

Even though I am a SQL Server person, MySQL has come a long way from what it used to be. They have made great strides. It seems like Google is moving more and more to it. In Google Data Studio, which gives you an interface to build dashboards, when you try and connect to new resources, you will notice they prefer MySQL on the cloud or a private server. Google is leaning more towards the MySQL side of things, and they make it very easy. It is a lot more work trying to connect to SQL Server. MySQL seems to be the preferred cloud database that people are going for.

How was the initial setup?

The initial setup was straightforward. MYSQL installation has fewer options than a SQL Server installation, which has endless options. MySQL installation is more straightforward and streamlined. It doesn't have a lot of extra features. It is just a database. It is a database engine that gives you what you need, and I like it.

I am doing one installation right now on Google Cloud. I am building an instance of MySQL. It is just more simplistic. It is more to the point and what you need. In SQL Server, you need to dive into the endless options, and you use maybe 60% of what is there. There is a lot of stuff that people don't use, which you end up uninstalling because it affects the server performance, and it is a service that you are not even using. There is a full install as well as a custom install with SQL Server. If you go for the full install, it throws everything into the server, and you start noticing performance issues. Then you realize that there are services that you are not even using. Some places don't even use analytics or reporting services.

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

Microsoft licensing for SQL Server is probably ten times more expensive. I used to work for the government, and I remember when we were looking into upgrading to the enterprise version of SQL Server 2019, the licensing was going to cost 350,000. To get the equivalent in the cloud, it was going to be about four grand to get the same processing power and everything else. With MySQL, it was going to be about 300 for the same licensing. 

Cost-wise, for sure, there is a huge difference. Would you prefer to pay 300 a month or 3,000 to have the same amount of data resources? You might lose a few options that you need, but it isn't worth the price difference.

What other advice do I have?

If you want just a database for data storage, I would recommend MySQL. If you want something that has everything in it, such as reporting services and analytics, SQL Server might be better. Cost-wise, MySQL is almost pricing itself out.

I would rate MySQL an eight out of ten for ease of use, especially for someone who has never used it and implemented it. It was pretty straightforward to implement it. It gives you what you need. It surely provides the basics such as data storage, setting up the tables, etc.

Which deployment model are you using for this solution?

Private Cloud

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

Amazon Web Services (AWS)
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Ingénieur Etude et Développement / Technical Lead Java at ATOS
Consultant
Oct 12, 2020
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."
  • "Mysql is free : it's an open source project, so you can use it with no cost."
  • "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."
  • "If you want to scale it you will require more knowledge on the product and you will need more support for it."

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

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 technical 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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
EUC Techical Operation at a tech services company with 10,001+ employees
Real User
Oct 5, 2020
Stable, easy to install, and comes with community support
Pros and Cons
  • "I like MySQL because of its community."
  • "I would recommend this product if someone is new to the IT world."
  • "MySQL doesn't have the auto-clustering and database clustering features that other competitors provide. They can include these features."

What is most valuable?

I like MySQL because of its community.

What needs improvement?

MySQL doesn't have the auto-clustering and database clustering features that other competitors provide. They can include these features.

For how long have I used the solution?

I have been using MySQL for about two years. 

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 really easy to scale. We have around 20 to 40 users who use it regularly.

How are customer service and technical support?

I never interacted with their technical support. If there is any problem in my project, I just look for it on Stack Overflow and fix it easily. It also comes with good documentation.

How was the initial setup?

It is easy to install. The deployment duration depends upon your internet connection. If you have a good internet connection, the deployment would be faster.

What other advice do I have?

I would recommend this product if someone is new to the IT world.

I would rate MySQL an eight out of ten.

Which deployment model are you using for this solution?

Private Cloud

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

Other
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.
Updated: October 2026
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.