- 9 The Replication Page
- 9.1 Replication Page Details
Choose a value from the refresh drop-down
list box to set the rate at which information is updated. This
refresh rate applies only to the information presented on this
page: It is independent of the rate set for the
Monitor page.
The following columns describe replication servers and their slaves:
Servers – Displays the group name and any master servers and slaves
Type – Indicates the topology of a server group or in the case of individual servers, whether a server is a master, a master/slave, or a slave
Slave IO – Reports the status of the slave I/O thread
Slave SQL – Reports the status of the slave SQL thread
Seconds Behind – The number of seconds the slave is behind the master. This column is blank if a server is a master.
Binlog – The binlog file name
Binlog Pos – The current position in the binlog file
Master Binlog – The master binlog file name
Master Binlog Pos – The current position in the master binlog file
Last Error – The most recent error
Unlabeled Column – Use the rename group link on the server group line to edit the server group name
Levels of indentation in the Servers column
show the relationship between master servers and their slaves.
Most column headings are active links that allow you to change the
order of display by clicking on the header. Sorting works
differently for different column groupings. Click the
Seconds Behind header to order servers by the
number of seconds they are behind their master. However, in all
cases, the server topology is respected. For example, in a
TREE topology, ordering occurs within branches
only.
If the agent is down, servers show in bold red in the
Servers column. The Slave IO
and the Slave SQL columns display
stopped in red text if these threads are not
running. If an agent is down, italics is used to display the last
know status of the I/O or SQL threads.
Clicking on a master server opens a dialog box that displays information about the server. The information shown includes:
The number of slave servers
The binlog file name
The binlog position
Which databases are replicated and which not
The dialog box also includes a link that allows the user to hide or show the slave servers.
Clicking on a slave server opens a dialog window showing extensive information about the slave.
