Monitoring the state of Greenplum® clusters and hosts
Data on cluster and host states are available in the management console. You can view them on the Monitoring tab of the cluster management page or in Yandex Monitoring.
Diagnostic information about cluster states is presented as graphs.
New data for charts is received every 15 seconds.
Note
The most appropriate multiple units (MB, GB, and more) are automatically used in charts.
Monitoring cluster state
To view detailed information about the Managed Service for Greenplum® cluster state:
- Go to the folder page
and select Managed Service for Greenplum. - Click the cluster name and select the
Monitoring tab. -
To get started with Yandex Monitoring metrics, dashboards, or alerts, click Open in Monitoring in the top panel.
The page displays the following charts:
-
Alive hosts: Cluster host functionality.
-
Alive segments: Primary and backup master as well as primary and mirror segment functionality.
-
Connections: Number of DB connections in each state:
- Active: Active.
- Waiting: Waiting.
- Idle: Idle.
- Idle in transaction: Idle in a transaction.
- Aborted: Terminated.
-
Group resource cpu: Processor core workload by process group:
- admin_group: In the administrative group.
- default_group: In the default group.
-
Group resource memory: Bytes of RAM used by process group:
- admin_group: In the administrative group.
- default_group: In the default group.
-
Master: Definition of primary master host.
-
Master replication lag: Master replication delay (in bytes).
-
Master replication state: Master replication condition.
-
Segment health: Number of segments with various levels of performance:
- total: Everything.
- not sync: Unsynced.
- down: Unavailable.
- not prefer role: Non-preferred.
-
Spill files count: Number of temporary files.
-
Spill files size: Total size of temporary files (in bytes).
-
Xid wraparound: Using a sequence of transaction IDs
(as a percentage).
Monitoring the state of hosts
To view detailed information about the state of individual Managed Service for Greenplum® hosts:
- Go to the folder page
and select Managed Service for Greenplum. - Click the cluster name and select the
Hosts → Monitoring tab. - Select the host from the drop-down list.
This page displays charts showing the workload of an individual cluster host (master or segment):
- CPU: Load on processor cores. As the load goes up, the
Idle
value goes down. - Disk IOPS in progress: Number of pending disk operations.
- Disk io time: Duration of disk operations.
- Disk read and write: Amount of data in disk operations (in bytes).
- Disk read and write time: Duration of disk reads and writes.
- Disk usage: Disk space usage (two charts are displayed, in bytes and %).
- Memory usage: Use of RAM, in bytes. At high loads, the
Free
value goes down, while the other values go up. - Network: Amount of network traffic (in bytes).
Integration with Yandex Monitoring
To configure cluster and host status metric alerts:
- In the management console
, select the folder with the cluster you want to configure alerts for. - In the list of services, select
Monitoring. - Under Service dashboards, select:
- Managed Service for Greenplum® — Cluster Overview to configure cluster alerts.
- Managed Service for Greenplum® — Host Overview to configure host alerts.
- In the chart with metrics, click
and select Create alert. - If the chart shows multiple metrics, select a data query to generate a metric and click Continue. You can learn more about the query language in the Yandex Monitoring documentation.
- Set the
Alarm
andWarning
thresholds for notifications. - Click Create alert.
To have other cluster health indicators monitored automatically:
- Create an alert.
- Add a status metric.
- In the alert parameters, set up your alert thresholds.
For a complete list of supported metrics, see the Monitoring documentation.
Cluster state and status
The State of a cluster shows the health of its hosts, while the Status shows whether the cluster is started, stopped, or is at an intermediate stage.
To view a cluster's state and status:
- Go to the folder page
and select Managed Service for Greenplum. - Hover over the indicator in the Availability column in the required cluster row.
Cluster states
Status | Description | Suggested actions |
---|---|---|
ALIVE | Cluster is operating normally. | No action is required. |
DEGRADED | Cluster is not running at its full capacity: the state of at least one of the hosts is other than ALIVE . |
Run the diagnostics:
|
DEAD | Cluster is out of order: all of its hosts are down. | Send a request to the support team
|
UNKNOWN | Cluster state is unknown. | Send a request to the support team
|
Cluster statuses
Status | Description | Suggested actions |
---|---|---|
CREATING | Preparing for the first launch | Wait a while and get started. The time it takes to create a cluster depends on the host class. |
RUNNING | Cluster is operating normally | No action is required. |
STOPPING | Stopping cluster | After a while, the cluster's status will change to STOPPED and it will be disabled. No action is required. |
STOPPED | Cluster stopped | For instructions on how to restart it, see Stopping and restarting a cluster. |
STARTING | Starting the cluster that was stopped earlier | After a while, the cluster's status will change to RUNNING . Wait a while and get started. |
UPDATING | Updating the cluster status | After the update is completed, the cluster's status will change to RUNNING . Wait a while and get started. |
ERROR | An error occurred that doesn't allow the cluster to continue working | Run the initial diagnostics:
|
STATUS_UNKNOWN | Cluster is unable to determine its own status | Run the initial diagnostics:
|
Greenplum® and Greenplum Database® are registered trademarks or trademarks of VMware, Inc. in the United States and/or other countries.