Overview
MySQL is the world's most-deployed open-source database, with an estimated installed base running into the tens of millions of instances. Now in version 8.4 LTS (and version 9.x Innovation track), MySQL is owned by Oracle and offered under a dual-licence model: the GPLv2 Community Edition and the commercial Enterprise Edition, plus the cloud-native MySQL HeatWave service that combines OLTP and in-memory analytics in a single instance.
MySQL remains the database of choice for the LAMP stack and powers a substantial portion of WordPress, Magento, Drupal, and SaaS application backends. In the enterprise, MySQL faces stronger competition from PostgreSQL and Aurora than at any point in its history, and several major adopters have publicly migrated away. It nonetheless remains a credible operational database for write-heavy web workloads and is consistently among the top three managed database services by revenue on every hyperscaler.
Key Features
- InnoDB storage engine with row-level locking and MVCC
- Group Replication and InnoDB Cluster for built-in HA without third-party tools
- MySQL Router for connection routing and failover
- MySQL Shell with AdminAPI for cluster provisioning and management
- Native JSON column type with JSON_TABLE and indexed JSON queries
- HeatWave in-memory accelerator for hybrid OLTP and analytic queries on OCI
- HeatWave Lakehouse for querying object storage (Parquet, CSV) directly
- GenAI integration in HeatWave for in-database LLM, vector store, and chat workflows
- X DevAPI for document-store style access alongside SQL
- Spatial data types with ST_* functions and SRS-aware operations
- Online DDL for most schema changes without table locking
- Transparent Data Encryption (Enterprise), audit, masking, and firewall add-ons
Pricing
| Edition / Service | Model | Cost |
|---|---|---|
| MySQL Community Edition | Open source (GPLv2) | $0 |
| MySQL Standard Edition | Per server/year | ~$2,000/server/year |
| MySQL Enterprise Edition | Per server/year | ~$5,000/server/year |
| MySQL Cluster Carrier Grade Edition | Per server/year | ~$10,000/server/year |
| MySQL HeatWave on OCI / AWS / Azure | Per OCPU/hour | From ~$0.30/OCPU/hour (HeatWave Lakehouse) |
| Amazon RDS for MySQL | Per instance/hour | From ~$0.017/hour (db.t4g.micro) |
Pricing verified May 2026 from Oracle's MySQL price list and AWS RDS pricing. Oracle uses a per-socket "server" metric for traditional editions; HeatWave is metered per OCPU and storage GB-hour.
Strengths
- Largest hosting and tooling ecosystem of any database; ubiquitous in web frameworks
- InnoDB Cluster provides production-ready HA without external tooling
- HeatWave is a meaningful differentiator for hybrid OLTP/analytics on OCI
- Predictable, well-understood performance characteristics for OLTP workloads
- Strong replication (group, async, semi-sync) with mature operational tooling
- Available as a first-party managed service on every major cloud
Limitations
- SQL feature gaps versus PostgreSQL — limited window function depth, no native partitioned views
- Dual licence creates real legal complexity for embedded distribution
- Enterprise edition features (TDE, audit, firewall) require paid commercial subscription
- Replication conflicts in group replication are operationally fragile under heavy write contention
- Several large adopters have publicly migrated to PostgreSQL or Aurora, signalling momentum risk