Supported Platforms

Supported Platforms

This section describes the supported platforms for deploying Pivotal Greenplum 6 in a production environment. It contains these topics:

Operating Systems

Pivotal Greenplum 6.0.0 runs on the following operating system platforms:

  • Red Hat Enterprise Linux 64-bit 7.x (See the following Note.)
  • Red Hat Enterprise Linux 64-bit 6.x
  • CentOS 64-bit 7.x
  • CentOS 64-bit 6.x
  • Ubuntu 18.04 LTS
Important: Significant Greenplum Database performance degradation has been observed when enabling resource group-based workload management on RedHat 6.x and CentOS 6.x systems. This issue is caused by a Linux cgroup kernel bug. This kernel bug has been fixed in CentOS 7.x and Red Hat 7.x systems.

If you use RedHat 6 and the performance with resource groups is acceptable for your use case, upgrade your kernel to version 2.6.32-696 or higher to benefit from other fixes to the cgroups implementation.

Note: For Greenplum Database that is installed on Red Hat Enterprise Linux 7.x or CentOS 7.x prior to 7.3, an operating system issue might cause Greenplum Database that is running large workloads to hang in the workload. The Greenplum Database issue is caused by Linux kernel bugs.

RHEL 7.3 and CentOS 7.3 resolves the issue.

Greenplum Database supports TLS V2.

Software Dependencies

Greenplum 6 requires the following software packages on RHEL/CentOS 6/7 systems (they are installed automatically as dependencies when you install the Pivotal Greenplum RPM package):
  • apr
  • apr-util
  • bash
  • bzip2
  • curl
  • krb5
  • libcurl
  • libedit
  • libevent
  • libxml2
  • libyaml
  • zlib
  • openldap
  • openssh
  • openssl
  • openssl-libs (RHEL7/Centos7)
  • perl
  • rsync
  • R
  • sed (used by gpinitsystem)
  • tar
  • zip
Greenplum client software requires these operating system packages:
  • apr
  • apr-util
  • libyaml
  • libevent
On Ubuntu systems Greenplum requires the following software packages, which are installed automatically as dependencies when you install Greenplum Database with the Debian package installer:
  • libapr1
  • libaprutil1
  • bash
  • bzip2
  • krb5-multidev
  • libcurl3-gnutls
  • libcurl4
  • libedit2
  • libevent-2.1-6
  • libxml2
  • libyaml-0-2
  • zlib1g
  • libldap-2.4-2
  • openssh-client
  • openssh-client
  • openssl
  • perl
  • rsync
  • sed
  • tar
  • zip
  • net-tools
  • less
  • iproute2

Greenplum Database 6 uses Python 2.7.12, which is included with the product installation (and not installed as a package dependency).

Important: SSL is supported only on the Greenplum Database master host system. It is not supported on the segment host systems.
Important: For all Greenplum Database host systems, SELinux must be disabled. You should also disable firewall software, although firewall software can be enabled if it is required for security purposes. See Disabling SELinux and Firewall Software.

Java

Pivotal Greenplum 6.0.0 supports these Java versions:

Hardware and Network

The following table lists minimum recommended specifications for hardware servers intended to support Greenplum Database on Linux systems in a production environment. All servers in your Greenplum Database system must have the same hardware and software configuration. Greenplum also provides hardware build guides for its certified hardware platforms. It is recommended that you work with a Greenplum Systems Engineer to review your anticipated environment to ensure an appropriate hardware configuration for Greenplum Database.

Warning: Running Pivotal Greenplum on hyper-converged infrastructure (HCI) has known issues with performance, scalability, and stability and is not recommended as a scalable solution for Pivotal Greenplum and may not be supported by Pivotal if stability problems appear related to the infrastructure. HCI virtualizes all of the elements of conventional hardware systems and includes, at a minimum, virtualized computing, a virtualised SAN, and virtualized networking.
Table 1. Minimum Hardware Requirement
Minimum CPU Any x86_64 compatible CPU
Minimum Memory 16 GB RAM per server
Disk Space Requirements
  • 150MB per host for Greenplum installation
  • Approximately 300MB per segment instance for meta data
  • Appropriate free space for data with disks at no more than 70% capacity
Network Requirements 10 Gigabit Ethernet within the array

NIC bonding is recommended when multiple interfaces are present

Pivotal Greenplum is supported using either IPV4 or IPV6 protocols.

Storage

The only file system supported for running Greenplum Database is the XFS file system. All other file systems are explicitly not supported by Pivotal.

Greenplum Database is supported on network or shared storage if the shared storage is presented as a block device to the servers running Greenplum Database and the XFS file system is mounted on the block device. Network file systems are not supported. When using network or shared storage, Greenplum Database mirroring must be used in the same way as with local storage, and no modifications may be made to the mirroring scheme or the recovery scheme of the segments. Other features of the shared storage such as de-duplication and/or replication are not directly supported by Pivotal Greenplum Database, but may be used with support of the storage vendor as long as they do not interfere with the expected operation of Greenplum Database at the discretion of Pivotal.

