Try our new research platform with insights from 80,000+ expert users
Anays Micolod - PeerSpot reviewer
Programmeuse Python 3 at Université Grenoble Alpes
Real User
Has easy access to data, is easy to grasp, and has good documentation
Pros and Cons
  • "The easy access to the data and the ability to sort the data with multiple methods are very valuable features."
  • "Sometimes, I get lost in the toggles and buttons, and a better visual design would be nice. The layout is not user-friendly or efficient."

What is our primary use case?

I'm using it to create a small database for a project that I'm working on.

What is most valuable?

The easy access to the data and the ability to sort the data with multiple methods are very valuable features.

It's quite easy to grasp and is really well documented, which are huge plus points.

What needs improvement?

Sometimes, I get lost in the toggles and buttons, and a better visual design would be nice. The layout is not user-friendly or efficient.

I would like to be able to sort the data easily without having to do a request to get the table out of the database into the web page. At present, I can't do it directly inside MySQL; I have to do a request and print out my request into a web page.

What do I think about the stability of the solution?

The stability is really good. I haven't had any issues with it.

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

What do I think about the scalability of the solution?

The scalability is good.

How was the initial setup?

The initial setup is easy.

I learned to use it in class, and the setup was quite fast because the teacher really helped us to gain access and take the first few steps. The setup took a few hours at most.

What about the implementation team?

I installed it myself.

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

I use a free version at present.

What other advice do I have?

Plan how the data will be constructed. I had to delete an entire database and start over because I didn't organize it properly. That was a huge block.

I would rate MySQL at eight on a scale from one to ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Enterprise Architect at a computer software company with 1,001-5,000 employees
Real User
I can meet the RPO in almost real-time
Pros and Cons
  • "MySQL's clustering features are very strong, and you can automate scripting, so that helps. We wrote a Terraform script and ran it."
  • "Rather than going in-depth about the technical features, which a technical person can directly tell, I would say that MySQL should be able to adapt to the next framework. The 5G framework means an unstructured framework. So if MySQL becomes smoother and more adaptable, it'll be easier."

What is our primary use case?

Our main use case for MySQL is for applications and seamless migration to the DR site. And the application in this case is an airport application.

How has it helped my organization?

I can meet the RPO in almost real-time. This changes the customer experience. That testing still needs to happen, but that is one of the advantages of MySQL. We have found MySQL to be a very sturdy and strong database. And I have run it in a solution where it's almost real-time, so it runs very efficiently.

What is most valuable?

MySQL's clustering features are very strong, and you can automate scripting, so that helps. We wrote a Terraform script and ran it. 

What needs improvement?

Rather than going in-depth about the technical features, which a technical person can directly tell, I would say that MySQL should be able to adapt to the next framework. The 5G framework means an unstructured framework. So if MySQL becomes smoother and more adaptable, it'll be easier. In terms of new features, automation is always the biggest demand from our customers.

For how long have I used the solution?

I've been doing pre-sales and working with MySQL since 2007.

What do I think about the stability of the solution?

I would say that MySQL is definitely stable, but its scalability has yet to be tested. I cannot say right now.

How was the initial setup?

We follow an agile strategy, so deployment is done in parallel. In comparison to other databases, I have always found MySQL to be the most efficiently managed. Of course, I don't discount Postgres, but MySQL deployment always has gone smoothly. I've never had an issue during migration, even on the granular level. UID numbers, which we commonly face in Microsoft SQL, have never been a problem with MySQL.

What about the implementation team?

We use the implementation partners for OEM. 

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

We get the standard packages, but mostly MySQL is freeware. You pay for a license to get the upgrades. We pay for an enterprise license if that is required, but that's not in every case. It depends.

What other advice do I have?

I would rate MySQL nine out of 10.

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
March 2025
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
844,944 professionals have used our research since 2012.
Sysad Database Administrator Lead at USSC
Real User
A stable solution with a community version, but the enterprise manager license should cover more virtual machines
Pros and Cons
  • "It has a community version. When I have to create a new database, I have no problems with licenses."
  • "It can have better monitoring. In addition, the enterprise manager should be able to cater to more than one virtual machine. Currently, you need one license per server. It seems a bit too much to get one license for one enterprise manager. I hope the enterprise manager for MySQL can accommodate more virtual machines for MySQL."

What is our primary use case?

We use it for financial transactions such as money remittance.

What is most valuable?

It has a community version. When I have to create a new database, I have no problems with licenses.

What needs improvement?

It can have better monitoring. In addition, the enterprise manager should be able to cater to more than one virtual machine. Currently, you need one license per server. It seems a bit too much to get one license for one enterprise manager. I hope the enterprise manager for MySQL can accommodate more virtual machines for MySQL.

For how long have I used the solution?

I have been using this solution for a decade.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

We have categorized the amount of data we have as big data, although we haven't really been using it much.

We have 2,000 people in our company, and we have over 100 virtual machines installed with MySQL.

How are customer service and technical support?

Because we are using the community version, we haven't had the chance to contact the technical support of MySQL.

