MK_mysql config with defaults-group-suffix

General
,
1

How is it possible to check multiple pxc/mysql instances on one cmk-agent?

Since ages there is a default-group-suffix option which allows to use different sections from mysql config file.

See MySQL :: MySQL 5.7 Reference Manual :: 4.2.2.3 Command-Line Options that Affect Option-File Handling

[clientDEV]
…
[clientQA]
…
[clientTEST]
…
[clientPROD]
…

How i can leverage this suffix feature in check_mk?
Or how you configure check_mk with multiple database instances on a cmk-agent?

2

It maybe related to this: Check_mk monitor multiple mysql instances

3

The socket marked with wildcards (*) is like an array. It can occur multiple times.
The solution was just to append more lines with socket=... to specify all instances.

What is not working with this semantics:

  • alias for each instance
  • different user/password for each instance

if you need such thing you need to modify the mk_mysql plugin file:
checkmk/mk_mysql at master · tribe29/checkmk (github.com)

4

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed. Contact an admin if you think this should be re-opened.