Skip to content
master
Switch branches/tags
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

mysqlrouter_exporter

Build Status

Supported MySQL Router version

check here

Usage

  1. Enable REST API on your MySQL Router here
  2. Download binary from release.
  3. Move to /usr/local/bin/
  4. Add systemd script.
  5. Start
[Unit]
Description=mysqlrouter-exporter
Documentation=https://github.com/rluisr/mysqlrouter-exporter
After=network-online.target

[Service]
Type=simple
Environment="MYSQLROUTER_EXPORTER_URL=url"
Environment="MYSQLROUTER_EXPORTER_USER=user"
Environment="MYSQLROUTER_EXPORTER_PASS=pass"
ExecStart=/usr/local/bin/mysqlrouter_exporter

[Install]
WantedBy=multi-user.target

Environment

Edit systemd script or add an environment variables.

Name Default Require Description
MYSQLROUTER_EXPORTER_URL - yes MySQL Router Rest API URL
MYSQLROUTER_EXPORTER_USER - no Username for REST API
MYSQLROUTER_EXPORTER_PASS - no Password for REST API

You can also set it as a flag.

Collector Flags

mysqlrouter_exporter can all get metrics. MySQL Router REST API Reference

Name Default Description
collect.metadata.status false Collect metrics from metadata status. CPU usage will increase.
collect.route.connections.byte_from_server false Collect metrics from route connections. CPU usage will increase.
collect.route.connections.byte_to_server false Collect metrics from route connections. CPU usage will increase.
collect.route.connections.time_started false Collect metrics from route connections. CPU usage will increase.
collect.route.connections.time_connected_to_server false Collect metrics from route connections. CPU usage will increase.
collect.route.connections.time_last_sent_to_server false Collect metrics from route connections. CPU usage will increase.
collect.route.connections.time_received_from_server false Collect metrics from route connections. CPU usage will increase.
Usage:
  mysqlrouter_exporter [OPTIONS]

Application Options:
      --url=                                                 MySQL Router Rest API URL [$MYSQLROUTER_EXPORTER_URL]
      --user=                                                Username for REST API [$MYSQLROUTER_EXPORTER_USER]
      --pass=                                                Password for REST API [$MYSQLROUTER_EXPORTER_PASS]
  -p, --listen-port=                                         Listen port (default: 49152)
  -k, --skip-tls-verify                                      Skip TLS Verification
      --collect.metadata.status                              Collect metrics from metadata status. CPU usage will increase.
      --collect.route.connections.byte_from_server           Collect metrics from route connections. CPU usage will increase.
      --collect.route.connections.byte_to_server             Collect metrics from route connections. CPU usage will increase.
      --collect.route.connections.time_started               Collect metrics from route connections. CPU usage will increase.
      --collect.route.connections.time_connected_to_server   Collect metrics from route connections. CPU usage will increase.
      --collect.route.connections.time_last_sent_to_server   Collect metrics from route connections. CPU usage will increase.
      --collect.route.connections.time_received_from_server  Collect metrics from route connections. CPU usage will increase.
  -v, --version                                              Show version

Help Options:
  -h, --help                                                 Show this help message

Prometheus configuration

scrape_configs:
  - job_name: 'mysqlrouter'
    static_configs:
      - targets:
        - mysqlrouter01.luis.local:49152

Grafana Dashboard

Grafana Dashboard

available here.