Seems that zabbix-agent-extension-mysql doesn't work correctly with MariaDB 10.4.
zabbix-agent-extension-mysql always returns "OK", even if replication is broken or in down state.
mysql -BNe "show grants for zabbix@localhost;"
GRANT PROCESS, SHOW DATABASES, REPLICATION CLIENT, SHOW VIEW ON . TO zabbix@localhost IDENTIFIED BY PASSWORD '****'
mysql -e "show slave status\G" | grep Running
Slave_IO_Running: No
Slave_SQL_Running: No
Seems that zabbix-agent-extension-mysql doesn't work correctly with MariaDB 10.4. zabbix-agent-extension-mysql always returns "OK", even if replication is broken or in down state.
zabbix-agent-mysql version: 20200228.15_04e8ed1 MariaDB version: 10.4.13 OS: Debian 10 buster
mysql -BNe "show grants for zabbix@localhost;" GRANT PROCESS, SHOW DATABASES, REPLICATION CLIENT, SHOW VIEW ON . TO
zabbix
@localhost
IDENTIFIED BY PASSWORD '****'mysql -e "show slave status\G" | grep Running Slave_IO_Running: No Slave_SQL_Running: No
/etc/zabbix/bin/zabbix-agent-mysql -n unix -m /tmp/mysql.sock --user zabbix --pass **** --discovery {"data":[{"{#TYPE}":"galera"},{"{#TYPE}":"slave"}]}
/etc/zabbix/bin/zabbix-agent-mysql -n unix -m /tmp/mysql.sock --user zabbix --pass **** --type slave OK