MySQL
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
Not sure about MySQL?
Compare with a popular alternative
Starting Price
Pricing Options
Features
Integrations
Ease of Use
Value for Money
Customer Service
Alternatives
BigTime
dBASE Plus
IBM Informix
Oracle E-Business Suite
Reviews
Already have MySQL?
Software buyers need your help! Product reviews help the rest of us make great decisions.
- 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 ServerReasons for Choosing MySQL
MySQL works great on windows and linux, uses less system resources than other softwaresSwitched From
Microsoft SQL ServerReasons for Switching to MySQL
With MySQL I have the same performance with less cost
- Industry: Computer Software
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
A very good option for small software development projects
Reviewed on 06/11/2021
To get started in application development, I highly recommend it for its ease of use and how...
To get started in application development, I highly recommend it for its ease of use and how effective it can be for handling data on a small scale.
Of course, MYSQL has to be just a step to later migrate to systems that better manage data on a large scale, such as SQL Server or Oracle.
Pros
Mysql is a good tool to start in the world of software development. It offers a small but powerful product, with effective database management when it comes to bringing us useful information for the business. With a few command lines we can get all the information we need, and its installation and first use is fast and intuitive.
Cons
Although MYSQL works well for small and medium projects, in large-scale projects we can suffer a bit with information and data management, since this tool is not entirely designed to handle large-volume data.
It can handle data in large volume, but the way in which it will do it will not be the most efficient or the most optimal, which can cause a certain lack of speed when deploying our project.
Reasons for Switching to MySQL
The ease of use of Mysql made me decide on this specific product in the end.- Industry: Writing & Editing
- Company size: Self Employed
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
Almost all my sites run on MySQL
Reviewed on 30/04/2019
I hardly think about MySQL because that is how it functions - quietly and in the background 24/7....
I hardly think about MySQL because that is how it functions - quietly and in the background 24/7. But MySQL is an totally ESSENTIAL part of my online presence, as my websites would immediately cease functioning without MySQL. It is that important! While it does its job most of time, if there are errors in MySQL for whatever reason, then to repair the problem can become a bit expensive. Apart from this small risk, MySQL is one of those "must-have" software if you run any independently hosted websites online.
Pros
MySQL is the standard database software used by virtually all the PHP-based scripts for database creation and functioning. It is a standard add-on software for most webhosts as part of the cPanel plan. As long as you are not hacked, the database software works quietly in the background 24/7 and delivers your website to the world. As an "add-on" software it is free in that sense (or may be part of my monthly hosting fees), but this is a trivial point. MySQL is like a set-and-forget kind of software, and indispensable to nearly all webmasters.
Cons
The database is not very efficient, and this often leads to errors, if some script overloads it or if your website is hacked and compromised. If there is too much traffic, things also can break down.
As anything database related is hard to repair, it is best to get an expert on MySQL, who can be expensive, to fix any issues in the database. Many additional plugins create further tables or rows in MySQL which remain there for life even if the plugin is removed later on. This leads to bloat in the database.
- Industry: Management Consulting
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 9.0 /10
Simple yet powerful
Reviewed on 27/05/2024
Pros
Very simple to get started with and take advantage of a broad set of features. Low learning curve to master it. In depth documentation with a large community support. Plethora of robust tools to support it, like the MySQL Workbench.
Cons
There are some not so intuitive functionalities that you have to look up the documentation to understand and work around. One of them is killing a query in process. Also, the profiler tool is not as powerful as some of the competitor DBMS.
- Industry: Computer Software
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 10.0 /10
Powerful FOSS RDBMS
Reviewed on 11/03/2021
My experience with MySQL has been positive. I haven't found an application that it wasn't suited...
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.
MySQL FAQs
Below are some frequently asked questions for MySQL.Q. What type of pricing plans does MySQL offer?
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)
Q. Who are the typical users of MySQL?
MySQL has the following typical customers:
2–10, 11–50, 51–200, 201–500, 501–1,000, 1,001–5,000
Q. What languages does MySQL support?
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
Q. Does MySQL support mobile devices?
MySQL supports the following devices:
Q. What other apps does MySQL integrate with?
We do not have any information about what integrations MySQL has
Q. What level of support does MySQL offer?
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.
