How to set static port for mysql_exporter

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

Hi all,

Im having 3 nodes using:

pmm-admin version: 3.3.1
pmm-agent version: 3.3.1

These agents running in Pull method. I set up mysql_exporter using:

pmm-admin add mysql
–username=pmm
–password=pmmpassword
–host=localhost
–port=3306
–metrics-mode=pull
–query-source=perfschema
–agent-password=pmmpassword

This allows me to use my own prometheus, and alertmanager can scrape and monitor pmm agent metrics ( I can use my ansible, template files to setup prometheus and alertmanager).

The problem is the mysql_exporter port is not the same in between nodes. Node 1 has mysql_exporter running with port 42002, but others running with 42001.

I want to use same port because Im setting up my prometheus and alertmanager using ansible, which requires a template for pmm’ metrics endpoints.

How can I set static port for mysql_exporter ?

Thanks.