Greenplum Command Center 1.3.0.0 Release Notes

Greenplum Command Center 1.3.0.0 Release Notes

About Pivotal Greenplum Command Center

Pivotal Greenplum Command Center is a management tool for Pivotal's Greenplum Database. Pivotal Greenplum Command Center monitors system performance metrics, system health, and also provides administrators the ability to perform management tasks such as start, stop, and recovery of systems for Greenplum Database. Pivotal Greenplum Command Center is an interactive graphical web application that can be installed on a web server on the master host, and used to view and interact with the collected system data from Greenplum Database and optionally from EMC's Data Computing Appliance (DCA).

Pivotal Greenplum Command Center is comprised of data collection agents that run on the Greenplum Database master host and each segment host. The agents collect data about queries and system utilization and send it to the database's master host at regular intervals. Pivotal Greenplum Command Center stores its data and metrics in a dedicated Greenplum database (the gpperfmon database) whose information is distributed among the master host and segment hosts, like any other Greenplum Database. The data stored in the gpperfmon database can be accessed through the web application or through SQL queries.

Greenplum Database is a requirement for operating Command Center (Command Center stores its information in a Greenplum database).

Supported Platforms

Red Hat Enterprise Linux 5 and 6
Note: For Greenplum Command Center 1.3:
  • OpenSSL version is 1.0.1j.
  • lighttd web server version is 1.4.35

Greenplum Command Center Compatibility

Pivotal Greenplum Command Center is currently certified for the EMC Data Computing Appliance (DCA) and Greenplum Database software-only environments. Command Center monitors the following for each environment:

Greenplum Data Computing Appliance

  • Greenplum Database Module: 4.3 and 4.2.6.3 or higher (4.2.7.1 or higher is recommended for full functionality of this release)
  • Greenplum Data Integration Accelerator (DIA) Module
  • Greenplum Data Computing Appliance Hardware (V1.2.x and V2.x)

If you have been using Greenplum's earlier monitoring tool, Performance Monitor with an older DCA release, we recommend you upgrade to a supported version of DCA.

Greenplum Database (software-only environments)

  • Greenplum Database: 4.3 and 4.2.6.3 or higher (4.2.7.1 or higher is recommended for full functionality of this release)

About Pivotal Command Center 1.3

Refer to the following sections for more information about this release:

What's New in the Release

  • Multi-Cluster Support: This release of Greenplum Command Center provides multi-cluster support. This new functionality allows you to view, within one page, the status of multiple clusters at one time; and to categorize clusters into groups. Configuration of multi-cluster support in the UI is defined by a super-user by means of a configuration file. Details are provided in the Greenplum Command Center 1.3 Administrator Guide.
  • Operator User Support: A new user has been introduced in this release, the Operator. There are now three levels of user supported, Superuser, Operator, and regular user. Instructions for creating Operator users are provided in the Greenplum Command Center 1.3 Administrator Guide.
  • A new Show/Hide button allows you to customize multi-element screens (Dashboard and System Metrics) by specifying which graphs to display.
  • A new Show/Hide button allows you to select the specific query fields (columns) to display in the Query Monitor.
  • A new Export icon allows you to export data as CSV file from any chart or table.
  • Overlaying Graphs: When viewing the System Metrics > Details, you are now able to overlay the graph of one metric over that of another metric.
  • lighttd Web Server Upgrade: The lighttd web server has been upgraded to version 1.4.35.
  • OpenSSL Upgrade: OpenSSL has been upgraded to 1.0.1j.
  • Display of EXPLAIN plan text: Greenplum Command Center can display EXPLAIN plan text of running and historical queries. The EXPLAIN plan text can be easier to use than the EXPLAIN plan graph when analyzing query performance.
  • PKI support: Greenplum Command Center supports a public key infrastructure (PKI) for single sign on authentication. Instructions for enabling PKI is provided in the Greenplum Command Center 1.3 Administrator Guide.
  • Disk Space Warning: Greenplum Command Center displays disk space warnings when disk space is running low on the cluster.
Important: Support of GPHD clusters has been removed from this release.

Installation and Upgrade Instructions

Note: Greenplum Command Center requires Adobe Flash Player version 11 or higher. If this requirement is not met, you see the following screen:

