Verify Database Status

Database Health

Purpose

To ensure that the database is in healthy state

Procedure

    1. Log in on any unified node (multinode unified topology) / database node (modular cluster topology).

  1. Run the following command:

    database config

  2. Verify that the stateStr of each node is one of the following values:

    • stateStr: PRIMARY

    • stateStr: ARBITER

    • stateStr: SECONDARY

Step to Resolve

If any node has a stateStr not listed above, contact VOSS L2 helpdesk. Provisioning must not take place if any of the database nodes are in STARTUP, STARTUP2 or RECOVERING state.

Primary Database

Purpose

To ensure the primary database is the correct node

Procedure

    1. Log in on any unified node (multinode unified topology) / database node (modular cluster topology).

  1. Run the following commands:

    database primary

    and

    cluster run database database primary

  2. Ensure the IP address matches the intended primary database expected.

Steps to Resolve

If a failover has occurred for any reason and the primary database has changed from what is expected, refer to the “Check General Cluster Health” section.

Database Weights

Purpose

Database weights are used to determine how a new primary node is elected in the event of database primary node failover. Although any values can be used, for 4 database nodes the weights: 40/30/20/10 is recommended and for 6 database nodes, 60/50/40/30/20/10. These numbers ensure that if a reprovision happens (when the primary data center goes offline for an indeterminate time), the remaining nodes have weights that will allow a new primary to be chosen.

Procedure

    1. Log in on any unified node (multinode unified topology) / database node (modular cluster topology).

  1. Run the following commands:

    database config

  2. Verify that weights are set with highest numbers in primary Data Center (DC), and lesser weights in secondary DC.

Steps to Resolve

Fix database weights to have the highest numbers at primary DC.