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

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

[BT](https://www.infoq.com/int/bt/ "bt")

InfoQ Software Architects' Newsletter

A monthly overview of things you need to know as an architect or aspiring architect.

View an example

Enter your e-mail address

Select your country - [x] I consent to InfoQ.com handling my data as explained in this Privacy Notice.

We protect your privacy.

Close

Live Webinar and Q&A: Portable by Design: Data Mobility & Recovery Patterns for Multi-Cloud Systems (May 21, 2026)Save Your Seat

Close

Toggle Navigation

Facilitating the Spread of Knowledge and Innovation in Professional Software Development

English edition

• English edition
• Chinese edition
• Japanese edition
• French edition

[Write for InfoQ](https://www.infoq.com/write-for-infoq/ "Write for InfoQ")

Search

RegisterSign in

Unlock the full InfoQ experience

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources.

Log In

or

Don't have an InfoQ account?

Register

• Stay updated on topics and peers that matter to youReceive instant alerts on the latest insights and trends.
• Quickly access free resources for continuous learningMinibooks, videos with transcripts, and training materials.
• Save articles and read at anytimeBookmark articles to read whenever youre ready.

Logo - Back to homepage

NewsArticlesPresentationsPodcastsGuides

Topics

[Development](https://www.infoq.com/development/ "Development")

• [Java](https://www.infoq.com/java/ "Java")
• [Kotlin](https://www.infoq.com/kotlin/ "Kotlin")
• [.Net](https://www.infoq.com/dotnet/ ".Net")
• [C#](https://www.infoq.com/c_sharp/ "C#")
• [Swift](https://www.infoq.com/swift/ "Swift")
• [Go](https://www.infoq.com/golang/ "Go")
• [Rust](https://www.infoq.com/rust/ "Rust")
• [JavaScript](https://www.infoq.com/javascript/ "JavaScript")

Featured in Development

• #### From VR to Flat Screens: Bridging the Input and Immersion Gap

Dany Lepage discusses the architectural journey of porting a hit VR title to seven non-VR platforms. He explains how his team solved the challenges of cross-progression, diverse input paradigms, and maintaining release velocity across Steam, iOS, and PlayStation. Beyond the tech, he shares candid lessons on the "product fit" gap when translating immersive social presence to 2D screens.


All in developmentFollow Topic

[Architecture & Design](https://www.infoq.com/architecture-design/ "Architecture & Design")

• [Architecture](https://www.infoq.com/architecture/ "Architecture")
• [Enterprise Architecture](https://www.infoq.com/enterprise-architecture/ "Enterprise Architecture")
• [Scalability/Performance](https://www.infoq.com/performance-scalability/ "Scalability/Performance")
• [Design](https://www.infoq.com/design/ "Design")
• [Case Studies](https://www.infoq.com/Case_Study/ "Case Studies")
• [Microservices](https://www.infoq.com/microservices/ "Microservices")
• [Service Mesh](https://www.infoq.com/servicemesh/ "Service Mesh")
• [Patterns](https://www.infoq.com/DesignPattern/ "Patterns")
• [Security](https://www.infoq.com/Security/ "Security")

Featured in Architecture & Design

• #### Stripe’s Docdb: How Zero-Downtime Data Movement Powers Trillion-Dollar Payment Processing

Jimmy Morzaria discusses the evolution of Stripe’s database tier to support 5 million QPS with 5.5 nines of reliability. He explains the architecture of DocDB and shares how Stripe leverages a custom zero-downtime data movement platform to perform horizontal sharding, version upgrades, and multi-tenant migrations - all while maintaining the strict consistency required for global commerce.


All in architecture-designFollow Topic

[AI Infrastructure](https://www.infoq.com/ai-ml-data-eng/ "AI Infrastructure")

• [Big Data](https://www.infoq.com/bigdata/ "Big Data")
• [Machine Learning](https://www.infoq.com/machinelearning/ "Machine Learning")
• [NoSQL](https://www.infoq.com/nosql/ "NoSQL")
• [Database](https://www.infoq.com/database/ "Database")
• [Data Analytics](https://www.infoq.com/data-analytics/ "Data Analytics")
• [Streaming](https://www.infoq.com/streaming/ "Streaming")

Featured in AI, ML & Data Engineering

• #### Leadership in AI-Assisted Engineering

Justin Reock discusses the reality of AI’s impact on engineering, moving past anecdotes to hard data from DORA and DX research. He explains the "GenAI Divide" - where 95% of pilots fail - and shares how leaders can use the SPACE and Core 4 frameworks to measure true ROI. He explains how to balance speed with quality, reduce developer fear, and apply agentic solutions across the entire SDLC.


All in ai-ml-data-engFollow Topic

[Culture & Methods](https://www.infoq.com/culture-methods/ "Culture & Methods")

• [Agile](https://www.infoq.com/agile/ "Agile")
• [Diversity](https://www.infoq.com/diversity/ "Diversity")
• [Leadership](https://www.infoq.com/leadership/ "Leadership")
• [Lean/Kanban](https://www.infoq.com/lean/ "Lean/Kanban")
• [Personal Growth](https://www.infoq.com/personal-growth/ "Personal Growth")
• [Scrum](https://www.infoq.com/scrum/ "Scrum")
• [Sociocracy](https://www.infoq.com/sociocracy/ "Sociocracy")
• [Software Craftmanship](https://www.infoq.com/software_craftsmanship/ "Software Craftmanship")
• [Team Collaboration](https://www.infoq.com/team-collaboration/ "Team Collaboration")
• [Testing](https://www.infoq.com/testing/ "Testing")
• [UX](https://www.infoq.com/ux/ "UX")

Featured in Culture & Methods

• #### The AI Joy Gap: Why Some Developers Thrive While Others Struggle

In this podcast, Shane Hastie, Lead Editor for Culture & Methods, spoke to Michael Parker, VP of Engineering at TurinTech AI, about bringing joy back to software development in the AI era, the emerging role of "factory architects" who orchestrate AI agents rather than write code directly, and the cultural divide between AI hype and the reality developers face on legacy codebases.


All in culture-methodsFollow Topic

DevOps

• [Infrastructure](https://www.infoq.com/infrastructure/ "Infrastructure")
• [Continuous Delivery](https://www.infoq.com/continuous_delivery/ "Continuous Delivery")
• [Automation](https://www.infoq.com/automation/ "Automation")
• [Containers](https://www.infoq.com/containers/ "Containers")
• [Cloud](https://www.infoq.com/cloud-computing/ "Cloud")
• [Observability](https://www.infoq.com/observability/ "Observability")

Featured in DevOps

• #### How Netflix Shapes our Fleet for Efficiency and Reliability

The speakers explain the inherent tension between service efficiency and reliability at Netflix's global scale. They share a mental model for "risk-adjusted net value," moving beyond simple CPU utilization to focus on capacity buffers. They discuss hardware shaping, proactive traffic steering, and reactive levers like "hammers" and prioritized load shedding to protect critical playback.


All in devopsFollow Topic

[Events](https://events.infoq.com/ "Events")

Helpful links

• [About InfoQ](https://www.infoq.com/about-infoq "About InfoQ")
• [InfoQ Editors](https://www.infoq.com/infoq-editors "InfoQ Editors")
• [Write for InfoQ](https://www.infoq.com/write-for-infoq "Write for InfoQ")
• [About C4Media](https://c4media.com/ "About C4Media")
• [Diversity](https://c4media.com/diversity "Diversity")

Choose your language

• [En](https://www.infoq.com/news/2026/05/mysql-97-lts/# "InfoQ English")
• 中文
• 日本
• Fr


[InfoQ Homepage](https://www.infoq.com/ "InfoQ Homepage")[News](https://www.infoq.com/news "News")MySQL 9.7: First Major LTS Since 8.4 Brings Enterprise Features to Community Edition

[AI, ML & Data Engineering](https://www.infoq.com/ai-ml-data-eng/ "AI, ML & Data Engineering")

Rethinking AppSec: Why Compiler‑Level Security Changes the Architecture Conversation (Webinar Jun 11th)

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

May 10, 2026 3 min read

by

• Renato Losio

Follow Cloud Expert | AWS Data Hero

#### Write for InfoQ

Feed your curiosity.Help 550k+ global

senior developers

each month stay ahead.Get in touch

Log in to listen to this article

Audio ready to play

Your browser does not support the audio element.

0:00 0:00

Normal 1.25x 1.5x

Like

• Reading list

Oracle has announced the general availability of MySQL 9.7.0, marking the start of a new 9.7 LTS release series and the first major one since MySQL 8.4. The release arrives amid community concerns about declining MySQL development activity and Oracle's long-term commitment to the project.

The new release consolidates innovations from the recent development cycle, including improvements in replication observability, telemetry, and query optimization. Specifically, it improves the MySQL REST Service, adds the Hypergraph optimizer, and introduces new security features, including dynamic data masking and OpenID authentication. It also adds developer-focused enhancements such as in-database JavaScript and JSON duality, along with bug fixes and security patches. Mike Frank, product management director at Oracle, writes:

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.

As previously covered on InfoQ, a MySQL repository analysis revealed declining development activity and a shrinking contributor base, and recent Oracle layoffs have further heightened community concerns.

With the 9.7 release, several capabilities previously available only in the Enterprise Edition are now available in the Community Edition. Frank adds:

The long-term goal is straightforward: to create a tighter feedback loop with the community and help craft the roadmap together.

The new LTS release comes at a time when many in the community are questioning Oracle's commitment to MySQL and its Community Edition. Oracle is working to reassure users following meetings about MySQL’s future, while new tracking forks are already underway to extend its capabilities.

MySQL 9.7.0 adds operational capabilities for DBAs and operators, including flow-control monitoring for visibility into cluster throttling, extended replication applier statistics to observe lag and throughput in multi-threaded replication, automatic eviction and rejoin of unhealthy cluster members, and primary election that favors the most up-to-date eligible node during failover.

The release also adds DML support for JSON Duality Views in MySQL Community Server, auto-increment support for JSON Duality View operations, and Hypergraph Optimizer support for improved optimization of complex queries. In a separate article, Øystein Grøvlen, senior principal software engineer at Oracle, writes:

The classic MySQL join optimizer is based on a long-standing left-deep search framework. That framework has been improved many times, but its basic shape makes some things hard (...) The hypergraph optimizer is useful because it makes several important choices first-class parts of optimization instead of afterthoughts.

_/filters:no\_upscale()/news/2026/05/mysql-97-lts/en/resources/1image-23-1777531118647.jpg)_

_Source: MySQL blog_

Among the advantages of the Hypergraph optimizer are that interesting orders are now part of the search, nested-loop join versus hash join is a real cost-based choice, and bushy join plans are supported. Peter Zaitsev, founder of Percona and open source advocate, warns:

Hypergraph optimized in MySQL 9.7 makes many queries to run faster, but as it usually goes with optimizers not all of them - make sure to test how it impacts your application do not just assume it is newer... so it must be better.

For the Enterprise Edition, the release introduces Dynamic Data Masking, which protects sensitive data at query time by applying masking policies to table columns without requiring application changes.

With the general availability, a bug in the mysql-community.repo update (MySQL Bug #120315) silently disabled the 8.4 LTS repository and enabled 9.7 LTS instead, causing routine package updates to switch the major version a server follows.

MySQL 8.4 is currently set to reach end of life in three years.

About the Author

#### Renato Losio

Renato has extensive experience as a cloud architect, tech lead, and cloud services specialist. Currently, he lives in Berlin and works remotely as a principal cloud architect. His primary areas of interest include cloud services and relational databases. He is an editor at InfoQ and a recognized AWS Data Hero. You can connect with him on LinkedIn.

Show more Show less

#### This content is in the AI, ML & Data Engineering topic

Follow Topic

##### Related Topics:

• Development### Development

Followers: 4096

Follow Topic

• DevOps### DevOps

Followers: 5067

Follow Topic

• AI, ML & Data Engineering### AI, ML & Data Engineering

Followers: 5899

Follow Topic

• MySQL### MySQL

Followers: 37

Follow Topic

• Relational Databases### Relational Databases

Followers: 72

Follow Topic

• Open Source### Open Source

Followers: 73

Follow Topic

* #### Popular in AI, ML & Data Engineering

• ##### Inside Claude Code Auto Mode: Anthropic’s Autonomous Coding System with Human Approval Gates

• ##### Cloudflare Announces Agent Memory, a Managed Persistent Memory Service for AI Agents

• ##### Vercel Releases Open Agents to Support Background AI Coding Workflows

• ##### OpenAI Introduces Websocket-Based Execution Mode to Reduce Latency in Agentic Workflows

• ##### Cloudflare Builds High-Performance Infrastructure for Running LLMs

* #### Related Sponsors

• ##### Why APIs Can’t Trust Clients—and How to Bridge the Gap

• ##### Designing Data Layers for Agentic AI: Patterns for State, Memory, and Coordination at Scale (Live Webinar May 12, 2026) - Save Your Seat

• ##### Architecting for What’s Next: Key Software Trends Every Senior Practitioner Must Act On — Download the InfoQ eMag

• ##### The Case for Real-Time Threat Monitoring and Analysis in Modern Mobile App Security

• ##### The Essential Guide to AI Tools for Jakarta EE Developers

• #### Related Sponsor

Test. Protect. Repeat. Guardsquare pairs mobile app testing and protection, delivering max security with zero performance trade-offs. [Request a Quote](https://www.infoq.com/url/f/e322e49b-fc5d-4712-9e5b-ecb7ce06f225/).

Related Content

• ##### Etsy Migrates 1000-Shard, 425 TB MySQL Sharding Architecture to Vitess

Apr 11, 2026

• ##### AWS Improves Aurora Serverless: 45% Faster Ramp-Up, 30% Higher Throughput

May 09, 2026

• ##### Vercel Releases Open Agents to Support Background AI Coding Workflows

Apr 30, 2026

• ##### Google ADK for Java 1.0 Introduces New App and Plugin Architecture, External Tools Support, and More

Apr 20, 2026

• Icon##### Empower Your Developers: How Open Source Dependencies Risk Management Can Unlock Innovation

Apr 15, 2026 

• Icon##### Powering Enterprise AI Applications with Data and Open Source Software

Dec 15, 2025 

• ##### Fonttrio Launches as Open-Source Font Pairing Registry for shadcn/ui

May 09, 2026

• ##### Cloudflare Ships Dynamic Workflows, Bringing Durable Execution to Per-Tenant and Per-Agent Code

May 09, 2026

• ##### How GitHub Is Securing Agentic Workflows in Modern CI CD Systems

May 08, 2026

Related Sponsors

• #### The Rise of Client-Side Risk and the Trust Gap

A global survey by TrendCandy reveals why traditional OS-level defenses fail against rising mobile app threats. Learn how client-side risk, API abuse, AI-generated code, and fast release cycles drive vulnerabilities—and how layered security and app attestation restore trust.

• #### Rethinking AppSec: Why Compiler‑Level Security Changes the Architecture Conversation (Live Webinar Jun 11th) - Save Your Seat

Security bolted on after the build process adds fragility and blind spots. Embedding protection at compile time improves performance and resilience. This session compares wrapper, runtime, and compiler approaches to help you choose where security belongs in your SDLC.

• Sponsored by


Related Content

• Icon##### Leadership in AI-Assisted Engineering

May 08, 2026 

• ##### Cloudflare Launches “Artifacts” Beta, Introducing Git-Like Versioning for AI Agents

May 08, 2026

• ##### Implementing the Sidecar Pattern in Microservices-based ASP.NET Core Applications

May 08, 2026 

• ##### OpenAI Introduces Websocket-Based Execution Mode to Reduce Latency in Agentic Workflows

May 07, 2026

• Icon##### Engineering at AI Speed: Lessons from the First Agentically Accelerated Software Project

May 07, 2026 

• ##### Applying Best Simple System for Now for Software Design

May 07, 2026

**The InfoQ** Newsletter

A round-up of last week’s content on InfoQ sent out every Tuesday. Join a community of over 250,000 senior developers. View an example

Enter your e-mail address

Select your country - [x] I consent to InfoQ.com handling my data as explained in this Privacy Notice.

We protect your privacy.

• Development

• ##### [Attacker Bought 30 WordPress Plugins on Flippa and Backdoored All of Them](https://www.infoq.com/news/2026/05/wordpress-plugins-supply-chain/ "Attacker Bought 30 WordPress Plugins on Flippa and Backdoored All of Them")

• ##### [Cloudflare Introduces Flagship: an Edge-Native Feature Flag Service Built on OpenFeature](https://www.infoq.com/news/2026/05/cloudflare-flagship-openfeature/ "Cloudflare Introduces Flagship: an Edge-Native Feature Flag Service Built on OpenFeature")

• ##### [QCon San Francisco 2026: 12 Tracks Announced](https://www.infoq.com/news/2026/04/qconsf-2026-tracks-announced/ "QCon San Francisco 2026: 12 Tracks Announced")

• Architecture & Design

• ##### [How GitHub Is Securing Agentic Workflows in Modern CI CD Systems](https://www.infoq.com/news/2026/05/github-agentic-workflows/ "How GitHub Is Securing Agentic Workflows in Modern CI CD Systems")

• ##### [OpenAI Introduces Websocket-Based Execution Mode to Reduce Latency in Agentic Workflows](https://www.infoq.com/news/2026/05/openai-websocket-responses-api/ "OpenAI Introduces Websocket-Based Execution Mode to Reduce Latency in Agentic Workflows")

• ##### [LinkedIn Consolidates Hiring Data Pipelines to Power AI Driven Talent Systems](https://www.infoq.com/news/2026/05/linkedin-unified-hiring-platform/ "LinkedIn Consolidates Hiring Data Pipelines to Power AI Driven Talent Systems")

• Culture & Methods

• ##### [The AI Joy Gap: Why Some Developers Thrive While Others Struggle](https://www.infoq.com/podcasts/some-developers-thrive-while-others-struggle/ "The AI Joy Gap: Why Some Developers Thrive While Others Struggle")

• ##### [Applying Best Simple System for Now for Software Design](https://www.infoq.com/news/2026/05/best-simple-system-design/ "Applying Best Simple System for Now for Software Design")

• ##### [The Human Scalability Problem: Why Your Teams Don’t Scale Like Your Code](https://www.infoq.com/presentations/human-scalability/ "The Human Scalability Problem: Why Your Teams Don’t Scale Like Your Code")

• AI, ML & Data Engineering

• ##### [MySQL 9.7: First Major LTS Since 8.4 Brings Enterprise Features to Community Edition](https://www.infoq.com/news/2026/05/mysql-97-lts/ "MySQL 9.7: First Major LTS Since 8.4 Brings Enterprise Features to Community Edition")

• ##### [Leadership in AI-Assisted Engineering](https://www.infoq.com/presentations/ai-assisted-engineering/ "Leadership in AI-Assisted Engineering")

• ##### [Engineering at AI Speed: Lessons from the First Agentically Accelerated Software Project](https://www.infoq.com/presentations/engineering-ai/ "Engineering at AI Speed: Lessons from the First Agentically Accelerated Software Project")

• DevOps

• ##### [Cloudflare Launches “Artifacts” Beta, Introducing Git-Like Versioning for AI Agents](https://www.infoq.com/news/2026/05/cloudflare-artifacts-ai-agents/ "Cloudflare Launches “Artifacts” Beta, Introducing Git-Like Versioning for AI Agents")

• ##### [Leading Open Source Author Calls for Verification over Trust in Software Supply Chains](https://www.infoq.com/news/2026/05/stenberg-curl-verification-trust/ "Leading Open Source Author Calls for Verification over Trust in Software Supply Chains")

• ##### [Grafana's Kubernetes Monitoring Helm Chart v4 Brings Multiple Fixes](https://www.infoq.com/news/2026/05/kubernetes-monitoring-helm/ "Grafana's Kubernetes Monitoring Helm Chart v4 Brings Multiple Fixes")

**The InfoQ** Newsletter

A round-up of last week’s content on InfoQ sent out every Tuesday. Join a community of over 250,000 senior developers. View an example

• Get a quick overview of content published on a variety of innovator and early adopter technologies
• Learn what you don’t know that you don’t know
• Stay up to date with the latest information from the topics you are interested in

Enter your e-mail address

Select your country - [x] I consent to InfoQ.com handling my data as explained in this Privacy Notice.

We protect your privacy.

**ONLINE INFOQ CERTIFICATION PROGRAM** A Cohort for Senior Engineers and Architects * **Focused on ARCHITECTURE** with Luca Mezzalira | JUNE 10 * **Focused on AI ENGINEERING** with Hien Luu | JULY 25 Bring a real architecture or AI engineering challenge from your work. Spend 5 weeks pressure-testing your approach with senior peers from other companies and experienced facilitators. Explore the upcoming cohorts. **Register Now.**

#### Events

• ##### QCon AI Boston

June 1-2, 2026

• ##### Online InfoQ Architect Certification

June 10, 2026

• ##### Online InfoQ AI Engineering Certification

July 25, 2026

• ##### QCon San Francisco

November 16-20, 2026

#### Follow us on

Youtube 232K FollowersLinkedin 26K FollowersInstagram NewRSS 19K ReadersX 57.1k FollowersFacebook 21K LikesBluesky New

#### Stay in the know

The InfoQ PodcastEngineering Culture PodcastThe Software Architects' Newsletter

General Feedback [[email protected]](mailto:[email protected]) Advertising [[email protected]](mailto:[email protected]) Editorial [[email protected]](mailto:[email protected]) Marketing [[email protected]](mailto:[email protected])

InfoQ.com and all content copyright © 2006-2026 C4Media Inc.

Privacy Notice, Terms And Conditions, Cookie Policy

Close

[BT](https://www.infoq.com/int/bt/ "bt")