Monitoring Failover Manager¶
If you are using EDB Failover Manager to monitor your replication scenario, you must manually install and configure Failover Manager. For detailed information about installing Failover Manager, visit the EnterpriseDB website at:
To monitor the status of a Failover Manager cluster on the Streaming
Replication dashboard, you must provide the following information on the
Advanced tab of the
server Properties dialog for each node of the
- Use the
EFM Cluster Namefield to specify the name of the Failover Manager cluster. The cluster name is the prefix of the name of the cluster properties file. For example, if your cluster properties file is named efm.properties, your cluster name is efm.
- Use the
EFM Installation Pathfield to specify the location of the Failover Manager binary file. By default, the Failover Manager binary file is installed in /usr/efm-2.1/bin.
After registering your servers, the
Streaming Replication Analysis
dashboard will display status information about your EFM cluster near
the bottom of the dashboard.
Failover Manager Cluster Status section of the Streaming Replication
Analysis dashboard displays information about the monitored cluster:
Failover Manager Cluster Information table provides information
about the Failover Manager cluster:
Propertiescolumn displays the name of the cluster property.
Valuescolumn displays the current value of the property.
Failover Manager Node Status table displays information about each
node of the Failover Manager cluster:
Agent Typecolumn displays the type of agent that resides on the node; the possible values are Master, Standby, Witness, Idle, and Promoting.
Addresscolumn displays the IP address of the node.
Agentcolumn displays the status of the agent that resides on the node.
DBcolumn displays the status of the database that resides on the node.
XLog Locationcolumn displays the transaction log location of the database.
Status Informationcolumn displays any error-related information about the node.
XLogInformation column displays any error-related information about the transaction log.
VIPcolumn displays the VIP address that is associated with the node.
VIP Statuscolumn displays True if the VIP is active for the node, False if the VIP is not.
Replacing a Master Node¶
You can use the PEM client to replace the Master node of a Failover Manager cluster with a standby node. To initiate the failover process, select Replace Cluster Master from the Management menu. A dialog opens, asking you to confirm that you wish to replace the current master node.
Yes to remove the current master node from the Failover Manager
cluster and promote a standby node to the role of read/write master node
within a Failover Manager cluster. The node with the highest promotion
priority (defined in Failover Manager) will become the new master node.
PEM will display a dialog, reporting the job status.
When the job completes and the Streaming Replication Analysis dashboard
refreshes, you can review the
Failover Manager Node Status table to
confirm that a standby node has been promoted to the role of master
within the Failover Manager cluster.