Last modified: 2014-08-14 17:54:41 UTC
I am creating this bug at the request of springle. It will be very useful to be able to consult replication lag on a table with wide access. The analytics team has nightly reports that compute stats for the day. If replication lag is too high there might not be any data for that day, thus teh report will look "artifically" empty. We could monitor timestamps of data but it will be much more useful to have a table we could consult with replication lag data before our daily run, if the lag is too high the run will just not happen. Our software backfills so if today's run is skipped we will log the issue and tomorrow's run can backfills today data if issue is resolved.
We schedule reports by project and i imagine replication will reported per host, not per project so a global measure of how replication is working on the labs cluster will be sufficient for us.
Please note that this table needs to exist on the labs side, not on the production side.