Mysql各版本说明和对比
Mysql 各版本说明
(2017-11-29 )
1. Mysql介绍
官方网站: https://www.mysql.com/
对应连接 :Topics:Cloud,MySQL Enterprise Edition
对应连接 : Title : MySQL Enterprise High Availability
对应连接 : Title :MySQL Enterprise Monitor
总结:
通过 banner可以知道,Mysql最强大的,最新,技术支持度最高的版本直接指向MySQL Enterprise Edition .
2. Mysql各版本
2.1 商业版对比
|
|
MySQL Standard Edition |
MySQL Enterprise Edition |
MySQL Cluster CGE |
|
Annual Subscription2,3,4,5 |
USD 2,000 |
USD 5,000 |
USD 10,000 |
|
24x7 Support |
√ |
√ |
√ |
|
Unlimited Support Incidents |
√ |
√ |
√ |
|
Knowledge Base |
√ |
√ |
√ |
|
Maintenance Releases |
√ |
√ |
√ |
|
√ |
√ |
√ |
|
|
MySQL Features |
|||
|
√ |
√ |
√ |
|
|
√ |
√ |
√ |
|
|
√ |
√ |
√ |
|
|
|
√ |
√ |
|
|
|
√ |
√ |
|
|
√ |
√ |
√ |
|
|
Storage Engine: MyISAM |
√ |
√ |
√ |
|
Storage Engine: InnoDB |
√ |
√ |
√ |
|
Storage Engine: NDB |
|
|
√ |
|
|
√ |
√ |
|
|
|
√ |
√ |
|
|
MySQL Enterprise Dashboard1 |
|
√ |
√ |
|
MySQL Enterprise Advisors1 |
|
√ |
√ |
|
MySQL Query Analyzer1 |
|
√ |
√ |
|
MySQL Replication Monitor1 |
|
√ |
√ |
|
|
√ |
√ |
|
|
Hot backup for InnoDB1 |
|
√ |
√ |
|
Full, Incremental, Partial, Optimistic Backups1 |
|
√ |
√ |
|
Full, Partial, Selective, Hot Selective restore1 |
|
√ |
√ |
|
Encryption and Compression1 |
|
√ |
√ |
|
Point-In-Time-Recovery1 |
|
√ |
√ |
|
MySQL Enterprise Security1 |
|
√ |
√ |
|
|
√ |
√ |
|
|
|
√ |
√ |
|
|
|
√ |
√ |
|
|
|
√ |
√ |
|
|
|
√ |
√ |
|
|
|
√ |
√ |
|
|
Thread Pool1 |
|
√ |
√ |
|
|
√ |
√ |
|
|
MySQL Group Replication |
|
√ |
√ |
|
MySQL InnoDB Cluster |
|
√ |
√ |
|
|
|
√ |
|
|
Configuration & Provisioning1 |
|
|
√ |
|
Automatic Scaling1 |
|
|
√ |
|
Management & Monitoring1 |
|
|
√ |
|
|
|
√ |
|
|
Oracle Product Certifications6 |
|||
|
Certified with Oracle Linux6 |
√ |
√ |
√ |
|
Certified with Oracle VM6 |
√ |
√ |
√ |
|
Certified with Oracle Solaris6 |
√ |
√ |
√ |
|
Certified with Oracle Clusterware6 |
|
√ |
√ |
|
Certified with Oracle Solaris Cluster6 |
|
√ |
√ |
|
Certified with Oracle Enterprise Manager6 |
|
√ |
√ |
|
Certified with Oracle GoldenGate6 |
|
√ |
√ |
|
Certified with Oracle Data Integrator6 |
|
√ |
√ |
|
Certified with Oracle Fusion Middleware6 |
|
√ |
√ |
|
Certified with Oracle Secure Backup6 |
|
√ |
√ |
|
Certified with Oracle Audit Vault and Database Firewall6 |
|
√ |
√ |
|
Certified with Oracle OpenStack for Oracle Linux6 |
|
√ |
√ |
|
Certified with Oracle OpenStack for Oracle Solaris6 |
|
√ |
√ |
1 Features onlyavailable in Commercial Editions.
2 Commercial License for perpetual use
3 Oracle Premier Supportfor MySQL is available separately (extra cost)
4 Server: is defined as the computer on which the programsare installed. A Server license allows you to use the licensed program on asingle specified computer.
5 Socket: is defined as a slot that houses a chip (or a multi-chipmodule), which contains a collection of one or more cores. Regardless of thenumber of cores, each chip (or multi-chip module) counts as a single socket.All occupied sockets on which the Oracle programs is installed and/or runningmust be licensed.
6 Non-MySQL products not included (can be purchasedseparately)
7 For pricing (all 4 MySQL Editions), ISVs, OEMs and VARsshould contact the MySQL Embedded SalesTeam
Foreducational purposes only. Subject to change without notice.
2.2 商业版收费标准
下面是每年预估的收费范围
2.3 支持平台
|
|
5.7 |
5.6 |
5.5 |
5.1 |
5.0 |
|
|
Operating System |
Architecture |
|
|
|
|
|
|
Oracle Linux |
||||||
|
Oracle Linux 7 |
x86_64 |
• |
• |
• |
|
|
|
Oracle Linux 6 |
x86_32, x86_64 |
• |
• |
• |
|
|
|
Oracle Linux 5 (EOL Notice ») |
x86_32, x86_64 |
• |
• |
• |
• |
• |
|
Oracle Linux 4 (EOL Notice ») |
x86_32, x86_64, Intel IA64 |
|
|
• |
• |
• |
|
Oracle Solaris |
||||||
|
Solaris 11 (Update 3+) |
SPARC_64, x86_64 |
• |
• |
• |
|
|
|
Solaris 10 (Update 11+) |
SPARC_64, x86_32, x86_64 |
|
• |
• |
• |
• |
|
Solaris 10 |
SPARC_32 |
|
|
|
• |
• |
|
Solaris 9 (EOL Notice ») |
SPARC_32, SPARC_64, x86_32, x86_64 |
|
|
|
• |
• |
|
Solaris 8 (EOL Notice ») |
SPARC_32, SPARC_64, x86_32, x86_64 |
|
|
|
• |
• |
|
Red Hat |
||||||
|
Red Hat Enterprise Linux 7 / CentOS 7 |
x86_64 |
• |
• |
• |
|
|
|
Red Hat Enterprise Linux 6 / CentOS 6 |
x86_32, x86_64 |
• |
• |
• |
|
|
|
Red Hat Enterprise Linux 5 / CentOS 5 (EOL Notice ») |
x86_32, x86_64 |
• |
• |
• |
• |
• |
|
Red Hat Enterprise Linux 4 (EOL Notice ») |
x86_32, x86_64, Intel IA64 |
|
|
• |
• |
• |
|
Red Hat Enterprise Linux 3 (EOL Notice ») |
x86_32, x86_64, Intel IA64 |
|
|
|
• |
• |
|
Canonical |
||||||
|
Ubuntu 16.04 LTS |
x86_32, x86_64 |
• |
|
|
|
|
|
Ubuntu 14.04 LTS |
x86_32, x86_64 |
• |
• |
• |
|
|
|
Ubuntu 12.04 LTS (EOL Notice ») |
x86_32, x86_64 |
• |
• |
• |
|
|
|
SUSE |
||||||
|
SUSE Enterprise Linux 12 |
x86_64 |
• |
• |
|
|
|
|
SUSE Enterprise Linux 11 (11.4+) |
x86_32, x86_64 |
• |
• |
• |
• |
|
|
SUSE Enterprise Linux 10 (EOL Notice ») |
x86_32, x86_64, Intel IA64 |
|
|
• |
• |
• |
|
SUSE Enterprise Linux 9 (EOL Notice ») |
x86_32, x86_64, Intel IA64 |
|
|
|
• |
• |
|
Debian |
||||||
|
Debian GNU/Linux 9 |
x86_32, x86_64 |
• |
• |
|
|
|
|
Debian GNU/Linux 8 |
x86_32, x86_64 |
• |
• |
|
|
|
|
Debian GNU/Linux 7 |
x86_32, x86_64 |
• |
• |
|
|
|
|
Debian GNU/Linux 6 (EOL Notice ») |
x86_32, x86_64 |
|
• |
• |
• |
|
|
Debian GNU/Linux 5 (EOL Notice ») |
x86_32, x86_64 |
|
|
• |
• |
|
|
Debian GNU/Linux 4 (EOL Notice ») |
x86_32, x86_64 |
|
|
|
• |
• |
|
Microsoft |
||||||
|
Microsoft Windows 2016 Server |
x86_64 |
• |
• |
|
|
|
|
Microsoft Windows 10 |
x86_32, x86_64 |
• |
|
|
|
|
|
Microsoft Windows 8 |
x86_32, x86_64 |
• |
• |
• |
|
|
|
Microsoft Windows 2012 Server R2 |
x86_64 |
• |
• |
• |
|
|
|
Microsoft Windows 7 (EOL Notice ») |
x86_32, x86_64 |
• |
• |
• |
• |
|
|
Microsoft Windows 2008 Server R2 (EOL Notice ») |
x86_64 |
• |
• |
• |
• |
|
|
Microsoft Windows Vista (EOL Notice ») |
x86_32, x86_64 |
|
• |
• |
• |
• |
|
Microsoft Windows 2003 Server (EOL Notice ») |
x86_32, x86_64 |
|
|
• |
• |
• |
|
Microsoft Windows XP (EOL Notice ») |
x86_32, x86_64 |
|
|
• |
• |
• |
|
IBM |
||||||
|
IBM AIX 5.3 (EOL Notice ») |
IBM Power5_64 |
|
|
|
• |
• |
|
Apple |
||||||
|
Apple macOS 10.12 |
x86_64 |
• |
• |
|
|
|
|
Apple OS X v10.11 |
x86_64 |
• |
• |
|
|
|
|
Apple OS X v10.10 (EOL Notice ») |
x86_64 |
• |
• |
|
|
|
|
Apple OS X v10.9 (EOL Notice ») |
x86_64 |
• |
• |
|
|
|
|
Apple OS X v10.8 (EOL Notice ») |
x86_64 |
|
• |
|
|
|
|
Apple Mac OS X v10.7 (EOL Notice ») |
x86_64 |
|
• |
|
|
|
|
Apple Mac OS X v10.6 (EOL Notice ») |
x86_32, x86_64 |
|
• |
• |
• |
|
|
Apple Mac OS X v10.5 (EOL Notice ») |
x86_32, x86_64 |
|
|
• |
• |
|
|
FreeBSD |
||||||
|
FreeBSD 11 |
x86_64 |
• |
• |
|
|
|
|
FreeBSD 10 (EOL Notice ») |
x86_64 |
• |
• |
|
|
|
|
FreeBSD 9 (EOL Notice ») |
x86_32, x86_64 |
|
• |
|
|
|
|
FreeBSD 8 (EOL Notice ») |
x86_32, x86_64 |
|
|
• |
|
|
|
FreeBSD 7 (EOL Notice ») |
x86_32, x86_64 |
|
|
• |
• |
|
|
FreeBSD 6 (EOL Notice ») |
x86_32, x86_64 |
|
|
|
• |
• |
|
Various Linux |
||||||
|
x86_32, x86_64, glibc 2.12, libstdc++ 4.4, gcc |
• |
• |
|
|
|
|
|
x86_64, dynamic glibc-2.3, icc |
|
|
|
• |
• |
|
|
x86_32, dynamic glibc-2.3 |
|
|
• |
• |
• |
|
|
IA64, glibc-2.3, dynamic, gcc |
|
|
• |
• |
|
|
|
HP-UX (EOL Notice ») |
||||||
|
HP-UX 11.31 (11i v3) |
Intel IA64 |
|
|
|
• |
• |
|
HP-UX 11.23 (11i v2) |
Intel IA64 |
|
|
|
• |
• |
|
HP-UX 11.23 (11i v1) |
PA-RISC 2.0, 64-bit; PA-RISC 1.1 and 2.0 |
|
|
|
• |
• |
2.4 社区版支持功能
参考: https://www.mysql.com/products/community/