Spec-Zone .ru
спецификации, руководства, описания, API

13.7.5.34. SHOW SLAVE HOSTS Syntax

SHOW SLAVE HOSTS

Displays a list of replication slaves currently registered with the master.

The list is displayed on any server (not just the master server). The output looks like this:

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 |+------------+-----------+------+-----------+--------------------------------------+