Database Monitoring
Database Monitoring
The goal of this course is to fully explain DBMS monitoring concepts and approaches, and provide practical knowledge of configuring DBMS monitoring with Zabbix. The course covers various Zabbix native approaches to collect DBMS performance metrics and collect DBMS-related data using Zabbix Agent 2, ODBC and API requests. The course also covers optimizing DBMS data collection by introducing dependent Low-level discovery for minimal DBMS performance impact.
During the course, students will practice configuring DBMS monitoring for such DBMS as MySQL, MariaDB, PostgreSQL, MongoDB, Redis, InfluxDB and Elasticsearch.
Acquired skills and knowledge
- Automatically discover and start collecting DBMS performance metrics from various database engines representing the most popular vendors
- Get an in-depth look at how DBMS metrics are exposed and collected
- Learn how to troubleshoot DBMS data collection issues
- Optimize DBMS data collection by implementing custom queries and bulk data collection
- Collect custom data from both SQL and NoSQL databases by using different Zabbix data collection approaches
Certificates
There is no exam after the course, but every attendee gets an official Zabbix certificate.
Training program
- Introduction to various DBMS
- Database monitoring using ODBC
- Additional database monitoring methods
- Database monitoring basics
- Database monitoring using encryption
- Performance impact
- Database monitoring using Zabbix agent 2
- Database monitoring with dependent LLD