Mysql各版本说明和对比

关注公众号 `N学无止界` 获取更多

Mysql 各版本说明

(2017-11-29 )

1.  Mysql介绍

官方网站: MySQL

对应连接 :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 product-metric	USD 2,000 Buy Now	USD 5,000 Buy Now	USD 10,000 Buy Now
Oracle Premier Support3
24x7 Support	√	√	√
Unlimited Support Incidents	√	√	√
Knowledge Base	√	√	√
Maintenance Releases	√	√	√
MySQL Consultative Support	√	√	√
MySQL Features
MySQL Database Server	√	√	√
MySQL Connectors	√	√	√
MySQL Replication	√	√	√
MySQL Router		√	√
MySQL Partitioning		√	√
MySQL Workbench1	√	√	√
Storage Engine: MyISAM	√	√	√
Storage Engine: InnoDB	√	√	√
Storage Engine: NDB			√
Oracle Enterprise Manager for MySQL1		√	√
MySQL Enterprise Monitor1		√	√
MySQL Enterprise Dashboard1		√	√
MySQL Enterprise Advisors1		√	√
MySQL Query Analyzer1		√	√
MySQL Replication Monitor1		√	√
MySQL Enterprise Backup1		√	√
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		√	√
MySQL Enterprise Authentication1		√	√
MySQL Enterprise TDE1		√	√
MySQL Enterprise Encryption1		√	√
MySQL Enterprise Firewall1		√	√
MySQL Enterprise Audit1		√	√
MySQL Enterprise Scalability1		√	√
Thread Pool1		√	√
MySQL Enterprise High-Availability1		√	√
MySQL Group Replication		√	√
MySQL InnoDB Cluster		√	√
MySQL Cluster Manager1			√
Configuration & Provisioning1			√
Automatic Scaling1			√
Management & Monitoring1			√
MySQL Cluster Geo-Replication			√
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		√	√
Complete List of Supported Platforms »

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
Yum Repo APT Repo SUSE Repo	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/

社区版和商业版区别