GreenPlum¶

Greenplum is a high-performance and highly available database system based on the massive parallel processing (MPP) architecture, primarily used for processing and analyzing large-scale datasets. Greenplum is suitable for scenarios such as data warehousing, business intelligence, and big data analysis, especially when dealing with PB level data volumes, it can provide efficient data storage and analysis capabilities. Greenplum's observability includes monitoring database performance, detecting and notifying faults, and visualizing system operating status.

Installation configuration¶

Preconditions¶

Greenblum 5 or 6 version, tested version:

• 6.24.3

Install Exporter¶

You can download and install from here greenlum exporter，This is a data collector that exposes the greenlum metric as prometheus and supports both GP5 and GP6

• Taking CentOS as an example, the startup command is as follows：

export GPDB_DATA_SOURCE_URL=postgres://gpadmin:password@10.17.20.11:5432/postgres?sslmode=disable
./greenplum_exporter --web.listen-address="0.0.0.0:9297" --web.telemetry-path="/metrics" --log.level=error

• If running Docker, the startup command is as follows：

docker run -d -p 9297:9297 -e GPDB_DATA_SOURCE_URL=postgres://gpadmin:password@10.17.20.11:5432/postgres?sslmode=disable inrgihc/greenplum-exporter:latest 

Note: The environment variable GPDBDATA_SOURCE-URL specifies the connection string to the Greenplum database (please use the gpadmin account to connect to the postgres database), which is prefixed with postgres://and follows the following format:

postgres://gpadmin:password@10.17.20.11:5432/postgres?sslmode=disable
postgres://[Database connection account, must be gpadmin]:[Account password, i.e. gpadmin password] @ [IP address of database]:[Database port number]/[Database name, must be postgres]?[Parameter Name]=[Parameter Value]&[Parameter Name]=[Parameter Value]

Then access the URL address of the monitoring indicator：http://127.0.0.1:9297/metrics

More startup parameters：

usage: greenplum_exporter [<flags>]

Flags:
  -h, --help                   Show context-sensitive help (also try --help-long and --help-man).
      --web.listen-address="0.0.0.0:9297"  
                               web endpoint
      --web.telemetry-path="/metrics"  
                               Path under which to expose metrics.
      --disableDefaultMetrics  do not report default metric
      (go metrics and process metrics)
      --version                Show application version.
      --log.level="info"       Only log messages with the given severity or above. Valid levels: [debug, info, warn, error, fatal]
      --log.format="logger:stderr"  
                               Set the log target and format. Example: "logger:syslog?appname=bob&local=7" or "logger:stdout?json=true"

Collector configuration¶

Host installation¶

• Install Datakit

Configure collector¶

Due to the ability of greenlum exporter to directly expose metrics URLs, data can be collected directly through the Prom collector by configuring the corresponding URLs. Go to theconf.d/prom directory in the DataKit installation directory, copy prom.conf.sample and name it greenplum.conf

cp prom.conf.sample greenplum.conf

Adjust the content of greenblum.conf as follows：

[[inputs.prom]]
  ## Exporter URLs.
  urls = ["http://127.0.0.1:9297/metrics"]
  ## Collector alias.
  source = "greenplum"
...

Adjust other configurations as needed， Parameter adjustment instructions ：

• urls：prom metrics address, fill in the corresponding indicator URL exposed by greenlum here，If DataKit is installed on the greenlum host, the default ishttp://127.0.0.1:9297/metrics
• source：Change the data source to greenlum for easy filtering of indicators in the future
• interval：Collection interval

Restart Datakit¶

Restart Datakit

Metric¶

GreenPlum Metric set¶