# No data pmm MySQL Replication Summary **URL:** \ **Category:** Percona Monitoring and Management (PMM)\ **Tags:** pmm, mysql, percona\ **Created:** [November 20, 2021, 6:47am UTC](https://forums.percona.com/t/no-data-pmm-mysql-replication-summary/13126 "2021-11-20T06:47:15Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![KevinU](https://avatars.discourse-cdn.com/v4/letter/k/a88e4f/32.png) [@KevinU](https://forums.percona.com/u/KevinU)\ **Post date:** [November 20, 2021, 6:47am UTC](https://forums.percona.com/t/no-data-pmm-mysql-replication-summary/13126/1 "2021-11-20T06:47:15Z")
add mysql service pmm-admin add mysql mysql8 --query-source=perfschema --username=pmm --password=xxxxxxx --replication-set=192.168.17.89 [root@cellsoft-m1-v1-node1 ~]# pmm-admin list Service type Service name Address and port Service ID MySQL mysql8 127.0.0.1:3306 /service\_id/d59fa380-5436-42fd-88ab-e7f105b664ce Agent type Status Metrics Mode Agent ID Service ID pmm\_agent Connected /agent\_id/65f92f63-3347-415f-be99-23525a82bdc3 node\_exporter Running push /agent\_id/b199aa81-82a5-4b97-8cdb-88b261ee31bb mysqld\_exporter Running push /agent\_id/f35e4bbc-2fa7-47fc-ab12-a70b6b00e118 /service\_id/d59fa380-5436-42fd-88ab-e7f105b664ce mysql\_perfschema\_agent Running /agent\_id/361e0d9b-27a4-484b-97c9-1644d3ccf95d /service\_id/d59fa380-5436-42fd-88ab-e7f105b664ce vmagent Running push /agent\_id/cc4cf691-f525-469d-870a-aff678484c56 # pmm-admin status Agent ID: /agent\_id/65f92f63-3347-415f-be99-23525a82bdc3 Node ID : /node\_id/67dc9e17-7b7c-4b33-ad51-9d2e96e4a0c3 PMM Server: URL : [https://192.168.17.89:443/](https://192.168.17.89:443/) Version: 2.23.0 PMM Client: Connected : true Time drift : 158.81204ms Latency : 691.555µs pmm-admin version: 2.23.0 pmm-agent version: 2.23.0 Agents: /agent\_id/361e0d9b-27a4-484b-97c9-1644d3ccf95d mysql\_perfschema\_agent Running /agent\_id/b199aa81-82a5-4b97-8cdb-88b261ee31bb node\_exporter Running /agent\_id/cc4cf691-f525-469d-870a-aff678484c56 vmagent Running /agent\_id/f35e4bbc-2fa7-47fc-ab12-a70b6b00e118 mysqld\_exporter Running and that ![219aaa9d4f47fa18a03d063f692c73d](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/2/20591224047626927d8baa9455f818e415b602f5.jpeg) how to do resolve it ? thank you very much. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [November 22, 2021, 3:44pm UTC](https://forums.percona.com/t/no-data-pmm-mysql-replication-summary/13126/2 "2021-11-22T15:44:39Z")
@KevinU Please log in manually using the same pmm user/pass you used when adding the service. Can you execute ‘SHOW SLAVE STATUS’? If not, you have a permissions problem and you need to GRANT REPLICATION CLIENT to the PMM user. ---
**Author:** ![KevinU](https://avatars.discourse-cdn.com/v4/letter/k/a88e4f/32.png) [@KevinU](https://forums.percona.com/u/KevinU)\ **Post date:** [November 23, 2021, 1:31am UTC](https://forums.percona.com/t/no-data-pmm-mysql-replication-summary/13126/3 "2021-11-23T01:31:53Z")
thank you reply on server 88: # mysql -h192.168.17.88 -upmm -p mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 34876 Server version: 8.0.22 MySQL Community Server - GPL Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. mysql\> show slave status\G; Empty set, 1 warning (0.01 sec) ERROR: No query specified mysql\> show master status\G; \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* File: mysql-bin.000005 Position: 152794 Binlog\_Do\_DB: Binlog\_Ignore\_DB: Executed\_Gtid\_Set: 776a7b31-646c-11eb-aacb-000c291af149:1-21307 1 row in set (0.01 sec) ERROR: No query specified’’ on server 89: # mysql -upmm -p mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19353 Server version: 8.0.22 MySQL Community Server - GPL Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. mysql\> show slave status\G; \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* Slave\_IO\_State: Waiting for master to send event Master\_Host: 192.168.17.88 Master\_User: repl Master\_Port: 3306 Connect\_Retry: 60 Master\_Log\_File: mysql-bin.000005 Read\_Master\_Log\_Pos: 152794 Relay\_Log\_File: cellsoft-m1-v1-node2-relay-bin.000004 Relay\_Log\_Pos: 152669 Relay\_Master\_Log\_File: mysql-bin.000005 Slave\_IO\_Running: Yes Slave\_SQL\_Running: Yes Replicate\_Do\_DB: Replicate\_Ignore\_DB: Replicate\_Do\_Table: Replicate\_Ignore\_Table: Replicate\_Wild\_Do\_Table: Replicate\_Wild\_Ignore\_Table: Last\_Errno: 0 Last\_Error: Skip\_Counter: 0 Exec\_Master\_Log\_Pos: 152794 Relay\_Log\_Space: 153354 Until\_Condition: None Until\_Log\_File: Until\_Log\_Pos: 0 Master\_SSL\_Allowed: No Master\_SSL\_CA\_File: Master\_SSL\_CA\_Path: Master\_SSL\_Cert: Master\_SSL\_Cipher: Master\_SSL\_Key: Seconds\_Behind\_Master: 0 Master\_SSL\_Verify\_Server\_Cert: No Last\_IO\_Errno: 0 Last\_IO\_Error: Last\_SQL\_Errno: 0 Last\_SQL\_Error: Replicate\_Ignore\_Server\_Ids: Master\_Server\_Id: 1 Master\_UUID: 776a7b31-646c-11eb-aacb-000c291af149 Master\_Info\_File: mysql.slave\_master\_info SQL\_Delay: 0 SQL\_Remaining\_Delay: NULL Slave\_SQL\_Running\_State: Slave has read all relay log; waiting for more updates Master\_Retry\_Count: 86400 Master\_Bind: Last\_IO\_Error\_Timestamp: Last\_SQL\_Error\_Timestamp: Master\_SSL\_Crl: Master\_SSL\_Crlpath: Retrieved\_Gtid\_Set: Executed\_Gtid\_Set: 776a7b31-646c-11eb-aacb-000c291af149:1-21503 Auto\_Position: 0 Replicate\_Rewrite\_DB: Channel\_Name: Master\_TLS\_Version: Master\_public\_key\_path: Get\_master\_public\_key: 0 Network\_Namespace: 1 row in set, 1 warning (0.01 sec) ERROR: No query specified ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [November 23, 2021, 4:43pm UTC](https://forums.percona.com/t/no-data-pmm-mysql-replication-summary/13126/4 "2021-11-23T16:43:00Z")
@KevinU, First thing, stop doing this: ``` show slave status\G; ``` \G is a terminator. You don’t need both \G and ; Pick one or the other, not both. Next, your PMM screenshot is very small, hard to read, but I think it is showing server .88? Well, then it is correct. In your connection example below, you connected to .88 and ran SHOW SLAVE STATUS which says ‘Empty set’, so I can only assume this is your master/source server. Thus, there will not be any replication information in PMM. All replication information comes from the replicas. Switch to this server in PMM and you’ll see the data. ---
**Author:** ![KevinU](https://avatars.discourse-cdn.com/v4/letter/k/a88e4f/32.png) [@KevinU](https://forums.percona.com/u/KevinU)\ **Post date:** [November 24, 2021, 2:31am UTC](https://forums.percona.com/t/no-data-pmm-mysql-replication-summary/13126/5 "2021-11-24T02:31:14Z")
server 88 is master server 89 is slave \G for easy to read. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [November 24, 2021, 4:07am UTC](https://forums.percona.com/t/no-data-pmm-mysql-replication-summary/13126/6 "2021-11-24T04:07:04Z")
Yes, I said all that above. Since 88 is the master there will never be any PMM replication data for this server. Yes, \G for easy reading, but don’t do “\G;” You don’t need the semi-colon after \G. ---
**Author:** ![KevinU](https://avatars.discourse-cdn.com/v4/letter/k/a88e4f/32.png) [@KevinU](https://forums.percona.com/u/KevinU)\ **Post date:** [November 24, 2021, 4:50am UTC](https://forums.percona.com/t/no-data-pmm-mysql-replication-summary/13126/7 "2021-11-24T04:50:16Z")
Why pmm reading slave status from master node? ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [November 24, 2021, 5:11am UTC](https://forums.percona.com/t/no-data-pmm-mysql-replication-summary/13126/8 "2021-11-24T05:11:24Z")
PMM reads the same data from all nodes. ---
**Author:** ![KevinU](https://avatars.discourse-cdn.com/v4/letter/k/a88e4f/32.png) [@KevinU](https://forums.percona.com/u/KevinU)\ **Post date:** [November 24, 2021, 6:07am UTC](https://forums.percona.com/t/no-data-pmm-mysql-replication-summary/13126/9 "2021-11-24T06:07:00Z")
Hi I change master to slave; on server 89: mysql\> stop slave; Query OK, 0 rows affected, 1 warning (0.03 sec) mysql\> reset slave all; Query OK, 0 rows affected, 1 warning (0.03 sec) mysql\> show master status; ±--------------±---------±-------------±-----------------±---------------------------------------------+ | File | Position | Binlog\_Do\_DB | Binlog\_Ignore\_DB | Executed\_Gtid\_Set | ±--------------±---------±-------------±-----------------±---------------------------------------------+ | binlog.000014 | 151915 | | | 776a7b31-646c-11eb-aacb-000c291af149:1-21503 | ±--------------±---------±-------------±-----------------±---------------------------------------------+ 1 row in set (0.00 sec) on server 88: mysql\> CHANGE MASTER TO MASTER\_HOST=‘192.168.17.89’,MASTER\_USER=‘repl’,MASTER\_PASSWORD=‘cellsoft@My888’,MASTER\_LOG\_FILE=‘binlog.000014’,MASTER\_LOG\_POS=151915; Query OK, 0 rows affected, 2 warnings (0.02 sec) mysql\> show warnings\G; \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* Level: Note Code: 1759 Message: Sending passwords in plain text without SSL/TLS is extremely insecure. \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 2. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* Level: Note Code: 1760 Message: Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the ‘START SLAVE Syntax’ in the MySQL Manual for more information. 2 rows in set (0.01 sec) ERROR: No query specified mysql\> start slave; Query OK, 0 rows affected, 1 warning (0.01 sec) mysql\> show slave status\G: \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* Slave\_IO\_State: Waiting for master to send event Master\_Host: 192.168.17.89 Master\_User: repl Master\_Port: 3306 Connect\_Retry: 60 Master\_Log\_File: binlog.000014 Read\_Master\_Log\_Pos: 151915 Relay\_Log\_File: cellsoft-m1-v1-node1-relay-bin.000002 Relay\_Log\_Pos: 321 Relay\_Master\_Log\_File: binlog.000014 Slave\_IO\_Running: Yes Slave\_SQL\_Running: Yes Replicate\_Do\_DB: Replicate\_Ignore\_DB: Replicate\_Do\_Table: Replicate\_Ignore\_Table: Replicate\_Wild\_Do\_Table: Replicate\_Wild\_Ignore\_Table: Last\_Errno: 0 Last\_Error: Skip\_Counter: 0 Exec\_Master\_Log\_Pos: 151915 Relay\_Log\_Space: 545 Until\_Condition: None Until\_Log\_File: Until\_Log\_Pos: 0 Master\_SSL\_Allowed: No Master\_SSL\_CA\_File: Master\_SSL\_CA\_Path: Master\_SSL\_Cert: Master\_SSL\_Cipher: Master\_SSL\_Key: Seconds\_Behind\_Master: 0 Master\_SSL\_Verify\_Server\_Cert: No Last\_IO\_Errno: 0 Last\_IO\_Error: Last\_SQL\_Errno: 0 Last\_SQL\_Error: Replicate\_Ignore\_Server\_Ids: Master\_Server\_Id: 2 Master\_UUID: 776a7b31-646c-11eb-aacb-000c291af888 Master\_Info\_File: mysql.slave\_master\_info SQL\_Delay: 0 SQL\_Remaining\_Delay: NULL Slave\_SQL\_Running\_State: Slave has read all relay log; waiting for more updates Master\_Retry\_Count: 86400 Master\_Bind: Last\_IO\_Error\_Timestamp: Last\_SQL\_Error\_Timestamp: Master\_SSL\_Crl: Master\_SSL\_Crlpath: Retrieved\_Gtid\_Set: Executed\_Gtid\_Set: 776a7b31-646c-11eb-aacb-000c291af149:1-21307 Auto\_Position: 0 Replicate\_Rewrite\_DB: Channel\_Name: Master\_TLS\_Version: Master\_public\_key\_path: Get\_master\_public\_key: 0 Network\_Namespace: 1 row in set, 1 warning (0.01 sec) the pmm still empty? ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/f/f3ed1cf830bcf8bdfd5340088de7299875f8def1.png) please help to me? thank you very much. ---
**Author:** ![KevinU](https://avatars.discourse-cdn.com/v4/letter/k/a88e4f/32.png) [@KevinU](https://forums.percona.com/u/KevinU)\ **Post date:** [November 24, 2021, 6:21am UTC](https://forums.percona.com/t/no-data-pmm-mysql-replication-summary/13126/10 "2021-11-24T06:21:36Z")
I switch over master to slave; on server 89: mysql\> stop slave; Query OK, 0 rows affected, 1 warning (0.03 sec) mysql\> reset slave all; Query OK, 0 rows affected, 1 warning (0.03 sec) mysql\> show master status; ±--------------±---------±-------------±-----------------±---------------------------------------------+ | File | Position | Binlog\_Do\_DB | Binlog\_Ignore\_DB | Executed\_Gtid\_Set | ±--------------±---------±-------------±-----------------±---------------------------------------------+ | binlog.000014 | 151915 | | | 776a7b31-646c-11eb-aacb-000c291af149:1-21503 | ±--------------±---------±-------------±-----------------±---------------------------------------------+ 1 row in set (0.00 sec) on server 88: mysql\> CHANGE MASTER TO MASTER\_HOST=‘192.168.17.89’,MASTER\_USER=‘repl’,MASTER\_PASSWORD=‘cellsoft@My888’,MASTER\_LOG\_FILE=‘binlog.000014’,MASTER\_LOG\_POS=151915; Query OK, 0 rows affected, 2 warnings (0.02 sec) mysql\> show warnings\G; \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* Level: Note Code: 1759 Message: Sending passwords in plain text without SSL/TLS is extremely insecure. \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 2. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* Level: Note Code: 1760 Message: Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the ‘START SLAVE Syntax’ in the MySQL Manual for more information. 2 rows in set (0.01 sec) ERROR: No query specified mysql\> start slave; Query OK, 0 rows affected, 1 warning (0.01 sec) mysql\> show slave status\G: \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* Slave\_IO\_State: Waiting for master to send event Master\_Host: 192.168.17.89 Master\_User: repl Master\_Port: 3306 Connect\_Retry: 60 Master\_Log\_File: binlog.000014 Read\_Master\_Log\_Pos: 151915 Relay\_Log\_File: cellsoft-m1-v1-node1-relay-bin.000002 Relay\_Log\_Pos: 321 Relay\_Master\_Log\_File: binlog.000014 Slave\_IO\_Running: Yes Slave\_SQL\_Running: Yes Replicate\_Do\_DB: Replicate\_Ignore\_DB: Replicate\_Do\_Table: Replicate\_Ignore\_Table: Replicate\_Wild\_Do\_Table: Replicate\_Wild\_Ignore\_Table: Last\_Errno: 0 Last\_Error: Skip\_Counter: 0 Exec\_Master\_Log\_Pos: 151915 Relay\_Log\_Space: 545 Until\_Condition: None Until\_Log\_File: Until\_Log\_Pos: 0 Master\_SSL\_Allowed: No Master\_SSL\_CA\_File: Master\_SSL\_CA\_Path: Master\_SSL\_Cert: Master\_SSL\_Cipher: Master\_SSL\_Key: Seconds\_Behind\_Master: 0 Master\_SSL\_Verify\_Server\_Cert: No Last\_IO\_Errno: 0 Last\_IO\_Error: Last\_SQL\_Errno: 0 Last\_SQL\_Error: Replicate\_Ignore\_Server\_Ids: Master\_Server\_Id: 2 Master\_UUID: 776a7b31-646c-11eb-aacb-000c291af888 Master\_Info\_File: mysql.slave\_master\_info SQL\_Delay: 0 SQL\_Remaining\_Delay: NULL Slave\_SQL\_Running\_State: Slave has read all relay log; waiting for more updates Master\_Retry\_Count: 86400 Master\_Bind: Last\_IO\_Error\_Timestamp: Last\_SQL\_Error\_Timestamp: Master\_SSL\_Crl: Master\_SSL\_Crlpath: Retrieved\_Gtid\_Set: Executed\_Gtid\_Set: 776a7b31-646c-11eb-aacb-000c291af149:1-21307 Auto\_Position: 0 Replicate\_Rewrite\_DB: Channel\_Name: Master\_TLS\_Version: Master\_public\_key\_path: Get\_master\_public\_key: 0 Network\_Namespace: 1 row in set, 1 warning (0.01 sec) ok. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/2/2ab404abcd7e93f0ed5cded669dc4584daaefc64.png) thank you.