Level 8 - PrincipalDebugging Questionsm3 replication ha dr
Debug Failover Candidate Ordering
Fix SQL picking best candidate: SELECT node_id, lag_seconds FROM replica_health WHERE region='us-east' ORDER BY lag_seconds LIMIT 1 DESC;
Schema Context
replica_health(node_id, region, lag_seconds, is_healthy)