How do I set up ZabbixDBA to monitor a PostgreSQL database?

First, install Perl with DBD::Pg module. Then, configure ZabbixDBA with PostgreSQL connection details and define custom queries, as templates are Oracle-only. Check the Wiki for configuration examples.

Is ZabbixDBA better than using Zabbix's native database monitoring?

ZabbixDBA offers threaded connections for efficient multi-instance monitoring, while native Zabbix may be slower. However, it adds complexity with Perl dependencies and is best for hybrid RDBMS environments.

Can ZabbixDBA monitor NoSQL databases like MongoDB?

No, ZabbixDBA is designed for relational databases via Perl DBI. For NoSQL, you'd need alternative monitoring tools or extensive custom Perl scripting, which isn't straightforward.

What are the performance implications of ZabbixDBA's threading?

Threading allows simultaneous connections to multiple databases, improving scalability. However, it requires sufficient server resources and proper configuration to avoid bottlenecks in high-load scenarios.

How to add custom queries for monitoring specific database metrics?

Edit the configuration file to include your SQL queries, then map them to Zabbix items in the template. The Wiki provides guidance, but it requires SQL and Zabbix knowledge.

Is ZabbixDBA compatible with Zabbix 6.0 or newer versions?

The README doesn't specify, but since it uses standard Zabbix methods, it likely works. Always test with your Zabbix version and refer to GitHub issues for updates.

ZabbixDBA

MITPerlv3.1.0

A fast, flexible service for monitoring multiple RDBMS instances (Oracle, PostgreSQL, MySQL, etc.) with Zabbix.

GitHub

What is ZabbixDBA?

ZabbixDBA is a monitoring service that integrates with Zabbix to track performance and health metrics across multiple relational database systems like Oracle, PostgreSQL, and MySQL. It solves the problem of fragmented database monitoring by providing a unified, automated solution for database administrators.

Target Audience

Database administrators, DevOps engineers, and IT teams managing multiple RDBMS instances who need centralized monitoring and alerting via Zabbix.

Value Proposition

Developers choose ZabbixDBA for its threaded connection handling, which allows simultaneous monitoring of many databases, and its flexibility via Perl DBI, supporting a wide range of database systems without vendor lock-in.

Overview

Zabbix Database Monitoring Service (Oracle, Pg, MySQL, MS SQL, DB2, etc.)

Use Cases

Best For

Monitoring Oracle database performance metrics in enterprise environments
Centralizing PostgreSQL and MySQL monitoring with Zabbix integration

Related Projects

Community-curated · Updated weekly · 100% open source

Found a gem we're missing?

Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.

Submit a project Star on GitHub

101 stars56 forks0 contributors

Tracking health of multiple RDBMS instances across distributed systems

Automating database alerting and performance dashboards

Extending Zabbix with custom database queries and templates

Managing hybrid database environments (e.g., Oracle, MS SQL, and DB2)

Not Ideal For

Projects not using Zabbix as their monitoring platform, as ZabbixDBA is tightly integrated with Zabbix.
Teams needing immediate out-of-the-box monitoring for PostgreSQL or MySQL without custom configuration, since templates are currently Oracle-focused.
Organizations preferring SaaS-based or web-GUI monitoring solutions, as ZabbixDBA is a command-line service requiring manual setup.
Environments with strict no-Perl policies, due to its dependency on Perl DBI and modules.

Pros & Cons

Pros

Broad RDBMS Support

Uses Perl DBI to monitor Oracle, PostgreSQL, MySQL, MS SQL, DB2, and more, as listed in the README, providing flexibility across diverse database environments.

Efficient Multi-Instance Handling

Implements threaded connections to monitor multiple database instances simultaneously, enhancing performance for distributed or high-volume monitoring tasks.

Lightweight and Configurable

Designed for simplicity and extensibility, allowing easy customization of metrics and queries without heavy overhead, as emphasized in the project philosophy.

Tested Compatibility

Verified with Oracle, PostgreSQL, and MySQL, ensuring reliable performance for these common databases, as stated in the README.

Cons

Oracle-Centric Defaults

Currently only includes pre-built templates and query sets for Oracle, requiring manual effort to set up other databases, which the README explicitly admits.

Perl Dependency Barrier

Requires installation of Perl and specific DBD modules, which can be complex for teams not versed in Perl or in environments where Perl is not standard.

Limited Non-Zabbix Use

Specifically designed for Zabbix integration, lacking built-in support for other monitoring systems like Prometheus, creating vendor lock-in for Zabbix users.

Frequently Asked Questions

Home

Database Tools

Mamonsu

mamonsu is a monitoring agent specifically designed for PostgreSQL, providing comprehensive collection of database and operating system metrics. It integrates seamlessly with Zabbix, offering a robust solution for database administrators to monitor PostgreSQL health and performance. The agent is built with a plugin architecture, allowing for extensibility and customization to meet specific monitoring needs. ## Key Features - **Active Agent** — Sends collected metrics directly to the Zabbix server, minimizing performance impact on the monitored PostgreSQL instance. - **Comprehensive Metrics** — Collects approximately 90 PostgreSQL-specific metrics (e.g., connections, locks, WAL, checkpoints) and 40 system metrics (e.g., CPU, memory, load average). - **Zabbix Integration** — Generates and uploads Zabbix templates complete with pre-configured screens, dashboards, triggers, and graphs for immediate visualization. - **Plugin Architecture** — Written in Python 3 with a modular plugin system, enabling users to create custom plugins for additional metrics. - **Cross-Platform Support** — Runs on Linux, FreeBSD, and Windows, supporting PostgreSQL versions 12 through 18 and Zabbix server versions 4.0.44 to 6.4.13. - **Command-Line Tools** — Provides utilities for bootstraping, tuning PostgreSQL settings, generating system reports, and managing Zabbix hosts and templates via CLI. ## Philosophy mamonsu prioritizes minimal performance overhead by using a single database connection for metric collection and emphasizes ease of integration with existing Zabbix monitoring ecosystems.

Stars188

Forks31

Last commit10 days ago

pg_monz

This is the Zabbix monitoring template for PostgreSQL Database.

Stars161

Forks80

Last commit4 years ago

Pyora

Python script to monitor Oracle Databases

Stars120

Forks79

Last commit2 years ago

Orabbix

Plugin designed to work with Zabbix Enterprise Monitor to provide multi-tiered monitoring, performance and availability reporting and measurement for Oracle Databases, along with server performance metrics