in mysql we can run SHOW SLAVE STATUS, in a replica connection, and then use Seconds_Behind_Master to get the replica lag, if any. If the replica lag is high enough, we can failover to master.

https://dev.mysql.com/doc/refman/8.0/en/show-slave-status.html