MySQL 新技术系列第一期
📢 MySQL 新技术系列开篇语 各位数据库同行、开发者朋友们，大家好！ 欢迎来到「MySQL 新技术」系列的第一期。在接下来的系列中，我将持续为大家追踪、解读 MySQL 社区的最新动态，深入剖析从核心引擎到生态工具的每一项关键技术演进，希望能为你的日常运维与架构选型提供有力参考。 作为本系列的开篇，第一期的主题是 「告别 MySQL 8.0 时代，全景解读 MySQL 9.x 创新版」。之所以以此开篇，是因为 2026 年 4 月，MySQL 8.0 正式结束生命周期（EOL），与此同时，9.7.0 LTS 正式确立为下一代长期支持版。这是一个时代的交接与新生。本文将从版本策略出发，系统梳理从 9.0 到 9.7 的全景新特性，帮助大家厘清技术脉络，把握升级方向。 一、开篇综述：MySQL 版本策略与路线图 1.1 创新版 vs 长期支持版（LTS） 在开启 9.x 系列介绍之前，有必要回顾一下 MySQL 自 2023 年启用的双轨制版本策略： 版本类型 定位 生命周期 适用场景 创新版（Innovation Release） 快速迭代，抢先体验新功能 约 3–6 个月 开发测试环境、希望尽早使用新特性的用户 长期支持版（LTS） 稳定优先，兼容性保障 标准支持至 2029 年 4 月，扩展支持至 2032 年 生产环境核心系统 简单来说，创新版是 MySQL 的「前沿试验场」，每季度左右发布一个新版本，将最新功能快速交付给社区；LTS 版则是「生产压舱石」，每两年左右从创新版分支中选取一个稳定基线，提供长达数年的长期维护。 1.2 重要里程碑时间线 时间 事件 2024 年 7 月 MySQL 9.0.0 创新版发布（后因严重 bug 撤回，由 9.0.1 替代） 2024 年 10 月 MySQL 9.1.0 创新版发布 2025 年 1 月 MySQL 9.2.0 创新版发布 2025 年 4 月 MySQL 9.3.0 创新版发布 2026 年 4 月 MySQL 8.0 正式 EOL；9.7.0 LTS GA 1.3 为什么要告别 8.0？ MySQL 8.0 于 2018 年 4 月正式 GA，至今已走过整整八个年头。作为 MySQL 历史上最成功的大版本，它带来了窗口函数、CTE、InnoDB 集群、JSON 全面增强等变革性功能。但从 2026 年 5 月 1 日起，8.0 已不再获得任何新的安全补丁和 bug 修复，继续运行意味着安全风险持续累积，尤其对于金融、电信、政务等强合规行业而言，这是一个必须严肃对待的风险信号。因此，尽早规划向 9.x LTS 的升级，是当下每个 DBA 和架构师需要提上日程的重要课题。 二、核心新特性全景概览 从 9.0 到 9.3 创新版，再到 9.7 LTS，MySQL 在多个维度实现了重大突破： 特性领域 关键创新 首发版本 🤖 AI 与向量 VECTOR 数据类型、向量检索、RAG 支持 9.0 / 8.4 📝 JavaScript 支持 MLE 多语言引擎、存储程序、LIBRARY 模块化 9.0 → 持续演进 🚀 性能与可观测性 触发器延迟加载、EXPLAIN 增强、Hypergraph Optimizer 9.1 → 9.7 🛡️ 高可用性 Primary Election 组件、自动驱逐与重加入、OpenTelemetry 集成 9.3 → 9.7 🔒 安全增强 OpenID Connect、原子 DDL、Dynamic Data Masking 9.1 → 9.7 📦 社区版扩展 […]
04-23
33
0
0
HiddenMerit Daily · Issue 59
# 📊 HiddenMerit Daily · Issue 59 > **Focus on Database Frontiers, Practical Insights for DBAs** > July 21, 2026 ｜ 5 Selected Global Breaking News ## 01｜Oracle Issues Urgent Warning: July 21 Release Update to Fix Large Number of High‑Risk Vulnerabilities, Immediate Deployment Recommended On July 13, Oracle issued an urgent security warning, strongly recommending that all customers running supported Oracle Database versions (including Oracle Database 19c and Oracle AI Database 26ai) immediately test and deploy the Release Update (RU) after its release on July 21. **Background**: New frontier AI models are significantly lowering the barrier to discovering and exploiting software vulnerabilities – these models can identify weaknesses, analyse software changes, reverse‑engineer security patches, and develop potential attack paths at unprecedented speed and scale. AI models are also becoming increasingly adept at combining multiple weaknesses across the application and data stack into complex attacks, even when individual weaknesses do not themselves pose a serious risk. As a result, protecting systems solely at the network or application layer is no longer sufficient; enterprises must protect the entire technology stack. **Fixes Included in This RU**: Oracle has collaborated with state‑of‑the‑art models from Anthropic and OpenAI to proactively identify and fix potential […]
22 hours ago
5
0
0
HiddenMerit Daily · Issue 58
# 📊 HiddenMerit Daily · Issue 58 > **Focus on Database Frontiers, Practical Insights for DBAs** > July 20, 2026 ｜ 5 Selected Global Breaking News ## 01｜CAICT: Domestic Databases Enter Core System “Deep Water,” AI‑Native Leads New Industry Landscape On July 9, at the 2026 Trustworthy Database Development Conference, CAICT released the “Database Development Research Report (2026).” The report notes that domestic databases have basically completed peripheral system replacement and have officially entered the **critical business system breakthrough phase**. **Key Data**: – The global database market reached **$131.6 billion** in 2025 (approximately RMB 894.09 billion). – The Chinese database market reached **$9.49 billion** in 2025 (approximately RMB 64.48 billion), and is expected to reach **RMB 97.974 billion** by 2028, with a CAGR of 13.06%. – The number of domestic database vendors has shrunk from a peak of 167 to 94, with a clear head‑concentration effect and an intensifying “Matthew effect.” **AI‑Native Becomes the Main Theme**: The report points out that database technology is accelerating its evolution toward the **AI‑native direction**, and the global database industry is entering a new phase of landscape restructuring. The role of databases is upgrading from “underlying support systems” to “core engines enabling intelligent decision‑making […]
1 day ago
11
0
0
HiddenMerit Daily · Issue 56
# 📊 HiddenMerit Daily · Issue 56 > **Focus on Database Frontiers, Practical Insights for DBAs** > July 6, 2026 ｜ 5 Selected Global Breaking News ## 01｜Kingware Releases Manufacturing Scenario Database Evolution White Paper: SQL Server Replacement Enters “Deep Water” On July 5, CETC Kingware published a technical article titled “Database Evolution in Manufacturing Scenarios: How Kingware Replaces SQL Server,” pointing out that the data surge on industrial shop floors has exceeded the processing capacity of single‑node systems. Traditional database architectures that rely on vertical scaling are facing unprecedented performance challenges. Over the next 1‑3 years, manufacturing enterprises will no longer face only the “choice of replacement,” but must answer the strategic question: “How do we build an autonomous data foundation in the context of de‑IOE?” **Three Paradigm Shifts**: 1. **Hybrid Workloads Become the Norm**: The IT architecture of modern factories is shifting from separated OLTP and OLAP to HTAP mode. The same data system must simultaneously handle tens of thousands of device instruction writes per second and minute‑level production report analysis. 2. **Distributed Architecture Becomes a Hard Requirement**: When a single table exceeds 100 million rows with daily increments exceeding 1 million rows, the index maintenance cost of […]
4 days ago
22
0
0
HiddenMerit Daily · Issue 57
# 📊 HiddenMerit Daily · Issue 57 > **Focus on Database Frontiers, Practical Insights for DBAs** > July 17, 2026 ｜ 5 Selected Global Breaking News ## 01｜CAICT Releases “Database Development Research Report (2026)”: China Market to Reach RMB 98 Billion by 2028, AI‑Native Becomes the Main Theme On July 9, at the 2026 Trustworthy Database Development Conference, the China Academy of Information and Communications Technology (CAICT) officially released the “Database Development Research Report (2026),” comprehensively revealing the latest landscape and evolution directions of the global and Chinese database markets. **Key Data**: – **Global Market**: The global database market reached **$131.6 billion** in 2025 (approximately RMB 894.09 billion). – **Chinese Market**: The Chinese database market reached **$9.49 billion** in 2025 (approximately RMB 64.48 billion), accounting for 7.2% of the global market. By 2028, the total Chinese database market is expected to reach **RMB 97.974 billion**, with a compound annual growth rate of **13.06%** . – **Industry Landscape**: There are 394 database product providers globally, with China and the US leading in vendor count. The number of global open‑source and closed‑source products is roughly balanced. Commercial databases account for over 70% in China, while the proportion of open‑source databases is increasing. […]
4 days ago
29
0
0