mpp 數據庫greenplum官方商業版本與開源版本的差異
greenplum是基于超大型DW或OLAP數據庫的集群型解決方案,它是基于postgresql開發的;你要是有postgresql數據庫的底子,進階greenplum自是如飛沖天。
greenplum和
mysql或者諸多的大型軟件一般,也是采用2條腳走路,一為商業版本,二為開源版本。
greenplum開源版本
其官方手冊 https://greenplum.org/documentation/
其下載介質地址 https://github.com/greenplum-db/gpdb/releases
greenplum商業版本(注:下載介質必須要付費,官方手冊可以在線或離線看)
其官方手冊 http://gpdb.docs.pivotal.io/570/main/index.html
其下載介質地址 https://network.pivotal.io/products/pivotal-gpdb/
greenplum商業版本與開源版本的差異
可在企業版的官方手冊之 pivotal greenplum 具體版本 release notes
difference compared to open source green plum database
Pivotal Greenplum 5.x includes all of the functionality in the open source Greenplum Database project and adds:
? Product packaging and installation script.
? Support for QuickLZ compression. QuickLZ compression is not provided in the open source version of
Greenplum Database due to licensing restrictions.
? Support for managing Greenplum Database using Pivotal Greenplum Command Center.
? Support for monitoring and managing queries with Pivotal Greenplum Workload Manager.
? Support for full text search and text analysis using Pivotal GPText.
? Spark Connector and Gemfire Connector
? Data Direct ODBC/JDBC Drivers
由上可見,企業版和開源版功能是差不多,不過前者,就是服務更多,功能更全。
建議在生產環境中,可以采用混用策略,即企業版和開源版并用。減少或壓縮運維及采購成本。