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
Aiven for PostgreSQL
IBM Informix
IBM Cognos Analytics
SQL Complete
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: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
The well balanced
Reviewed on 30/09/2020
I use MySQL in many personal projects, like my automated house project. It was a very good choice,...
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!
Alternatives Considered
PostgreSQLReasons for Switching to 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.- Industry: Libraries
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
10 Years of MySQL
Reviewed on 08/06/2023
MySQL is a robust and scalable choice for many database-driven projects, offering numerous...
MySQL is a robust and scalable choice for many database-driven projects, offering numerous advantages for both beginners and experienced developers. I appreciated this coming in as a novice and learning overtime how important a functioning database is to a project.
Pros
MySQL's compatibility with various platforms and extensive support for programming languages contributes to its versatility, making it suitable for diverse applications. Moreover, its extensive online community and detailed documentation make troubleshooting and learning effortless.
Cons
MySQL lacks some advanced performance optimization features found in other database management systems. This limitation may require additional effort to optimize complex queries manually.
Reasons for Switching to MySQL
Because its compatibility with other platforms and services is unparalleled, offering rocksteady databases is an important part in beginning a project.- 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
PostgreSQLReasons for Switching to MySQL
I thought it would be easier. In the short term it was, but it was a bad choice.
- Industry: Information Technology & Services
- Company size: 2–10 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
My experience with MySQL
Reviewed on 06/08/2023
Overall, my experience with MySQL has been great. Every developer in my office prefer to use MySQL...
Overall, my experience with MySQL has been great. Every developer in my office prefer to use MySQL for the database. I myself have a huge fan of this classic database management system. I even tried using other DBM Systems but I couldn't have anything as easy to use as MySQL. This is why I recommend everyone to use MySQL every time.
Pros
Without a doubt, every feature MySQL offers is very useful and effective. The database management system that MySQL provides is very important in the field I am in. The developers in my company use MySQL for the data management in backend. Our company itself stores the data of its employees in the database using MySQL. I myself have used MySQL a lot. I completed my final year project in university by developing a website which store all of the user's data in MySQL database. It is very easy use and understand. The way it performs even with huge number of data is also very impressive. Data filtering and monitoring are also fluid and easy to carry out using MySQL.
Cons
MySQL is heavily based on queries or commands and it is quite confusing sometimes. Personally, I have a habit of forgetting small details in the queries and commands which I have to google search later. I would prefer to have a GUI based options to work with MySQL or suggestions with commands. But, that is a personal preference, not all users will forget the queries. Other than that, I don't have any complaints with MySQL as of now.
- Industry: Computer Games
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
MySQL: A Comprehensive Review
Reviewed on 18/01/2023
MySQL is an incredibly powerful and versatile database management system that is suitable for...
MySQL is an incredibly powerful and versatile database management system that is suitable for businesses of all sizes. Its features are comprehensive and allow users to customize the system to their needs. However, it can be difficult to understand and use for those who are not experienced with databases.
Pros
MySQL is an incredibly powerful and versatile open-source relational database management system. It is easy to setup and use, and it is highly customizable, allowing users to tailor the system to their specific needs. The sheer number of features and capabilities available makes MySQL an ideal choice for businesses of all sizes.
Cons
MySQL can be quite difficult to understand and use for those who are not experienced with databases. The complex nature of the software can make it difficult to troubleshoot and maintain. Also, some of the features are not always as intuitive as they could be, which can make it difficult for novice users to understand.
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:
- 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.
