SHOW SLAVE HOSTS
This command is run on the master and displays a list of replication slaves that are currently registered with it. Only slaves started with the --report-host=host_name
option are visible in this list.
The list is displayed on any server (not just the master server). 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 slave server, as configured in the server's option file, or on the command line with --server-id=value
. Host
: The host name of the slave 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 slave server is listening on. Master_id
: The unique server ID of the master server that the slave 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 and MySQL 5.6.
SHOW PROCESSLIST
output, slave threads are identified by Binlog Dump
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/show-slave-hosts/