MySQL

4.6 (2,061)
Write a Review!
One database service for transactions, analytics, and ML

About MySQL

MySQL is a relational database management system (RDBMS) designed to help businesses record, update, and manage data and deploy cloud-native applications. Features include data masking and de-identification, multi-document transaction support, intrusion detection, alerts, and configuration management.

The application provides tools to automate administrative tasks such as data provisioning, backup, patching, and tuning. Engineers can protect confidential data by using encryption, key generation, and digital signatures. Administrators can also monitor user and application-level performance and resource consumption of the database via performance schema.

MySQL Enterprise Firewall helps database administrators protect information through real-time threat monitoring, whitelisting, and SQL statement blocking features. The Query Analyzer lets engineers view query activities, identify problematic queries through full table scans and bad index searches, and evaluate multiple executions during a specific time period.

Developers can use MySQL Workbench to perform database modeling, query development and testing, server configuration, audit data inspection, and database migrations. MySQL allows team members to recover data by utilizing backward compatible full recovery, precise one-click, point-in-time, and partial recovery capabilities.

MySQL Products include:

MySQL HeatWave, our fully managed database service, for OLTP, OLAP, & ML workloads.

MySQL Enterprise Edition for delivering business-critical, enterprise database applications.

MySQL Enterprise Edition for ISVs, OEMs and VARs who want a proven, low cost, embedded database.


Key benefits of MySQL

Ease of use: Developers can install MySQL in minutes, and the database is easy to manage.

Reliability: MySQL is one of the most mature and widely used databases. It has been tested in a wide variety of scenarios for more than 25 years, including by many of the world’s largest companies. Organizations depend on MySQL to run business-critical applications because of its reliability.

Scalability: MySQL scales to meet the demands of the most accessed applications. MySQL’s native replication architecture enables organizations such as Facebook to scale applications to support billions of users.

Performance: MySQL HeatWave is faster and less expensive than other database services, as demonstrated by multiple standard industry benchmarks, including TPC-H, TPC-DS, and CH-benCHmark.

High availability: MySQL delivers a complete set of native, fully integrated replication technologies for high availability and disaster recovery. For business-critical applications, and to meet service-level agreement commitments, customers can achieve Recovery point objective = 0 (zero data loss) and Recovery time objective = seconds (automatic failover)

Security: Data security entails protection and compliance with industry and government regulations, including the European Union General Data Protection Regulation, the Payment Card Industry Data Security Standard, the Health Insurance Portability and Accountability Act, and the Defense Information Systems Agency’s Security Technical Implementation Guides. MySQL Enterprise Edition provides advanced security features, including authentication/ authorization, transparent data encryption, auditing, data masking, and a database firewall.

Flexibility: The MySQL Document Store gives users maximum flexibility in developing traditional SQL and NoSQL schema-free database applications. Developers can mix and match relational data and JSON documents in the same database and application.


Images

MySQL Software - MySQL Enterprise Manager
MySQL Software - MySQL Enterprise Monitor
MySQL Software - MySQL Workbench
View 5 more
MySQL video
MySQL video
MySQL Software - MySQL Enterprise Manager
MySQL Software - MySQL Enterprise Monitor
MySQL Software - MySQL Workbench

Not sure about MySQL? Compare with a popular alternative

MySQL

4.6 (2,061)
VS.

Starting Price

US$2,000.00
year
US$20.00
month

Pricing Options

Free version
Free trial
Free version
Free trial

Features

145
186

Integrations

No integrations found
17

Ease of Use

4.4 (2,061)
4.5 (636)

Value for Money

4.6 (2,061)
4.5 (636)

Customer Service

4.2 (2,061)
4.7 (636)
Green rating bars show the winning product based on the average rating and number of reviews.

Alternatives

BigTime

4.6
#1 Alternative to MySQL
BigTime helps firms reduce operational costs, align talent to projects, accelerate payments and enable quicker...

dBASE Plus

4
#2 Alternative to MySQL
dBASE Plus is an on-premise application development solution that helps businesses build various applications such as...

IBM Informix

5
#3 Alternative to MySQL
IBM Informix is a cloud-based database solution, which provides features such as real-time analytics, high availability...

IBM Cognos Analytics

4.2
#4 Alternative to MySQL
IBM Cognos is a suite of business intelligence and performance management software, that includes dashboards, reports,...

Reviews

Overall rating

4.6 /5
(2,061)
Value for Money
4.6/5
Features
4.5/5
Ease of Use
4.4/5
Customer Support
4.2/5

Already have MySQL?

Software buyers need your help! Product reviews help the rest of us make great decisions.

Showing 5 reviews of 2,061
Filipe
Filipe
Overall rating
  • Industry: Information Technology & Services
  • Company size: Self Employed
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

MySQL review

Reviewed on 31/01/2020

With MySQL i can sell more software because I can sell cheaper, and the performance is the same...

With MySQL i can sell more software because I can sell cheaper, and the performance is the same than others

Pros

MySQL is a great to database and is very very powerfull
I use it everyday on my work when I develop web applications for my clients
MySQL is reliable and have some great admistration tools with great value
MySQL works very good and uses less system resources than other similar softwares

