MySQL的发行版本主要有oracle MySQL、Percona server for MySQL、MariaDB三个版本,
其中Percona的版本命名和MySQL官方的版本命名一致。
oracle MySQL版本和MariaDB版本对应表:
MariaDB版本 MySQL版本
MariaDB 10.3 MySQL 8.0
MariaDB 10.2 MySQL 5.7
MariaDB 10.1 MySQL 5.6
MariaDB 10.0 MySQL 5.5
MariaDB 5.5 MySQL 5.5
software GA_DATE Premier_end_date End_of_Life_Date
MySQL 8.0 20180419 20230419 20260419
MySQL 5.7 20151021 20201021 20231021
MySQL 5.6 20130205 20180205 20210205
MySQL 5.5 20101203 20151203 20181203
MySQL 5.1 20081114 201312 20131231
MySQL 5.0 200510 201112 20120209
Percona 5.7 20160203 20201001 20231001
Percona 5.6 20131007 20180201 20210201
Percona 5.5 20180428 20171231 20181201
Percona 5.1 20081216 20160223
MariaDB 10.3 20180525 20230525
MariaDB 10.2 20170523 20220523
MariaDB 10.1 20151017 20201017
MariaDB 10.0 20140331 20190331
MariaDB 5.5 20120411 20200411
截止2018年9月 基本只需要关注MySQL 5.6 、5.7和8.0版本;
Percona关注的版本等同于MySQL;
MariaDB关注最新的三个发行版本即可。
各个MySQL发行版本官方提供5年的支持期限,MySQL和Percona还提供额外的3年补丁更新期限,
总计提供8年的服务支持。
结论:
参考:
ReleaseNote:
https://mariadb.com/kb/en/library/library-mariadb-releases/
https://www.percona.com/doc/percona-server/5.7/genindex.html
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/
https://www.percona.com/services/policies/percona-software-platform-lifecycle
https://www.mysql.com/support/supportedplatforms/database.html
http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf
https://mariadb.org/about/maintenance-policy/
https://www.mysql.com/support/eol-notice.html
版本差异:
https://www.percona.com/software/mysql-database/percona-server/feature-comparison