no mysql or mongodb no problem! how to extend pmm's ... · santa clara, california | april...
Post on 31-May-2020
3 Views
Preview:
TRANSCRIPT
Santa Clara California | April 23th ndash 25th 2018
No MySQL or MongoDB No Problem How to Extend PMMs Functionality to
Monitor Other DBMSs
2
Who are we
Agustiacuten Gallego Percona Support Engineer httpswwwlinkedincominagustiacuten-g
Fernando Ipar Pythian Principal Consultant httpsuylinkedincominfipar
3
Agenda
PMM architecture Adding an external exporter Dashboards Importing dashboards Creating dashboards Extending Functionality
PMM Architecture
5
Introducing Percona Monitoring and Management
Built on top of software like Grafana Prometheus Nginx Consul Docker
Main github repository httpsgithubcomperconapmm
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQLreg MariaDBreg and MongoDBreg performance
httpswwwperconacomsoftwaredatabase-toolspercona-monitoring-and-management
6
Introducing Percona Monitoring and Management
7
PMM Architecture
httpswwwperconacomdocpercona-monitoring-and-managementarchitecturehtml
8
PMM Server
Can be run in the following ways Docker container Open Virtual Appliance (OVA) package Amazon Machine Image (AMI) instance
Has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployindexhtmlinstalling-pmm-server
9
PMM Client
Can be installed via the following methods yum apt repos yum apt packages linux generic tarball
Can have many exporters per instance Use explicit names for each to avoid confusions
hostname is used by default Also has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployclientindexhtmlinstalling-pmm-client
Adding an External Exporter
11
For which exporters will we see examples
PostgreSQL
Cassandra
ClickHouse
12
Are there any other we can choose from
These are just three of them there are plenty more httpsprometheusiodocsinstrumentingexporters
Some examples Consul ElasticSearch Memcached OpenTSDB Redis RethinkDB
13
Before anything else
Have a running PMM server
shellgt git clone httpsgithubcomguriandoropercona_live_18git
shellgt cd percona_live_18
shellgt source pmm-dockersh
shellgt initsh
14
Before anything else
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
2
Who are we
Agustiacuten Gallego Percona Support Engineer httpswwwlinkedincominagustiacuten-g
Fernando Ipar Pythian Principal Consultant httpsuylinkedincominfipar
3
Agenda
PMM architecture Adding an external exporter Dashboards Importing dashboards Creating dashboards Extending Functionality
PMM Architecture
5
Introducing Percona Monitoring and Management
Built on top of software like Grafana Prometheus Nginx Consul Docker
Main github repository httpsgithubcomperconapmm
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQLreg MariaDBreg and MongoDBreg performance
httpswwwperconacomsoftwaredatabase-toolspercona-monitoring-and-management
6
Introducing Percona Monitoring and Management
7
PMM Architecture
httpswwwperconacomdocpercona-monitoring-and-managementarchitecturehtml
8
PMM Server
Can be run in the following ways Docker container Open Virtual Appliance (OVA) package Amazon Machine Image (AMI) instance
Has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployindexhtmlinstalling-pmm-server
9
PMM Client
Can be installed via the following methods yum apt repos yum apt packages linux generic tarball
Can have many exporters per instance Use explicit names for each to avoid confusions
hostname is used by default Also has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployclientindexhtmlinstalling-pmm-client
Adding an External Exporter
11
For which exporters will we see examples
PostgreSQL
Cassandra
ClickHouse
12
Are there any other we can choose from
These are just three of them there are plenty more httpsprometheusiodocsinstrumentingexporters
Some examples Consul ElasticSearch Memcached OpenTSDB Redis RethinkDB
13
Before anything else
Have a running PMM server
shellgt git clone httpsgithubcomguriandoropercona_live_18git
shellgt cd percona_live_18
shellgt source pmm-dockersh
shellgt initsh
14
Before anything else
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
3
Agenda
PMM architecture Adding an external exporter Dashboards Importing dashboards Creating dashboards Extending Functionality
PMM Architecture
5
Introducing Percona Monitoring and Management
Built on top of software like Grafana Prometheus Nginx Consul Docker
Main github repository httpsgithubcomperconapmm
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQLreg MariaDBreg and MongoDBreg performance
httpswwwperconacomsoftwaredatabase-toolspercona-monitoring-and-management
6
Introducing Percona Monitoring and Management
7
PMM Architecture
httpswwwperconacomdocpercona-monitoring-and-managementarchitecturehtml
8
PMM Server
Can be run in the following ways Docker container Open Virtual Appliance (OVA) package Amazon Machine Image (AMI) instance
Has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployindexhtmlinstalling-pmm-server
9
PMM Client
Can be installed via the following methods yum apt repos yum apt packages linux generic tarball
Can have many exporters per instance Use explicit names for each to avoid confusions
hostname is used by default Also has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployclientindexhtmlinstalling-pmm-client
Adding an External Exporter
11
For which exporters will we see examples
PostgreSQL
Cassandra
ClickHouse
12
Are there any other we can choose from
These are just three of them there are plenty more httpsprometheusiodocsinstrumentingexporters
Some examples Consul ElasticSearch Memcached OpenTSDB Redis RethinkDB
13
Before anything else
Have a running PMM server
shellgt git clone httpsgithubcomguriandoropercona_live_18git
shellgt cd percona_live_18
shellgt source pmm-dockersh
shellgt initsh
14
Before anything else
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
PMM Architecture
5
Introducing Percona Monitoring and Management
Built on top of software like Grafana Prometheus Nginx Consul Docker
Main github repository httpsgithubcomperconapmm
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQLreg MariaDBreg and MongoDBreg performance
httpswwwperconacomsoftwaredatabase-toolspercona-monitoring-and-management
6
Introducing Percona Monitoring and Management
7
PMM Architecture
httpswwwperconacomdocpercona-monitoring-and-managementarchitecturehtml
8
PMM Server
Can be run in the following ways Docker container Open Virtual Appliance (OVA) package Amazon Machine Image (AMI) instance
Has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployindexhtmlinstalling-pmm-server
9
PMM Client
Can be installed via the following methods yum apt repos yum apt packages linux generic tarball
Can have many exporters per instance Use explicit names for each to avoid confusions
hostname is used by default Also has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployclientindexhtmlinstalling-pmm-client
Adding an External Exporter
11
For which exporters will we see examples
PostgreSQL
Cassandra
ClickHouse
12
Are there any other we can choose from
These are just three of them there are plenty more httpsprometheusiodocsinstrumentingexporters
Some examples Consul ElasticSearch Memcached OpenTSDB Redis RethinkDB
13
Before anything else
Have a running PMM server
shellgt git clone httpsgithubcomguriandoropercona_live_18git
shellgt cd percona_live_18
shellgt source pmm-dockersh
shellgt initsh
14
Before anything else
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
5
Introducing Percona Monitoring and Management
Built on top of software like Grafana Prometheus Nginx Consul Docker
Main github repository httpsgithubcomperconapmm
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQLreg MariaDBreg and MongoDBreg performance
httpswwwperconacomsoftwaredatabase-toolspercona-monitoring-and-management
6
Introducing Percona Monitoring and Management
7
PMM Architecture
httpswwwperconacomdocpercona-monitoring-and-managementarchitecturehtml
8
PMM Server
Can be run in the following ways Docker container Open Virtual Appliance (OVA) package Amazon Machine Image (AMI) instance
Has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployindexhtmlinstalling-pmm-server
9
PMM Client
Can be installed via the following methods yum apt repos yum apt packages linux generic tarball
Can have many exporters per instance Use explicit names for each to avoid confusions
hostname is used by default Also has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployclientindexhtmlinstalling-pmm-client
Adding an External Exporter
11
For which exporters will we see examples
PostgreSQL
Cassandra
ClickHouse
12
Are there any other we can choose from
These are just three of them there are plenty more httpsprometheusiodocsinstrumentingexporters
Some examples Consul ElasticSearch Memcached OpenTSDB Redis RethinkDB
13
Before anything else
Have a running PMM server
shellgt git clone httpsgithubcomguriandoropercona_live_18git
shellgt cd percona_live_18
shellgt source pmm-dockersh
shellgt initsh
14
Before anything else
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
6
Introducing Percona Monitoring and Management
7
PMM Architecture
httpswwwperconacomdocpercona-monitoring-and-managementarchitecturehtml
8
PMM Server
Can be run in the following ways Docker container Open Virtual Appliance (OVA) package Amazon Machine Image (AMI) instance
Has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployindexhtmlinstalling-pmm-server
9
PMM Client
Can be installed via the following methods yum apt repos yum apt packages linux generic tarball
Can have many exporters per instance Use explicit names for each to avoid confusions
hostname is used by default Also has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployclientindexhtmlinstalling-pmm-client
Adding an External Exporter
11
For which exporters will we see examples
PostgreSQL
Cassandra
ClickHouse
12
Are there any other we can choose from
These are just three of them there are plenty more httpsprometheusiodocsinstrumentingexporters
Some examples Consul ElasticSearch Memcached OpenTSDB Redis RethinkDB
13
Before anything else
Have a running PMM server
shellgt git clone httpsgithubcomguriandoropercona_live_18git
shellgt cd percona_live_18
shellgt source pmm-dockersh
shellgt initsh
14
Before anything else
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
7
PMM Architecture
httpswwwperconacomdocpercona-monitoring-and-managementarchitecturehtml
8
PMM Server
Can be run in the following ways Docker container Open Virtual Appliance (OVA) package Amazon Machine Image (AMI) instance
Has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployindexhtmlinstalling-pmm-server
9
PMM Client
Can be installed via the following methods yum apt repos yum apt packages linux generic tarball
Can have many exporters per instance Use explicit names for each to avoid confusions
hostname is used by default Also has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployclientindexhtmlinstalling-pmm-client
Adding an External Exporter
11
For which exporters will we see examples
PostgreSQL
Cassandra
ClickHouse
12
Are there any other we can choose from
These are just three of them there are plenty more httpsprometheusiodocsinstrumentingexporters
Some examples Consul ElasticSearch Memcached OpenTSDB Redis RethinkDB
13
Before anything else
Have a running PMM server
shellgt git clone httpsgithubcomguriandoropercona_live_18git
shellgt cd percona_live_18
shellgt source pmm-dockersh
shellgt initsh
14
Before anything else
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
8
PMM Server
Can be run in the following ways Docker container Open Virtual Appliance (OVA) package Amazon Machine Image (AMI) instance
Has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployindexhtmlinstalling-pmm-server
9
PMM Client
Can be installed via the following methods yum apt repos yum apt packages linux generic tarball
Can have many exporters per instance Use explicit names for each to avoid confusions
hostname is used by default Also has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployclientindexhtmlinstalling-pmm-client
Adding an External Exporter
11
For which exporters will we see examples
PostgreSQL
Cassandra
ClickHouse
12
Are there any other we can choose from
These are just three of them there are plenty more httpsprometheusiodocsinstrumentingexporters
Some examples Consul ElasticSearch Memcached OpenTSDB Redis RethinkDB
13
Before anything else
Have a running PMM server
shellgt git clone httpsgithubcomguriandoropercona_live_18git
shellgt cd percona_live_18
shellgt source pmm-dockersh
shellgt initsh
14
Before anything else
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
9
PMM Client
Can be installed via the following methods yum apt repos yum apt packages linux generic tarball
Can have many exporters per instance Use explicit names for each to avoid confusions
hostname is used by default Also has some specialized dashboards for monitoring itself
httpswwwperconacomdocpercona-monitoring-and-managementdeployclientindexhtmlinstalling-pmm-client
Adding an External Exporter
11
For which exporters will we see examples
PostgreSQL
Cassandra
ClickHouse
12
Are there any other we can choose from
These are just three of them there are plenty more httpsprometheusiodocsinstrumentingexporters
Some examples Consul ElasticSearch Memcached OpenTSDB Redis RethinkDB
13
Before anything else
Have a running PMM server
shellgt git clone httpsgithubcomguriandoropercona_live_18git
shellgt cd percona_live_18
shellgt source pmm-dockersh
shellgt initsh
14
Before anything else
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
Adding an External Exporter
11
For which exporters will we see examples
PostgreSQL
Cassandra
ClickHouse
12
Are there any other we can choose from
These are just three of them there are plenty more httpsprometheusiodocsinstrumentingexporters
Some examples Consul ElasticSearch Memcached OpenTSDB Redis RethinkDB
13
Before anything else
Have a running PMM server
shellgt git clone httpsgithubcomguriandoropercona_live_18git
shellgt cd percona_live_18
shellgt source pmm-dockersh
shellgt initsh
14
Before anything else
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
11
For which exporters will we see examples
PostgreSQL
Cassandra
ClickHouse
12
Are there any other we can choose from
These are just three of them there are plenty more httpsprometheusiodocsinstrumentingexporters
Some examples Consul ElasticSearch Memcached OpenTSDB Redis RethinkDB
13
Before anything else
Have a running PMM server
shellgt git clone httpsgithubcomguriandoropercona_live_18git
shellgt cd percona_live_18
shellgt source pmm-dockersh
shellgt initsh
14
Before anything else
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
12
Are there any other we can choose from
These are just three of them there are plenty more httpsprometheusiodocsinstrumentingexporters
Some examples Consul ElasticSearch Memcached OpenTSDB Redis RethinkDB
13
Before anything else
Have a running PMM server
shellgt git clone httpsgithubcomguriandoropercona_live_18git
shellgt cd percona_live_18
shellgt source pmm-dockersh
shellgt initsh
14
Before anything else
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
13
Before anything else
Have a running PMM server
shellgt git clone httpsgithubcomguriandoropercona_live_18git
shellgt cd percona_live_18
shellgt source pmm-dockersh
shellgt initsh
14
Before anything else
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
14
Before anything else
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
15
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
httpsgithubcomwrouesnelpostgres_exporter
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
16
PostgreSQL
httpswwwpostgresqlorg
httpsgithubcomguriandoropercona_live_18
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
17
PostgreSQL
Continuing examples from Slide 13 Before anything else
shellgt create_and_start_postgresql
shellgt create_and_start_postgresql_exporters
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
18
PostgreSQL
shellgt pmm-admin config --server pmm-server
shellgt pmm-admin add externalmetrics postgresql postgresql-exporter9187
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
19
PostgreSQL
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
20
PostgreSQL
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
21
create_and_start_postgresql_exporters()
docker run -d
--publish 91879187
--name postgresql-exporter
--network pmm-network
--env DATA_SOURCE_NAME=postgresqlpostgrespostgrespostgresql5432sslmode=disable
wrouesnelpostgres_exporterlatest
docker exec -it postgresql usrlocalbinconfigure-pmm-clientsh
PostgreSQL
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
22
PostgreSQL
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
23
Exporter is up and running now
Buthellip
PostgreSQL
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
24
Exporter is up and running now
Buthellip how can we see the data
PostgreSQL
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
25
Cassandra
httpscassandraapacheorg
httpsgithubcomfipardocker-cassandra-prometheus
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
26
Cassandra
Continuing examples from Slide 17 PostgreSQL
shellgt create_and_start_cassandra
shellgt create_and_start_cassandra_exporters
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
27
Cassandra
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
28
Cassandra
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
29
Cassandra
create_and_start_cassandra()
for i in 1 2 do
docker run --name cassandra$i
--network pmm-network
-p 127001$i74007400
-e CASSANDRA_CLUSTER_NAME=plmce
-d fiparcassandra-pmmv1
done
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
30
Cassandra
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
31
Cassandra
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
32
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
Docker image httpshubdockercomryandexclickhouse-server Exporter httpsgithubcomf1yegorclickhouse_exporter
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
33
ClickHouse
httpsclickhouseyandex
httpsgithubcomguriandoropercona_live_18
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
34
ClickHouse
Continuing examples from Slide 25 Cassandra
shellgt create_and_start_clickhouse
shellgt create_and_start_clickhouse_exporters
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
35
ClickHouse
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
36
ClickHouse
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
37
create_and_start_clickhouse_exporters() docker run -d --publish 91169116 --name clickhouse-exporter --network pmm-network f1yegorclickhouse-exporter -scrape_uri=httpclickhouse8123
docker exec -it clickhouse usrlocalbinconfigure-pmm-clientsh
ClickHouse
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
38
ClickHouse
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
Dashboards
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
40
What are dashboards
Where information and metrics are displayed Composed of panels positioned in a grid Highly customizable In PMM dashboards group similar metrics together
OS -gt Disk Performance MySQL -gt InnoDB Metrics MongoDB -gt ReplSet
(it is a convention only but well come back to this point soon) They are stored in JSON format
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
41
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
42
What are dashboards
httpspmmdemoperconacomgraphdashboarddbmysql-overview
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
Importing Dashboards
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
44
Where can we get custom dashboards
Since they are simply json files sharing dashboards is very straightforward
We can get custom dashboards from the official Grafana dashboards page
httpsgrafanacomdashboards github repositories like our own PMM dashboards page
httpsgithubcomperconagrafana-dashboards any other means of sharing the json file(s)
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
45
How can we import custom dashboards
There are three ways in which we can do this Upload a json file Provide a dashboard ID from official repository Copypaste JSON directly to text box
TODO check a fourth way programmatically via API
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
46
How can we import custom dashboards
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
47
How can we import custom dashboards
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
48
How can we import custom dashboards
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
49
Checking for Data Sources
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
50
Checking for Data Sources
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
51
How can we import custom dashboards
Remember Slide 23 PostgreSQL We had exporter running but how did we see data from it
Lets see an example for PostgreSQL
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
52
How can we import custom dashboards
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
53
How can we import custom dashboards
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
54
How can we import custom dashboards
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
55
How can we import custom dashboards
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
56
How can we import custom dashboards
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
57
How can we import custom dashboards
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
58
How can we import custom dashboards
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
59
How can we import custom dashboards
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
60
How can we import custom dashboards
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
61
How can we import custom dashboards
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
62
How can we import custom dashboards
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
63
How can we import custom dashboards
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
64
How can we import custom dashboards
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
65
How can we import custom dashboards
Takeaways PMM uses Prometheus as datasource name Check for variables used
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
Creating Dashboards
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
67
Creating a dashboard from scratch
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
68
Creating a dashboard from scratch
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
69
Creating a dashboard from scratch
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
70
Cloning an existing dashboard
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
71
Why were these sections important
Dashboards are what holds everything together PMM is not just about gathering meaningful metrics but also about
displaying them Adding external exporters can break this harmony if the dashboards
used to show metrics dont follow the same principles
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
Extending Functionality Further
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
73
Extending functionality
We can even extend exporting capabilities further
httpsgithubcomalbertodonatoquery-exporter
In a nutshell this query exporter has the ability to add business logic from our application into the Dashboards
74
query-exporter
Questions
76
Rate Our Session
Thank You
74
query-exporter
Questions
76
Rate Our Session
Thank You
Questions
76
Rate Our Session
Thank You
76
Rate Our Session
Thank You
Thank You
top related