{
  "$type": "site.standard.document",
  "bskyPostRef": {
    "cid": "bafyreieviowemrqlxcjxzrzfzhwby5k4sutdt6tzdp5i6kst3pjfzyn3ke",
    "uri": "at://did:plc:5sgu76a53rz3n6unbykmovqy/app.bsky.feed.post/3mloh64rr2te2"
  },
  "description": "MySQL is one of the most widely deployed open-source relational databases, especially common in web stacks and as the storage layer behind countless WordPress, Rails, and PHP applications. It is owned by Oracle, with two prominent community forks: MariaDB (separate project since 2010) and Percona Server (a drop-in replacement with operational tooling).\n\n\nKey features\n\n * InnoDB engine. The default storage engine since MySQL 5.5: ACID transactions, row-level locking, MVCC, foreign keys.\n * Replic",
  "path": "/engineering-glossary/mysql-relational-database/",
  "publishedAt": "2026-05-12T18:46:27.000Z",
  "site": "https://sahilkapoor.com",
  "tags": [
    "PostgreSQL",
    "SQL",
    "ACID",
    "MVCC",
    "Replication",
    "OLTP"
  ],
  "textContent": "**MySQL** is one of the most widely deployed open-source relational databases, especially common in web stacks and as the storage layer behind countless WordPress, Rails, and PHP applications. It is owned by Oracle, with two prominent community forks: MariaDB (separate project since 2010) and Percona Server (a drop-in replacement with operational tooling).\n\n## Key features\n\n  * **InnoDB engine.** The default storage engine since MySQL 5.5: ACID transactions, row-level locking, MVCC, foreign keys.\n  * **Replication.** Mature primary-replica replication with semi-synchronous, asynchronous, and Group Replication options.\n  * **Pluggable storage engines.** InnoDB by default; MyISAM, MEMORY, Archive, and others available for niche workloads.\n  * **JSON support.** Native JSON columns since 5.7, with indexing via generated columns or multi-valued indexes.\n  * **Mature ecosystem.** Connectors for every language, broad managed offerings (RDS, Aurora, PlanetScale, Cloud SQL).\n\n\n\n## MySQL vs PostgreSQL\n\n  * MySQL is permissive by default and has historically focused on simplicity and replication speed; PostgreSQL is stricter and richer in types, extensions, and advanced SQL features.\n  * PostgreSQL has overtaken MySQL as the default for new projects in many parts of the industry; MySQL remains dominant in installed base and in specific stacks.\n\n\n\n🔗\n\n**Related Terms**\nPostgreSQL, SQL, ACID, MVCC, Replication, OLTP.",
  "title": "MySQL",
  "updatedAt": "2026-05-13T19:14:40.128Z"
}