About MySQL

MySQL is a cloud-based scalable database management system, which enables organizations to securely record, update and manage data in compliance with GDPR, PCI, HIPPA and various regulatory standards. Features include data masking, audit, de-identification, real-time monitoring, provisioning, patching and authentication.

The ACID-compliant solution comes with a query analyzer, which helps developers gain visibility into query activities and execution, identify problematic queries and filter out specific issues such as full table scans and bad indexes. Using MySQL Workbench, professionals can perform database modeling, develop queries, configure servers, migrate databases and automate backup and recovery. Administrators can use the Enterprise F...


Read More

Supported Operating System(s):

Web browser (OS agnostic)

1,457 Reviews of MySQL

Average User Ratings

Overall

4.57 / 5 stars

Ease-of-use

4.5

Value for money

4.5

Customer support

4.0

Functionality

4.5

Ratings Snapshot

5 stars

(857)

857

4 stars

(484)

484

3 stars

(57)

57

2 stars

(2)

2

1 stars

(0)

0

Likelihood to Recommend

Not likely

Very likely

Showing 1 - 5 of 1457 results

September 2020

User Profile Picture

Fernando from Pelissari Gestão e Tecnologia

Verified Reviewer

Company Size: 201-500 employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

4.0

September 2020

The well balanced

I use MySQL in many personal projects, like my automated house project. It was a very good choice, I'm happy with this. Also, in the past, I have worked with MySQL and PHP in my company's intranet page. It was a good tool, but as the company grows, we need to migrate to another platform. Also, it is important to say that if you use the correct database engine with MySQL, you can have foreign keys and other types of constraints so it is very flexible.

Pros

MySQL is a well balanced product, while it is free to use, it also has many features you can find in corporative solutions, like SQL Server and Oracle. If you ever need help, you will find answers almost everywhere, from their own documentation to stackoverflow and other forums, easily. You will have a very short learning curve with MySQL.

Cons

When you need to deal with great amount of data, like some kind of data warehouse structure or huge amount of measures to analyze, you better go other choices. It starts getting too slow with the same hardware other products will work smoothly. But I guess that is not the purpose for MySQL. In the other hand, if you want it to build a transactional system like an e-commerce platform or even a Blog page, it is a very good choice!

Reasons for Choosing MySQL

I chose it instead of PostgreSQL because the ease of use and plenty of documentation around the internet, with many forums and examples. Both tools have a great community support, but I felt MySQL has more.

April 2021

Aleksandr from ===

Verified Reviewer

Company Size: 501-1,000 employees

Industry: Computer Software

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Functionality

5.0

April 2021

Great overall but has some very important caveats.

Mysql as any other tools has it's advantages and downsides. It may be fast, ACID-compatible, it may serve as memory cache. It has some dark corners and sometimes may hang on complex queries, or even corrupt the data (this is really rare case, but I faced it more than 10 times during my experience). Consider your scenario carefully. And always, always, ALWAYS make backups.

Pros

There a whole world of documentation, best practice, books on mysql. It can be found on nearly any cloud, system, paas. It is really fast (on MyISAM), support transactions (InnoDB), may perform as in-memory cache (memory), or even CSV (never use this one except for testing or reports). Deploy and set up takes next to no time, it consumes very little resources. Actually I feel it is hard to write a review on MySql because over decades of extensive usage it become the standard de-facto, even LAMP has (M) for MySQL. It is a mature if, well known RDBMS with tons of extensions and forks (not sure I may name them here). It is worth to mention though that MySQL is a default backend storage for a whole number of software. MySQL is compliant to SQL standard though with some differences. It may require some changes to your codebase but still, they should not be critical. What will really surprise you is that ORDER by lacks "nulls first/last" clause and that collates may surprise you. In a somewhat unpleasant way. Window functions, virtual tables, temporary tables are here as well and trust me - this is quite important matter, something that is a vital part of any DB. You will find a lot of web and standalone management tools to work both with server and data, some of them are free, others are not, chose yours.

Cons