Cons

MySQL have all that I need to do my work perfect with less cost than others similar softwares
MySQL works great for web applications, with good performance

Alternatives Considered

Microsoft SQL Server

Reasons for Choosing MySQL

MySQL works great on windows and linux, uses less system resources than other softwares

Switched From

Microsoft SQL Server

Reasons for Switching to MySQL

With MySQL I have the same performance with less cost
Aleksandr
Aleksandr
Overall rating
  • Industry: Computer Software
  • Company size: 501–1,000 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Likelihood to recommend 5.0 /10

Great overall but has some very important caveats.

Reviewed on 23/04/2021

Mysql as any other tools has it's advantages and downsides.
It may be fast, ACID-compatible, it...

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.

Alternatives Considered

Microsoft SQL Server and PostgreSQL

Reasons for Switching to 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.
Toby
Overall rating
  • Industry: Computer Software
  • Company size: 11–50 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 2.0 /10

You're better with postgres

Reviewed on 05/07/2021

I'm grateful to mysql as it's free - but I feel like it's had it's day as a database, and there's...

I'm grateful to mysql as it's free - but I feel like it's had it's day as a database, and there's better open source options out there.

Pros

Mysql is easy to set up, as things like access controls are generally very simple. Thought that benefit is quickly lost if you need more complex controls.

There's a couple of nice features about the mysql syntax that I like - e.g. being able to insert and update using the SET command.

Cons

Having using postgres and mysql in parallel on two similar applications, I regularly wish we'd migrated out of mysql years ago. Postgres is a little harder to set up, but then it works. I can't think of a time when I've had to go trawling through internet forums or manuals trying to explain some weird database bug. Mysql on the other hand frequently introduces it's own strange little bugs into the mix, which we've had to work around.

Alternatives Considered

PostgreSQL

Reasons for Switching to MySQL

I thought it would be easier. In the short term it was, but it was a bad choice.
Maha
Overall rating
  • Industry: Computer Software
  • Company size: 501–1,000 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

MySQL: A Popular RDBMS for Teaching Database Concepts

Reviewed on 02/08/2023

Great experience using MySQL for teaching database concepts for undergraduate and graduate students.

Great experience using MySQL for teaching database concepts for undergraduate and graduate students.

Pros

The main feature that I cherish in MySQL is the ability of my students to deploy it locally without the complexities of intricate configurations and deployment mechanisms. I used MySQL as part of the Bitnami WAMP stack (MariaDB is now packaged in Bitnami) to get a complete server bundle that is easy for students to deploy and configure. Before I relied in my teaching on a networked Oracle installation that was not that performance efficient and didn't give students the chance to configure the server environment. Moreover, with a networked configuration testing various SQL concepts would be a bit complex compared to having a local database installation.

Cons

Changing the open-source license by Oracle was a bit disappointing. MariaDB is a kind of open-source alternative to MySQL with very similar features and architecture.

Emiliano
Emiliano
Overall rating
  • Industry: Information Technology & Services
  • Company size: 201–500 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Likelihood to recommend 8.0 /10

MySQL has always been one of the best relational databases

Reviewed on 12/05/2021

Many of our relational databases work nowadays with MySQL, we find it easier to maintain than...

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)

Alternatives Considered

PostgreSQL

Reasons for Switching to 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.
Showing 5 reviews of 2,061 Read all reviews

MySQL FAQs

Below are some frequently asked questions for MySQL.

MySQL offers the following pricing plans:

  • Starting from: US$2,000.00/year
  • Pricing model: Free Version, Subscription
  • Free Trial: Available

MySQL offers a free trial for new users, after which the software is available across 4 commercial editions. Pricing and functionality are outlined below. MySQL Cluster Carrier Grade Edition Subscription (1-4 socket server): starts at $10,000 per year MySQL Cluster Carrier Grade Edition Subscription (5+ socket server): starts at $20,000 per year MySQL Enterprise Edition Subscription (1-4 socket server): starts at $5,000 per year MySQL Enterprise Edition Subscription (5+ socket server): starts at $10,000 per year MySQL Standard Edition Subscription (1-4 socket server): starts at $2,000 per year MySQL Standard Edition Subscription (5+ socket server): starts at $4,000 per year MySQL Classic Edition (only available for ISVs/OEMs)

MySQL has the following typical customers:

2–10, 11–50, 51–200, 201–500, 501–1,000, 1,001–5,000

MySQL supports the following languages:

Arabic, Chinese, Croatian, Czech, Danish, Dutch, English, European Portuguese, Finnish, French, German, Greek, Hebrew, Hungarian, Italian, Japanese, Korean, Norwegian, Polish, Portuguese, Romanian, Russian, Slovak, Slovenian, Spanish, Swedish, Thai, Traditional Chinese, Turkish

MySQL supports the following devices:

We do not have any information about what integrations MySQL has

MySQL offers the following support options:

Email/Help Desk, FAQs/Forum, Knowledge Base, Phone Support, 24/7 (Live rep), Chat

Related categories

See all software categories found for MySQL.