Bug #34900 Add Global Status on the MEM replication page to show all Seconds Behind Master

Submitted: 27 Feb 2008 18:20 Modified: 30 Jun 2009 14:09
Reporter: Chris Calender Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Enterprise Monitor: Server Severity:S4 (Feature request)
Version:2.0.5.7153 OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: MySQL Enterprise Monitor, Seconds Behind Master

[27 Feb 2008 18:20] Chris Calender
Description:
If you have many replication trees, when the trees are not opened, one cannot see the "Time Behind" (or Seconds Behind Master).  With this many replication trees, it becomes unmanageable to open each tree every time to check these values.

It would be nice if there was an easier way to detect and see this information rather than having to open each tree first.

For example, if we could add a global status for this on the MEM replication page, it would save a good amount of time, and make this really easy to check.  

For instance, we could output the following:

Servers Type Slave IO Slave SQL Time Behind Binlog Binlog Pos Master Binlog Master Binlog Pos Last Error 
GLOBAL-REP (2) TREE Running Running __2servers_critical_behind__ rename group

If we had something like the above, one could easily see if the status of the replication of all trees is okay or not.

How to repeat:
N/A

Suggested fix:
See above.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.058 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.