Mysql在master上查看有哪些slave

mysql> select * from information_schema.processlist as p where p.command = 'Binlog Dump'; 

或

mysql> show slave hosts;(此方法需要在从服务启动时指定--report-host=HOSTNAME选项，此处HOSTNAME为任意名称。)

这个红色的黄海没有测试到，可能不好使，也可能是我们的配置不对。

 

MariaDB [(none)]> select * from information_schema.processlist as p where p.command = 'Binlog Dump';
+-------+------+-----------------+------+-------------+------+----------------+------+------------+-------+-----------+----------+-------------+---------------+----------+-------------+-------+
| ID    | USER | HOST            | DB   | COMMAND     | TIME | STATE          | INFO | TIME_MS    | STAGE | MAX_STAGE | PROGRESS | MEMORY_USED | EXAMINED_ROWS | QUERY_ID | INFO_BINARY | TID   |
+-------+------+-----------------+------+-------------+------+-----------