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.

See also

• MariaDB replication
• Replication threads
• SHOW PROCESSLIST. In SHOW PROCESSLIST output, slave threads are identified by Binlog Dump