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,492 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 1492 results

May 2021

User Profile Picture

Emiliano from Etermax

Verified Reviewer

Company Size: 201-500 employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Functionality

4.0

May 2021

MySQL has always been one of the best relational databases

Many of our relational databases work nowadays with MySQL, we find it easier to maintain than PostgreSQL or other alternatives, as well as it's knowledge more broadly distributed due to it being very beginner friendly for web projects, joined with PHP usually.

Pros

First of all there's a free community version, as well as alternative software like MariaDB and Percona Server which have an open-source approach as well. There are multiple services to manage MySQL like Amazon RDS as well as similar products on GCP or Azure, so it's not entirely required to have expert knowledge to use these databases if you are willing to pay for support.

Cons

The upgrade process for MySQL requires downtime and it's not easy to perform a rollback either (on some cases it's entirely impossible unless you restore a backup). Managed services don't provide a zero-downtime upgrade process either, except for migration all your info and deltas into a new database (which sometimes is not entirely available)

Reasons for Choosing MySQL

We find it easier to maintain than PostgreSQL and also more teammates felt comfortable with this software since they were quite familiar with it and possible debugging on the future.

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.

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.

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.

February 2021

Michael from hs2n Informationstechnlogie GmbH

Company Size: 11-50 employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Customer support

4.0

Functionality

5.0

February 2021

From small php pages to big data

We are using mysql in many installations. From very small php sites to big data stuff - it's always the same database engine!

Pros

It's so easy to setup. Just install via package manager and you are up and running. If you need more features, just customize the setup files. Replication, Backup, all is working out of the box.

Cons

Creating a database and adding a new user must be done in sql. For this step an installer/menu would be great since I've to do this very often.

Reasons for Choosing MySQL

Mysql is the default database of so many php frameworks.

Reasons for Switching to MySQL

Setup is so much easier than oracle.