Greenplum Data Computing Appliance

Pivotal Greenplum Command Center is already installed on the appliance (versions 1.2.x and 2.x).

For more information about setting up, upgrading, and configuring Pivotal Greenplum Command Center on an EMC Greenplum DCA, refer to the appropriate versions of the Greenplum Data Computing Appliance Software Upgrade Guide and Greenplum Data Computing Appliance Installation and Configuration Guide.

Greenplum Database Software-only

Instructions for installing, configuring, and upgrading your system for Pivotal Greenplum Command Center are provided in the latest Pivotal Greenplum Command Center 1.3 Administrator Guide (see Documentation for availability).

Pivotal Greenplum Command Center replaced a monitoring tool called Greenplum Performance Monitor. You are not required to upgrade to Pivotal Greenplum Command Center; you can continue using Performance Monitor as before. To continue running Performance Monitor, do not setup Command Center. You will not be able to access new monitoring features if you decide not to upgrade. You may also run Performance Monitor and Command Center in parallel (for example, to compare functionality before upgrading). For parallel operations, assign a different port number to Command Center during setup.

Accessing Command Center

The Command Center administrative user, gpmon, is created automatically by the dca_setup utility on the Data Computing Appliance, and by the gpperfmon_install utility in a Greenplum Database software-only environment.

Any other Greenplum Database users with appropriate privileges can access Command Center.

To create a new Command Center user, first you have to create a Greenplum Database user, then edit the pg_hba.conf file to give that user access to Command Center. An example of this procedure is provided in the Pivotal Greenplum Command Center Administrator Guide and more detailed information can be found in the Pivotal Greenplum Database Administrator Guide.

Resolved Issues

The following table lists issues that were resolved in Pivotal Greenplum Command Center (Command Center) 1.3.

For issues resolved in earlier GPCC releases, refer to their release notes, available on our website at http://docs.pivotal.io/.

Issue Description
CMDR-283 Alert messages 'password authentication failed' are generated for every login. Before attempting authentication with the entered password, GPCC tested whether the logged in user was trusted and the allow_trusted_login parameter in the web application configuration file was set to true. The authentication failure alert was generated during this initial phase of the authentication. The allow_trusted_login option has been removed.
CMDR-1833 Large amount of connection errors to hadoop nodes were being generated even though there were no hadoop nodes in the cluster.
CMDR-1861 Errors were displayed when a non-superuser logged into GPCC that prevented some of the data from being displayed in the UI.
CMDR-1763 All special characters are now supported in the Greenplum Command Center user login name.
CMDR-1928 In response to OpenSSL Security Advisory [15 Oct 2014] (see https://www.openssl.org/news/secadv_20141015.txt), OpenSSL has been upgraded to 1.0.1j.

See http://www.pivotal.io/security for more information regarding security vulnerabilities in Pivotal products.

CMDR-1940 GPCC did not work properly with reverse proxy.
CMDR-1933 Filtering of users in the Resource Queue view has been improved.
CMDR-1904 The application name is now displayed for GPCC queries.
CMDR-1622 The EXPLAIN plan displayed in GPCC has been enhanced.
CMDR-1788 GPCC 1.3.0.0 supports the new user type Operator. GPCC users who are members of this group have access to more functionality in the GPCC user interface than regular users, but do not have to be a Greenplum Database superuser.
CMDR-1932 GPCC supports encryption of Command Center sessions with self-signed certificates and OpenSSL encryption.

Known Issues

This section lists the known issues in Pivotal Greenplum Command Center 1.3. A work-around is provided where applicable.

Issue Description
CMDR-297

Heavy workload on the Greenplum Database can affect responsiveness

The refresh rate of the Command Center user interface can be adversely affected by simultaneous heavy workload on the underlying Greenplum Database.

Pivotal Documentation

The following Pivotal Greenplum Command Center and related documentation is available on our website at http://docs.pivotal.io/.

Title Revision
Pivotal Greenplum Command Center 1.3 Administrator Guide A01
Pivotal Greenplum Command Center 1.3 Release Notes (this document) A01

Additionally, we provide end user information via online help. To launch the online help, click the Help button at the top right of the GPCC user interface.