Table of Contents Previous Next


4 Using Failover Manager : 4.2 Monitoring a Failover Manager Cluster

You can use either the Failover Manager efm cluster-status command or the PEM Client graphical interface to check the current status of a monitored node of a Failover Manager cluster.
The cluster-status command returns a report that contains information about the status of the Failover Manager cluster. To invoke the command, enter:
The following status report is for a cluster named edb that has four nodes running:
efm cluster-status efm
Cluster Status: efm

Agent Type Address Agent DB VIP

-----------------------------------------------------
Witness 172.19.12.170 UP N/A
Master 172.19.13.105 UP UP 172.19.13.107*

Standby 172.19.13.113 UP UP 172.19.13.106
Standby 172.19.14.106 UP UP 172.19.13.108


Allowed node host list:
172.19.12.170 172.19.13.113 172.19.13.105 172.19.14.106

Membership coordinator: 172.19.12.170

Standby priority host list:
172.19.13.113 172.19.14.106

Promote Status:

DB Type Address WAL LSN Info
-------------------------------------------------------
Master 172.19.13.105 0/31000140
Standby 172.19.13.113 0/31000140
Standby 172.19.14.106 0/31000140

Standby database(s) in sync with master. It is safe to promote.
The Cluster Status section provides an overview of the status of the agents that reside on each node of the cluster:
Cluster Status: efm

Agent Type Address Agent DB VIP

-----------------------------------------------------
Witness 172.19.12.170 UP N/A
Master 172.19.13.105 UP UP 172.19.13.107*

Standby 172.19.13.113 UP UP 172.19.13.106
Standby 172.19.14.106 UP UP 172.19.13.108

The Allowed node host list and Standby priority host list provide an easy way to tell which nodes are allowed to join the cluster, and the promotion order of the nodes. The IP address of the Membership coordinator is also displayed in the report:
Allowed node host list:
172.19.12.170 172.19.13.113 172.19.13.105 172.19.14.106

Membership coordinator: 172.19.12.170

Standby priority host list:
172.19.13.113 172.19.14.106
The Promote Status section of the report is the result of a direct query from the node on which you are invoking the cluster-status command to each database in the cluster; the query also returns the transaction log location of each database.
Promote Status:

DB Type Address WAL LSN Info
-------------------------------------------------------
Master 172.19.13.105 0/31000140
Standby 172.19.13.113 0/31000140
Standby 172.19.14.106 0/31000140

Standby
database(s) in sync with master. It is safe to promote.
If a database is down (or if the database has been restarted, but the resume command has not yet been invoked), the state of the agent that resides on that host will be Idle. If an agent is idle, the cluster status report will include a summary of the condition of the idle node:
Agent Type Address Agent DB VIP
-----------------------------------------------------
Idle 172.19.18.105 UP UP 172.19.13.105

4 Using Failover Manager : 4.2 Monitoring a Failover Manager Cluster

Table of Contents Previous Next