How do I stop an auxiliary database cluster?

Purpose
CAUTION 

CAUTION

Service disruption

Stopping an auxiliary database cluster may be service-affecting.

Perform the procedure only if required, and only during a scheduled maintenance period.

Note: In a geo-redundant auxiliary database, stopping the primary cluster will cause the standby cluster to be activated. If this behaviour is not desired, you must stop the proxy on the standby auxiliary database stations first.

If you do not know which cluster is currently the primary cluster, perform How do I check the auxiliary database status?.

Perform this procedure to stop the auxiliary database software on all stations in an auxiliary database cluster, for example, for maintenance purposes.

 
1 

If the NSP deployment does not include the NFM-P, go to Step 4.

2 

Perform the following steps on each NFM-P auxiliary server station to stop the server.

  1. Log in to the station as the nsp user.

  2. Open a console window.

  3. Enter the following:

    bash$ cd /opt/nsp/nfmp/auxserver/nms/bin ↵

  4. Enter the following:

    bash$ ./auxnmsserver.bash auxstop ↵

  5. Enter the following to display the auxiliary server status:

    bash$ ./auxnmsserver.bash auxappserver_status ↵

    The server status is displayed; the server is fully stopped if the status is the following:

    Auxiliary Server is stopped

    If the server is not fully stopped, wait five minutes and then repeat this step. Do not perform the next step until the server is fully stopped.

3 

Perform the following steps on each NFM-P main server station to stop the server.

Note: In a redundant system, you must perform the steps on the standby main server first.

  1. Log in to the station as the nsp user.

  2. Open a console window.

  3. Enter the following:

    bash$ cd /opt/nsp/nfmp/server/nms/bin ↵

  4. Enter the following

    bash$ ./nmsserver.bash stop ↵

  5. Enter the following to display the NFM-P server status:

    bash$ ./nmsserver.bash appserver_status ↵

    The server status is displayed; the server is fully stopped if the status is the following:

    Application Server is stopped

    If the server is not fully stopped, wait five minutes and then repeat this step. Do not perform the next step until the server is fully stopped.

4 

Log in as the root user on each auxiliary database station in the cluster.

5 

Enter the following to stop the auxiliary database proxy services:

# systemctl stop nspos-auxdbproxy.service ↵

6 

Log in to any auxiliary database station in the cluster as the root user.

7 

Enter the following to block external access to the auxiliary database ports:

# /opt/nsp/nfmp/auxdb/install/bin/auxdbAdmin.sh shieldsUp ↵

8 

Enter the following:

# /opt/nsp/nfmp/auxdb/install/bin/auxdbAdmin.sh stop ↵

You are prompted to enter the database administrator user's password.

9 

Enter the password.

10 

Enter the following to display the auxiliary database status:

# ./auxdbAdmin.sh status ↵

Information like the following is displayed:

Database status

 Node       | Host          | State | Version | DB

------------+---------------+-------+---------+-------

 node_1     | internal_IP_1 | STATE | version | db_name

 node_2     | internal_IP_2 | STATE | version | db_name

.

.

.

 node_n     | internal_IP_n | STATE | version | db_name

      Output captured in log_file

The cluster is stopped when each STATE entry reads DOWN.

Note: If the cluster is not stopped, enter the following to force the auxiliary database to stop, entering the database administrator user's password when prompted.

# ./auxdbAdmin.sh force_stop ↵

11 

Close the console windows.

End of steps