Broadcom API Gateway - Why MySQL is running in safe mode all the time?

Products

• CA API Gateway

Issue/Introduction

Some customer have concern about MySQL running in safe mode.  

 

Environment

Broadcom API Gateway 9.x Appliance

Cause

As shown in below screenshot, there should be two instance of mysql and running, mysqld and mysqld_safe.

mysqld is the server binary and mysqld_safe is a "launcher" script for mysqld.

This is perfectly normal and is the way MySQL should run in Linux/Unix system, in fact mysqld_safe is the recommended way to start a mysqld server on Unix/linux. mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. 

 

Resolution

It is expected and is running as per Oracle design.

Additional Information

Reference: 

MySQL 5.x - https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html

MySQL 8.x - https://dev.mysql.com/doc/refman/8.0/en/mysqld-safe.html