How was the initial setup?

It is easy for us. After a few trials or installing it a few times, we have benchmarked and created best practices for installing it.

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

It has a community version.

What other advice do I have?

If you are not into command-line usage, I don't think MySQL is for you. I found MySQL easier to use by using the command line rather than by using the workbench. The workbench is comparatively slow, especially when exporting.

I would rate MySQL a seven 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
Powerbuilder Consultant at a government with 1,001-5,000 employees
Vendor
Relational databse that can be used with PHP, Python, and Java.

What is most valuable?

  • Relational database (Although it's not 100% compliant with Standard SQL)
  • Performance
  • Open Source
  • Ease of setup and use
  • Ease of use with PHP, Python, and Java

How has it helped my organization?

Using MySQL helps to keep the costs down. With immense material available on the web, training is easy too.

This is the de facto DB for web development with PHP. If you worked with LAMP environment, this was the M in it (others being Linux, Apache Tomcat and PHP). With open source products, development was a breeze. Overall, this is a boon to small to medium database applications.

What needs improvement?

The simplicity of the product lets people abuse it. I've seen so many people create tables and add indices in PHP code. Some of these web developers only know some things about the database.

For how long have I used the solution?

I have used this solution for about eight years.

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

We did not use a different solution for the applications that use MySQL. I mostly use Oracle for larger, enterprise software.

How was the initial setup?

The initial setup was straightforward. There are a number of Open Source tools, including Toad and MySQL Workbench which helps with configuration and use.

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

This started as Open Source project under Sun. With Oracle acquiring Sun, MySQL is now owned by Oracle (not the community). Oracle promised to keep it open sourced, but the community is not convinced. So, there is a branch that's called Maria DB that's slowly taking over in some Open Source projects.

That being said, it is still an Open Source product and it is free to use under GPL license. This means you can always, get community support. But, if you want Oracle's support, that is not free.

If you use it in enterprise applications, you may have to purchase commercial license from Oracle. Here is a couple of links that discuss various options:

http://white-paper.b-lay.com/o...

https://www.linkedin.com/pulse...

Which other solutions did I evaluate?

We evaluated MS Access, SQLite, PostgreSQL, FireBird, and Oracle.

What other advice do I have?

This is a relational database tool for small to medium sized applications. However, this didn't start as a Relational DB, so if you want a truly Relational Database for an Enterprise, similar to Oracle, you may want to look into PostgreSQL, as well. However, MySQL is still a very good database for internet based applications.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Database Administrator at a recruiting/HR firm with 1,001-5,000 employees
Real User
It is easy to understand the inner picture of the database from the EER model.

What is most valuable?

The EER diagram is the most important feature for me as the EER diagram can show the inner picture of the database, such as the relationship between the tables very easily. We can also add, modify or delete EER diagrams very easily.

How has it helped my organization?

The user friendly interface which is easy to interact with such as creating backups, tables, views, and the EER model.

What needs improvement?

It has lot of options to interact with. Sometimes it is hard to find the appropriate options quickly. They need to add descriptions somewhere as to where a user can go to find the proper menu easily when required. Another problem is that since all the databases can be seen and operated together, it’s possible to make mistakes such as dropping the wrong database.

For how long have I used the solution?

I have used this product for two years.

What was my experience with deployment of the solution?

There was no issue with deployment

What do I think about the stability of the solution?

There were no issues with stability

What do I think about the scalability of the solution?

There was no issue with scalability

How are customer service and technical support?

Customer Service:

The level of customer service is good. I understand sometimes they need to transfer the service to a knowledgeable person, so we need to have patience and explain the same problem several times.

Technical Support:

The level of technical services is good. I understand the product is technical, so sometimes the reported problem requires more investigation.

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

I used phpMyAdmin. It is also a graphical interface but you have to buy the product while MySQL Workbench is free.

How was the initial setup?

The initial setup is very straightforward. I didn’t face any problem at all.

What about the implementation team?

I did the installation.

What other advice do I have?

This product is good as it is a graphical interface. It's easy to do all MySQL database administration very easily. You just need to play around to be more familiar with it. The MySQL Workbench interface is well prepared to design a database including EER diagram, create table, and view very easily. The EER diagram allows the user to completely understand the database design, which is very important and useful for the people who are involved with the database. It’s easy to understand the inner picture of the database from the EER model.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Haim Tzadok - PeerSpot reviewer
Haim TzadokCo-Founder/CEO at Grigale LTD
Reseller

Workbench is the original GUI for managing MySQL databases it allows to:
* Manage DB - it allows to administer a DB. (by creating a connection to a database).
* Model DB - It allows you to model your database using EER diagrams to represent tables and link between tables. EER diagrams can be transformed to a schema by creating SQL script from the EER diagram. EER diagram can be also produced from an existing DB, by connecting to a database and performing reverse engineering.
* Migrate DB - It also allows you to migrate from another DB to MySQL

it_user2652 - PeerSpot reviewer
Project Manager at a non-tech company with 10,001+ employees
Vendor
Top 20
Highly recommended open source database for small/medium sized organizations

Pros:- 

1) MySQL is an open source database under the GNU General Public License, that means developers can use it at no cost as long as the associated projects are also open source. 

