Try our new research platform with insights from 80,000+ expert users
Shivaprasad C S - PeerSpot reviewer
Programmer at a government with 1,001-5,000 employees
Real User
Top 5
Mar 22, 2024
Provides good indexing and supports multiple data types, but performance needs to be improved
Pros and Cons
  • "I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures."
  • "MySQL's performance needs to be improved for enterprise-level applications compared to Oracle and Postgres."

What is most valuable?

I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures.

What needs improvement?

MySQL's performance needs to be improved for enterprise-level applications compared to Oracle and Postgres. That's the only drawback I found in MySQL. When the table storage is full, the solution's performance becomes slow. The solution's security needs improvement as DB2 is more secure than MySQL.

For how long have I used the solution?

I have been using MySQL for more than ten years.

What do I think about the stability of the solution?

MySQL has good stability.

I rate the solution a six or seven out of ten for stability.

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

What do I think about the scalability of the solution?

Around 150 users are using the solution daily in our organization.

I rate the solution a six out of ten for scalability.

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

We previously used Oracle. We switched to MySQL because Oracle's license was costly.

How was the initial setup?

It's really easy to set up MySQL. On a scale from one to ten, where one is difficult and ten is easy, I rate the solution's initial setup an eight out of ten.

What about the implementation team?

We implemented the solution in our organization through a consultant. It took a few hours to set up everything. Around one to two people were needed to deploy the solution.

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

MySQL is a cheap solution.

What other advice do I have?

When you compare Oracle and DB2 with SQL Server and MySQL, all these come under RDBMS (Relational Database Management System). Since the licensing for Oracle and DB2 is costly, people will go for either MySQL or Postgres. People go for MySQL because it is better than Postgres in indexing and supports multiple data types compared to Postgres.

Just one person is needed to maintain MySQL. We didn't face any challenges using MySQL because of many open communities. If you have MySQL's commercial license, you will get good support. I would recommend MySQL to users who are going for medium enterprise applications.

Overall, I rate the solution a seven 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
PrinceKumar2 - PeerSpot reviewer
Associate Cloud Engineer at a computer software company with 501-1,000 employees
Real User
Top 5
Apr 1, 2024
Provides powerful data querying.
Pros and Cons
  • "MySQL gives us a very user-friendly workspace in which to query the database."
  • "We have encountered some performance issues, and the solution takes time for performing complex queries."

What is our primary use case?

We are developers working on different types of projects. We use relational databases in some projects and non-relational databases in others. When we use relational databases, we use MySQL. When we use non-relational databases, we use our DynamoDB or MongoDB.

What is most valuable?

  1. Ease of Use: MySQL is relatively easy to set up, configure, and manage, especially with tools like MySQL Workbench and command-line utilities. Its widespread popularity also means there is ample documentation, tutorials, and community support available for users.
  2. Open Source and Cost-effective: MySQL is open-source software, which means it is free to use and can be customized according to specific requirements. This makes it a cost-effective choice for startups, small businesses, and projects with budget constraints.

What needs improvement?

Compared to some other database systems, MySQL may have limitations in terms of advanced features and functionalities, especially when it comes to complex data relationships and transactions.

For how long have I used the solution?

I have been using MySQL for two years.

What do I think about the stability of the solution?

In my past two years of MySQL experience, I found no bugs or breakdowns. It works completely fine.

What do I think about the scalability of the solution?

Many cloud providers offers managed mysql service with scalable architecture ,automated backups , monitoring and scaling. Leveraging this can solve the scalability problem.

How was the initial setup?

MySQL is very easy to install and use.

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

As it is an open source and there is community edition available so if you have small or medium use case it is much cheaper to use.

What other advice do I have?

Below are some thing to consider while working with mysql.

1. Regular maintenance 

2. Security consideration

3. Version compatibility

You can try MySQL if you have any use cases of relational databases. It is very easy for somebody to learn to use MySQL for the first time. The solution worked fine for me, with no breakdowns or scalability issues.

