MySQL 9.7 LTS: Enterprise Power for the Community

MySQL 9.7: A New Era of Openness

The announcement of MySQL 9.7 LTS is a pivotal moment, aiming to bridge the gap between Enterprise and Community editions by democratizing advanced features. The inclusion of the Hypergraph optimizer is particularly noteworthy, promising significant performance gains for complex queries by fundamentally altering the optimization approach. This move, coupled with enhanced replication observability and security features like dynamic data masking, signals Oracle's intent to revitalize community engagement and address past concerns about development velocity. The integration of in-database JavaScript and JSON duality further expands the platform's versatility, catering to modern development paradigms. However, the success of this initiative hinges on sustained development activity and genuine community collaboration beyond this release. The specter of declining contributor numbers and recent layoffs still looms, and the community will be closely watching Oracle's long-term commitment to fostering an open and vibrant ecosystem. As Peter Zaitsev rightly cautions, thorough testing is paramount; new optimizers, while promising, can introduce regressions, and the impact on existing applications must be meticulously evaluated.

From a technical perspective, the Hypergraph optimizer's ability to consider interesting orders and bushy join plans is a substantial architectural shift from the traditional left-deep framework. This allows for more sophisticated cost-based decisions, potentially unlocking performance improvements that were previously difficult to achieve. The operational enhancements for DBAs, such as flow-control monitoring and automatic eviction of unhealthy cluster members, are crucial for maintaining stability and reliability in distributed environments. The introduction of OpenID authentication and dynamic data masking addresses growing security demands, making MySQL a more robust choice for sensitive applications. While these features are commendable, their implementation details and the ease of adoption will be critical factors in their real-world impact. The bug in the mysql-community.repo update, though seemingly minor, highlights the importance of robust release management and communication, especially when transitioning between LTS versions and potentially impacting production environments. Overall, MySQL 9.7 represents a significant step forward, but its long-term success will be defined by Oracle's continued dedication to transparency, community involvement, and consistent feature delivery.

Key Points

• MySQL 9.7 LTS general availability marks the first major LTS release since 8.4.
• Brings previously Enterprise-only features to the Community Edition, addressing feature parity concerns.
• Introduces the Hypergraph optimizer for improved complex query optimization, supporting bushy join plans.
• Enhances replication observability with flow-control monitoring and extended applier statistics.
• Adds new security features: dynamic data masking and OpenID authentication.
• Includes developer-focused enhancements like in-database JavaScript and JSON duality support.
• Aims to foster a tighter feedback loop with the community and influence the roadmap.
• Addresses community concerns about declining development activity and Oracle's commitment.

---

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