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.