Syntax\n------\n\nSHOW { SLAVE | REPLICA } HOSTS\n\nDescription\n-----------\n\nThis command is run on the master and displays a list of slaves that are currently registered with it. The output looks like this:\n\n``sql\nSHOW SLAVE HOSTS;\n+------------+-----------+------+-----------+\n| Server_id  | Host      | Port | Master_id |\n+------------+-----------+------+-----------+\n|  192168010 | iconnect2 | 3306 | 192168011 |\n| 1921680101 | athena    | 3306 | 192168011 |\n+------------+-----------+------+-----------+\n`\n\nServer_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.\n\nHost: 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). If a slave 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.\n\nHost: 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). If a slave 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 slave's --report-host parameter is not configured.\n\nPort: The port the slave server is listening on.\n\nMaster_id: The unique server ID of the master server that the slave server is replicating from.\n\nRequires the REPLICATION MASTER ADMIN privilege.\n\nRequires the REPLICATION SLAVE privilege.\n\nSHOW REPLICA HOSTS\n\nSHOW REPLICA HOSTS is an alias for SHOW SLAVE HOSTS .\n\nSHOW REPLICA HOSTS is not available, use SHOW SLAVE HOSTS` instead.\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-replica-hosts