Overall, I rate MySQL eight and a half or nine out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud

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

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
MySQL
December 2025
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,711 professionals have used our research since 2012.
Senior Consultant at a tech vendor with 10,001+ employees
Real User
Top 10
Mar 25, 2024
Enables a wide range of features and benefits, including high performance, scalability and security
Pros and Cons
  • "While MySQL offers strong basic functionality."
  • "MySQL lacks a feature akin to Oracle's Real Application Clusters, which ensures continuous database availability within the same data center or nearby data centers."

What is our primary use case?

We use it to meet the requirements of our customers while optimizing performance and reliability within the constraints provided.

How has it helped my organization?

The performance and scalability of our project have been influenced positively by MySQL. From what I've observed, performance has been satisfactory, and I haven't received any complaints from teams that have implemented it.

What is most valuable?

While MySQL offers strong basic functionality.

What needs improvement?

MySQL lacks a feature akin to Oracle's Real Application Clusters, which ensures continuous database availability within the same data center or nearby data centers. Without this capability, MySQL's suitability for mission-critical applications is diminished. Until MySQL incorporates a similar feature at the application level, its appeal for high availability remains limited. Historically, we've relied on external security measures for data protection, such as encryption. However, when encryption methodologies are employed within MySQL, there may be a slight performance degradation due to the computational overhead associated with processing large volumes of data in the database.

For how long have I used the solution?

I have been working with it for twelve years.

What do I think about the stability of the solution?

Stability is crucial, and it's influenced not just by the inherent features of the database system, but also by how the application team writes queries. If queries are poorly written or not optimized, it can affect stability significantly. While logging can help, improper usage, such as logging entire tables instead of specific fields, can also impact stability. Therefore, ensuring stability requires a holistic approach that considers both the database infrastructure and how the application interacts with it.

What do I think about the scalability of the solution?

Scalability is not as straightforward with MySQL compared to Oracle. I would rate it seven out of ten. Our clientele typically includes small, medium, and enterprise-level businesses.

How was the initial setup?

The initial setup was straightforward. I would rate it nine out of ten.

What about the implementation team?

For the MySQL installation, it's crucial to have a broader understanding of the solution we're implementing. Sometimes, we may need to address OS-level issues, especially when dealing with OS-level addressing like OSFlow. In such cases, thorough testing at the voice level is essential to ensure a smooth installation process. Implementing MySQL in a single-node setup may uncover additional challenges that need to be addressed.

Typically, our focus is on implementing the product rather than the database or operating system level. While I oversee infrastructure aspects, the implementation process is heavily influenced by the specific application being deployed. From setting up voice-level deployment and alerting to handling licensing and the database infrastructure, this entire process usually takes four to six weeks, depending on the complexity of the functionality. Once we complete the initial deployment, subsequent enrollments become more streamlined, and the application is handed over for production use. Any further adjustments or configurations are managed separately.

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

The pricing falls within the moderate range. I would rate it four out of ten.

What other advice do I have?

Rather than recommending specific servers or operating systems, decisions are driven by how the application behaves and what functionalities it requires. This approach streamlines the process as pre-tested systems are already available, reducing the time and investment required for testing. Overall, I would rate it eight 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
Database and Middleware Technical Head at a government with 201-500 employees
Real User
Top 5
Aug 15, 2024
Open-source solution to store data of hardware servers and their configurations

What is our primary use case?

MySQL was open-source at the beginning until Oracle acquired it in 2010. I started working with MySQL because I was an Oracle expert, having worked for Oracle for eight years. That's why I added MySQL to my skills as an administrator. MySQL is a powerful database engine that is easy to install, manage, and work with. It's ideal for fast application deployment and is cost-effective as well.

How has it helped my organization?

MySQL is for metadata and data. My organization has used it to store data about hardware servers and their configurations, including network and storage configurations. MySQL is an RDBMS engine, so it can be used for any business application.

What is most valuable?

MySQL has a straightforward installation process, is lightweight, and easy to manage. Compared to its competitors, it is more accessible and user-friendly. While competitors like Oracle are known for their extensive features, they are often more complex to install, configure, and maintain, requiring experts to manage them, which can be costly. MySQL, now owned by Oracle, may not have the same feature set as Oracle's flagship database, but it is simple to install, manage, and cost-effective. MySQL is a viable option that can be enhanced with additional features, making it reliable for small to medium-scale applications and capable of effectively handling substantial amounts of data.

