MySQL 8.0 vs MariaDB 10.11 LTS
MariaDB 10.11 LTS was released 4.9 years after MySQL 8.0. Source: endoflife.date (aggregating official MySQL/Oracle and MariaDB Foundation EOL announcements), checked 2026-07-31.
| Fact | MySQL 8.0 | MariaDB 10.11 LTS |
|---|---|---|
| Release date | 2018-04-08 | 2023-02-16 |
| End of life | 2026-04-30 | 2028-02-16 |
| LTS release | Yes | Yes |
| Currently supported | No | Yes |
Feature differences
Unchanged New capability Behavior changed Deprecated Removed
| Feature | MySQL 8.0 | MariaDB 10.11 LTS |
|---|---|---|
| Default authentication plugin | caching_sha2_password (since 8.0.4) | unix_socket / mysql_native_password |
| GROUP BY implicit sort order | Never guaranteed — add explicit ORDER BY | Never guaranteed — add explicit ORDER BY |
| Default character set | utf8mb4 | utf8mb4 |
| Query cache | Removed entirely — no ON/OFF option exists | Still available |
| Window functions (OVER()) | Supported | Supported (since 10.2) |
| Common Table Expressions (WITH) | Supported, including RECURSIVE | Supported (since 10.2) |
| Roles (CREATE ROLE) | Supported | Supported (since 10.0.5 — earlier than MySQL) |
| JSON column type | Native binary JSON type, expanded functions | JSON is an alias for LONGTEXT + a CHECK constraint — not a native type |
| Replication terminology | SOURCE / REPLICA syntax added (8.0.23+); old terms still accepted | MASTER / SLAVE terminology retained |
| Upgrade process | Automatic upgrade on startup (since 8.0.16) | mariadb-upgrade required after binary swap |
| New reserved keywords | Adds OVER, RECURSIVE, ROW_NUMBER, RANK, LAG, LEAD, GROUPS, WINDOW, and more | Different keyword set — check MariaDB's own reserved-words list |
Explore another pair
Compare any two versions
All 45 released MySQL and MariaDB version lines are listed here — pick any two. Source: endoflife.date (aggregating official MySQL/Oracle and MariaDB Foundation EOL announcements), checked 2026-07-31.