Greenplum Command Center 220.127.116.11 Release Notes
Greenplum Command Center 18.104.22.168 Release Notes
Published: May, 2015
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).
- 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 22.214.171.124 or higher (126.96.36.199 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 188.8.131.52 or higher (184.108.40.206 or higher is recommended for full functionality of this release)
About Pivotal Command Center 1.3
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.
Installation and Upgrade Instructions
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.
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/.
|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 220.127.116.11 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.|
This section lists the known issues in Pivotal Greenplum Command Center 1.3. A work-around is provided where applicable.
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.
The following Pivotal Greenplum Command Center and related documentation is available on our website at http://docs.pivotal.io/.
|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.