Not the answer you need?
Register and ask your own question!

Added 4 MySQL servers as clients but the PMM Metrics Monitor only shows one

MilosMilos EntrantCurrent User Role Beginner
Hi All, I ha ve 5 servers in total:

1. Used for pmm-server, installed with Docker
2. MySQL master server for DB1
3. MySQL slave server for DB1 (Maria DB)
4. MySQL slave server for DB1 (Maria DB)
5. MySQL master server for DB2

I installed the pmm-client on all 4 servers (2-5) but on the graph/dashboard/db/cross-server-graphs?refresh=1m&orgId=1 url, I can only see the metrics for the pmm-server and the server number 2 hosting the DB1 master DB.

Any idea on what I am doing wrong? Should I open some ports on other servers (firewall)? Is there something to do in MySQL settings, on the Pmm server side?
Note that the port used is 8077 for the master.

On all 4 MySQL servers, I can see while executing sudo pmm-admin list:

2. pmm-admin 1.7.0

PMM Server | aaa.aaa.aaa.aaa::8077
Client Name | MySQL
Client Address | bbb.bbb.bbb.bbb
Service Manager | linux-upstart






SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS





mysql:queries MySQL - YES root:***@unix(/var/run/mysqld/mysqld.sock) query_source=slowlog, query_examples=true
linux:metrics MySQL 42000 YES -
mysql:metrics MySQL 42002 YES root:***@unix(/var/run/mysqld/mysqld.sock) tablestats=OFF


3. pmm-admin 1.7.0

PMM Server | aaa.aaa.aaa.aaa::8077
Client Name | mysql3
Client Address | ccc.ccc.ccc.ccc
Service Manager | linux-systemd






SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS





mysql:queries mysql3 - YES root:***@unix(/var/run/mysqld/mysqld.sock) query_source=slowlog, query_examples=true
linux:metrics mysql3 42000 YES -
mysql:metrics mysql3 42002 YES root:***@unix(/var/run/mysqld/mysqld.sock) tablestats=OFF


4. pmm-admin 1.7.0

PMM Server | aaa.aaa.aaa.aaa:8077
Client Name | mysql2
Client Address | ddd.ddd.ddd.ddd
Service Manager | linux-systemd






SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS





mysql:queries mysql2 - YES root:***@unix(/var/run/mysqld/mysqld.sock) query_source=slowlog, query_examples=true
linux:metrics mysql2 42000 YES -
mysql:metrics mysql2 42002 YES root:***@unix(/var/run/mysqld/mysqld.sock) tablestats=OFF


5. pmm-admin 1.7.0

PMM Server | aaa.aaa.aaa.aaa::8077
Client Name | chbslds018
Client Address | eee.eee.eee.eee
Service Manager | linux-upstart






SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS





mysql:queries chbslds018 - YES root:***@unix(/var/run/mysqld/mysqld.sock) query_source=slowlog, query_examples=true
linux:metrics chbslds018 42000 YES -
mysql:metrics chbslds018 42002 YES root:***@unix(/var/run/mysqld/mysqld.sock)

Thank you!

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.