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 and Binary Logging Options and Variables.
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.