- 13.7.5 SHOW Syntax
- 13.7.5.1 SHOW AUTHORS Syntax
- 13.7.5.2 SHOW BINARY LOGS Syntax
- 13.7.5.3 SHOW BINLOG EVENTS Syntax
- 13.7.5.4 SHOW CHARACTER SET Syntax
- 13.7.5.5 SHOW COLLATION Syntax
- 13.7.5.6 SHOW COLUMNS Syntax
- 13.7.5.7 SHOW CONTRIBUTORS Syntax
- 13.7.5.8 SHOW CREATE DATABASE Syntax
- 13.7.5.9 SHOW CREATE EVENT Syntax
- 13.7.5.10 SHOW CREATE FUNCTION Syntax
- 13.7.5.11 SHOW CREATE PROCEDURE Syntax
- 13.7.5.12 SHOW CREATE TABLE Syntax
- 13.7.5.13 SHOW CREATE TRIGGER Syntax
- 13.7.5.14 SHOW CREATE VIEW Syntax
- 13.7.5.15 SHOW DATABASES Syntax
- 13.7.5.16 SHOW ENGINE Syntax
- 13.7.5.17 SHOW ENGINES Syntax
- 13.7.5.18 SHOW ERRORS Syntax
- 13.7.5.19 SHOW EVENTS Syntax
- 13.7.5.20 SHOW FUNCTION CODE Syntax
- 13.7.5.21 SHOW FUNCTION STATUS Syntax
- 13.7.5.22 SHOW GRANTS Syntax
- 13.7.5.23 SHOW INDEX Syntax
- 13.7.5.24 SHOW MASTER STATUS Syntax
- 13.7.5.25 SHOW OPEN TABLES Syntax
- 13.7.5.26 SHOW PLUGINS Syntax
- 13.7.5.27 SHOW PRIVILEGES Syntax
- 13.7.5.28 SHOW PROCEDURE CODE Syntax
- 13.7.5.29 SHOW PROCEDURE STATUS Syntax
- 13.7.5.30 SHOW PROCESSLIST Syntax
- 13.7.5.31 SHOW PROFILE Syntax
- 13.7.5.32 SHOW PROFILES Syntax
- 13.7.5.33 SHOW RELAYLOG EVENTS Syntax
- 13.7.5.34 SHOW SLAVE HOSTS Syntax
- 13.7.5.35 SHOW SLAVE STATUS Syntax
- 13.7.5.36 SHOW STATUS Syntax
- 13.7.5.37 SHOW TABLE STATUS Syntax
- 13.7.5.38 SHOW TABLES Syntax
- 13.7.5.39 SHOW TRIGGERS Syntax
- 13.7.5.40 SHOW VARIABLES Syntax
- 13.7.5.41 SHOW WARNINGS 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 |
+------------+-----------+------+-----------+--------------------------------------+
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=.valueHost: 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_namePort: 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'sauto.cnffile.This column was added in MySQL 5.6.0.
User Comments
SHOW SLAVE HOSTS syntax doesn't display a list of replication slaves when it's configured a daizy-chain replication - A->B->A. When both servers act as masters i.e there's not server breakdown, both servers replicate to each other. So at one time one of them will act as slave so I don't understand why its options wouldn't be visible in this list.
my mistake: not daisy-chain replication I mean multi-master replication
The slave's --report-X parameters have a lot to do with what appears here. They control the hostname, port, username and password. The username and password appear only if --show-slave-auth-info is set on the master.
Add your own comment.