- 12.4.5 SHOW Syntax
- 12.4.5.1 SHOW AUTHORS Syntax
- 12.4.5.2 SHOW BINARY LOGS Syntax
- 12.4.5.3 SHOW BINLOG EVENTS Syntax
- 12.4.5.4 SHOW CHARACTER SET Syntax
- 12.4.5.5 SHOW COLLATION Syntax
- 12.4.5.6 SHOW COLUMNS Syntax
- 12.4.5.7 SHOW CONTRIBUTORS Syntax
- 12.4.5.8 SHOW CREATE DATABASE Syntax
- 12.4.5.9 SHOW CREATE EVENT Syntax
- 12.4.5.10 SHOW CREATE FUNCTION Syntax
- 12.4.5.11 SHOW CREATE PROCEDURE Syntax
- 12.4.5.12 SHOW CREATE TABLE Syntax
- 12.4.5.13 SHOW CREATE TRIGGER Syntax
- 12.4.5.14 SHOW CREATE VIEW Syntax
- 12.4.5.15 SHOW DATABASES Syntax
- 12.4.5.16 SHOW ENGINE Syntax
- 12.4.5.17 SHOW ENGINES Syntax
- 12.4.5.18 SHOW ERRORS Syntax
- 12.4.5.19 SHOW EVENTS Syntax
- 12.4.5.20 SHOW FUNCTION CODE Syntax
- 12.4.5.21 SHOW FUNCTION STATUS Syntax
- 12.4.5.22 SHOW GRANTS Syntax
- 12.4.5.23 SHOW INDEX Syntax
- 12.4.5.24 SHOW MASTER STATUS Syntax
- 12.4.5.25 SHOW OPEN TABLES Syntax
- 12.4.5.26 SHOW PLUGINS Syntax
- 12.4.5.27 SHOW PRIVILEGES Syntax
- 12.4.5.28 SHOW PROCEDURE CODE Syntax
- 12.4.5.29 SHOW PROCEDURE STATUS Syntax
- 12.4.5.30 SHOW PROCESSLIST Syntax
- 12.4.5.31 SHOW PROFILE Syntax
- 12.4.5.32 SHOW PROFILES Syntax
- 12.4.5.33 SHOW RELAYLOG EVENTS Syntax
- 12.4.5.34 SHOW SLAVE HOSTS Syntax
- 12.4.5.35 SHOW SLAVE STATUS Syntax
- 12.4.5.36 SHOW STATUS Syntax
- 12.4.5.37 SHOW TABLE STATUS Syntax
- 12.4.5.38 SHOW TABLES Syntax
- 12.4.5.39 SHOW TRIGGERS Syntax
- 12.4.5.40 SHOW VARIABLES Syntax
- 12.4.5.41 SHOW WARNINGS Syntax
SHOW SLAVE HOSTS
Displays a list of replication slaves currently registered with
the master. (Before MySQL 5.5.3, 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 removed in MySQL 5.5.3.
(Bug#13963)
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.