MySQL DB Sync — Ops Dashboard

{ "nodes_online": 2, // 0–2, based on failover flags "active_failovers": 0, // count of nodes in failover "failover_a2": false, // true if A2 is down "failover_local": false, // true if LocalDB is down "wf_active": 3, // workflows with status=success "records_synced": 5, // sync_log success row count "triggers": { "full_sync": "success", // WF1 (A2→Local nightly) last status "a2_to_local": "success", // WF2 last status "local_to_a2": "success", // WF3 last status (NEW direction) "health_check":"ok" // WF4 current state }, "last_synced": { "full_sync": "2026-05-21T02:00:05Z", "a2_to_local": "2026-05-21T14:15:03Z", "local_to_a2": "2026-05-21T14:15:04Z" }, "generated_at": "2025-05-21T14:32:00Z" }

SELECT workflow_name, table_name, last_synced_at, status, notes FROM sync_log ORDER BY last_synced_at DESC;

-- Runs on whichever DB is connected (A2 or Local) — no hardcoded name. SELECT table_name, table_rows AS est_rows FROM information_schema.tables WHERE table_schema = DATABASE() AND table_type = 'BASE TABLE' ORDER BY table_rows DESC;

-- Pick a table from the schema browser below SELECT COUNT(*) AS new_records FROM `orders` -- change to any table that has updated_at WHERE updated_at >= NOW() - INTERVAL 1 HOUR;

-- Valid workflow_name values (v3.1): full_sync, a2_to_local, local_to_a2, -- health_check, reconciliation, repair SELECT table_name, MAX(last_synced_at) AS last_sync, TIMESTAMPDIFF(MINUTE, MAX(last_synced_at), NOW()) AS lag_minutes FROM sync_log WHERE workflow_name = 'a2_to_local' -- WF2 incremental A2->Local GROUP BY table_name ORDER BY lag_minutes DESC;

SELECT t.table_name FROM information_schema.tables t LEFT JOIN information_schema.columns c ON t.table_schema = c.table_schema AND t.table_name = c.table_name AND c.column_name = 'updated_at' WHERE t.table_schema = DATABASE() AND t.table_type = 'BASE TABLE' AND c.column_name IS NULL ORDER BY t.table_name;