Auto Restart MySQL, mysqld : Wrong Concepts

Actually we have discussed it for WordPress Database Connection Error. MySQL, Percona, MariaDB Will Restart on Failure With Configured my.cnf. Wrong Concepts Around Auto Restart MySQL, mysqld are discussed in this guide plus needed my.cnf configuration shown. These two questions are frequently asked :

 

1. Is there an option to automatically restart MySQL after a crash?
2. Is there any script for automatic restart of the MySQL after a crash?

 

Auto Restart MySQL, mysqld : Wrong Concepts

 

MySQL, Percona, MariaDB – all basically same at this part. All has auto-restart system if installed from repo. At least for Deb GNU/Linux (Debian, Ubuntu) we have never seen any problem. Your concept is wrong – if mysqld crashed then mysqld_safe would restart it automatically because mysqld_safe is the control script. Provided that, your my.cnf looks right and restarted msqld / MySQL normally like :

that is what written here for mysqld_safe :

Basically, by default, at my.cnf under [mysqld_safe], all needed are not present, socket, PID if not present, probably mysqld can not restart on crash (I am not MySQL database expert) :

In real life – you really never need an external script to restart MySQL. Yeah, the above thing kill keep MySQL server up but, it may still die at some action when you’ll perform. It is unlikely to fail to restart on a well tuned my.cnf.

Restart mysql after the changes (if you need) :

If still your MySQL do not auto-restart, then read the next sub header.

 

Auto Restart MySQL, mysqld : Check Your Error Log

 

Where is your error log, that you’ll know!. Suppose log is at /var/log/mysqld.log, then cat it :

Here is an example of error with huge output, this is real example.

In the log, there is clear history of crushes :

You need to fix the error of your error log. Your database may be corrupted or my.cnf has wrong settings, that is not getting restarted.

Tagged With mysql restart , can mysql be setup to auto restart on failure , mysql auto restart , mysql Restart=on-failure

This Article Has Been Shared 711 Times!

Facebook Twitter Pinterest