MySQL 9.7: First Major LTS Since 8.4 Brings Enterprise Features to Community Edition

2026-05-10 · Source: InfoQ · Field: Technology & Digital — Software Development & Engineering, Cloud Computing & IT Infrastructure · Depth: Intermediate, short

Summary

Oracle has released MySQL 9.7.0, initiating a new Long-Term Support (LTS) series and marking the first major LTS since MySQL 8.4. This release integrates innovations from recent development cycles, including enhanced replication observability, telemetry, and query optimization, alongside new security features like dynamic data masking and OpenID authentication. Developer-focused enhancements such as in-database JavaScript and JSON duality are also included. Notably, several capabilities previously exclusive to the Enterprise Edition, such as the Hypergraph optimizer and DML support for JSON Duality Views, are now available in the Community Edition. The release comes amidst community concerns regarding declining MySQL development activity and Oracle's commitment to the project, with Oracle aiming to foster a tighter feedback loop with the community.

Key takeaway

For CTOs and VP of Engineering evaluating database strategies, MySQL 9.7.0's inclusion of Enterprise features in the Community Edition, like the Hypergraph optimizer, offers significant performance and security upgrades without additional licensing costs. You should plan to thoroughly test the new Hypergraph optimizer's impact on your specific application queries, as its benefits may vary, and consider leveraging dynamic data masking for enhanced data protection.

Key insights

MySQL 9.7.0 LTS expands Community Edition capabilities, addressing performance and security while aiming to rebuild community trust.

Principles

• Broader access to capabilities fosters community engagement.
• Query optimizers require testing for application impact.

Method

The Hypergraph optimizer improves complex query optimization by making join order, join type, and bushy join plans first-class parts of the search, moving beyond a left-deep search framework.

In practice

• Test Hypergraph optimizer impact on existing queries.
• Utilize Dynamic Data Masking for sensitive data protection.

Topics

• MySQL 9.7 LTS
• Hypergraph Optimizer
• Dynamic Data Masking
• Community Edition Enhancements
• Database Replication

Best for: CTO, VP of Engineering/Data, Software Engineer, Data Engineer, IT Professional

Related on AIssential

• Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker — Specialized database architectures and strong data integrity are crucial for performance and correctness, especially as applications become complex.
• MySQL 9.6 Changes Foreign Key Constraints and Cascade Handling — MySQL 9.6 moves foreign key cascade handling to the SQL layer, improving data consistency for replication.
• The TechBeat: Optimizing a Fast Feature Store for Costs: ShareChat's Lessons Learned (6/21/2026) — ShareChat achieved 10x cost reduction in its 1B features/sec ML feature store through ScyllaDB, cloud tuning, protobuf, and profiling.
• VillageSQL Launches as an Extension-Focused MySQL Fork — VillageSQL extends MySQL with a robust extension framework for AI and modern data demands.
• Viaduct 1.0 and the future of Airbnb’s data mesh — Viaduct 1.0 offers a GraphQL-based data mesh for decentralized schema development via multi-tenant modules, enhancing stability and community contribution.
• 🚀 HyperspaceDB v3.0 LTS is out: We built the first Spatial AI Engine, trained the world's first Native Hyperbolic Embedding Model, and benchmarked it against the industry. — Hyperbolic embeddings offer superior semantic context and efficiency for hierarchical data compared to Euclidean vector spaces.

Open in AIssential →

Editorial summary, takeaway, and curation by AIssential. Original article published by InfoQ.