Enabling Multi-Cluster Support

Multi-cluster functionality allows you to view the status of multiple Greenplum Database clusters at one time in the Command Center user interface. The clusters can be organized into groups.

Typically, one Greenplum cluster is designated the master cluster; its Command Center instance hosts the multi-cluster view for all Command Center-managed clusters.

See Monitoring Multiple Greenplum Database Clusters for information about accessing the multi-cluster view.

Setting Up Multiple Clusters

Multi-cluster support is enabled with a multi-cluster configuration file. There is a template for this configuration file in the instance directory of each Command Center instance at the following location:

$GPCCHOME/instances/<instance_name>/conf/clusters.conf

Locate the clusters.conf template on the Command Center instance you want to identify as the master instance. This will be the web server that hosts the multi-cluster web page.

The configuration file consists of the following values separated by colons:

SERVER : HOST : PORT : TABGROUP : AUTOLOGIN : SSL : ACCESS

For example:

Miracle:www.example.com:28080:Production:True:false:gpdb_role,accounting_role
Deforest:192.51.100.186:28080:Development:False:false
Grandalpha:grandalpha:32020:Development:False:false

All fields except the last, ACCESS, are required.

SERVER

The server value is a primary key, used to uniquely identify each Greenplum Database cluster.

The name may not contain special characters, other than the space character, underscore (_), or hyphen (-).

Command Center throws an error if there are any entries with the same primary key.

HOST

This is the host name or IP address for the cluster’s Command Center UI.

PORT

The Command Center port number.

TABGROUP

This field is used to divide Greenplum Database clusters into categories; for example, Testing, Production, and Deployment.

AUTOLOGIN

This field enables automatic login to the cluster from the multi-cluster view. When automatic login is enabled, clicking the cluster’s health chart on the multi-cluster page loads the cluster’s Command Center UI in a new browser window.

The AUTOLOGIN field is a true or false value. It is not case-sensitive.

SSL

This field indicates whether SSL is enabled for the host. It takes a true or false value and is not case-sensitive. Any other value is an error, which will be shown in the UI.

Important: All hosts must have the same SSL configuration. SSL must be enabled or disabled for all hosts.

ACCESS

This optional field contains a comma-separated list of database roles that can see the Multiple GPDB Clusters view. If this field is empty, all users can see the view.