MySQL5.6 5.7 8.0 产品生命周期及分支MariaDB 生命周期停止服务更新时间 独家大全摘自官方

经常会被问到MySQL各个版本的生命周期,以及如何选择MySQL版本的问题。今天在这里主要向各位介绍一下MySQL产品的生命周期。

MySQL被Oracle收购之后,在产品的开发上面变得比之前更加规范,并且参照了Oracle其它产品的开发模式,产品会遵循事先制定的生命周期去开发维护。事先制定好的生命周期,对于用户来说是非常有利的事情,用户可以参照数据库产品的生命周期,根据项目情况,选择适合自己的产品版本。

 

官方最新表格

MariaDB general release maintenance periods

Rolling release
ReleaseStable (GA) Date
11.5In development
Currently maintained long-term releases
Release seriesStable (GA) DateEnd-of-life
11.429 May 202429 May 2029
10.1116 Feb 202316 Feb 2028
10.66 Jul 20216 Jul 2026
10.524 Jun 202024 Jun 2025
10.418 Jun 201918 Jun 2024
Currently maintained short-term releases
Release seriesStable (GA) DateEnd-of-life
11.221 Nov 202321 Nov 2024
11.121 Aug 202321 Aug 2024
11.06 Jun 20236 Jun 2024
Unmaintained releases
Release seriesStable (GA) DateEnd-of-life
11.316 Feb 2024Rolling
10.1017 Nov 202217 Nov 2023
10.922 Aug 202222 Aug 2023
10.820 May 202220 May 2023
10.79 Feb 20229 Feb 2023
10.325 May 201825 May 2023
10.223 May 201723 May 2022
10.117 Oct 201517 Oct 2020
10.031 Mar 201431 Mar 2019
5.511 Apr 201211 Apr 2020
5.329 Feb 20121 Mar 2017
5.210 Nov 201010 Nov 2015
5.11 Feb 20101 Feb 2015

These dates constitute the public policy of the MariaDB Foundation and are not legally binding. The software is released with the GPL license as-is, without warranties.

 

 

oracle MySQL版本和MariaDB版本对应表:

MariaDB版本 MySQL版本

MariaDB 10.3 发布时间2018 MySQL 8.0 发布时间2018

MariaDB 10.2 发布时间2017 MySQL 5.7 发布时间2015

MariaDB 10.1 发布时间2015 MySQL 5.6 发布时间2013

MariaDB 10.0 发布时间2014 MySQL 5.5 发布时间2010

MariaDB 5.5 发布时间2012 MySQL 5.1 发布时间2008

MySQL 5.0 发布时间2005

让我们先看一下MySQL产品的生命周期是怎样定义的。

https://www.mysql.com/cn/support/


产品的生命周期分为三个支持阶段,标准支持服务、延伸支持服务和持续支持服务,对应这三个阶段的时间分别是产品从GA(正式发布)开始1-5年、6-8年及9年以上。对应不同阶段,所提供的服务已经显示在上面这个表里。乍一看标准支持和延伸支持服务没有区别,事实上区别还是有一些的,主要在于,进入延伸支持阶段后,产品不会像之前那样频繁的进行版本维护和发布补丁,原则上只会发布安全补丁。对于MySQL社区版的用户来说,非常关心社区版的MySQL是否和商业版的MySQL同样提供版本维护和补丁。这一点请大家可以放心,从Oracle接手MySQL到目前为止,社区版和商业版的补丁一直是同步发行的。

MariaDB是mysql完美替代者 相关文章推荐

MariaDB与MySQL的版本对照表/版本对应关系

推荐先看此文 MySQL与MariaDB性能比拼,哪个更出色?

MariaDB general release maintenance periods

Major and Minor VersionStable (GA) DateEnd-of-life
5.11 Feb 20101 Feb 2015
5.210 Nov 201010 Nov 2015
5.329 Feb 20121 Mar 2017
5.511 Apr 201211 Apr 2020
10.031 Mar 201431 Mar 2019
10.117 Oct 201517 Oct 2020
10.223 May 201723 May 2022
10.325 May 201825 May 2023
10.418 Jun 201918 Jun 2024
10.524 Jun 202024 Jun 2025
10.66 Jul 20216 Jul 2026
10.79 Feb 20229 Feb 2023
10.820 May 202220 May 2023
10.922 Aug 202222 Aug 2023
10.10TBCTBC

These dates constitute the public policy of the MariaDB Foundation and are not legally binding. The software is released with the GPL license as-is, without warranties.

Currently maintained long-term releases
Release seriesStable (GA) DateEnd-of-life
10.325 May 201825 May 2023
10.418 Jun 201918 Jun 2024
10.524 Jun 202024 Jun 2025
10.66 Jul 20216 Jul 2026
10.1116 Feb 202316 Feb 2028

