gpbackup Exporter

Prometheus exporter for collecting metrics from gpbackup history file gpbackup_history.db.

By default, the metrics are collected for all databases and backups in history file. You need to run exporter or Docker image on the same host where is gpbackup_history.db file located (Greenplum Master host).

If you are using an old gpbackup version that supports only the YAML format gpbackup_history.yaml , then use gpbackup_exporter <= v0.3.0.

Grafana dashboard

To get a dashboard for visualizing the collected metrics, you can use a ready-made dashboard gpbackup Exporter Dashboard or make your own.

Collected metrics

Backup metrics

Metric	Description	Labels	Additional Info
gpbackup_backup_status	backup status	backup_type, database_name, object_filtering, plugin, timestamp	Values description: 0 - success, 1 - failure.
gpbackup_backup_deletion_status	backup deletion status	backup_type, database_name, date_deleted, object_filtering, plugin, timestamp	Values description: 0 - backup still exists, 1 - backup was successfully deleted, 2 - the deletion is in progress, 3 - last delete attempt failed to delete backup from plugin storage, 4 - last delete attempt failed to delete backup from local storage.
gpbackup_backup_info	backup info	backup_dir, backup_ver, backup_type, compression_type, database_name, database_ver, object_filtering, plugin, plugin_ver, timestamp, with_statistic	Values description: 1 - info about backup is exist.
gpbackup_backup_duration_seconds	backup duration in seconds	backup_type, database_name, object_filtering, plugin, timestamp

Last backup metrics

Metric	Description	Labels	Additional Info
gpbackup_backup_since_last_completion_seconds	seconds since the last completed backup	backup_type, database_name

Exporter metrics

Metric	Description	Labels	Additional Info
gpbackup_exporter_build_info	information about gpbackup exporter	branch, goarch, goos, goversion, revision, tags, version
gpbackup_exporter_status	gpbackup exporter get data status	database_name	Values description: 0 - errors occurred when fetching information from history database, 1 - information successfully fetched from history database.

Getting Started

Building and running

git clone https://github.com/woblerr/gpbackup_exporter.git
cd gpbackup_exporter
make build
./gpbackup_exporter <flags>

Available configuration flags:

./gpbackup_exporter --help
usage: gpbackup_exporter [<flags>]


Flags:
  -h, --[no-]help                Show context-sensitive help (also try --help-long and --help-man).
      --web.telemetry-path="/metrics"  
                                 Path under which to expose metrics.
      --web.listen-address=:19854 ...  
                                 Addresses on which to expose metrics and web interface. Repeatable for multiple addresses. Examples: `:9100` or `[::1]:9100` for http, `vsock://:9100` for vsock
      --web.config.file=""       Path to configuration file that can enable TLS or authentication. See: https://github.com/prometheus/exporter-toolkit/blob/master/docs/web-configuration.md
      --collect.interval=600     Collecting metrics interval in seconds.
      --collect.depth=0          Metrics depth collection in days. Metrics for backup older than this interval will not be collected. 0 - disable.
      --gpbackup.history-file=""  
                                 Path to gpbackup_history.db.
      --gpbackup.db-include="" ...  
                                 Specific db for collecting metrics. Can be specified several times.
      --gpbackup.db-exclude="" ...  
                                 Specific db to exclude from collecting metrics. Can be specified several times.
      --gpbackup.backup-type=""  Specific backup type for collecting metrics. One of: [full, incremental, data-only, metadata-only].
      --[no-]gpbackup.collect-deleted  
                                 Collecting metrics for deleted backups.
      --[no-]gpbackup.collect-failed  
                                 Collecting metrics for failed backups.
      --log.level=info           Only log messages with the given severity or above. One of: [debug, info, warn, error]
      --log.format=logfmt        Output format of log messages. One of: [logfmt, json]
      --[no-]version             Show application version.

Additional description of flags.

It's necessary to specify the gpbackup_history.db file location via --gpbackup.history-file flag.

By default, metrics a collected only for active backups. The flag --gpbackup.collect-deleted allows to collect metrics for deleted backups. The flag --gpbackup.collect-failed allows to collect metrics for failed backups.

Custom database for collecting metrics can be specified via --gpbackup.db-include flag. You can specify several databases.
For example, --gpbackup.db-include=demo1 --gpbackup.db-include=demo2.
For this case, metrics will be collected only for demo1 and demo2 databases.

Custom database to exclude from collecting metrics can be specified via --gpbackup.db-exclude flag. You can specify several databases.
For example, --gpbackup.db-exclude=demo1 --gpbackup.db-exclude=demo2.
For this case, metrics will not be collected for demo1 and demo2 databases.
If the same database is specified for include and exclude flags, then metrics for this database will not be collected. The flag -gpbackup.db-exclude has a higher priority.
For example, --gpbackup.db-include=demo1 -gpbackup.db-exclude=demo1.
For this case, metrics will not be collected for demo1 database.

Custom backup type for collecting metrics can be specified via --gpbackup.backup-type flag. Valid values: full, incremental, data-only, metadata-only.
For example, --gpbackup.backup-type=full.
For this case, metrics will be collected only for full backups.

Custom metrics depth collection in days can be specified via --collect.depth flag. Since gpbackup doesn't have regular options for removing info about outdated backups from history file, it is possible to limit the depth of collection metrics.
For example, --collect.depth=14.
For this case, metrics will be collected for backups not older then 14 days from current time.
Value 0 - disable this functionality.

