Understanding Server States

The LSMS has two servers for high availability. Usually, the LSMS is in duplex mode, with one server the active server and the other server in a standby state. In duplex mode, the active server is the master MySQL database server, and the standby server acts as the MySQL slave. Any database changes are made on the active server and are replicated to the standby server.

If the active server is not able to run LSMS functions, the standby server can take over to be the active server. The servers are peers; either server can be the active server, but only one server can be active at a time.

When one server is in ACTIVE state and the other server is not in STANDBY state, the LSMS is in simplex mode. When the LSMS is in simplex mode, the non-ACTIVE server should be brought back to STANDBY state as soon as possible (use the procedure described in “Starting a Server”).

The state of each server is monitored by the LSMS High Availability (HA) utility. Table 1 shows the possible states for each server (but only one server at a time can be in the ACTIVE state).

LSMS Server States

State

Server Status

ACTIVE

Server is online, running the LSMS application, and acts as the MySQL master.

STANDBY

Server is online and participating in database replication. The server ready to become the active server if automatic switchover is necessary or if manual switchover is performed. The server is not currently running the LSMS application.

UNINITIALIZED "INHIBITED"

Server is online but it is not participating in database replication and no application is running.

Note: Other transitional states may be displayed while a server is changing from one to another of these states.