Measure replication lag with a heartbeat table

-- on the primary, every second
REPLACE INTO heartbeat (id, ts) VALUES (1, NOW(6));

-- on the replica: wall-clock staleness, which cannot be fooled
SELECT TIMESTAMPDIFF(MICROSECOND, ts, NOW(6)) / 1000 AS lag_ms
FROM heartbeat WHERE id = 1;