Database
November 18, 2026
2 views
2 min read

Amazon RDS for MySQL LTS version 9.7 is now generally available

Curated by Patrick
Source: AWS Database Blog
Amazon RDS for MySQL LTS version 9.7 is now generally available
Tech Daily Byte Analysis

AWS announced that Amazon RDS for MySQL can now run the community’s newest Long‑Term Support release, version 9.7, alongside the existing 8.0 and 8.4 options. The rollout ships with minor version 9.7.4, which contains only security and bug fixes, and it inherits a handful of default‑parameter changes that originated in the 9.5 Innovation releases—most notably a shift of the EXPLAIN output to TREE format, a switch of InnoDB’s change‑buffering to “none,” and the activation of dedicated log‑writer threads. AWS also hard‑codes the rdsproxyadmin account as a reserved user, forces GTID mode ON_PERMISSIVE, and disables Multi‑AZ clusters with two readable standbys for this version. Customers must follow a strict LTS‑to‑LTS upgrade chain (5.7 → 8.0 → 8.4 → 9.7) and use blue/green deployments, read replicas, or in‑place upgrades, with blue/green recommended to limit downtime.

The move reflects MySQL’s evolving release cadence, where Innovation releases (9.0‑9.6) are short‑lived and preview‑only on RDS, while LTS releases provide a stable baseline for production workloads. By adding 9.7, AWS aligns its managed service with the community’s decision to transition to calendar‑based versioning after this line, positioning RDS as the go‑to platform for enterprises that need the newest stable MySQL features without the churn of Innovation releases. At the same time, AWS extended Extended Support for MySQL 5.7 to mid‑2029—well beyond the original February 2027 deadline—giving legacy users a longer runway to migrate, a tactic that mirrors similar extensions in Azure and Google Cloud’s managed database offerings.

Enterprises should audit their parameter groups for the new defaults, especially any tooling that parses EXPLAIN output, and verify that GTID settings and replication topologies comply with the 9.7 constraints. The lack of support for Multi‑AZ clusters with two standbys means high‑availability architectures may need to revert to single‑standby configurations or wait for a future update. Monitoring the upcoming calendar‑versioned releases (e.g., MySQL 26.7) will be critical, as they will inherit the 9.7 LTS baseline but may introduce additional breaking changes. Finally, teams should treat the extended 5.7 support as a temporary safety net rather than a long‑term strategy, planning migrations to 8.4 or 9.7 to stay within AWS’s security‑patch window.

Key Takeaways

RDS now runs MySQL 9.7 LTS (9.7.4) with new defaults that can affect EXPLAIN parsing and InnoDB buffering.

Upgrade paths are forced LTS‑to‑LTS; skipping versions (e.g., 5.7 → 9.7) is unsupported.

Multi‑AZ deployments with two readable standbys are blocked for 9.7, requiring architecture adjustments.

AWS extended MySQL 5.7 Extended Support to June 2029, giving legacy users extra time but urging migration to newer LTS releases.

About the Source

This analysis is based on reporting by AWS Database Blog. Here is a short excerpt for context:

Amazon RDS for MySQL now supports MySQL 9.7, the latest community LTS version, alongside 8.0 and 8.4. This post covers what’s new in 9.7, the key breaking changes, and how to upgrade safely from MySQL 8.4 using Amazon RDS Blue/Green deployments.
Read the original at AWS Database Blog

More in Database