Integrate JMeter in Grafana Dashboard by using InfluxDB as a backend

What is Grafana?
Grafana is an open source metric analytics & visualization suite. It is most commonly used for visualizing time series data for infrastructure and application analytics but many use it in other domains including industrial sensors, home automation, weather, and process control.

Sample dashboard:

  • Download Grafana from the link(https://grafana.com/grafana/download)
  • unzip grafana-4.5.2.windows-x64.zip in your machine and execute the server file in the location grafana-4.5.2.windows-x64\grafana-4.5.2\bin\grafana-server.exe
  • Once executed verify the Grafana by http://localhost:3000 in the browser.
  • Grafana default username is admin and password is an admin.
  • We need influxDB to store the JMeter test result.



What is InfluxDB?
InfluxDB is an open-source* (1.1.0) time series database developed by InfluxData. It is written in Go and optimized for fast, high-availability storage and retrieval of time series data in fields such as operations monitoring, application metrics, Internet of Things sensor data, and real-time analytics.
Download InfluxDB https://dl.influxdata.com/influxdb/releases/influxdb-1.1.0_windows_amd64.zip and unzip the same.
  • Open the Config file in the location \influxdb-1.1.0_windows_amd64\influxdb-1.1.0-1 and uncomment the following and save Graphite set up on the same.
  • Execute the file influxd.exe in the location(\influxdb-1.1.0_windows_amd64\influxdb-1.1.0-1\) to start the InfluxDB
  • Execute the file influx.exe in the location(\influxdb-1.1.0_windows_amd64\influxdb-1.1.0-1\) to start the create a database.
  • Query to create a Database "Create Database JMeter(Db name which we are going to use in JMeter script)"
  •        Show Databases "To see the available database"
  •        UseJMeterr(Database)
  •        Show the Measurement "Will display the available measurements in the Database if available"


Please refer the following link for more commands https://docs.influxdata.com/influxdb/v1.3/query_language/spec/
Jmeter + InfluxDB
  1.  Download influx DB writer for JMeter from the link https://github.com/NovaTecConsulting/JMeter-InfluxDB-Writer/releases and place the same in the location Jmeter\apache-JMeter-3.3\lib\ext\JMeter-InfluxDB-Writer-plugin-1.2.jar
  2.  Now Restart the Jmeter
  3. Open the respective project in your JMeter UI
  4. Add the Backend Listener to your project (Right click Thread Group -> Add-> Listener->Backend Listener)
  5. Select rocks.nt.apm.jmeterJMeterInfluxDBBackendListenerClient from the Backend Listener Implementation and set up the configuration as how in the below image.

  1. Run the Jmeter at least for 1 time to see the table detail in the InfluxDB
  2. Use the comment show measurement for the table jmeter for the db data
  3. After Jmeter Execution

  1. Like that, we can see the information details using the script


Grafana + Influx Db configuration
Launch the localhost:3000 and add the data source.
Fill the following details
  1. Name for the data source
  2. Type: Influxdb
  3. URL: http://localhost:8086
  4. Access: Direct
  5. Database JMeter (As of now we are not using an authorization for the DB).
  6. Click Add to save the Datasource

After data source configuration.
  1. Go to Menu-> Dashboard-> New
  2. Select the graph you are looking for
  3. Click on the graph title to edit
  4. Select the Data Source in Metrix-> Datasource->Jmeter (Data source name)
  5. Select the Request type you like to configure in your database.

Below image show graph for the respective query

Jmeter grafana dashboard after configuring all the details.


Note: You can build your own dashboard with the available options in grafana.

Comments

Post a Comment

Popular posts from this blog

Image
A story about a fresher who starting his career as a software testing professional in a small  organization The first day he had started to office with a question     Second day with lot of questions for a single  concept       The third day he feels alone when comparing  himself with his friends, who were placed as a developer in various  organization           While googling about the testing he got an answer in “yahoo answer” that “Testing is just a typing work”, yeah at that time he had a training to write test cases. He feels sad and weak inside      When his discussing with his friends about testing. They used to ask “Are you in Testing”. He suddenly replies yeah in the XXX  organization , the  organization  is quickly developing one,  organization  has a...
Read more

Usability Testing

Image
When I started to work on my first project (fortunately I got an opportunity to work in a mobile application project) after two months of training, I thought that I was doing well and travelling in the right path. During one of the “QA discussion” sessions, my manager asked me to take a presentation regarding the training given to me and my first project experience. She wanted to understand my perspective of the training and project experience. I spent lots of effort on creating a presentation. I took the presentation with the title  “Starting a career as testing professional” . Generally in our meetings we used to have technical presentations, however, with just 3 months of experience in the field of testing, I did not have much to contribute technically (also the fear on what to present in front of experienced testers). Hence, I proceeded to share my 3 months of experience, based on my self-analysis, I compared myself with the developers and how my QA team involved in my care...
Read more