Skip to content

v0.6.0-alpha

Choose a tag to compare

View all tags
@Anyel-ec Anyel-ec released this 05 Dec 06:09
· 185 commits to main since this release
v0.6.0-alpha
5dd2fa7

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*

image

Dashboards*

Postgres

image

MariaDB

image

MongoDB

image

AlertManager

image

Prometheus

image

Email Alert - Template 1

image

Email Alert - Template 2

image

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

Assets 2
Loading