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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database maintenance » SQL Anywhere high availability » Database mirroring


Database mirroring modes

Three operational modes are provided for database mirroring:

These modes control when and how transactions are recorded on the mirror server, and you set them by using the SET MIRROR OPTION statement to set the value of the synchronization_mode option. Synchronous mode is the default.

The sending of log pages to the copy nodes is always done asynchronously, regardless of the mode chosen.

When choosing a synchronization mode for your database mirroring system, you must determine whether recovery speed or the state of the data is more important when failover occurs.

You can check the database mirroring mode by querying the value of the MirrorMode database property:

 Synchronous mode
 Asynchronous mode
 Asyncfullpage mode
 See also

Synchronization states
State information files