When --log.level=debug is specified - information of values and labels for metrics is printing to the log.

The flag --web.config.file allows to specify the path to the configuration for TLS and/or basic authentication.
The description of TLS configuration and basic authentication can be found at exporter-toolkit/web.

Building and running docker

Environment variables supported by this image:

• TZ - container's time zone, default Etc/UTC;
• EXPORTER_TELEMETRY_PATH - path under which to expose metrics, default /metrics;
• EXPORTER_PORT - port for prometheus metrics to listen on, default 19854;
• EXPORTER_CONFIG - path to the configuration file for TLS and/or basic authentication, default "";
• COLLECT_INTERVAL - collecting metrics interval in seconds, default 600;
• COLLECT_DEPTH - metrics depth collection in days, default 0;
• COLLECT_DELETED - collect metrics for deleted backups, default false;
• COLLECT_FAILED - collect metrics for failed backups, default false;
• HISTORY_FILE - path to gpbackup history file, default "";
• DB_INCLUDE - specific database for collecting metrics, default "";
• DB_EXCLUDE - specific database to exclude from collecting metrics, default "";
• BACKUP_TYPE - specific backup type for collecting metrics, default "".

When running exporter in docker, it is necessary to specify correct timezone via TZ variable. The timestamp values in the history database are stored taking into account the timezone in which Greenplum cluster operates. Otherwise, there may be incorrect values for gpbackup_backup_since_last_completion_seconds metric.

Pull

Change tag to the release number.

• Docker Hub:

docker pull woblerr/gpbackup_exporter:tag

• GitHub Registry:

docker pull ghcr.io/woblerr/gpbackup_exporter:tag

Build

make docker

Run

Simple run:

docker run -d --restart=always \
    --name gpbackup_exporter \
    -e TZ=America/Chicago \
    -e HISTORY_FILE=/data/gpbackup_history.db \
    -p 19854:19854 \
    -v /data/master/gpseg-1/gpbackup_history.db:/data/gpbackup_history.db:ro \
    gpbackup_exporter

For specific database:

docker run -d --restart=always \
    --name gpbackup_exporter \
    -e HISTORY_FILE=/data/gpbackup_history.db \
    -e DB_INCLUDE=demo1 \
    -p 19854:19854 \
    -v /data/master/gpseg-1/gpbackup_history.db:/data/gpbackup_history.db:ro \
    gpbackup_exporter

If you want to specify several databases for collecting metrics, you can run containers on different ports:

docker run -d --restart=always \
    --name gpbackup_exporter \
    -e HISTORY_FILE=/data/gpbackup_history.db \
    -e DB_INCLUDE=demo1 \
    -p 19854:19854 \
    -v /data/master/gpseg-1/gpbackup_history.db:/data/gpbackup_history.db:ro \
    gpbackup_exporter

docker run -d --restart=always \
    --name gpbackup_exporter \
    -e HISTORY_FILE=/data/gpbackup_history.db \
    -e DB_INCLUDE=demo2 \
    -p 19855:19854 \
    -v /data/master/gpseg-1/gpbackup_history.db:/data/gpbackup_history.db:ro \
    gpbackup_exporter

To exclude specific database:

docker run -d --restart=always \
    --name gpbackup_exporter \
    -e HISTORY_FILE=/data/gpbackup_history.db \
    -e DB_EXCLUDE=demo1 \
    -p 19854:19854 \
    -v /data/master/gpseg-1/gpbackup_history.db:/data/gpbackup_history.db:ro \
    gpbackup_exporter

For specific backup type not older than 14 days:

docker run -d --restart=always \
    --name gpbackup_exporter \
    -e HISTORY_FILE=/data/gpbackup_history.db \
    -e BACKUP_TYPE=full \
    -e COLLECT_DEPTH=14 \
    -p 19854:19854 \
    -v /data/master/gpseg-1/gpbackup_history.db:/data/gpbackup_history.db:ro \
    gpbackup_exporter

Running as systemd service

• Register gpbackup_exporter (already builded, if not - exec make build before) as a systemd service:

make prepare-service HISTORY_FILE="/path/to/gpbackup_history.db"

Validate prepared file gpbackup_exporter.service and run:

sudo make install-service

• View service logs:

journalctl -u gpbackup_exporter.service

• Delete systemd service:

sudo make remove-service

---

Manual register systemd service:

cp gpbackup_exporter.service.template gpbackup_exporter.service

In file gpbackup_exporter.service.template replace /usr/bin/gpbackup_exporter to full path to gpbackup_exporter and /data/master/gpseg-1/gpbackup_history.db to full path to gpbackup_history.db.

sudo cp gpbackup_exporter.service /etc/systemd/system/gpbackup_exporter.service
sudo systemctl daemon-reload
sudo systemctl enable gpbackup_exporter.service
sudo systemctl restart gpbackup_exporter.service
systemctl -l status gpbackup_exporter.service

RPM/DEB packages

You can use the already prepared rpm/deb package to install the exporter. Only the gpbackup_exporter binary and the service file are installed by package.

For example:

rpm -ql gpbackup_exporter

/etc/systemd/system/gpbackup_exporter.service
/usr/bin/gpbackup_exporter

After installation RPM/DEB package, you need to set correct path to gpbackup_history.db in /etc/systemd/system/gpbackup_exporter.service.

Running tests

Run the unit tests:

make test

Run the end-to-end tests:

make test-e2e