Sometimes a restart of the database process is required. There are several ways to do this.
If you are running ClustrixDB 7.5 or later you can use the clx tool to easily restart the database. The following command run from a single node will stop and start the database process on every node on the cluster:
In ClustrixDB version 7.0 or earlier use the nanny process via the clx tool to stop and start the database. The following commands run from a single node will stop and start the database process on every node on the cluster:
/opt/clustrix/bin/clx nanny 'stop_job krobix'/opt/clustrix/bin/clx nanny 'start_job krobix'
To only stop and start a single node you can use the argument "-nN" where N is the NID of the node to effect.
ClustrixDB 7.5 Example:
/opt/clustrix/bin/clx -n1 dbrestart
ClustrixDB 7.0 Example:
/opt/clustrix/bin/clx -n1 nanny 'stop_job krobix'
In the event that you want to completely stop all Clustrix processes on a node use initctl. This will stop and start all the Clustrix processes on the node that the command is run from.
initctl stop clustrix
initctl start clustrix
This method can be used in conjunction with the clustrix clx tool to stop/start Clustrix on the entire cluster.
/opt/clustrix/bin/clx cmd 'initctl stop clustrix'
Using initctl to stop the database while under heavy load not advisable as this can cause inflight transaction to be rolled back and may increase database startup time.