First and biggest cons is that MySQL is not suitable for big amount of data. It always had and still have troubles performing complex joins. Database may get corrupted under some scenarios when significant selections is performed same time as other clients perform batches of inserts/updates (basically, there is a long lasting bug in memory management). Transactions are available in a single engine InnoDB and it is much slower than MyISAM. Worst thing is that in scenarios with multitenant databases with somewhat mediocre load MySQL starts to leak memory. This i a known well-issue, and there is no cure at this moment, you have to reboot the database instance. This is simply a disaster. Performance insight is something that could enjoy some more love. While Mysql is compatible with most of standard SQL, there are still some hard to explain differences.

Reasons for Choosing MySQL

Mysql is still used in some of our projects, but we are on our way to switch to another RDBMS for the reasons I described above.

August 2019

Anonymous

Verified Reviewer

Company Size: 11-50 employees

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

2.0

Functionality

5.0

August 2019

MySQL the default database server

We just use MySQL for all of our databases

Pros

It's the default standard for many companies. MySQL has grown into a very stable product that never crashes. We've made the move to MariaDB, but found that the tables sometimes get corrupted when restarting a database server under heavy load. With the recent speed improvements to MySQL, we have decided to actually migrate back to MySQL.

Cons

I'd really like if they would spend a bit more time on their CLI interface. As in, syntax highlighting in the CLI, an easier way to scroll through multiline queries when going through the history. I would also like it if we can specify a color scheme to use for the output.

Reasons for Choosing MySQL

both other servers come highly recommended by other parties, but for some reason they just don't have the feature that we're looking for.

Reasons for Switching to MySQL

MariaDB crashes too much.

January 2021

Mohammad Iqbal from MIKS Company

Verified Reviewer

Company Size: 51-200 employees

Industry: Computer Software

Time Used: More than 2 years

Review Source: GetApp


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

January 2021

MySQL is lighter and fast database

Our application has 2-way interface, data-entry and user / customer interfaces. On one hand it is being used with .Net for data-entry part of application and on other hand being used with PHP for user / customer interface. The .Net part is deployed locally while user / customer interface is deployed on Azure. A in-house developed desktop utility is also being used to transport data from local MySQL server to Azure MySQL database. We are having almost 2M+ transactions in few tables, working well. It helps us to save the licensing cost. It is also being used in our other websites in backend for data storage and retrieval.

Pros

The thing I like most about MySQL is, It is available for multiple operating systems like Windows, Linux, etc. It is free and open-source. It is very lighter in comparison to MsSQL and very fast. It is very easy to learn and use. It is very easy to install, configure and manage. The syntax is very identical to the same we use sentences in English. It is capable to hold large data in tables. It is best free database with enterprise level features. It is supported by almost all popular programming languages. There are numerous 3rd party custom tools available for it.

Cons

With huge data, I had faced data loss and improper data retrieval but it is very rare and manageable. Some of the error messages are so general and unable represent the actual problem. Some error messages are so weird then the actual problem. It gives sense of insecurity at some points.

Reasons for Switching to MySQL

For advanced functionality in saving, retrieving and accessing the data and use it webpages.

March 2021

User Profile Picture

Adam from Fisher College of Business

Verified Reviewer

Company Size: 10,000+ employees

Industry: Computer Software

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Functionality

4.0

March 2021

Powerful FOSS RDBMS

My experience with MySQL has been positive. I haven't found an application that it wasn't suited for yet. It has allowed us to move the majority of our systems off of Windows servers onsite to the cloud. Additionally it's compatible with ArouraDB which allows us to safe money with non production sites.

Pros

I've used both Microsoft SQL Server and Oracle and what I liked most about MySQL, aside from my personal preference for it's syntax, is that it runs well on all platforms and is easy to setup and maintain. MSSQL limits you to Windows servers and while Oracle will run on various platforms it is difficult to setup and maintain.

Cons

What I like least about MySQL is that backing up and restoring databases is a pain. You basically have to dump the database to a text file that contains every SQL statement needed to recreate the database. I also feel like the MySQL dataconnector for .NET Core isn't well developed or supported. Also MSSQL and Oracle have more ease of use functions when programming.

Reasons for Switching to MySQL

We wanted to move to the cloud and not be locked into the expense of running windows servers.