This documentation is for an older version. If you're using the most current version, select the documentation for that version with the version switch in the upper right corner of the online documentation, or by downloading a newer PDF or EPUB file. SHOW SLAVE HOSTS Syntax


Displays a list of replication slaves currently registered with the master. Only slaves started with the --report-host=host_name option are visible in this list.

SHOW SLAVE HOSTS should be executed on a server that acts as a replication master. The statement displays information about servers that are or have been connected as replication slaves, with each row of the result corresponding to one slave server, as shown here:

| Server_id  | Host      | Port | Master_id |
|  192168010 | iconnect2 | 3306 | 192168011 |
| 1921680101 | athena    | 3306 | 192168011 |

Some MySQL versions report another variable, Rpl_recovery_rank. This variable was never used, and was eventually removed. (Bug #13963)