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 & Network Security
- Company size: 11–50 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
The Security in MySQL Database
Reviewed on 15/11/2023
MySQL has a large and active community. This means there's an abundance of resources, forums, and...
MySQL has a large and active community. This means there's an abundance of resources, forums, and tutorials available, making it easier to find help and solutions to common issues. Being open source and freely available is a significant advantage. It reduces costs for businesses and developers and promotes a collaborative development environment.
Pros
MySQL's combination of being open source, easy to use, and offering strong performance and scalability makes it a popular choice for various applications, from small-scale projects to large-scale enterprise solutions.
Cons
The MyISAM storage engine, while simple and fast for read-heavy workloads, lacks support for transactions and foreign keys. This limitation makes it less suitable for applications that require strong ACID compliance.
- 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.
- Industry: Accounting
- Company size: 2–10 Employees
- Used Weekly for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
Value benefit product
Reviewed on 19/02/2024
Pros
ease of use, user friendly, good interface
Cons
not updated with latest requirements of my field
- Industry: Business Supplies & Equipment
- Company size: 5,001–10,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
Easy to learn and use - effective tool
Reviewed on 29/09/2024
Overall wonderful experience and great learning tool
Overall wonderful experience and great learning tool
Pros
Very user friendly and easy to learn and connect
Cons
Large datasets are not easily supported and may not be compatible
- Industry: Electrical/Electronic Manufacturing
- Company size: 2–10 Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
There is no better database management system than MySQL.
Reviewed on 15/09/2023
I've used MySQL for a few years, and I'd heartily recommend it. It is a very capable and flexible...
I've used MySQL for a few years, and I'd heartily recommend it. It is a very capable and flexible solution for managing your server-based data.
Pros
Despite being available for free, MySQL has numerous functionalities that are also present in commercial products like SQL Server.
Cons
The majority of other databases, save for MySQL, offer data transfer between DB and distributed file systems like AWS S3.
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.
