MySQL
FreemiumThe world's most popular open source database.
Scores
About
MySQL is an open-source relational database management system (RDBMS) first released in 1995 and now owned by Oracle Corporation. It is the 'M' in the classic LAMP stack and remains one of the most widely deployed databases on the planet — used by Facebook, Twitter, YouTube, Airbnb, and countless others at massive scale.
MySQL uses a client-server architecture and stores data in tables with rows and columns, enforcing relationships through foreign keys. The default storage engine, InnoDB, provides full ACID compliance, row-level locking, and native replication support. MyISAM is a legacy engine still used for read-heavy, non-transactional workloads.
MySQL is available as the free Community Edition (GPL) and as MySQL Enterprise Edition, a commercially licensed product from Oracle that adds enterprise monitoring, security plugins, backup tooling, and 24/7 support.
It is particularly dominant in PHP and web application stacks, pairs natively with WordPress, and is first-class in cloud-managed offerings from AWS (Amazon RDS for MySQL, Aurora MySQL-compatible), Google Cloud (Cloud SQL for MySQL), and Azure (Azure Database for MySQL).
Key Features
- Full ACID compliance via InnoDB storage engine
- Master-replica and group replication built in
- Rich SQL dialect with stored procedures, triggers, and views
- Broad connector ecosystem (Python, Java, PHP, Node.js, Go, .NET, Ruby)
- Cloud-managed on AWS RDS, Aurora, Google Cloud SQL, Azure Database
- JSON column type and multi-valued indexes for semi-structured data
- Point-in-time recovery and binary log-based replication
- Row-level locking for high-concurrency OLTP workloads
Pros
- Extremely mature, battle-tested at massive scale
- Huge ecosystem: tutorials, ORMs, tools, managed cloud offerings
- Excellent performance for standard OLTP read-heavy workloads
- Native replication makes high-availability setups straightforward
- First-class support in every major web framework and language
- Strong default in shared hosting environments — ubiquitous
Cons
- Fewer advanced SQL features compared to PostgreSQL (e.g. partial indexes, CTEs were late additions)
- Oracle stewardship raises open-source sustainability concerns for some teams
- Limited support for complex analytics / OLAP without a separate engine
- JSON support and window functions mature later than in PostgreSQL
- Strict mode quirks and charset/collation configuration can catch beginners off guard
Pricing
Freemium- · Full-featured MySQL server under GPL license
- · Community support only (forums, Stack Overflow)
- · No SLA or Oracle support contract
- · Enterprise Monitor and Query Analyzer
- · MySQL Enterprise Backup (hot online backups)
- · MySQL Enterprise Security (PAM, LDAP, Kerberos auth plugins)
- · MySQL Enterprise Firewall
Possible Stacks
WordPress Site
ProjectContent-driven website powered by WordPress with MySQL — the most widely deployed CMS in the world.
WooCommerce Store
ProjectE-commerce store built on WordPress with WooCommerce and MySQL — launch an online shop without writing code.
Related Tools
Works well with (16)
Alternative to (4)
Learning Resources
No resources yet — check back soon.
