I have setup and deployed the pmm-server as a Marathon app within Mesos and have successfully setup the linux:metrics and mysql:metrics monitoring on the mysql nodes I am interested in monitoring. I have not been able to successfully get mysql:queries to return anything to the server. Whenever I attempt to view any of the registered nodes I get an error message saying:
“QAN API error: “MySQL Query Analytics configuration not found”.
Check the /var/log/qan-api.log file in docker container for more information.”
Clicking into the server info tab also reports that no agents are connected.
I setup the pmm-client on the mysql nodes with the following steps:
- sudo pmm-client config --server pmm.dcos.us.monitoring.net --client-address 10.190.110.180
- sudo pmm-admin add mysql --user abc --password 123 --query-source=perfschema
NOTE: I have had to manually specify the client-address as without it the pmm-client was assigning the client-address to something other then the nodes ip address and resulted in errors attempting to listen on a local ports (42000, 42001, etc).
After the above the output of the version, config, list and check-network commands are as follows:
sudo pmm-admin --version
sudo pmm-admin config
OK, PMM server is alive.
sudo pmm-admin list
SERVICE TYPE NAME CLIENT PORT RUNNING DATA SOURCE OPTIONS
linux:metrics node1.northamerica.company.net 42000 YES -
mysql:queries node1.northamerica.company.net 42001 YES root:@unix(/var/lib/mysql/mysql.sock) query_source=perfschema
mysql:metrics node1.northamerica.company.net 42002 YES root:@unix(/var/lib/mysql/mysql.sock)
PMM Network Status
Server | pmm.dcos.us.monitoring.net
Client | 10.190.110.180
- Client → Server
SERVER SERVICE CONNECTIVITY