How do I start an auxiliary database cluster?

Purpose

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

 

Log in to an auxiliary database station as the root user.


Enter the following:

/opt/nsp/nfmp/auxdb/install/bin/auxdbAdmin.sh start ↵


The auxiliary database starts.


If the shields were raised in order to block external access to the auxiliary database ports, lower the shields by entering the following:

/opt/nsp/nfmp/auxdb/install/bin/auxdbAdmin.sh shieldsDown ↵


If the auxiliary database proxies were stopped, start them by performing the following:

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

  2. Enter the following to start the auxiliary database proxy services:

    systemctl start nspos-auxdbproxy.service ↵


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 started when each STATE entry reads UP.

End of steps