Syntax
------ 
SHOW SLAVE HOSTS
 
Description
----------- 
This command is run on the master and displays a list of
replication slaves that are currently registered with it.
Only slaves started with the --report-host=host_name option
are visible in this list.
 
The list is displayed on any server (not just the master
server). The output
looks like this:
 
SHOW SLAVE HOSTS;
+------------+-----------+------+-----------+
| Server_id | Host | Port | Master_id |
+------------+-----------+------+-----------+
| 192168010 | iconnect2 | 3306 | 192168011 |
| 1921680101 | athena | 3306 | 192168011 |
+------------+-----------+------+-----------+
Server_id: The unique server ID of the slave server, as
configured in the server's option file, or on the command
line with --server-id=value.
Host: The host name of the slave server, as configured in
the server's option file, or on the command line with
--report-host=host_name. Note that this can differ from the
machine name as configured in the operating system.
Port: The port the slave server is listening on.
Master_id: The unique server ID of the master server that
the slave server is replicating from.
 
Some MariaDB and MySQL versions report another variable,
rpl_recovery_rank. This
variable was never used, and was eventually removed in
MariaDB 10.1.2 and MySQL 5.6.
 


URL: https://mariadb.com/kb/en/show-slave-hosts/