mysql-unit之 mysqldrplshow 在mysql 复制环境中的使用

jikcheng

 显示当前的主机从机的配置拓扑图

[root@mysqldb ~]# mysqlrplshow --master=root:123@127.0.0.1:3307 --discover-slaves-login=root:123;
WARNING: Using a password on the command line interface can be insecure.
# master on 127.0.0.1: ... connected.
# Finding slaves for master: 127.0.0.1:3307

# Replication Topology Graph
127.0.0.1:3307 (MASTER)
   |
   +--- 127.0.0.1:3308 - (SLAVE)
   |
   +--- 127.0.0.1:3309 - (SLAVE)


显示拓扑图的详细信息：
[root@mysqldb ~]# mysqlrplshow --master=root:123@127.0.0.1:3307 --discover-slaves-login=root:123 --verbose;
WARNING: Using a password on the command line interface can be insecure.
# master on 127.0.0.1: ... connected.
# Finding slaves for master: 127.0.0.1:3307
WARNING: Unable to find aliases for hostname 'mysqldb' reason: [Errno 1] Unknown host

# Replication Topology Graph
127.0.0.1:3307 (MASTER)
   |
   +--- 127.0.0.1:3308 [IO: Yes, SQL: Yes] - (SLAVE)
   |
   +--- 127.0.0.1:3309 [IO: Yes, SQL: Yes] - (SLAVE)