6smarketersSoftware
Home/Developer & IT/Database Management/MySQL

MySQL

Database Management

Visit websiteCompare
★★★★☆ 4.4 / 5 on G2 · 4.6 on Capterra (1,686 G2 reviews)
4.4 / 5
G2 rating, 1,686 reviews [source]
Open source
Oracle stewarded [source]
Free
GPL open source [source]
Web
Most popular [source]

Quick facts

CategoryOpen source relational database
VendorOracle (MySQL)
Starts atOpen source free; managed cloud options
Best forPopular open source relational
DeploymentSelf hosted and managed cloud
Free planYes, open source (GPL)
IntegrationsBroad, every language and framework
G2 rating4.4 / 5
Capterra rating4.6 / 5

What is MySQL?

MySQL is the world's most popular open source relational database, fast, reliable and easy, powering countless web apps, free and open with managed cloud options. A widely used relational DBMS, it is known for speed, reliability, ease of use and ubiquity, forming the backbone of the LAMP stack and powering an enormous share of web applications and sites, available free as open source (GPL) and self hosted, with commercial editions and managed cloud services (MySQL HeatWave, Amazon RDS, and others). The default relational database for many web and application projects, MySQL combines popularity, performance and a huge ecosystem at no licence cost. For popular open source relational data, MySQL is a leading choice.

MySQL's distinction is being the most popular, proven, free open source relational database with a vast ecosystem. Its speed, reliability and ubiquity mean enormous community support, tooling, hosting and expertise, and it is free and easy to adopt, which is why it powers so much of the web. That popularity, proven simplicity and ecosystem, at no licence cost, set it apart for mainstream web and app data.

MySQL at a glanceMySQL is the world's most popular open source relational database [MySQL]. It holds a 4.4 out of 5 rating across 1,686 reviews on G2 and 4.6 on Capterra, a default for web and app data.

Who MySQL is best for

MySQL is best for web and application projects that want a popular, fast, reliable, free open source relational database with a huge ecosystem and easy adoption, from small sites to large web platforms. It suits mainstream web and app data. It is a weaker fit for teams needing the most advanced relational features, where PostgreSQL fits, the deepest enterprise capability, where Oracle fits, flexible document data, where MongoDB fits, or analytics, where Snowflake or BigQuery fit.

Key features

The core strengths are a fast, reliable, easy to use relational engine, SQL, replication and clustering options, and ubiquity with a vast ecosystem, free as open source, with commercial and managed cloud options. MySQL offers broad language and framework support, strong community and tooling, and proven web performance. Its popularity, speed, ease and ecosystem at no licence cost are its defining advantages.

MySQL pricing

MySQL Community Edition is free and open source (GPL) to self host, with Oracle's commercial MySQL Enterprise editions adding features and support, and managed cloud services (MySQL HeatWave, Amazon RDS for MySQL, Azure Database for MySQL and others) priced by usage. So teams can run it free, or pay for commercial support or managed cloud. Costs are low, mainly infrastructure or usage. Details are on the MySQL downloads page.

Integrations and ecosystem

MySQL has one of the largest database ecosystems, with drivers and support in every major language and framework, countless tools, hosting options, and a vast community. Its ubiquitous ecosystem, which means almost any tool, framework, host and developer works with MySQL, is a signature strength and a key reason it is so widely adopted.

MySQL and popularity

Popularity and ecosystem are the signature strength: MySQL's ubiquity means vast community support, tooling, hosting, expertise and framework integration, and it is free, fast and easy, so teams building web and app data get a proven, well supported default at no licence cost. For mainstream projects, this is the main reason to choose MySQL.

Ease of use and support

MySQL is highly rated for ease of use, speed, reliability and its ecosystem, with vast community and commercial support, suiting projects of all sizes. Its G2 reviews praise ease, performance and ubiquity, with fewer advanced features than PostgreSQL the main consideration for sophisticated needs.

Is MySQL worth it?

For web and application projects that want a popular, fast, reliable, free open source relational database with a huge ecosystem, MySQL is an excellent, proven default. The main caution is fewer advanced features than PostgreSQL, so teams needing those may prefer PostgreSQL, the deepest enterprise capability Oracle, document data MongoDB, and analytics Snowflake or BigQuery, but for popular open source relational data MySQL leads.

Pricing

Community (open source)

$0
free
  • Full relational engine
  • Self hosted
  • GPL

Enterprise

Commercial
subscription
  • Advanced features
  • Support
  • Tools

Managed cloud

Usage
per provider
  • HeatWave, RDS, Azure
  • Managed operations
  • Scale

Pros and cons

Pros

  • Most popular open source relational DB
  • Fast, reliable and easy
  • Free and open source
  • Huge ecosystem and community
  • Managed cloud options

Cons

  • Fewer advanced features than PostgreSQL
  • Enterprise features need commercial edition
  • Not for document or analytics workloads
  • Oracle stewardship concerns for some

MySQL alternatives

These database management tools come up most often against MySQL.

MySQL FAQ

What is MySQL used for?
MySQL is used to store and manage relational data, especially for web applications and sites: a fast, reliable, easy relational database using SQL, forming the backbone of the LAMP stack and powering a huge share of the web, free as open source or via managed cloud.
Is MySQL free?
Yes. MySQL Community Edition is free and open source (GPL) to self host, with Oracle's commercial MySQL Enterprise editions adding features and support, and managed cloud services priced by usage, so teams can run it at no licence cost.
MySQL vs PostgreSQL, which is better?
MySQL is the most popular, fast and easy, great for web apps, while PostgreSQL is more advanced and extensible with sophisticated features. MySQL suits simple, popular web data; PostgreSQL suits advanced features, and both are free open source.
Is MySQL good for web applications?
Yes. MySQL is the default relational database for a huge share of web applications, as the backbone of the LAMP stack, thanks to its speed, reliability, ease of use, ubiquity and vast ecosystem, with support in every major language and framework.
Who owns MySQL?
MySQL is stewarded by Oracle, which maintains the open source Community Edition (GPL) and offers commercial MySQL Enterprise editions and HeatWave cloud, while the open source MariaDB fork exists for those preferring community governance.
Does MySQL have managed cloud options?
Yes. MySQL is available as managed cloud services including Oracle MySQL HeatWave, Amazon RDS for MySQL, Azure Database for MySQL and Google Cloud SQL, which handle operations like backups, patching and scaling for usage based pricing.

External links