Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere High Availability » Introduction to database mirroring » Choosing a database mirroring mode

Synchronization states Next Page

State information files

Each server in the mirroring system maintains a state information file that records that server's view of the state of the mirroring system.

The state information file is used during startup when determining the role to be assumed by a server. The server's local state is compared against that of the other servers in the database mirroring system. You must always specify a state information file for each server in the mirroring system using the -xf option. See -xf server option.

The state information file contains the following information:

OwnerIndicates which database server is the primary server.
StateContains the synchronization state (one of synchronizing or synchronized) to indicate whether the server is receiving log pages or is up to date. See Synchronization states.
ModeSpecifies the synchronization mode (one of synchronous, asynchronous, or page). See Choosing a database mirroring mode.
SequenceContains a value indicating how many times failover has occurred on the database mirroring system. The sequence number is incremented on each role switch. It helps to determine whether a server's view of the state of the mirroring system is current. See Introduction to database mirroring.

The following shows sample contents for a state information file:


If a state information file does not exist, it will be created automatically. State information files should only be modified by the database server.