List registered replicas. This statement displays information about replica servers connected to the current primary.
This command is run on the primary and displays a list of replicas that are currently registered with it. The output looks like this:
Server_id: The unique server ID of the replica server, as configured in the server's option file, or on the command line with .
Host: The host name of the replica server, as configured in the server's option file, or on the command line with --report-host=host_name (note that this can differ from the machine name as configured in the operating system). If a replica doesn't configure --report-host explicitly, the value for the Host column is automatically extracted using the network connection's host name or IP address.
Host: The host name of the replica server, as configured in the server's option file, or on the command line with --report-host=host_name (note that this can differ from the machine name as configured in the operating system). If a replica doesn't configure --report-host explicitly, the value for the Host column is automatically extracted using the network connection's host name or IP address. The Host value is left blank if a replica's
Port: The port the replica server is listening on.
Master_id: The unique server ID of the primary server that the replica server is replicating from.
Requires the privilege.
Requires the privilege.
SHOW REPLICA HOSTS is an alias for SHOW SLAVE HOSTS .
SHOW REPLICA HOSTS is not available, use SHOW SLAVE HOSTS instead.
. In output, replica threads are identified by Binlog Dump
This page is licensed: GPLv2, originally from
SHOW { REPLICA | SLAVE } HOSTSSHOW REPLICA HOSTS;
+------------+-----------+------+-----------+
| Server_id | Host | Port | Master_id |
+------------+-----------+------+-----------+
| 192168010 | iconnect2 | 3306 | 192168011 |
| 1921680101 | athena | 3306 | 192168011 |
+------------+-----------+------+-----------+--report-host