Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
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 |+------------+-----------+------+-----------+--------------------------------------+
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=.
Note that this can differ from the machine name as configured in the operating system. host_name
Port: The port the slave server is listening on.
In MySQL 5.6.5 and later, a zero in this column means that the slave port (--report-port) was not set. Prior to MySQL 5.6.5, 3306 was used as the
default in such cases (Bug #13333431).
Master_id: The unique server ID of the master server
that the slave server is replicating from.
Slave_UUID: The globally unique ID of this slave, as generated on the slave
and found in the slave's auto.cnf file.
This column was added in MySQL 5.6.0.