SHOW REPLICA HOSTS

List registered replicas. This statement displays information about replica servers connected to the current primary.

Syntax

SHOW { SLAVE | REPLICA } HOSTS

Description

This command is run on the primary and displays a list of replicas that are currently registered with it. The output looks like this:

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 replica server, as configured in the server's option file, or on the command line with --server-id=value.

Current

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.

< 10.5

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 --report-host parameter is not configured.

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.

Current

Requires the REPLICATION MASTER ADMIN privilege.

< 10.5.1

Requires the REPLICATION SLAVE privilege.

SHOW REPLICA HOSTS

Current

SHOW REPLICA HOSTS is an alias for SHOW SLAVE HOSTS .

< 10.5.1

SHOW REPLICA HOSTS is not available, use SHOW SLAVE HOSTS instead.

See Also

• MariaDB replication

• Replication threads

• SHOW PROCESSLIST. In SHOW PROCESSLIST output on the primary, connected replicas are identified by Binlog Dump

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}