Technical Overview

Tue, 2022-06-21 16:48 — Shinguz

The FromDual Performance Monitor for MariaDB and MySQL (fpmmm) will be hooked into the Zabbix Agent (zabbix_agentd).
It consists of:

The Monitor program itself (bin/fpmmm) which controls the other modules and its own module (FromDual_agent.inc)
A Template for the FromDual Performance Monitor Configuration File (tpl/fpmmm.conf.template)
And several different modules for monitoring MariaDB/MySQL (lib/FromDual_*.inc)

The FromDual Performance Monitor Architecture looks as follows:

Modules

The FromDual Performance Monitor Agent is split into several different Modules. For every Module there is a:

Each module is for its own specific purpose. Available modules are:

aria	Module to monitor the Aria Storage Engine status variables.
data	Module to monitor database data growth.
drbd	Module to monitor DRBD device status information.
errorlog	Module to monitor the database Error Log.
fpmmm^*	Module to monitor the `fpmmm` Agent itself. This module is mandatory because it triggers the send process.
galera	Module to monitor Galera Cluster.
innodb	Module to monitor the InnoDB Storage Engine status variables.
master	Module to monitor a Replication Master in a MariaDB/MySQL Master/Slave Replication.
memcached	Module to monitor MemcacheD services.
myisam	Module to monitor the MyISAM Storage Engine status variables.
mysql	Module to monitor general MariaDB/MySQL status variables.
process	Module to monitor all kinds of Linux Processes (`mysqld`, etc.)
security	Module to monitor security rules.
server	Module to monitor a Linux machine (additional items related to database use).
slave	Module to monitor Replication Slaves in a MariaDB/MySQL Master/Slave set-up.
smart	Module to query some S.M.A.R.T metrics.
user	Module to monitor user behaviour.

^* Required modules