So to start back to beginning
I have gone back to trying for the mysql data
on the agent server I have
-bash-4.1$ sudo pmm-admin add mysql:metrics mysql_swcolabmysql01 --user pmm_admin --password PASSWORD --host 192.168.142.138
OK, now monitoring MySQL metrics using DSN pmm_admin:***@tcp(192.168.142.138:3306)
-bash-4.1$
-bash-4.1$
-bash-4.1$
-bash-4.1$ sudo pmm-admin list
pmm-admin 1.5.3
PMM Server | 192.168.145.100 (password-protected)
Client Name | swcolabmysql01.wco.int
Client Address | 192.168.142.138
Service Manager | unix-systemv
SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS
linux:metrics linux_swcolabmysql01 42000 YES -
mysql:metrics mysql_swcolabmysql01 42002 YES pmm_admin:***@tcp(192.168.142.138:3306)
On the PMM Server I now have done
[root@scordbapmm01 ~]# pmm-admin list
pmm-admin 1.5.2
PMM Server | 192.168.145.100 (password-protected)
Client Name | scordbapmm01.wco.int
Client Address | 192.168.145.100
Service Manager | linux-systemd
No services under monitoring.
[root@scordbapmm01 ~]# pmm-admin add linux:metrics
OK, now monitoring this system.
[root@scordbapmm01 ~]# pmm-admin list
pmm-admin 1.5.2
PMM Server | 192.168.145.100 (password-protected)
Client Name | scordbapmm01.wco.int
Client Address | 192.168.145.100
Service Manager | linux-systemd
SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS
linux:metrics scordbapmm01.wco.int 42000 YES -
[root@scordbapmm01 ~]# pmm-admin list
pmm-admin 1.5.2
PMM Server | 192.168.145.100 (password-protected)
Client Name | scordbapmm01.wco.int
Client Address | 192.168.145.100
Service Manager | linux-systemd
SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS
linux:metrics scordbapmm01.wco.int 42000 YES -
[root@scordbapmm01 ~]# pmm-admin list
pmm-admin 1.5.2
PMM Server | 192.168.145.100 (password-protected)
Client Name | scordbapmm01.wco.int
Client Address | 192.168.145.100
Service Manager | linux-systemd
SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS
linux:metrics scordbapmm01.wco.int 42000 YES -
[root@scordbapmm01 ~]# pmm-admin add mysql
[linux:metrics] OK, already monitoring this system.
[mysql:metrics] OK, now monitoring MySQL metrics using DSN root:@unix(/var/lib/mysql/mysql.sock)
[mysql:queries] OK, now monitoring MySQL queries from slowlog using DSN root:@unix(/var/lib/mysql/mysql.sock)
[root@scordbapmm01 ~]#
[root@scordbapmm01 ~]#
[root@scordbapmm01 ~]#
[root@scordbapmm01 ~]# pmm-admin list
pmm-admin 1.5.2
PMM Server | 192.168.145.100 (password-protected)
Client Name | scordbapmm01.wco.int
Client Address | 192.168.145.100
Service Manager | linux-systemd
SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS
mysql:queries scordbapmm01.wco.int - YES root:@unix(/var/lib/mysql/mysql.sock) query_source=slowlog, query_examples=true
linux:metrics scordbapmm01.wco.int 42000 YES -
mysql:metrics scordbapmm01.wco.int 42002 YES root:@unix(/var/lib/mysql/mysql.sock)