2) MySQL is ideally suited for small/medium sized organizations for faster performance. 

3) MySQL can be used in client/Server architecture as well as it can also be embedded in standalone applications. 

4) MySQL is fast, east to use, highly extensible, lightweight, scalable, and reliable database. 

5) MySQL supports clustering in the network for redundancy. 

6) MySQL provides flexibility to modify environment variables/kernel settings to limit the amount of memory usage for increasing performance. 

7) MySQL is strongly recommended for web applications, middleware and LAMP architecture systems. 

8) MySQL can be integrated with ldap to provide centralized authentication. It can also be integrated with LAMP/WAMP, web applications and number of programming languages. It is widely used for phpadmin and wordpress. 

9) MySQL is platform independent and can be run in mixed OS platform like windows, linux, ubuntu etc. It gives compatibility even over different OS during backup and restore. Data can be backed up from one OS and can be restored on other OS.

Cons:- 

1) MySQL can be integrated with ldap, however, it is very complex, tedious and time consuming. 

2) MySQL support is available through communities like other open source projects which means that it is sometimes scarce and hard to find. 

3) MySQL doesn't have some of RDBMS features like foreign keys, transaction, rollback and subselect. 

4) MySQL also doesn't have tablespaces, role management, snapshots, synonyms and packages. 

5) MySQL uses both InnoDB and MyISAM, however, it gives slower performance when using InnoDB as compared to MyISAM for using simple queries due to complexity of InnoDB. 

6) MySQL does not provide good development and debugging tools, so it’s cumbersome to write large SQL statements.

Alternate Vendors:- Oracle, DB2, Sybase, Postgres, Informatica!!


Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user2652 - PeerSpot reviewer
it_user2652Project Manager at a non-tech company with 10,001+ employees
Top 20Vendor

I have researched more on the pros and cons I listed and modified them accordingly.

See all 2 comments
Milton Palacin - PeerSpot reviewer
Solution Architect at SBS
Real User
Good tech support; great activity performance
Pros and Cons
  • "The feature I found most valuable is activity performance."
  • "This solution needs to be improved when it comes to working with desktop applications on the developer side."

What is our primary use case?

Our primary use case for this solution is a home database of payments.

What is most valuable?

The feature I found most valuable is activity performance.

What needs improvement?

This solution needs to be improved when it comes to working with desktop applications on the developer side.

For how long have I used the solution?

I have about 15 years of experience with MySQL.

What do I think about the stability of the solution?

My impression of the stability of this solution is that it is quite good.

What do I think about the scalability of the solution?

My impression of the scalability of this solution is that it is standard. However, scalability depends on enterprise size and legacy product compatibility.

How are customer service and support?

My impression is that their technical support is good.

How was the initial setup?

My impression is that the initial setup is pretty standard. Some parts of it can be difficult. We had a tough time with the administration and database.

What other advice do I have?

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

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Project Manager at Realnux
Real User
Top 5Leaderboard
A lightweight database that's easy to maintain and develop
Pros and Cons
  • "MySQL is a light database. It's not very complex. It's easy to develop, easy to maintain, and easy to back up and restore."
  • "We want to continue using MySQL but it merged with Oracle and the scalage changed."

What is our primary use case?

We use MySQL as a light database engine to provide database service to our web application. 

Almost all of our software engineers use MySQL.

We want to continue using MySQL but it merged with Oracle and the scalage changed. After they merged, we tried MariaDB. 

For two years, we tried MongoDB and prepared for application migration; all because the scalability changed when MySQL merged with Oracle. 

What is most valuable?

This solution is very easy to use. It's stable and very quick. MySQL is a light database. It's not very complex. It's easy to develop, easy to maintain, and easy to back up and restore. 

For how long have I used the solution?

Our software team has been using MySQL for more than eight years.

What do I think about the scalability of the solution?

It's hard to say if MySQL is scalable as we've never tried to scale it. 

How are customer service and technical support?

We have never had to contact support. 

How was the initial setup?

We installed MySQL Database on our server. It took roughly 12 to 13 minutes to install it. 

What about the implementation team?

Installation was done by our software team's engineers — seven to eight of them.

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

We've never bought a commercial license. We just use the open-source community edition. 

Which other solutions did I evaluate?

We evaluated other databases and products, including EnterpriseDB and PostgreSQL. The latter was scalable, but it wasn't easy to use. MySQL is much easier to use and install. Before MySQL merged with Oracle, our software engineers were very satisfied.

What other advice do I have?

We recommend MySQL to our customers and other partners. The only problem relates to the business strategy from Oracle. For this reason, most MySQL users are considering migrating to MariaDB.

Overall, on a scale from one to ten, I would give this solution a rating of nine. We're very satisfied with MySQL. If we could scale-out further, I would give it a ten. We need a database cluster or a scalable database solution for our future applications.

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