How We Integrate Grafana with Prometheus

1 . Percona + Grafana + Prometheus = Love How We Integrate Grafana with Prometheus for Easy MySQL and MongoDB Monitoring Peter Zaitsev CEO, Percona GrafanaCon 30 November 2016, NYC 1 © 2016 Percona 

2 .About Percona We Exist to help you to succeed with MySQL and MongoDB 2 © 2016 Percona 

3 .Support Broad Ecosystem Percona AWS for Server for MySQL MariaDB MySQL and MySQL Aurora Percona Google MongoDB Server for CloudSQL MongoDB 3 © 2016 Percona 

4 .Percona Software – 100% Open Source Percona Server Percona Server Percona XtraDB for MySQL for MongoDB Cluster Percona Percona Percona Toolkit Monitoring and Xtrabackup Management 4 © 2016 Percona 

5 .Services • Support • More than Support (Percona Care) • Managed Services (Percona Care Ultimate) • Consulting 5 © 2016 Percona 

6 .We resolve complex Data Layer problems We need deep insights into Database Operation 6 © 2016 Percona 

7 .Existing Solutions are Commercial Cloud Only • MySQL Enterprise • VividCortex Monitor • DataDog • MongoDB Ops • NewRelic Manager • MonYog 7 © 2016 Percona 

8 .Open Source Solutions Great Components exist Need to put together for complete solution Typically Lacks Depth in Database Insights 8 © 2016 Percona 

9 .Our Requirements Free and Open Source Solution In The Cloud and on Premises Easy to Install Monitor Development and Production 9 © 2016 Percona 

10 .Modern Systems: Well Defined Roles Data Storage and Visualization Capture Processing 10 © 2016 Percona 

11 .Data Capture “Telemetry” Requirements Solutions • High Level of Details • Statsd • Low Overhead • Collectd • Support for your • Prometheus Exporters technology • InfluxDB Telegraf • Intel Snap 11 © 2016 Percona 

12 .Storage and Processing Requirements Solutions • High Performance (ingest • OpenTSB and queries) • InfluxDB • Efficient Storage • Prometheus • Powerful Query Language • ElasticSearch • Graphite (Whisper) • Riak TS 12 © 2016 Percona 

13 .Visualization/Dashboards Requirements Technologies •Visualization/Usability •Chronograf •Support Multiple •Kibana Sources •Graphite •Extensibility •Grafana 13 © 2016 Percona 

14 .What Makes Grafana Special Grafana does not focus on data capture or storage Focus on Visualization only Supports Plugins Supports Multiple Data Sources Integrates with Other visualization tools (Graphite, OpenNMS, Zabbix) Greatest momentum in the Community 14 © 2016 Percona 

15 .Why Prometheus Data Model Query Language Efficiency • Any number of • Very Expressive • High Ingestion Key-Value Pairs • Custom designed Speeds • Great for complex for problem • High relationships in space Compression Database World • Operates on the • Excellent whole “data compression universe” 15 © 2016 Percona 

16 .Grafana+Prometheus+Custom=PMM Note: Name is futureproof, currently doing Monitoring not Management 16 © 2016 Percona 

17 .PMM at Glance Easy to use Monitoring Solution for MySQL and MongoDB 100% Free and Open Source Using Best in Class components as Grafana and Prometheus Custom Percona Development for Query Insights 17 © 2016 Percona 

18 .Inside PMM 18 © 2016 Percona 

19 .For the User ? Get Docker Container for “Server Part” Install the “Agent” on MySQL or MongoDB Servers Point the agent to the right server location 19 © 2016 Percona 

20 .Insights on Operating Systems layer 20 © 2016 Percona 

21 .Insights on MySQL Layer 21 © 2016 Percona 

22 .Find What queries are causing load 22 © 2016 Percona 

23 .Why are they causing this load 23 © 2016 Percona 

24 .… And How to Fix Them 24 © 2016 Percona 

25 .Find out More • Talk to us at the Booth • Check out our live demo http://pmmdemo.percona.com 25 © 2016 Percona 

26 . DATABASE PERFORMANCE Database Performance Matters MATTERS