Database monitoring#

To monitor databases in K2 Cloud, we recommend enabling cloud Prometheus-based monitoring service. If you have your own Prometheus- or Zabbix-based monitoring server, you can connect PaaS services to it.

Databases in K2 Cloud are deployed with monitoring agents already installed. Exporters from the Prometheus project ecosystem are used as agents. Each of them runs in the background mode and listens to a specific port. You can make an HTTP GET request to the port at any time to get the metrics.

Exporter

PaaS

Metrics

Metric collection point

Description

node_exporter

All services

Host properties, OS metrics, utilization of system resources

http://<IP>:9100/metrics

Project page node_exporter

mysqld_exporter

MySQL

Variables and statuses of a running DBMS, full list of MySQL metrics

http://<IP>:9104/metrics

Project page mysqld_exporter

postgres_exporter

PostgreSQL

Metrics of a running DBMS, full list of PostgreSQL metrics

http://<IP>:9187/metrics

Project page postgres_exporter

redis_exporter

Redis

Metrics of a running DBMS, full list of Redis metrics

http://<IP>:9121/metrics

Project page redis_exporter

mongodb_exporter

MongoDB

Metrics of a running DBMS, full list of Mongo DB metrics

http://<IP>:9216/metrics

Project page mongodb_exporter

DBMS listens to addresses and ports can be found in the Information tab.

You can use addresses not only to connect applications to the DBMS but also to connect to monitoring agents.

For example, to get metrics from MySQL that listens to the following addresses:

../../../_images/AdressesMySQL_example.png

you need to use the following cluster endpoints:

And to get metrics from the host and VM OS, you should use the following endpoints:

For a Prometheus server, the configuration for working with such a service might look like this (http:// and /metrics are default values and are not specified in the given configuration for connection points):

scrape_configs:
- job_name: node
  static_configs:
  - targets:
    - 172.31.1.37:9100
    - 172.31.0.55:9100
    - 172.31.2.40:9100
- job_name: mysqld
  static_configs:
  - targets:
    - 172.31.1.37:9104
    - 172.31.0.55:9104
    - 172.31.2.40:9104

Zabbix monitoring server can also use data that exporters provide via integration with the help of their HTTP client; for details, see.