What needs improvement?

MySQL is now in a real application cluster. In terms of high availability, MySQL can be configured for active-active or as a real application cluster.

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?

When MySQL is involved in the metadata, it never gets down. It's very stable.

What do I think about the scalability of the solution?

It's secure. MySQL supports large databases that can contain nearly fifty million records. It also supports up to sixty-four indexes per table.

How are customer service and support?

They provide 24/7 support. It provides faster resolution and identification.

How would you rate customer service and support?

Positive

How was the initial setup?

It is very easy to install and takes an hour to complete.

I rate the initial setup a ten out of ten, where one is difficult and ten is easy.

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

It is open-source and supported by Oracle.

What other advice do I have?

Oracle occupies it, so Oracle added more security features, such as password system improvements, host-based verification, and encryption, to the MySQL engine. It's developed and managed by a big company, and they keep adding new features.

I recommend another solution for large data, like billions of records. However, MySQL is a good option for data up to about fifty million records.

Overall, I rate the solution an eight out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Prince Barai - PeerSpot reviewer
Back End Developer at a tech services company with 11-50 employees
Real User
Top 5Leaderboard
Mar 24, 2024
Easy to use and can be used to store data
Pros and Cons
  • "MySQL is an easy-to-use solution that provides stability, reliability, flexibility, performance, security, and high availability."
  • "MySQL could introduce more indexing strategies."

What is our primary use case?

MySQL is an open-source relational database management system used to store data.

What is most valuable?

MySQL is an easy-to-use solution that provides stability, reliability, flexibility, performance, security, and high availability.

What needs improvement?

MySQL could introduce more indexing strategies. There are a couple of strategies where you can index things to be more searchable and visible. We lack that kind of functionality. For example, if your name is indexed correctly with a certain strategy, it can improve the search results faster. The solution’s interface could be improved.

For how long have I used the solution?

I have been using MySQL for my entire career.

What do I think about the stability of the solution?

MySQL is a stable solution.

What do I think about the scalability of the solution?

MySQL is a scalable solution.

How was the initial setup?

The solution’s initial setup is easy.

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

MySQL is a free and open-source solution.

What other advice do I have?

MySQL is deployed on the cloud in our organization. Big companies like Netflix, Uber, and Facebook use the solution. Since MySQL is an old product, many people might have faced similar issues, posted them online, and got a resolution. MySQL's performance and scalability features have supported our database growth.

New users can follow the documentation to use the solution, as it is straightforward. You need to be very clear about why you want to use the solution. MySQL is a relational database management system that cannot be used as a dynamic database management system.

MySQL is generally faster and more efficient than other relational database management systems. Hence, it is our preferred choice for applications that require high performance.

Overall, I rate the solution a nine out of ten.

Which deployment model are you using for this solution?

Public 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
Kevin Honde - PeerSpot reviewer
Data Solution Architect at a comms service provider with 1,001-5,000 employees
Real User
Dec 31, 2022
Great cluster setup; works fine on the technical side
Pros and Cons
  • "The way that MySQL has improved my organization is that it comes free and also works fine on the technical side."
  • "The integration with other systems can be improved as can the integration between other databases."

What is our primary use case?

Our primary use case for MySQL is for our internally-built system. When our developers are doing the assistance, usually we provision them with the MySQL driver.

How has it helped my organization?

The way that MySQL has improved my organization is that it comes free and also works fine on the technical side.

What is most valuable?

The feature I found most valuable was the cluster setup.

What needs improvement?

The integration with other systems can be improved as can the integration between other databases. We have a workaround to integrate it with other systems but that can be improved.

In the next release, I would like to see better day-to-day support in case we face any issues.

For how long have I used the solution?

I have been using MySQL since 2008.

What do I think about the stability of the solution?

I would rate the stability of this solution an eight, on a scale from one to 10, with one being the worst and 10 being the best. We have a team of three DBAs supporting and maintaining this product.

What do I think about the scalability of the solution?

I would rate the scalability of this solution an eight, on a scale from one to 10, with one being the worst and 10 being the best. I believe MySQL very scalable.

