Chapter 16. Replication Status

Table of Contents

16.1. Introduction
16.2. Configuring Replication Servers
16.3. Using the Replication Status Section

16.1. Introduction

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.

16.2. Configuring Replication Servers

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.

16.3. Using the Replication Status Section

Once your servers are configured, they will appear in the Replication Status section, as seen in the following figure:

Figure 16.1. The Replication Status section

The Replication Status section

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 Add Instance to Monitoring List button. To stop monitoring a server that is currently being monitored, click the Remove Instance from monitoring List button.