。 话说当年 Greenplum（当时还是一个 Startup 公司，创始人家门口有 一棵青梅 ——greenplum，因此而得名）召集了十几位业界大咖（据 说来自 google、yahoo、ibm 和 TD），说干就干，花了一年多的时间 完成最初的版本设计和开发，用软件实现了在开放 X86 平台上的分布 式并行计算，不依赖于任何专有硬件，达到的性能却远远超过传统高 昂的专有系统。 Big Date2 （分享一下开源的直接好处，最近我们某用户的一个特殊需求，加载 数据中有回车等特殊字符，我们下载了 GP 外部表 gpfdist 源代码，不 到一天就轻松搞定问题） Greenplum 也正在积极的拥抱云计算，Cloud Foundry 的 PaaS 云平 台正在技术考虑把 Greenplum MPP 做为 DaaS 服务来提供，对于 Mesos 或其它云计算技术的爱好者，也可以考虑采用容器镜像技术 + 集群资源框架管理技术来部署 indd 21 16-11-22 下午3:38 22 2. 开放性 在短短的两年半时间里，该客户已经选择了多个厂商的 PC 服务器用 于部署 Greenplum，包括 DELL、HP、IBM 等等，且在单个集群混合 了不同厂商不同型号的服务器。Greenplum 数据库在这些硬件上的表 现都很稳定。 开放性的特性给客户带来的好处，不只是硬件厂商和型号的选择范围， 也包含工程实施过程的便利性。2014

using in-memory database computation 10 不同存储介质的访问时间 图片来源：Systems Performance: Enterprise and the Cloud，中译本《性能之巅》， 作者Brendan Gregg 11 缓冲区Buffer Pool page … Buffer Pool Manager (Main Memory) Access 采用WAL协议的恢复算法: Dr. C. Mohan ARIES: Algorithms for Recovery and Isolation Exploiting Semantics, 1993, IBM DB2 19 ● Steal + No-force ● redo log，没有undo log，事务回滚不需要做undo操作 • PG采用的是MVCC，更新操作不是in-place

Playbook 0 Ansible Playbook - Greenplum Database Installation for CentOS 7 305 Greenplum Database Cloud Technical Recommendations 308 Operating System 308 Storage 308 Security 308 Amazon Web Services driver for Cognos Analytics V11. Connecting to IBM Cognos software with an ODBC driver is not supported. Greenplum Database supports connecting to IBM Cognos software with the DataDirect JDBC driver includes improvements to error handling and error surfacing. PXF bundles newer guava and Google Cloud Storage hadoop2 libraries. The PXF pxf-log4j.properties template file updates a log filter and changes

Playbook 0 Ansible Playbook - Greenplum Database Installation for CentOS 7 315 Greenplum Database Cloud Technical Recommendations 317 Operating System 317 Storage 317 Security 317 Amazon Web Services driver for Cognos Analytics V11. Connecting to IBM Cognos software with an ODBC driver is not supported. Greenplum Database supports connecting to IBM Cognos software with the DataDirect JDBC driver includes improvements to error handling and error surfacing. PXF bundles newer guava and Google Cloud Storage hadoop2 libraries. The PXF pxf-log4j.properties template file updates a log filter and changes

Playbook 0 Ansible Playbook - Greenplum Database Installation for CentOS 7 239 Greenplum Database Cloud Technical Recommendations 241 Operating System 241 Storage 241 Security 241 Amazon Web Services driver for Cognos Analytics V11. Connecting to IBM Cognos software with an ODBC driver is not supported. Greenplum Database supports connecting to IBM Cognos software with the DataDirect JDBC driver two interface names for host sdw1. For information about running Greenplum Database in the cloud see Cloud Services in the Tanzu Greenplum Partner Marketplace. Important: When data loss is not acceptable

Playbook 309 Ansible Playbook - Greenplum Database Installation for CentOS 7 310 Greenplum Database Cloud Technical Recommendations 312 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 13 Operating driver for Cognos Analytics V11. Connecting to IBM Cognos software with an ODBC driver is not supported. Greenplum Database supports connecting to IBM Cognos software with the DataDirect JDBC driver includes improvements to error handling and error surfacing. PXF bundles newer guava and Google Cloud Storage hadoop2 libraries. The PXF pxf-log4j.properties template file updates a log filter and changes

on DCA Systems 293 Storage 293 Hadoop Distributions 294 VMware vSphere Requirements 294 Public Cloud Requirements 295 Operating System 295 Storage 295 Amazon Web Services (AWS) 295 Virtual Machine includes improvements to error handling and error surfacing. PXF bundles newer guava and Google Cloud Storage hadoop2 libraries. The PXF pxf-log4j.properties template file updates a log filter and changes requirements for deploying the software to VMware vSphere, to on-premise hardware, or to public cloud services such as AWS, GCP, or Azure. Operating System Requirements Greenplum Database 6 runs on

Connectors 261 VMware Greenplum Text 262 Greenplum Command Center 263 Hadoop Distributions 263 Public Cloud Requirements 263 Operating System 263 Storage 263 Security 264 Amazon Web Services (AWS) 264 includes improvements to error handling and error surfacing. PXF bundles newer guava and Google Cloud Storage hadoop2 libraries. The PXF pxf-log4j.properties template file updates a log filter and changes requirements for deploying the software to VMware vSphere, to on-premise hardware, or to public cloud services such as AWS, GCP, or Azure. VMware vSphere Requirements In order to determine what versions

VMware Tanzu Greenplum 6 Documentation VMware, Inc 10 Hadoop Distributions 255 Greenplum Database Cloud Technical Recommendations 255 Operating System 255 Storage 255 Security 256 Amazon Web Services includes improvements to error handling and error surfacing. PXF bundles newer guava and Google Cloud Storage hadoop2 libraries. The PXF pxf-log4j.properties template file updates a log filter and changes to Dell EMC VxRail Tanzu Greenplum deployed to on-premise hardware Tanzu Greenplum deployed to cloud services such as AWS, GCP, or Azure Supported Platforms VMware Tanzu Greenplum on vSphere is compatible

Tanzu Greenplum Text 251 Greenplum Command Center 251 Hadoop Distributions 251 Greenplum Database Cloud Technical Recommendations 251 Operating System 251 Storage 252 Security 252 Amazon Web Services includes improvements to error handling and error surfacing. PXF bundles newer guava and Google Cloud Storage hadoop2 libraries. The PXF pxf-log4j.properties template file updates a log filter and changes to Dell EMC VxRail Tanzu Greenplum deployed to on-premise hardware Tanzu Greenplum deployed to cloud services such as AWS, GCP, or Azure Platform Requirements for On-Premise Hardware This topic describes