Syntax
------

SHOW SLAVE HOSTS
SHOW REPLICA HOSTS -- from MariaDB 10.5.1

Description
-----------

This command is run on the primary and displays a list of replicas that are
currently registered with it. Only replicas started with the
--report-host=host_name option are visible in this list.

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.
* 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.
* 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.

Some MariaDB and MySQL versions report another variable, rpl_recovery_rank.
This variable was never used, and was eventually removed in MariaDB 10.1.2 .

Requires the REPLICATION MASTER ADMIN privilege (>= MariaDB 10.5.2) or the
REPLICATION SLAVE privilege (<= MariaDB 10.5.1).

SHOW REPLICA HOSTS
------------------

MariaDB starting with 10.5.1
----------------------------
SHOW REPLICA HOSTS is an alias for SHOW SLAVE HOSTS from MariaDB 10.5.1.

URL: https://mariadb.com/kb/en/show-replica-hosts/