LATEST VERSION: 3.3.1 - CHANGELOG
Pivotal Greenplum Command Center v3.3.1

Greenplum Command Center 2.0.0 Release Notes

Greenplum Command Center version: 2.0.0

Greenplum Workload Manager version: 1.0.3

Rev: A01

Published: November 2015

Contents

About Pivotal Greenplum Command Center

Pivotal Greenplum Command Center is a management tool for Pivotal 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 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).

About Pivotal Greenplum Workload Manager

Greenplum Workload Manager software is included with Greenplum Command Center and may optionally be installed by running the gpcmdr --setup utility. Greenplum Workload Manager collects query execution data and real-time system statistics on each segment host. The Workload Manager rules engine allows you to create rules that specify criteria that trigger an action, for example cancelling a query that runs longer than a specified time or consumes too many resources on a segment host. Real-time query performance can be viewed in the Workload Manager gptop curses-based GUI.

Supported Platforms

Greenplum Command Center may be installed on the following platforms:

  • Red Hat Enterprise Linux 5 or 6, 64-bit
  • CentOS 5 or 6, 64-bit
  • Greenplum Database 4.3.x

Greenplum Workload Manager may be installed on the following platforms:

  • Red Hat Enterprise Linux 5.5+ or 6, 64-bit
  • CentOs 5.5+ or 6, 64-bit
  • Greenplum Database 4.3.x

Greenplum Command Center includes:

  • OpenSSL version 1.0.1o.
  • lighttpd web server version 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.x
  • 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.x

Product Enhancements in Greenplum Command Center Release 2.0.0

Pivotal Greenplum Workload Manager is included in the Pivotal Greenplum Command Center 2.0.0 package. Greenplum Workload Manager is a management tool for Greenplum Database you can use to monitor and manage queries and to manage resource queues.

Greenplum Command Center Release 2.0.0 includes Greenplum Workload Manager 1.0.3.

The gpcmdr --setup utility now asks if you want to install Greenplum Workload Manager when you create a Greenplum Command Center instance:

Would you like to install workload manager?

The Greenplum Workload Manager installer detects existing software versions and either installs or upgrades the Workload Manager software.

The Greenplum Workload Manager installer may also be run separately at the command line. See “Installing Greenplum Workload Manager” in the Greenplum Workload Manager User Guide for command syntax and usage instructions.

Product Enhancements in Greenplum Workload Manager 1.0.3

The following are enhancements and changes in Greenplum Workload Manager 1.0.3:

Enhancements to gptop:

  • gptop may be started from the command line with the gptop command.
  • Added the ability to quit gptop by pressing the q key.
  • The window beneath a pop-up window now continues to update.
  • Fixed scrolling when changing the view.
  • Units of measurement have been added to column titles where appropriate.
  • An open menu can be dismissed by pressing the F2 key.
  • When the terminal window is resized, the ncurses view resizes.
  • Pop-up windows are sized proportionally to the parent window.

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 DCA 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 2.0 Administrator Guide (see Pivotal 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.

Installing and Upgrading Greenplum Workload Manager

The gpcmdr --setup utility offers the option to run the Greenplum Workload Manager installer when you create a Greenplum Command Center instance. The Greenplum Workload Manager installer detects existing software versions and either installs or upgrades the Workload Manager software.

The Greenplum Workload Manager installer may also be run separately at the command line. See “Installing Greenplum Workload Manager” in the Greenplum Workload Manager User Guide for command syntax and usage instructions.

Accessing Command Center

For enhanced security, beginning with Greenplum Command Center release 1.3.0.1, the gpadmin user is not permitted to log in to the Command Center. The Command Center does not accept logins from any user on the host running GPCC configured with trust authentication in the pg_hba.conf file.

You should create new administrative, operator, and regular Command Center users for Command Center. To create a new Command Center user, first you create a Greenplum Database role, 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 Administration Guide.

Greenplum Command Center Resolved Issues

The following table lists issues that were resolved in Pivotal Greenplum Command Center 2.0.0.

Issue Description
CMDR-1988 Running gpcmdr --setup failed when copying the instance directory to the secondary master due to incorrect softlinks created by a previous GPCC release. Before running gpcmdr --setup, run the GPCC 2.0.0 gpccinstall utility, which fixes the incorrect softlinks and allows gpcmdr --setup to succeed.

Greenplum Workload Manager Resolved Issues

The following table lists issues that were resolved in Pivotal Greenplum Workload Manager 1.0.3.

Issue Description
86754546 Provide a service and log manager.
98140558 Special characters at the end of a rule name are not caught as invalid syntax.
99748286 Usability enhancements for gptop.
99748698 Installation performance improvements for large clusters.
100588688 Add a Quit option to gptop.
105333134 Log history of gp-wlm commands with timestamp and success or failure result.
106970094 Improve cluster-health-check reporting when invoked interactively.
100833430 Remove absolute paths from log messages. Paths in messages are now relative to the root of the source tree.
107246500 Integrate GP-WLM into the GPCC installer.

Greenplum Command Center Known Issues

This section lists the known issues in Pivotal Greenplum Command Center 2.0. 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.

PT-87736724 The Command Center installer does not have support to upgrade existing Command Center instances when upgrading to a new release.

Greenplum Workload Manager Known Issues

This section lists the known issues in Pivotal Greenplum Workload Manager. A work-around is provided where applicable.

Issue Description
  In rare cases it is possible for installations or upgrades to fail at the cluster-health-check stage. In the event that the cluster is not healthy, re-run the Workload Manager installer with the --force option. See “Installing Greenplum Workload Manager” in the Pivotal Greenplum Workload Manager User Guide for instructions to run the installer at the command line.

Pivotal Documentation

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

Title Revision
Pivotal Greenplum Command Center 2.0 Administrator Guide A01
Pivotal Greenplum Command Center 2.0.0 Release Notes (this document) A01
Pivotal Greenplum Workload Manager 1.0 User Guide A01

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