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: Computer Software
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 8.0 /10
A very good option for small software development projects
Reviewed on 2021-11-06
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: 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 2021-03-11
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.
- Industry: Writing & Editing
- Company size: Self Employed
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 7.0 /10
Almost all my sites run on MySQL
Reviewed on 2019-04-30
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: Publishing
- Company size: 2–10 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 10.0 /10
Relational database management system
Reviewed on 2024-06-03
MySQL remains one of the most popular open source databases.
MySQL remains one of the most popular open source databases.
Pros
MySQL open source software, easy to manage and query. In my experience, it's reliable and very efficient. It enables efficient database management. MySQL provides a very high level of security.
Cons
Mysql has its limits when it comes to very advanced functions, or when the load is high. The SQL-dependent system does not support certain languages.
- Industry: Internet
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 10.0 /10
MySQL is the world's most popular free open source database
Reviewed on 2021-09-23
It's simply perfect that was able to fulfil my needs. Basically, I use the MySQL database for web...
It's simply perfect that was able to fulfil my needs. Basically, I use the MySQL database for web development purposes, It was so helpful for me so far. My overall experience is really remarkable with the MySQL database.
Pros
MySQL is so easy to use and comfortable, even a lot suitable for the WordPress platforms. I like how this database has organized everything, backup process, data replacement, adding or deleting tables, find out the important data even query. If I want to do something, I can write some code as commands and all done. This database supports a query language too.
Cons
There are no cons I've noticed with the MySQL database. But I think it should be easier because newbies will get confused while using and learning MySQL. With little knowledge, you can't manage and control the MySQL database.
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 Software, Phone Support, 24/7 (Live rep), Chat
Related categories
See all software categories found for MySQL.
