Use some schema (post-send lazy loading and local memcached) to check slave vs master position/timestamp instead of only using the Mysql slave lag functions which only check the slaves application lag (not the full relay lag).
Apparently we have pt-heartbeat set up, and it would be nice to use something like that.We rely on the stock mysql SHOW STATUS functions to detect slave lag, We can write a LoadMonitor subclass that does thatbut these only give log -> DB lag not the "lag behind master DB".
A few possibilities:
a) We have pt-heartbeat set up, and it would be nice to use something like that. We can write a LoadMonitor subclass that does that. I'd prefer this.
b) Use some schema (post-send lazy loading and local memcached) to check slave vs master position/timestamp instead of only using the Mysql slave lag functions which only check the slaves application lag (not the full relay lag).
Also make sure the read only mode triggers when remote DC slaves are lagged too.