Skip to content

Instantly share code, notes, and snippets.

@azimut

azimut/prom.md

Last active April 8, 2016 15:31
Show Gist options
  • Save azimut/659a8a03feda548a763a to your computer and use it in GitHub Desktop.
Save azimut/659a8a03feda548a763a to your computer and use it in GitHub Desktop.
Download ZIP
slides
Raw
prom.md

Mysql monitoring with Prometheus

Agenda

  1. Prometheus
  2. Grafana
  3. Percona use case

Prometheus

logo

Prometheus architecture overview

promoverview

Prometheus is a systems and service monitoring system. It collects metrics from configured targets at given intervals, evaluates rule expressions, displays the results, and can trigger alerts if some condition is observed to be true. https://github.com/prometheus/prometheus

Prometheus exporters

With Prometheus you set up “Exporters” that have the ability to export the data. It is up to the Prometheus server configuration to choose what data to sample and how frequently.

node_exporter

https://github.com/prometheus/node_exporter

mysqld_exporter

https://github.com/prometheus/mysqld_exporter

Prometheus alerts

Grafana

grafanalog

Grafana is an open source, feature rich metrics dashboard and graph editor for Graphite, Elasticsearch, OpenTSDB, Prometheus and InfluxDB. https://github.com/grafana/grafana

Grafana at wikimedia

Tech Talk: Creating Useful Dashboards with Grafana http://grafana.wikimedia.org/

  • Timeshift (WOW)
  • Moving average
  • Total percentage

Percona monitoring and managment

Recently (mid-2015) Percona started using Prometheus, Grafana and Influxdb for monitoring and alerting.

Percona - Overview

prom

TODO

  • Metrics by node
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment