Install only qan packages

Percona Monitoring and Management (PMM) PMM 1.x
1

Hi,
i already use prometheus and mysql exporter with percona app plugin for grafana.
I don’t want another prometheus shipped with PMM but I want to use qan too, so it is possible to install only QAN part of PMM ? how i can do this?

Thank you everyone

2

Hi Antonio Falzarano ,

About PMM Server:
It is possible, you have two ways: [LIST=1]
[]install everything manually. it is really not a trivial task.
you can find components on [url]Percona Monitoring and Management page.
repositories of all components are located on GitHub - [url]https://github.com/percona/[/url]
useful PMM Server setup information can be found in Ansible scripts
[url]https://github.com/percona/pmm-server/blob/master/playbook-init.yml[/url]
[url]https://github.com/percona/pmm-server/blob/master/playbook-install.yml[/url]
It is the totally unsupported way!
[]you can start PMM Server as usual (as docker container) and use only QAN functionality (see below).
[/LIST]About PMM Client:
pmm-admin tool supports the possibility to add QAN and Metrics independently.
So it is possible to add only QAN monitoring without exporters.
just use
{code}sudo pmm-admin add mysql:queries{code}
instead of
{code}sudo pmm-admin add mysql{code}

anyway, keep in mind that percona exporters have SSL and Authentification support, this is not supported in original prometheus exporters (see [url]https://www.robustperception.io/prometheus-security-authentication-authorization-and-encryption/[/url])
also, percona/mysqld_exporter smarter that original, we have three different targets for high, medium and low resolution metrics, because internal database performance debug requires high-resolution for some metrics.

3

Hi Mykola , thank you , i look into this informations.
About different resolution metrics there is some documentation that can i read, to understand differences with original mysql_exporter?

4

All Percona code is publically available, so if you want you can diff changes between percona/mysqld_exporter and prometheus/mysqld_exporter repositories.

Anyway, his part is not well documented yet, so I created a ticket - PMM-1162, it is publicly visible and you can register in our Jira and add self to the watcher list or vote for this ticket or write any suggestions :slight_smile:

5

Thank you Mykola, it seems that PMM-1162 is not a public ticket, i miss something?

photoid=49495
photoid=494951479×820 26 KB

6

Hi Antonio Falzarano , I’ve just configured the security settings for that issue, it should now load correctly. [url][PMM-1407] Document differences between upstream and percona exporters - Percona JIRA