How can zabbix monitor the status of replications on the server?

R

Reikoemco2019-02-20 16:13:57

MySQL

Reikoemco, 2019-02-20 16:13:57

Good afternoon.
There are several servers from which databases are replicated to one server.
Master servers use mysql 5.0
Slave server - mariadb 10.3
How can I monitor each slave according to the parameters slave_sql , seconds behind master and slave_io and so that zabbix understands which slave is being dumped?
Does anyone have similar templates? Tried to do something on this guide

spoiler

https://serveradmin.ru/monitoring-mysql-replikatsi...

, but the replication not running trigger just works for me, when it seems to work and everything is in order everywhere
Help

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

V

Vladimir, 2019-02-20
@MechanID

make a script -
which should run mysql -e "show slave status\G"
output check for:
Slave_IO_Running:Yes
Slave_SQL_Running: Yes
Seconds_Behind_Master: 0
optional - that Exec_Master_Log_Pos: greater than last check (depends on write intensity on master)