v1.0

feat: update alerting rules for MariaDB, MongoDB, and PostgreSQL; adj…

v0.8.0-alpha

Version 0.8 Pre - Release

v0.6.0-alpha

Tag: v0.6 (Dashboard PostgreSQL, MariaDB, MongoDB, Alert basic send by email)

Version: 0.6 Alpha

Version Description:

This version marks the completion of the configuration of the following services:

• PostgreSQL
• MariaDB
• MongoDB

Additionally, Alertmanager for Prometheus has been configured, with basic alert rules set to notify via email when any service goes down.

Features Implemented:

1. Complete Installation and Configuration:

The installation and configuration of essential services are complete, including:

• PostgreSQL: Database configuration with integrated dashboards in Grafana.
• MariaDB: Configuration and secure credential storage.
• MongoDB: Integration and available dashboards for monitoring.

2. Credential and Configuration Management:

Users can securely manage credentials for the services. Relevant data, such as ports and service configurations, are stored accurately in the database.

• PostgreSQL: Connection configuration and connection testing.
• MariaDB: Credential and connection management.
• MongoDB: Credential storage and configuration for monitoring.

3. Alertmanager for Prometheus:

The Alertmanager configuration is in place to receive email alerts if any of the services go down or are inactive.

• Basic alert rules:
  • If a database service (PostgreSQL, MariaDB, or MongoDB) is down, an email alert is generated.
  • Alerts are managed and sent via Alertmanager in Prometheus.

4. Dashboard and Monitoring:

• PostgreSQL: Fully configured dashboard with key metrics.

  • General counters, CPU usage, memory, and file descriptor stats.
  • Active session stats, transactions, cache hit rate, data metrics.
  • Monitoring of table locks and deadlock conflicts.

• MariaDB and MongoDB: Basic dashboards with key metrics configured.

5. Result

App Web*

Dashboards*

Postgres

MariaDB

MongoDB

AlertManager

Prometheus

Email Alert - Template 1

Email Alert - Template 2

Enhanced Features:

• Improved form validation and error handling in the user interface.
• Optimized management of database connections and credentials.
• Proper deployment of all services in the production environment.

Notes:

• The system is now ready for production use.
• The integration between Grafana, Prometheus, and the configured exporters has been tested and works seamlessly.
• Users can input PostgreSQL credentials and access fully functional dashboards displaying key performance and usage metrics.

Pending Improvements:

• Configuration of dashboards for MariaDB and MongoDB, as well as tailored dashboards for each database.
• Ongoing UI/UX improvements for better user experience.
• Expansion of dashboard templates for more comprehensive monitoring solutions.

---

Tag: v0.6.0-alpha (First version with configured alerts and database dashboards)

Full Changelog: v0.4.0-alpha...v0.6.0-alpha

Tag: v0.4.0 (Full Installation and Configuration Completed to PostgreSQL)

Release v0.4 Aplha

Tag: v0.4 (Full Installation and Configuration Completed to Postgres)

Current Status:

This release marks the full completion of the installation and configuration process for Grafana, Prometheus, their exporters, and the PostgreSQL datasource and dashboards. The following features have been successfully implemented:

Complete Service Installation:

• Grafana: Full configuration and installation.
• Prometheus: Complete setup and integration.
• Exporters: Properly configured exporters for:
  • PostgreSQL
  • MongoDB
  • MariaDB

Credential and Configuration Management:

• The system allows users to manage and store credentials securely in the database for:
  • PostgreSQL (including connection testing capability)
  • MariaDB
  • MongoDB
• User installation data, including credentials, ports, and services, is stored accurately in the database.

Functional Interface:

• A comprehensive wizard has been implemented to guide users through the entire installation process.
• User configuration and service installation are correctly saved.

Enhanced Features:

• Grafana Datasource Configuration: Automatic setup of the Prometheus datasource in Grafana.
• Dashboard Creation: Automatic creation and configuration of PostgreSQL dashboards in Grafana.
• PostgreSQL Dashboard Access: Users can input PostgreSQL credentials and immediately access a fully functional dashboard displaying key metrics such as:
  • General Counters, CPU, Memory, and File Descriptor Stats
  • Active Sessions
  • Transaction Statistics
  • Cache Hit Rate
  • Fetch and Return Data Metrics
  • Open File Descriptors
  • Lock Tables and Deadlocks

Example Dashboard Metrics:

• CPU Usage: Displays average CPU usage with metrics including mean, last usage, max, and min.
• Memory Usage: Details of resident and virtual memory consumption.
• Database Statistics: Insights on active sessions, transactions, and data operations (inserts, updates, fetches).
• Cache Hit Rate: Shows cache efficiency for various databases.
• Conflicts and Deadlocks: Monitors database locks and deadlocks.

Improvements:

• Enhanced form validation and error handling in the user interface.
• Streamlined access and management of database connections.
• Ensured the correct deployment of all services in the production environment.

Notes:

• The system is now fully prepared for production use.
• The integration between Grafana, Prometheus, and the configured exporters has been tested and works seamlessly.
• Users can confidently input PostgreSQL credentials and view detailed performance and usage metrics directly in Grafana dashboards.

Pending and Future Enhancements:

• Configuration of dashboards for MariaDB and MongoDB, and dashboards tailored for specific databases.
• Continued UI/UX improvements for better user experience.
• Expansion of dashboard templates for more comprehensive monitoring solutions.

Result

Manager Database Credential

Grafana

Metrics Prometheus

This version solidifies the base functionality and sets the stage for further feature expansions and optimizations in future releases.

Tag: v0.2.0-aplha (Initial Setup Completed)

Tag: v1.0-beta (Initial Setup Completed)

Current Status:
This tag marks the completion of the initial setup and configuration of Grafana, Prometheus, and their exporters, as well as the database credentials for PostgreSQL. The system now allows users to perform the following:

• Complete service installation:

  • Configuration and installation of Grafana.
  • Configuration and installation of Prometheus.
  • Configuration of exporters for Prometheus:
    • Exporter for PostgreSQL.
    • Exporter for MongoDB.
    • Exporter for MariaDB.

• Credential and configuration management:

  • The user can manage credentials for:
    • PostgreSQL (includes connection test).
    • MariaDB.
    • MongoDB.
  • Installation data (user credentials, ports, services) are correctly stored in the database.

• Functional interface:

  • A wizard has been implemented to guide the user through the installation process.
  • User configuration and service installation are saved correctly.

Project Status:

• It is now possible to install and configure Grafana, Prometheus, and their exporters.
• The credential management for databases is functional and stored in the database.
• PostgreSQL connection tests can be run from the user interface.

Pending Implementation:

1. Grafana configuration:

   • Automatic creation of dashboards and the Prometheus datasource in Grafana is still pending.

2. Improvement of the connections interface:

   • The view for connections and database credentials needs to be reorganized to improve the user experience.

3. Other Improvements:

   • Ensure all services are deployed correctly in the production environment.
   • Improve form validation and error handling in the graphical interface.

Notes:

• The system is ready for initial installation and testing.
• Integration between the mentioned services has been tested and is working correctly, except for the automatic creation of dashboards in Grafana.