Zabbix extension for monitoring mysql/galera/slave. Popular
Zabbix extension for monitoring mysql.
Feature:
- 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
Manual build
git clone https://github.com/zarplata/zabbix-agent-extension-mysql.git
cd zabbix-agent-extension-mysql
make
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.
Import Template_App_MySQL.xml and link with host.
Add mysql users:
GRANT REPLICATION CLIENT,PROCESS ON *.* TO 'zabbix'@'127.0.0.1' IDENTIFIED BY 'zabbix';
You must define macro with name - {$ZABBIX_SERVER_IP} in global or local (template) scope with IP address of zabbix server.
Listing Details
Type
Min Zabbix version
3.4.x
Created
Modified
Author
zarplata.ru
Owner