MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

13.7.7.33 SHOW SLAVE HOSTS Statement

SHOW SLAVE HOSTS

Displays a list of replicas currently registered with the source. SHOW SLAVE HOSTS requires the REPLICATION SLAVE privilege.

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

mysql> SHOW SLAVE HOSTS;
+------------+-----------+------+-----------+--------------------------------------+
| Server_id  | Host      | Port | Master_id | Slave_UUID                           |
+------------+-----------+------+-----------+--------------------------------------+
|  192168010 | iconnect2 | 3306 | 192168011 | 14cb6624-7f93-11e0-b2c0-c80aa9429562 |
| 1921680101 | athena    | 3306 | 192168011 | 07af4990-f41f-11df-a566-7ac56fdaf645 |
+------------+-----------+------+-----------+--------------------------------------+