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
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.
Ensure that the following prerequisites are satisfied:
- Greenplum Command Center software is installed. See Install the Greenplum Command Center Software.
- The gpperfmon database is created and the data collection agents are running. See Creating the gpperfmon Database.
gpmonuser is created and is able to log in to the
psql -U gpmon gpperfmon).
- Any certificates or Kerberos keytab files needed for encryption and user authentication are installed. See Securing a Greenplum Command Center Console Instance.
- If the
gpmonuser is to be authenticated with Kerberos, install the keytab file for the
gpmonKerberos principal on the Greenplum master and standby hosts and run
kinit gpmonbefore you begin to create the Command Center Console instance. See Securing the gpmon Database User for more information.
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.
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.
- Log in as the Greenplum administrator (
gpadmin) and source the
With the Greenplum Database instance running, launch the setup utility.
$ gpcmdr --setup
Provide an instance name for the Greenplum Database instance monitored by this Console.
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.
nto 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
yand enter the hostname or IP address of the master at the prompt.
Provide the port number for the Greenplum Database master instance.
Provide a port number for the Command Center Console web server. The default is 28080.
yto 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
nyou can enable Kerberos authentication later using the
If you choose to enable Kerberos authentication:
- 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.
- At the prompt
Enter the GPDB Kerberos service name:enter the name of the Kerberos service principal for Greenplum Database.
- 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.
- 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.
- At the prompt
yto enable SSL connections for the Command Center Console, or
nif 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
If this is not Enter
nto specify whether you want this installation copied to a standby master. This option is only available when you are creating an instance on the Greenplum master host. If you enter
y, you are prompted for the standby master host name.
Start the Console and log in. See Connecting to the Greenplum Command Center Console.
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.
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
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:
[DEFAULT] # defaults apply to all instances remote_db: false enable_copy_standby: true standby_master_host: smdw enable_kerberos: false enable_ssl: true ssl_cert_file: /etc/ssl/certs/cert.pem [production] master_hostname: mdw instance_name: prod display_name: Production master_port: 5432 web_port: 28080 [development] 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 Greenplum Command Center Console instance by entering:
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.