Re: How to monit mariadb

[Paul Theodoropoulos]

Hi Tino,

You didn't provide any details on how specifically it is failing. Does monit say it's not running, or does monit ignore the status and always thinks it's running whether it is or not? Is the PID saved in the same subdirectory of /run/?

On 3/20/19 14:39, Tino Hendricks wrote:

Dear list,

I upgraded one (gentoo) server  from mysql-5.7.24 to mariadb-10.1.37 and since then I’m not able to check it's running.

monit 5.25.3 Config is unchanged:
check process mysqld with pidfile /run/mysqld/mysql.pid
        group database
        start program = "/etc/init.d/mysql restart" with timeout 30 seconds
        stop program = "/etc/init.d/mysql stop"
        if failed host localhost port 3306 protocol mysql for 3 times within 5 cycles then alert
	if cpu > 7% for 2 cycles then alert


Port is open:
~ # netstat -ln | grep 3306
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN

Process is running:
 ~ # ps aux | grep mysql
mysql    11281  1.6  0.1 2610924 456172 ?      Ssl  12:53   9:25 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf
root     14224  0.0  0.0  11192   968 pts/3    S+   22:37   0:00 grep --colour=auto mysql

I am out of ideas and grateful for a little hint.

Thanks

Tino

-- 
Paul Theodoropoulos
www.anastrophe.com