With MySQL 9.7.0 LTS, MySQL establishes its next long-term support release line, expands key capabilities in Community Edition, and introduces Dynamic Data Masking for Enterprise users.

The April releases mark an important milestone for MySQL.

With the GA of MySQL 9.7.0 LTS, MySQL moves from the 9.x innovation series to a new Long-Term Support release line. This begins the 9.7.x LTS series, giving users a stable branch to standardize on while continuing to build on the innovation delivered through the 9.x cycle.

This release matters not only because it establishes the next LTS baseline, but because it reflects a broader direction for MySQL. Over the last several releases, we have talked about giving users earlier visibility into what is coming, broadening access to important capabilities, and working more openly with the MySQL community. With MySQL 9.7.0 LTS, that direction is reflected in the product itself.

Several capabilities previously limited to MySQL Enterprise Edition are now available in MySQL Community Edition, while Dynamic Data Masking is now available in MySQL Enterprise Edition. Together, these changes make MySQL 9.7.0 LTS a meaningful release for DBAs, developers, and operators across both editions.

More capability in MySQL Community Edition

One of the biggest themes in MySQL 9.7.0 LTS is the continued expansion of MySQL Community Edition. Across 4 major technical areas, this release delivers 8 notable new Community Edition capabilities — a substantial broadening of what DBAs and developers can do with Community Edition.

The 4 major areas

  • Replication observability and HA behavior
    • Flow-control monitoring
    • Multi-threaded applier extended statistics
    • Automatic Eviction & Rejoin
    • Up-to-date Aware Primary Election
  • Telemetry and observability integration
    • Telemetry / OpenTelemetry support
  • Modern application development
    • MySQL JSON Duality Views
  • Query optimization and performance
    • Hypergraph Optimizer
    • Profile-Guided Optimization (PGO)

What that means in GA

At the GA level, those themes show up in specific Community Edition additions:

For DBAs and operators, these are meaningful additions:

  • Flow-control monitoring
    • Better visibility into when a cluster is being throttled and how much impact that throttling is having.
  • Extended applier statistics
    • Better visibility into lag, throughput, queued work, and worker behavior in multi-threaded replication.
  • Automatic Eviction & Rejoin
    • More resilient cluster behavior through detection of unhealthy members, eviction of unstable nodes, and automatic recovery when conditions improve.
  • Up-to-date Aware Primary Election
    • Better failover quality by preferring the most current eligible member during primary election.

Telemetry in Community Edition

Telemetry is worth calling out on its own because it is a substantial step forward for Community Edition.

Key areas include:

  • OpenTelemetry / OTLP integration
  • Export of logs, metrics, and traces
  • Component-based configuration
  • Support for modern observability workflows
  • Better alignment with centralized monitoring and tracing pipelines

For DBAs, SREs, and platform teams, that makes MySQL easier to integrate into the same observability systems used across the rest of the stack.

More for developers and performance-focused users

  • DML support for JSON Duality Views in MySQL Community Server
    • Expands Community support beyond DDL-only usage.
  • Auto-increment support in JSON Duality View DML
    • Makes JSON Duality Views easier to use in common application designs with generated keys.
  • Hypergraph Optimizer in Community Edition
    • Expands access to advanced optimization for complex queries and broader join plan exploration.

Together, these changes make Community Edition stronger in:

  • observability
  • high availability operations
  • modern application design
  • query optimization

There’s also more in MySQL 9.7.0 LTS

Beyond the headline Community Edition changes, MySQL 9.7.0 LTS includes a number of additional enhancements that matter to DBAs and developers.

Security and authentication

  • PBKDF2 storage format support for caching_sha2_password
    • Adds stronger password storage flexibility and improves the security story for deployments standardizing on caching_sha2_password.

Replication and upgrade operations

  • replica_allow_higher_version_source
    • Adds control over whether a lower-version replica can replicate from a higher-version source.
  • Clone plugin support for cloning between consecutive LTS versions higher than 9.7.0
    • Helps with longer-term upgrade planning across LTS branches.

Performance and resource awareness

  • cpuset cgroup awareness
    • Improves calculation of available logical CPUs in constrained environments.
  • Profile-Guided Optimization (PGO)
    • Extends the performance story for 9.7.0 and adds PGO-related RPM build support on SLE/openSUSE and Fedora.

These are not the primary headline items, but together they add value across security, upgrade planning, performance, and day-to-day operations.

Dynamic Data Masking is now available in MySQL Enterprise Edition

On the commercial side, one of the most important additions in MySQL 9.7.0 LTS is Dynamic Data Masking (DDM).

Dynamic Data Masking enables server-side protection of sensitive data without requiring application changes or separate masked copies of data. By attaching a masking policy directly to a base-table column, MySQL can return either the original value or a masked value at query time based on the executing user or active role.

In practical terms, Dynamic Data Masking gives organizations:

  • a more centralized control point for sensitive data exposure
  • less dependence on application-layer masking logic
  • reduced need for separate masked copies of data
  • a more consistent approach across applications and query paths

We will cover Dynamic Data Masking in more detail in a separate blog.

There’s also more in MySQL Enterprise Edition

In addition to Dynamic Data Masking, MySQL Enterprise Edition also includes audit-related enhancements in 9.7.0 LTS.

Audit and operational improvements

  • Time-based audit log rotation
    • Adds support for rotating audit logs based on elapsed time.
  • Audit log filter recovery mode
    • Helps the server recover more safely from invalid audit filter configurations at startup.

From momentum to delivery

What makes MySQL 9.7.0 LTS especially important is that it is not just a release marker. It is a release that shows visible progress in areas MySQL has been highlighting for some time:

  • earlier visibility into new functionality
  • broader access to important capabilities
  • more innovation delivered into Community Edition
  • a more open dialogue with MySQL users

That broader effort is also why the community message belongs in this post. The long-term goal is straightforward: to create a tighter feedback loop with the community and help craft the roadmap together.

Closing

With MySQL 9.7.0 LTS, MySQL establishes its next long-term support release line while delivering meaningful technical value across both editions.

For Community Edition users, this release expands access to:

  • replication and Group Replication observability
  • self-healing and election behavior
  • telemetry
  • JSON-relational application functionality
  • advanced query optimization

For Enterprise Edition users, it introduces Dynamic Data Masking and includes additional audit-related improvements, adding practical server-side controls for protecting sensitive data and managing audit operations.

And more broadly, it reflects the direction MySQL has been building toward: working more openly, delivering more visibly, and building in closer partnership with its users.

Also check out the latest MySQL HeatWave release highlights for additional new capabilities not covered in this post.

Note: As with any major MySQL release, rollout across downloads and distribution channels may take 3–4 days to complete. Not everything becomes available at the same time, so if a specific package, build, or platform download is not yet available, please check back soon.

As always, thank you for using MySQL!

Related Links