Creating Greenplum Command Center Console Instances

A Command Center Console instance is a web server providing an HTML5 graphical console application to monitor system metrics and perform some administrative tasks for a single Greenplum Database cluster.

The Command Center Console runs on the gpmonws web server. The default web server port is 28080. Configuration files, log files, and runtime files for each Command Center instance are managed in a subdirectory of the $GPPERFMON/instances directory.

If you have multiple Greenplum Database instances, you can create separate Command Center Console instances for each of them. Each separate console instance operates on a unique port and has its own unique configuration options. A multi-cluster view may be enabled to allow you to view status for all clusters. See Enabling Multi-Cluster Support for more information.

For more information about the web server, see Web Server Administration.

The Command Center Console supports current browser versions of Chrome, Safari, Firefox, and Internet Explorer.

Before You Begin

Ensure that the following prerequisites are satisfied:

The gpcmdr --setup command-line utility sets up the Command Center instance. The command can be run interactively, or you can create a configuration file and run the command non-interactively. If you use a configuration file, you can create multiple Command Center instances at once.

Creating the Greenplum Command Center Instance (Interactive)

Follow the steps below to create a new Command Center Console instance. To accept the displayed default values for any parameters at configuration time, press the ENTER key. To monitor multiple Greenplum Database clusters, run the setup utility separately to create an instance for each cluster.

  1. Log in as the Greenplum administrator (gpadmin) and source the $GPPERFMON/ file.
  2. With the Greenplum Database instance running, launch the setup utility. For example:

    $ gpcmdr --setup
  3. Provide an instance name for the Greenplum Database instance monitored by this Console.

  4. Provide a display name for the instance. This name is shown in the Console user interface. This prompt does not appear if the master host is remote.

  5. Select y or n to specify if the Greenplum Database master for this instance is on a remote host. Note that Console performance is better when the Console and Greenplum Database master are on the same host. If the master host is remote, enter y and enter the hostname or IP address of the master at the prompt.

  6. Provide the port number for the Greenplum Database master instance.

  7. Provide a port number for the Command Center Console web server. The default is 28080.

  8. Enter y to the prompt Enable kerberos login for this instance? to use Kerberos authentication. To use this feature, Kerberos authentication must be enabled for Greenplum Database and the Kerberos administrator must have created a keytab file for Command Center. See Enabling Kerberos Authentication with Greenplum Command Center for details. If you enter n you can enable Kerberos authentication later using the gpcmdr --krbenable command.

    If you choose to enable Kerberos authentication:

    1. At the prompt Enter web server name for this instance: enter the name of the host from the Kerberos principal. The principal name is in the format HTTP/<host>@<realm>. The host must be entered in the same format as the Kerberos principal and should exclude the port number.
    2. At the prompt Enter the GPDB Kerberos service name: enter the name of the Kerberos service principal for Greenplum Database.
    3. At the prompt Choose Kerberos mode: enter the number of the Kerberos mode you want to use. See Enabling Authentication With Kerberos for a description of these options.
    4. At the prompt Enter the path to the keytab file: enter the full path to the keytab containing the web server principal. If you are setting up this instance on the Greenplum master, the keytab file may be the same one used for Greenplum Database.
  9. Enter y to enable SSL connections for the Command Center Console, or n if you do not want SSL.

    Note: Because database login information is sent over the network, it is strongly recommended to use SSL to encrypt these communications.

    You are asked to specify the location of your X509 certificate file. Enter the full path to the certificate file. The path you enter is added to the app.conf file. n

  10. Enter y or n to specify whether you want this installation copied to a standby master. If you enter y, you are prompted for the standby master host name.

  11. Start the Console and log in. See Connecting to the Greenplum Command Center Console.

  12. You can also configure authentication so that other Greenplum users can log in to the Console, see Configuring Authentication for the Command Center Console for details.

Creating the Command Center Console Instance (Non-interactive)

It can be useful to run gpcmdr --setup non-interactively, taking input from a file. For example, you could install GPCC and create Command Center instances as part of a Greenplum cluster installation script. To accomplish this, create a configuration file and supply it to the gpcmdr utility using the --config_file option:

gpcmdr --setup --config_file file

The configuration file is similar to a Windows INI file, containing one or more sections beginning with a section header in square braces. Parameters in the optional [DEFAULT] section apply to all subsequent sections and may be overridden. Each section other than [DEFAULT] defines a Command Center Console instance to create.

Parameters are specified one-per-line as name-value pairs separated with equals signs (=) or colons (:). Comments begin with a number sign (#) or semicolon (;) and continue to the end of the line.

Here is an example configuration file:

# defaults apply to all instances
remote_db: false
enable_copy_standby: true
standby_master_host: smdw
enable_kerberos: false
enable_ssl: true
enable_user_import_cert: true
ssl_cert_file: /etc/ssl/certs/cert.pem
enable_user_import_dhe: false
enable_reuse_dhe: true

master_hostname: mdw
instance_name: prod
display_name: Production
master_port: 5432
web_port: 28080

master_hostname: mdw
instance_name: dev
enable_copy_standby: false ; override
display_name: Development
master_port: 5532
web_port: 28090

See Setup Configuration File for a detailed description of the setup configuration file syntax and parameters.

Start the Command Center Console Instance

Start the Greenplum Command Center Console instance by entering:

gpcmdr --start

If you do not specify an instance name, all Command Center Console instances are started. To start a particular instance, you can specify the name of the instance. For example:

gpcmdr --start instance_name

See Administering Greenplum Command Center for a complete list of administrative commands.