Deployment to virtualized systems is supported only if the storage is presented as block devices and the XFS file system is mounted for the storage of the segment directories.
Warning: Running Pivotal Greenplum on hyper-converged infrastructure (HCI) has known issues with performance, scalability, and stability and is not recommended as a scalable solution for Pivotal Greenplum and may not be supported by Pivotal if stability problems appear related to the infrastructure. HCI virtualizes all of the elements of conventional hardware systems and includes, at a minimum, virtualized computing, a virtualised SAN, and virtualized networking.

Greenplum Database is supported on Amazon Web Services (AWS) servers using either Amazon instance store (Amazon uses the volume names ephemeral[0-20]) or Amazon Elastic Block Store (Amazon EBS) storage. If using Amazon EBS storage the storage should be RAID of Amazon EBS volumes and mounted with the XFS file system for it to be a supported configuration.

Data Domain Boost

Pivotal Greenplum 6.0.0 supports Data Domain Boost for backup on Red Hat Enterprise Linux. This table lists the versions of Data Domain Boost SDK and DDOS supported by Pivotal Greenplum 6.x.

Table 2. Data Domain Boost Compatibility
Pivotal Greenplum Data Domain Boost DDOS
6.x 3.3 6.1 (all versions)

6.0 (all versions)

Note: In addition to the DDOS versions listed in the previous table, Pivotal Greenplum supports all minor patch releases (fourth digit releases) later than the certified version.
Note: Pivotal Greenplum 6 does not support the ODBC 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 for Pivotal Greenplum. This driver is available as a download from Pivotal Network.

Tools and Extensions Compatibility

Client Tools

Greenplum Database 6 releases a Clients tool package on various platforms that can be used to access Greenplum Database from a client system. The Greenplum 6 Clients tool package is supported on the following platforms:

  • Red Hat Enterprise Linux x86_64 6.x (RHEL 6)
  • Red Hat Enterprise Linux x86_64 7.x (RHEL 7)

The Greenplum 6 Clients package includes the client and loader programs provided in the Greenplum 5 packages plus the addition of database/role/language commands and the Greenplum-Kafka Integration and Greenplum Stream Server command utilities. Refer to Greenplum Client and Loader Tools Package for installation and usage details of the Greenplum 6 Client tools.

Extensions

Table 3. Pivotal Greenplum 6.0.0 Extensions Compatibility
Pivotal Greenplum Extension Versions
MADlib machine learning for Greenplum Database 6.0.x1 MADlib 1.12, 1.11
PL/Java for Greenplum Database 6.0.x PL/Java 1.4.2, 1.4.0
PL/R for Greenplum Database 6.0.x 2.3.0, 2.2.0
PostGIS Spatial and Geographic Objects for Greenplum Database 6.0.x 2.1.5
Python Data Science Module Package for Greenplum Database 6.0.x2 1.0.0, 1.1.0
R Data Science Library Package for Greenplum Database 6.0.x3 1.0.0
Oracle Compatibility Functions for Greenplum Database 6.04 3.7.0
Note: 1For information about MADlib support and upgrade information, see the MADlib FAQ.

2For information about the Python package, including the modules provided, see the Python Data Science Module Package.

3For information about the R package, including the libraries provided, see the R Data Science Library Package.

4For information about the Oracle Compatibility Functions, see Oracle Compatibility Functions.

These Greenplum Database extensions are installed with Pivotal Greenplum Database
  • Fuzzy String Match Extension
  • PL/Python Extension
  • pgcrypto Extension

Data Connectors

  • Greenplum Platform Extension Framework (PXF) - PXF, integrated with Greenplum Database 6, provides access to Hadoop, object store, and SQL external data stores. Refer to Accessing External Data with PXF in the Greenplum Database Administrator Guide for PXF configuration and usage information.
  • Greenplum-Kafka Integration - The Pivotal Greenplum-Kafka Integration provides high speed, parallel data transfer from a Kafka cluster to a Pivotal Greenplum Database cluster for batch and streaming ETL operations. Refer to the Pivotal Greenplum-Kafka Integration Documentation for more information about this feature.
  • Greenplum Stream Server - The Pivotal Greenplum Stream Server is an ETL tool that provides high speed, parallel data transfer from Informatica, Kafka, and custom client data sources to a Pivotal Greenplum Database cluster. Refer to the Performing ETL Operations with the Pivotal Greenplum Stream Server Documentation for more information about this feature.
  • Gemfire-Greenplum Connector - The Pivotal Gemfire-Greenplum Connector supports the transfer of data between a GemFire region and a Greenplum Database cluster. The Gemfire-Greenplum Connector is available as a separate download from Pivotal Network. Refer to the Gemfire-Greenplum Connector documentation for compatibility and usage information.

GPText

Greenplum Text is not supported with this Beta release.

Greenplum Command Center

Greenplum Command Center is not supported with this Beta release.

Hadoop Distributions

Greenplum Database provides access to HDFS with the Greenplum Platform Extension Framework (PXF).

PXF supports Cloudera, Hortonworks Data Platform, MapR, and generic Apache Hadoop distributions.

Note: If you plan to access JSON format data stored in a Cloudera Hadoop cluster, PXF requires a Cloudera version 5.8 or later Hadoop distribution.