Mysql在master上查看有哪些slave
mysql> select * from information_schema.processlist as p where p.command = 'Binlog Dump';
或
mysql> show slave hosts;(此方法需要在从服务启动时指定--report-host=HOSTNAME选项,此处HOSTNAME为任意名称。)
ref: https://blog.51cto.com/linuxtips/1773936
mysql> select * from information_schema.processlist as p where p.command = 'Binlog Dump';
或
mysql> show slave hosts;(此方法需要在从服务启动时指定--report-host=HOSTNAME选项,此处HOSTNAME为任意名称。)
ref: https://blog.51cto.com/linuxtips/1773936