24. pt-slave-find

 

pt-slave-find --host 192.168.100.101 --port 3306 --user admin --password admin

 

[root@server01 test]# pt-slave-find --host 192.168.100.101 --port 3306 --user admin --password admin
192.168.100.101
Version 5.7.20-log
Server ID 1013306
Uptime 04:25:45 (started 2018-11-23T12:01:16)
Replication Is not a slave, has 2 slaves connected, is not read_only
Filters
Binary logging ROW
Slave status
Slave mode STRICT
Auto-increment increment 1, offset 1
InnoDB version 5.7.20
+- 192.168.100.102
Version 5.7.20-log
Server ID 1023306
Uptime 02:55 (started 2018-11-23T16:24:06)
Replication Is a slave, has 0 slaves connected, is not read_only
Filters
Binary logging ROW
Slave status 104780 seconds behind, running, no errors
Slave mode STRICT
Auto-increment increment 1, offset 1
InnoDB version 5.7.20
+- 192.168.100.103
Version 5.7.20-log
Server ID 1033306
Uptime 03:15 (started 2018-11-23T16:23:46)
Replication Is a slave, has 0 slaves connected, is not read_only
Filters
Binary logging ROW
Slave status 108849 seconds behind, running, no errors
Slave mode STRICT
Auto-increment increment 1, offset 1
InnoDB version 5.7.20