Re: How to monit mariadb

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

-- 
To unsubscribe:
https://lists.nongnu.org/mailman/listinfo/monit-general