- 12.5.5 SHOW Syntax
- 12.5.5.1 SHOW AUTHORS Syntax
- 12.5.5.2 SHOW BINARY LOGS Syntax
- 12.5.5.3 SHOW BINLOG EVENTS Syntax
- 12.5.5.4 SHOW CHARACTER SET Syntax
- 12.5.5.5 SHOW COLLATION Syntax
- 12.5.5.6 SHOW COLUMNS Syntax
- 12.5.5.7 SHOW CONTRIBUTORS Syntax
- 12.5.5.8 SHOW CREATE DATABASE Syntax
- 12.5.5.9 SHOW CREATE EVENT Syntax
- 12.5.5.10 SHOW CREATE FUNCTION Syntax
- 12.5.5.11 SHOW CREATE PROCEDURE Syntax
- 12.5.5.12 SHOW CREATE TABLE Syntax
- 12.5.5.13 SHOW CREATE TRIGGER Syntax
- 12.5.5.14 SHOW CREATE VIEW Syntax
- 12.5.5.15 SHOW DATABASES Syntax
- 12.5.5.16 SHOW ENGINE Syntax
- 12.5.5.17 SHOW ENGINES Syntax
- 12.5.5.18 SHOW ERRORS Syntax
- 12.5.5.19 SHOW EVENTS Syntax
- 12.5.5.20 SHOW FUNCTION CODE Syntax
- 12.5.5.21 SHOW FUNCTION STATUS Syntax
- 12.5.5.22 SHOW GRANTS Syntax
- 12.5.5.23 SHOW INDEX Syntax
- 12.5.5.24 SHOW INNODB STATUS Syntax
- 12.5.5.25 SHOW MASTER STATUS Syntax
- 12.5.5.26 SHOW OPEN TABLES Syntax
- 12.5.5.27 SHOW PLUGINS Syntax
- 12.5.5.28 SHOW PRIVILEGES Syntax
- 12.5.5.29 SHOW PROCEDURE CODE Syntax
- 12.5.5.30 SHOW PROCEDURE STATUS Syntax
- 12.5.5.31 SHOW PROCESSLIST Syntax
- 12.5.5.32 SHOW PROFILE Syntax
- 12.5.5.33 SHOW PROFILES Syntax
- 12.5.5.34 SHOW SCHEDULER STATUS Syntax
- 12.5.5.35 SHOW SLAVE HOSTS Syntax
- 12.5.5.36 SHOW SLAVE STATUS Syntax
- 12.5.5.37 SHOW STATUS Syntax
- 12.5.5.38 SHOW TABLE STATUS Syntax
- 12.5.5.39 SHOW TABLES Syntax
- 12.5.5.40 SHOW TRIGGERS Syntax
- 12.5.5.41 SHOW VARIABLES Syntax
- 12.5.5.42 SHOW WARNINGS Syntax
SHOW SLAVE HOSTS
Displays a list of replication slaves currently registered with
the master. Only slaves started with the
--report-host=
option are visible in this list.
host_name
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 |
+------------+-----------+------+-----------+
| 192168010 | iconnect2 | 3306 | 192168011 |
| 1921680101 | athena | 3306 | 192168011 |
+------------+-----------+------+-----------+
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.Master_id: The unique server ID of the master server that the slave server is replicating from.
Some MySQL versions report another variable,
Rpl_recovery_rank. This variable was never
used, and was eventually removed.
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.