Table of Contents
The Replication Status
sections give you a
visual overview of your MySQL replication master and slaves. The
server status icons beside each machine tells you which slave
machines are connected to the master and which ones are offline.
To use the Replication Status
section you must
be connected to the server that acts as the master in your
replication scheme. Your MySQL servers must be version 4 or higher
to use this feature.
For a slave server to show in the Replication
Status
screen, it must register itself with the master
server. To have a slave server register itself with the master,
set the report-host
option in your server
configuration (my.cnf/my.ini) file. See
Replication Startup Options.
You can also set the value in the Replication
tab of the Startup Variables
section of
MySQL Administrator.
Once your servers are configured, they will appear in the
Replication Status
section, as seen in the
following figure:
All servers are listed under the Hostname
column, along with their server ID, Port, and current status.
New servers that are not currently being monitored will have an
exclamation mark as their status symbol, and will be listed as a
New Instance
in the Status
column of their entry.
Servers that are currently being monitored and are online will
have a green status icon and will be listed as
Available
in the Status
column of their entry.
Servers that are currently not in contact with the master server
will have a red status icon and will be listed as Not
Available
.
There will be a slight delay between a slave machine going offline and having its status updated to allow for an adequate timeout in the communications between master and slave.
To start monitoring a new server that is not currently being monitored, click the
button. To stop monitoring a server that is currently being monitored, click the button.