slave_hosts

NAME

slave_hosts: listing of hosts replicating from current server

TYPE

View

DESCRIPTION

slave_hosts lists host names where slaves of this server are located. The view utilizes processlist_repl and looks for connections issued by replicating slaves.

No information is provided on the ports on which replicating slaves listen on.

STRUCTURE

mysql> DESC common_schema.slave_hosts;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| host  | varchar(64) | NO   |     |         |       |
+-------+-------------+------+-----+---------+-------+

SYNOPSIS

Columns of this view:

  • host: host name or IP address of replicating slave, as it appears on PROCESSLIST, without port number

EXAMPLES

Show slave hosts on a master machine:

mysql> SELECT * FROM common_schema.slave_hosts;
+-----------------+
| host            |
+-----------------+
| sql00.mydomain  |
| sql02.mydomain  |
+-----------------+

ENVIRONMENT

MySQL 5.1 or newer.

SEE ALSO

match_grantee(), processlist_per_userhost, processlist_repl, processlist_summary

AUTHOR

Shlomi Noach
 
common_schema documentation