How to integrate node exporter with mysql

General Questions
1

can any one please let me know that how to integrate exporter with msql for pmm plugin dashboards. I have explored so much time but i didn’t get anything

1 Like
2

Hi @cshannu

Are you trying to use PMM dashboards outside the PMM?
Please add additional labels:

  • node_name,
  • service_name,
  • replication_set,
  • cluster

e.g.

Screenshot_20210624_143351
Screenshot_20210624_1433511536×458 41.6 KB

1 Like
3

Hi, I have integrated with MySQL in my SpotnRides Uber clone app. I will add the code snippet below for your reference.

$cat /etc/prometheus/prometheus.yml

#my global config
global:
scrape_interval: 15s # Set the scrape interval to every 15 seconds. Default is every 1 minute.
evaluation_interval: 15s # Evaluate rules every 15 seconds. The default is every 1 minute.
#scrape_timeout is set to the global default (10s).

#Alertmanager configuration
alerting:
alertmanagers:

  • static_configs:
  • targets:
    #- alertmanager:9093

#Load rules once and periodically evaluate them according to the global ‘evaluation_interval’.
rule_files:
#- “first_rules.yml”
#- “second_rules.yml”

#A scrape configuration containing exactly one endpoint to scrape:
#Here it’s Prometheus itself.
scrape_configs:
#The job name is added as a label job=<job_name> to any timeseries scraped from this config.

  • job_name: ‘prometheus’

#metrics_path defaults to ‘/metrics’
#scheme defaults to ‘http’.

static_configs:

  • targets: [‘localhost:9090’]