IBM Db2 Event Store Graphana visualization

Questions about this material? Reach me on Twitter @Loic Julien

The IBM Db2 Event Store is an in-memory database optimized for event-driven data processing and analysis. Download the free developer edition or the enterprise edition

In order to visualize your data with Graphana, follow the steps below:

Grafana Datasource

The IBM Db2 Event Store backend implements 2 urls:

• / will return 200 ok. This is used for "Test connection" on the datasource config page
• /query will return metrics based on input

Prerequisites

• An IBM Db2 Event Store Enterprise Edition cluster

Installation of Grafana within an IBM Db2 Event Cluster

In an enterprise configuration, the IBM Db2 Event Store is installed on 3 nodes. One of those node is going to be arbitrary referenced as MASTER1_IP.

• SSH to the Master 1 node

ssh root@${MASTER1_IP}

• Install Grafana on that node

sudo yum install -y wget
sudo wget https://s3-us-west-2.amazonaws.com/grafana-releases/release/grafana-5.0.0-1.x86_64.rpm
sudo yum install -y initscripts freetype fontconfig urw-fonts
sudo rpm -Uvh grafana-5.0.0-1.x86_64.rpm
sudo service grafana-server start

• Validate that Grafana correctly comes up in a Web Browser http://${MASTER1_IP}:3000/login [admin/admin]

• Download the archive from the GIT repo, unzip it, and place it in your home directory on {MASTER1_IP}

wget https://github.com/IBMProjectEventStore/db2eventstore-grafana/files/2019003/db2-event-store-grafana.tar.zip

Install the IBM Db2 Event Store plugin for Grafana

GRAFANA=/var/lib/grafana
sudo mkdir -p $GRAFANA/plugins/db2-event-store
sudo rm -rf $GRAFANA/plugins/db2-event-store/*
sudo cp db2-event-store-grafana.tar $GRAFANA/plugins/db2-event-store
cd $GRAFANA/plugins/db2-event-store
sudo tar -zxvf db2-event-store-grafana.tar
sudo service grafana-server restart

@Loic Julien, IBM Db2 Event Store