pt-slave-find

pt-slave-find:​​官方地址​​

说明

用途：查看主从环境的复制层次结构图，类似于拓扑图的意思。

语法：

pt-slave-find [OPTIONS] [DSN]

具体例子

[root@BigData ~]# pt-slave-find h=192.168.20.5,p=Sanshi_408,P=3306,u=root
192.168.20.5   --主库
Version         5.7.25-log
Server ID       5
Uptime          9+09:49:32 (started 2019-07-23T00:01:32)
Replication     Is not a slave, has 1 slaves connected, is not read_only
Filters
Binary logging  MIXED
Slave status
Slave mode      STRICT
Auto-increment  increment 1, offset 1
InnoDB version  5.7.25
+- 192.168.20.6     --从库
   Version         5.7.25-log
   Server ID       6
   Uptime          6+18:31:24 (started 2019-07-25T15:19:40)