Hoping someone can help I am using the agent with the Zabbix mysql_agent2 template to monitor.
It is working, but I am not getting the Replication Monitoring. I verified that the zbx_monitor user in MySQL can do "show slave status" in the DB and it returns the normal status with the master host as one of the columns.
Has anyone been able to get this working?
It is working, but I am not getting the Replication Monitoring. I verified that the zbx_monitor user in MySQL can do "show slave status" in the DB and it returns the normal status with the master host as one of the columns.
Has anyone been able to get this working?
| MySQL | MySQL: Replication Slave SQL Running State {#MASTER_HOST} | This shows the state of the SQL driver threads. | DEPENDENT | mysql.slave_sql_running_state["{#MASTER_HOST}"] Preprocessing: - XMLPATH: /resultset/row[field/text()='Slave_SQL_Running_State']/field[@name='Value']/text() - DISCARD_UNCHANGED_HEARTBEAT: 6h |
| MySQL | MySQL: Replication Seconds Behind Master {#MASTERHOST} | The number of seconds that the slave SQL thread is behind processing the master binary log. A high number (or an increasing one) can indicate that the slave is unable to handle events from the master in a timely fashion. |
DEPENDENT | mysql.seconds_behind_master["{#MASTERHOST}"] Preprocessing: - XMLPATH: /resultset/row/field[@name='Seconds_Behind_Master']/text() - DISCARD_UNCHANGED_HEARTBEAT: 1h - NOT_MATCHES_REGEX: null ⛔️ON_FAIL: CUSTOM_ERROR -> Replication is not performed. |
Comment