Re: How to monit mariadb

[Tino Hendricks]

Paul, Viktor,

thank you very much for reminding me that I obviously missed the most important 
part, sorry.

Here’s the log:
[CET Mar 20 22:14:27] info     : ’server' Monit 5.25.3 started
[CET Mar 20 22:14:27] error    : 'mysqld' process is not running
[CET Mar 20 22:14:27] info     : 'mysqld' trying to restart
[CET Mar 20 22:15:28] error    : 'mysqld' process is not running
[CET Mar 20 22:15:28] info     : 'mysqld' trying to restart
[CET Mar 20 22:16:28] error    : 'mysqld' process is not running
[CET Mar 20 22:16:28] info     : 'mysqld' trying to restart
[CET Mar 20 22:17:28] error    : 'mysqld' process is not running
[CET Mar 20 22:17:28] info     : 'mysqld' trying to restart
[CET Mar 20 22:18:16] info     : 'mysqld' unmonitor on user request

And pid-file exists with the same permissions as on the other, still mysql 
servers:
 ~ # ls -l /run/mysqld/mysqld.pid
-rw-rw---- 1 mysql mysql 6 20. Mär 12:53 /run/mysqld/mysqld.pid

httpd listing (monitoring temporarily disabled):
 Parameter Value
   Name mysqld
   Pid file /run/mysqld/mysql.pid
   Status Not monitored
   Group database
   Monitoring status Not monitored
   Monitoring mode active
   On reboot start
   Data collected Thu, 21 Mar 2019 08:41:18
   Existence If doesn't exist then restart
   Port If failed [127.0.0.1]:3306 type TCP/IP protocol MYSQL with timeout 5 s 
for 3 times within 5 cycles
   then alert
   CPU usage limit If greater than 7.0% for 2 cycles then alert

Thanks again for thinking about it!

Tino

> Am 20.03.2019 um 22:43 schrieb Paul Theodoropoulos <address@hidden>:
> 
> 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