Check_mk monitor multiple mysql instances

[rezizter]

Hi

We have 3 instances of Mysql running on a single server, running on port 4001, 4002 and 4003

We have check_mk 1.6.0.p13 with the mysql plugin working

we have the following configuration

/etc/check_mk/mysql.cfg

[client]
user=monitoruser
password=*********
host=127.0.0.1
port=4001
socket=/data/4001/mysql01/mysql.sock
[client]
user=monitoruser
password=*********
host=127.0.0.1
port=4002
socket=/data/4002/mysql02/mysql.sock
[client]
user=monitoruser
password=*********
host=127.0.0.1
port=4003
socket=/data/4003/mysql03/mysql.sock

However check_mk only picks up the last instance (4003)

How can we monitor all 3 instance?

[marco]

The way I solved this was I had to modify the agent side plugin so that the plugin output could be generated for my 4 MYSQL instances running on the single server. I had one more problem : the mysqldadmin and mysql binary were not available as root user. It were available as the instance user.So, I had to modify this as well.

So, you can do few things to get this working:

1. If you have a Dev/Inte/QA server that you can try on that first
2. Create a copy of the original mk_mysql plugin in the plugins folder and then remove the execute permissions of the original plugin and then you need to debug the plugin. As I have no idea what is your Mysql setup? I won’t be able to tell you much.