最新表格

10.6- 2026.07

10.11 2028.02

来自官网 https://mariadb.org/about/#maintenance-policy

Currently maintained short-term releases
Release seriesStable (GA) DateEnd-of-life
11.1In development1 year after GA
11.0In development1 year after GA
10.1017 Nov 202217 Nov 2023
10.922 Aug 202222 Aug 2023
10.820 May 202220 May 2023

 

从上表我们可以清除看出  现在最佳版本是10.5 或者 10.6

不要安装10.7以后 因为支持时间短 兼容性一般 安装文件大 个人意见

 

接下来,大家可以参考下图记录MYSQL的各个版本的发布时间,来确认各个版本的最终补丁日期:


从上图可以看出,今年的10月份,5.7版本会停止标准支持阶段,进入延伸阶段,2023年10月以后,停止发布补丁。迫在眉睫的是5.6版本,明年2月以后,不会再提供任何补丁了,还在使用MySQL5.6版本的小伙伴,你的MySQL该升级了!

 

Additional milestones in MySQL development included:

First internal release on 23 May 1995
Version 3.19: End of 1996, from www.tcx.se
Version 3.20: January 1997
Windows version was released on 8 January 1998 for Windows 95 and NT
Version 3.21: production release 1998, from www.mysql.com
Version 3.22: alpha, beta from 1998
Version 3.23: beta from June 2000, production release 22 January 2001[24]
Version 4.0: beta from August 2002, production release March 2003 (unions).
Version 4.1: beta from June 2004, production release October 2004 (R-trees and B-trees, subqueries, prepared statements).
Version 5.0: beta from March 2005, production release October 2005 (cursors, stored procedures, triggers, views, XA transactions).
The developer of the Federated Storage Engine states that "The Federated Storage Engine is a proof-of-concept storage engine",[25] but the main distributions of MySQL version 5.0 included it and turned it on by default. Documentation of some of the short-comings appears in "MySQL Federated Tables: The Missing Manual".[26]
Sun Microsystems acquired MySQL AB in 2008.[27]
Version 5.1: production release 27 November 2008 (event scheduler, partitioning, plugin API, row-based replication, server log tables)
Version 5.1 contained 20 known crashing and wrong result bugs in addition to the 35 present in version 5.0 (almost all fixed as of release 5.1.51).[28]
MySQL 5.1 and 6.0-alpha showed poor performance when used for data warehousing – partly due to its inability to utilize multiple CPU cores for processing a single query.[29]
Oracle acquired Sun Microsystems on 27 January 2010.[30][31][32]
The day Oracle announced the purchase of Sun, Michael "Monty" Widenius forked MySQL, launching MariaDB, and took a swath of MySQL developers with him.[33]

Geir Høydalsvik, current Senior Software Development Director for MySQL at Oracle in 2018
MySQL Server 5.5 was generally available (as of December 2010). Enhancements and features include:
The default storage engine is InnoDB, which supports transactions and referential integrity constraints.
Improved InnoDB I/O subsystem[34]
Improved SMP support[35]
Semisynchronous replication.
SIGNAL and RESIGNAL statement in compliance with the SQL standard.
Support for supplementary Unicode character sets utf16, utf32, and utf8mb4.[a]
New options for user-defined partitioning.
MySQL Server 6.0.11-alpha was announced[36] on 22 May 2009 as the last release of the 6.0 line. Future MySQL Server development uses a New Release Model. Features developed for 6.0 are being incorporated into future releases.
The general availability of MySQL 5.6 was announced in February 2013.[37] New features included performance improvements to the query optimizer, higher transactional throughput in InnoDB, new NoSQL-style memcached APIs, improvements to partitioning for querying and managing very large tables, TIMESTAMP column type that correctly stores milliseconds, improvements to replication, and better performance monitoring by expanding the data available through the PERFORMANCE_SCHEMA.[38] The InnoDB storage engine also included support for full-text search and improved group commit performance.
The general availability of MySQL 5.7 was announced in October 2015.[39] As of MySQL 5.7.8, August 2015,[40] MySQL supports a native JSON data type defined by RFC 7159.[41]
MySQL Server 8.0 was announced in April 2018,[42] including NoSQL Document Store, atomic and crash safe DDL sentences and JSON Extended syntax, new functions, such as JSON table functions, improved sorting, and partial updates. Previous MySQL Server 8.0.0-dmr (Milestone Release) was announced 12 September 2016.[43]
MySQL was declared DBMS of the year 2019 from the DB-Engines ranking[44]

声明:本站所有文章,如无特殊说明或标注,均为本站原创发布。任何个人或组织,在未征得本站同意时,禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益,可联系我们进行处理。