SQL Practice Logo

SQLPractice Online

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)