zabbix-agent-extension-mysql

zabbix-agent-extension-mysql - this extension for monitoring mysql.

Supported features

This extension obtains stats of three types:

Global stats

• Aborted clients
• Aborted connects
• Bytes received
• Bytes sent
• Com begin
• Com commit
• Com delete
• Com insert
• Com rollback
• Com select
• Com update
• Innodb rows deleted
• Innodb rows inserted
• Innodb rows read
• Innodb rows updated
• Queries
• Slow queries
• Threads running
• Uptime

Process stats

• Processlist count
• Max query time

Galera stats

• Galera cluster size
• Galera cluster state uuid
• Galera cluster status
• Galera connected
• Galera internal state EVS Protocol
• Galera cluster gcom uuid
• Galera local state
• Galera local state comment
• Galera local state uuid
• Galera protocol version
• Galera provider name
• Galera ready

Slave stats

• Mysql io running
• Mysql sql running
• Mysql Seconds behind master
• Mysql master host
• Mysql master port

Installation

Manual build

# Building
git clone https://github.com/zarplata/zabbix-agent-extension-mysql.git
cd zabbix-agent-extension-mysql
make

#Installing
make install

# By default, binary installs into /usr/bin/ and zabbix config in /etc/zabbix/zabbix_agentd.conf.d/ but,
# you may manually copy binary to your executable path and zabbix config to specific include directory

Arch Linux package

# Building
git clone https://github.com/zarplata/zabbix-agent-extension-mysql.git
git checkout pkgbuild

makepkg

#Installing
pacman -U *.tar.xz

Requirements

Add mysql users:

GRANT REPLICATION CLIENT,PROCESS ON *.* TO 'zabbix'@'127.0.0.1'  IDENTIFIED BY 'zabbix';

Dependencies

zabbix-agent-extension-mysql requires zabbix-agent v3.4+ to run.

Zabbix configuration

In order to start getting metrics, it is enough to import template and attach it to monitored node.

WARNING: You must define macro with name - {$ZABBIX_SERVER_IP} in global or local (template) scope with IP address of zabbix server.