Zabbix Conference 2014 - Steve Mushero | SHORT TALK: Loving the Zabbix Database

All about the internals of the Zabbix database, tables, statuses, relationships, and how we use SQL every day to cross-check data, find missing elements, answer questions, track the queue, do housekeeping, special auto discovery, and much more. I will cover the 10-20 reports we use daily to validate our large Zabbix system, which has new hosts and configuration changes every day. I will also describe how we created a new useful audit system to find who changed what and when with lookups by common elements. Plus, how we extended the DB a little to integrate into our ticket and other real-time systems. And, Zabbix 2.2 ER diagram from MySQL WorkBench.