How are customer service and support?

I would rate the technical support an eight, on a scale from one to 10, with one being the worst and 10 being the best.

How would you rate customer service and support?

Positive

How was the initial setup?

I would rate the initial setup process a nine, on a scale from one to 10, with one being the worst and 10 being the best. I would say that this process has been quite easy.

The deployment of this solution was done by an in-house team and it took around 30 minutes to one hour.

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

I would rate the pricing of this solution a two, on a scale from one to 10, with one being not expensive and 10 being very expensive.

What other advice do I have?

I would recommend this solution to other people.

Overall, I would rate MySQL solution a nine, on a scale from one to 10, with one being the worst and 10 being the best.

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
Prashob Km - PeerSpot reviewer
Software Engineer / Team Lead at a tech vendor with 51-200 employees
Real User
Top 20
Aug 3, 2024
Supports Laravel PHP framework, but we need to define every table beforehand
Pros and Cons
  • "MySQL is the best option for the Laravel PHP framework."
  • "In MySQL, we need to define every table beforehand."

What is our primary use case?

We use MySQL in multiple projects for storing, task management apps, and dating apps.

What is most valuable?

MySQL is the best option for the Laravel PHP framework. It supports multiple model systems, and it's very easy to call MySQL compared to other languages like MongoDB. I prefer MySQL for the Laravel PHP framework.

The solution's security features depend on where we host our server and database. We have some preventive measures to reduce attacks. We have taken authentication and only allow a particular IP address.

What needs improvement?

In MySQL, we need to define every table beforehand.

For how long have I used the solution?

I have been using MySQL for four to five years.

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

In MySQL, we need to define every table beforehand. However, we don't need to do so in MongoDB. We can add a new row or column in MongoDB anytime, making it much easier. If you purchase MongoDB's plan, it supports many security features, and you don't need to check about security. They will handle everything.

How was the initial setup?

The solution’s initial setup is very easy. For the first time, the solution's implementation will take some time. However, you can use it multiple times after you configure it.

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

MySQL is a cheap solution.

What other advice do I have?

Maintaining the database is a task. We take a weekly backup for each database so that we can upload it to the server if anything happens to the data. We created a cron job so that the data can be taken and then uploaded to a specific space so that we can go back to the particular big data whenever we want. I prefer MongoDB for scalability because it's much easier to maintain MongoDB.

Just one person is enough to maintain the solution. The solution has good documentation available on Google.

Overall, I rate the solution six and a half out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Data Analyst at a financial services firm with 501-1,000 employees
Real User
Top 10
Mar 27, 2024
Easy to manage, saves time, and provides good documentation
Pros and Cons
  • "SKIP LOCKED is a valuable feature."
  • "The full-text search feature must be improved."

What is our primary use case?

I use the solution for personal use cases like software development, mostly database bug systems.

How has it helped my organization?

I used the tool to build our website. It is used as a database to store information.

What is most valuable?

SKIP LOCKED is a valuable feature. It prevents us from deleting things we put in the database. It's mostly for background jobs in the software development site in MySQL 8. It is a new feature. The solution easily integrates with other tools and systems in our IT environment.

What needs improvement?

The full-text search feature must be improved.

For how long have I used the solution?

I have been using the solution for the past three weeks.

What do I think about the stability of the solution?

I rate the tool’s stability an eight out of ten. We can create a database user schema. It's quite easy to update and remove in case anything happens. Backing up is quite easy. We have security features for the backup.

What do I think about the scalability of the solution?

I’m the only user in my organization.

How are customer service and support?

The product provides good documentation online.

How was the initial setup?

It is easy to deploy the product. I deployed it on my own. The deployment took an hour. We deploy the product using Kamal. It uses Docker. The tool is deployed on the cloud. To deploy the solution, we just have to enter the password in the server and deploy it. It wasn't much of a hassle.

What was our ROI?

The tool is easy to manage and saves us time. It has much less complications.

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

We're using the community version. The tool is open source.

Which other solutions did I evaluate?

I also use PostgreSQL.

What other advice do I have?

The tool helps us get the job done. It is not very complex. Overall, I rate the product a nine out of ten.

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