Unable to Load data In PMM2 dashboard

successfully completed pmm2 server installation & also configure pmm2 client into remote db server… In dashboard pmm2 agent is added but unable to load data into dashboard

pmm2 server status:
[root@node1 docker]# pmm-admin status
Agent ID: /agent_id/32d386d8-3150-49b7-9f46-526b07e923c1
Node ID : /node_id/c973924c-01e7-48cd-9c35-2d639db7fb4d

PMM Server:
URL : https://192.168.59.128:443/
Version: 2.23.0

PMM Client:
Connected : true
Time drift : 351.959µs
Latency : 623.232µs
pmm-admin version: 2.23.0
pmm-agent version: 2.23.0
Agents:
/agent_id/1eee4406-c274-4596-a8e3-1d5cbb85ac58 mysqld_exporter Running
/agent_id/6e54d12c-115c-4ba2-a8cb-e5420933e266 mysql_perfschema_agent Running
/agent_id/adf75ed9-b1b1-4907-8994-afe8d0e9cce4 node_exporter Running
/agent_id/bb694bae-6abf-40af-b0c3-ab7abd44d278 vmagent Running

Remote host/ pmm agent:
[root@node2 ~]# pmm-admin status
Agent ID: /agent_id/732da7e3-80e3-4833-bf44-c39563aca889
Node ID : /node_id/0d1f95f2-d719-4f35-8fe4-f29a622c53db

PMM Server:
URL : https://192.168.59.128:443/
Version: 2.23.0

PMM Client:
Connected : true
Time drift : 270.221753ms
Latency : 8.859067ms
pmm-admin version: 2.23.0
pmm-agent version: 2.23.0
Agents:
/agent_id/17109a29-7e95-4644-8b7c-96124e96c3b8 vmagent Running
/agent_id/69ecfc81-7e8a-4f60-8926-d076c3a3aa1f mysql_slowlog_agent Running
/agent_id/a6997f81-8a77-4a11-9221-a6c098831d97 node_exporter Running
/agent_id/f40f3398-698c-445e-9f0e-06e080a809ae mysqld_exporter Running

MySQL enterprise is running in node2(in pmm2 agent host)

Change the time view in PMM to the latest 5m. Still no data?

1 Like

Hi Matthewb,
Nothing changes, after changing time view in PMM.

Thanks

1 Like

Did you configure the remote agent via the web UI? If not, that might be the issue. Please remove the manually added agent and try again using the web UI for remote mysql.

1 Like

No changes done after adding remote node through web UI

image


1 Like

Finally data loaded, Issue was with server time…

Thanks

1 Like