SHOW SLAVE HOSTS Syntax

Displays a list of replication slaves currently registered with the master.

The list is displayed on any server (not just the master server). The output looks like this:

mysql> SHOW SLAVE HOSTS;
+-----------+-----------+-------+-----------+--------------------------------------+
| Server_id | Host | Port | Master_id | Slave_UUID |
+-----------+-----------+-------+-----------+--------------------------------------+
| 192168010 | iconnect2 | 3306 | 192168011 | 14cb6624-7f93-11e0-b2c0-c80aa9429562 |
| 1921680101 | athena | 3306 | 192168011 | 07af4990-f41f-11df-a566-7ac56fdaf645 |
+------------+-----------+------+-----------+--------------------------------------+

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

  In MariaDB 5.6.5 and later, a zero in this column means that the slave port (--report-port) was not set. Prior to MariaDB 5.6.5, 3306 was used as the default in such cases (Bug #13333431).

• Master_id: The unique server ID of the master server that the slave server is replicating from.
• Slave_UUID: The globally unique ID of this slave, as generated on the slave and found in the slave's auto.cnf file.

  This column was added in MariaDB 5.6.0.

Retornar