Building a Monitoring Dashboard for Multi-Site Video Platforms

When you run multiple video sites across different servers, monitoring is essential. Here's how I built a lightweight monitoring dashboard for TrendVidStream and its sister sites. What to Monitor For a multi-site video platform, the critical metrics are: Site availability - Is each site responding? Content freshness - When was the last successful fetch? Database health - SQLite integrity and size API quota - YouTube API usage Cache hit rates - Are caches working? Performance - PageSpeed scores over time Health Check Endpoint Each site exposes a /health endpoint: <?php // health.php header ( 'Content-Type: application/json' ); header ( 'Cache-Control: no-cache' ); $db = new PDO ( 'sqlite:' . __DIR__ . '/data/app.db' ); // Check database $dbOk = false ; try { $result = $db -> query ( 'PRAGMA integrity_check' ) -> fetchColumn (); $dbOk = ( $result === 'ok' ); } catch ( Exception $e ) { $dbOk = false ; } // Get last fetch time $lastFetch = $db -> query ( "SELECT MAX(fetched_at) FROM videos