Safely stopping Spectrum mysql database when processd has shut down

Products

• Network Observability
• Spectrum

Issue/Introduction

There are times when, for a variety of possible reasons, processd has shut down without properly stopping the services it started.

One scenario might be an install run failure that leaves mysql started by the installer instead of processd, and no functional processd to use to stop it.

Environment

All supported Network Observability DX NetOps Spectrum releases

Cause

MySql left running without a functional processd services to help shut it down.

Resolution

To stop the MySQL service without a running processd take the following steps. 

• Windows
  
  • Go to this directory:
    • cd $SPECROOT/mysql/bin/
  • Run the following to stop MySql.
    • mysqladmin.exe -uroot -p<password> shutdown
• Linux
  
  • Go to this directory:
    • cd $SPECROOT/mysql/bin/
  • 
    Run the following to stop MySql.
    • ./mysqladmin --defaults-file=../my-spectrum.cnf -uroot -p<password>  shutdown

To restart MySql properly start processd which should restart it.

Additional Information

Steps to stop MySql when processd is still running and functional are as follows.

• Windows:
  • Go to the following directory:
    • cd $SPECROOT/bin/
  • Run the following, replacing <hostname> with the servers hostname.
    • cmdC.exe <hostname> 2 MYSQL
    • Using localhost like this example may work.
      • cmdC.exe localhost 2 MYSQL 
• Linux:
  • Go to the following directory:
    • cd $SPECROOT/bin/
  • Run the following, replacing <hostname> with the servers hostname.
    • ./cmdC <hostname> 2 MYSQL
    • Using localhost like this example may work.
      
      • ./cmdC localhost 2 MYSQL