On one of our processing nodes, when we check the status of the MySQL DB, it shows the database isn't running.
API Gateway: 9.3
First, check the following:
1. the ssg log for any outstanding MySQL errors 2. the /var/log/mysqld.log for any outstanding MySQL errors 3. make sure the /var/lib/mysql directory isn't full 4. make sure the permissions on the /var/lib/mysql directory, files and sub-directories are set properly
If everything above checks out, run the following command:
mysqld_safe --user=root &
After a few seconds, you can hit CTRL +C to break out of the command and check the status of the MySQL DB.