Using mysql as backend database

General
,
1

can i use mysql database as a backend database for checkmk

2

Hi farhan,
what do you want to achieve?

If you’re talking about metrics, then there are ways to get them replicated/forwarded to someplace else.

3

Hi Simon

We are trying to install checkmk with MySQL as DB.
Can checkmk Active Active setup using mysql clustered database?

4

You didn’t understand my question.

Let me rephrase: What do you want to save inside this database?

If you insist on having MySQL for yet undisclosed reasons … there’s another open source monitoring software out there using a RDBMS (MySQL included)

5

Hi Simon
Sorry for my earlier responded. Inside the database I want to save all the checkmk logs.
Additional question
since checkmk by default use rrd, can we cluster the rrd?

6

Hi @farhan and welcome to the community!

Simple and short answer: No as @simon-mueller already told you. :slight_smile:
The Checkmk Software architecture does not allow something like this, plus it wouldn’t make sense from an engineering or technical point of view. You don’t win anything if you just slap a MySQL database onto something.

A MySQL Database shouldn’t be used as a log storage, and there is no out of the box solution for that. You can achieve this better with a Syslog server software. I don’t see the benefit, maybe you can elaborate on this and be a bit more specific about it.

Round Robin Databases are not your typical relational databases. They are pretty much files with a certain structure for performance data. You can read more about them here: Measured values and graphing - Evaluating measured values in Checkmk quickly and easily

So the answer is no. You cannot cluster a RRD itself. You could cluster Checkmk Server with the Appliances from Checkmk.

Please be a bit more specific on the goals you want to achieve, so we can help you better in the first place. :slightly_smiling_face:

Looking forward to your reply.
Norm

2 Likes
7

I still don’t know what logs exactly you’re talking about. Events(windows eventlog, syslog, snmptraps)?

You talk about RRDs: those are the metrics to your checks, they can be stored eg. in InfluxDB:

If you’re worried about your (WATO-)configuration getting lost, you can always activate git and create a post-deploy hook to push your changes to a central repo.

1 Like
8

Actually on my test lab i have Galera Cluster. So what I’m trying to do is to forward/replicated data that been generate by checkmk to my Galera.
Please advice

9

As @Norm already pointed out, there are (NoSQL) databases that are way better suited.

1 Like
10

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.