Nodes

Provides detailed information for each node in the cluster. On the left-hand column, you can find a list of all nodes that are members of the cluster including the ClusterControl node. If you added slaves to your cluster through ClusterControl, these will also be listed.

Nodes Monitoring

The node on the list will appear in red color to indicate it is unhealthy. The tabs show performance and resource usage for a specific node. There are also database specific tabs depending on the type of database running on the host:

Controller Node

Database Nodes

Database node status indicator:

Nodes Actions

The remove icon will only appear when you roll over the mouse pointer on the node icon in the left-hand column. This removes the database node from the cluster.

SSH Console

Opens a web-based SSH terminal in a new browser window that allows executing shell commands on the server directly from a browser as the configured os_user. This feature only supported with Apache 2.4+ with ClusterControl SSH component is installed and service cmon-ssh is started. Details at ClusterControl SSH.

Schedule Maintenance Mode

Puts individual nodes into maintenance mode which prevents ClusterControl to raise alarms and notifications during the maintenance period. When toggling ON, you can set the maintenance period for a pre-defined time or schedule it accordingly. Specify the reason for auditing purposes. ClusterControl will not degrade the node, hence the node’s state remains as what it is unless you perform any maintenance onto it.

Alarms and notifications for this node will be activated back once the maintenance period is exceeded, or you explicitly toggling it OFF.

Reboot Host

Initiates a system reboot of the selected host. Once initiated, ClusterControl will monitor the reboot progress every 5 seconds for 10 minutes (600 seconds) before declaring the reboot operation is failed.

Restart Node

Restarts the active monitored process of the selected host. For example, if the node’s role is HAProxy, ClusterControl will restart the HAProxy process. This is not a system reboot. Only available if the service is started.

You can configure the graceful shutdown timeout (default is 1800 seconds) in the Confirm Shutdown dialog. ClusterControl will give up waiting for a node to gracefully terminate. If the node is still running after the timeout you may send the SIGKILL signal to force the node down by toggling on the “Force stop (SIGKILL) node after the graceful shutdown timeout has been reached” option.

The node will be shut down and enter maintenance mode.

Enable WAL Archiving

To utilize point-in-time recovery (PITR), the user has to take a pg_basebackup backup, and if Write-ahead Log (WAL) files are archived after the backup, then it is possible to roll forward to any timestamp from backup creation time until the most recent event captured in the WAL files. This job will update the configuration of the chosen node to enable the WAL archiving.

Stop Node

Stops the monitored process of the selected host. For example, if the node’s role is HAProxy, ClusterControl will restart the HAProxy process. This is not a system shut down. Only available if the service is started.

You can configure the graceful shutdown timeout (default is 1800 seconds) in the Confirm Shutdown dialog. ClusterControl will give up waiting for a node to gracefully terminate. If the node is still running after the timeout you may send the SIGKILL signal to force the node down by toggling on the “Force stop (SIGKILL) node after the graceful shutdown timeout has been reached” option.

The node will be shut down and enter maintenance mode.

Start Node

Starts the monitored process of the selected host. For example, if the node’s role is HAProxy, ClusterControl will restart the HAProxy process. Only available if the service is stopped.

Rebuild Replication Slave

Exclusive for slave node. It rebuilds replication slave on this node from another master. This is only relevant if you have set up a replication slave for the cluster and you want to re-sync the data. It uses pg_basebackup to stage the replication data.

Choose a master node from the dropdown list, and then click Proceed to start to rebuild the salve. The following actions will happen:

1. Stop PostgreSQL server (slave).
2. Remove content from its data directory.
3. Stream a backup from the master to the slave using pg_basebackup.
4. Start the slave.

Promote Slave

Exclusive for slave node. Promotes the selected slave to become the new master. If the master is currently functioning correctly, then stop application queries prior to promoting another slave to safeguard from data loss. Connections on the current running master will be killed after a 10-second grace period.

Unregister Node

Removes the database node from the database cluster and/or ClusterControl monitoring. You can choose one of these 3 options: