I’m trying to start pmm client on a docker container to monitor query of a remote Percona server where it’s not possible to install pmm, as for example for AWS RDS service. I can exec this command sequence at container startup
pmm-admin config --client-name mypmmclient --server perconapmmhost
pmm-admin --host perconahost --user root --password root add mysql
pmm-admin list
pmm-admin start --all
with such logs (actually percona server is on another container on localhost)
OK, PMM server is alive.
PMM Server | perconapmmhost
Client Name | 09e3b496d586
Client Address | 172.19.0.8
[linux:metrics] OK, now monitoring this system.
[mysql:metrics] OK, now monitoring MySQL metrics using DSN root:git03
[mysql:queries] OK, now monitoring MySQL queries from perfschema using DSN root:git03
pmm-admin 1.0.5
PMM Server | perconapmmhost
Client Name | 09e3b496d586
Client Address | 172.19.0.8
Service manager | unix-systemv
SERVICE TYPE NAME CLIENT PORT RUNNING DATA SOURCE OPTIONS
linux:metrics 09e3b496d586 42000 YES -
mysql:queries 09e3b496d586 42001 YES root:git03 query_source=perfschema
mysql:metrics 09e3b496d586 42002 YES root:git03
My problem is that I don’t know how to run percona-qan-agent in container and I’m not able to monitor queries. I’m trying to use docker container for pmm-client to setup a “portable” version in the same way as pmm-server.
Thanks
Luca