Data Warehouse Monitoring with Icinga 2
summary
Practical setup for monitoring a data warehouse using Icinga 2 and Icinga Web 2, storing time series in Graphite/Whisper and using the Icinga web graph module. Uses check_mysql_query against Talend/DataStage log tables, NRPE remote checks (not just SNMP), plus basic CPU/memory/disk/load plugins; demonstrates configs, live demo, and usable alert thresholds while highlighting problems like missing DB indexes, short ETL jobs missed by long check intervals, and excessive/frequent queries overloading the database.
AI-written summary · about
chapters (8)
- 0:00Data warehouse intro
- 1:49Monitoring pain points
- 7:31Why Icinga 2
- 12:58Key DW checks
- 18:19Live monitoring demo
- 24:51ETL jobs and queries
- 30:26Summary
- 31:29Q&A
related talks
46mWhy favour Icinga over
29mHow Companies use Icinga
24mIcinga as aggregation tool
34mEnhancing Visualization in IcingaWeb2: From Markdown to Metrics
24mDevOps. Monitoring Databases. On-Premise and Cloud environments
38mMonitoring 101
43mWindows Monitoring 3.0 – Now More Than Ever!
38mInfrastructure Monitoring Basics with Telegraf, Grafana and InfluxDB