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

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Maintaining your database » SQL Anywhere high availability » Introduction to database mirroring

 

Choosing a database mirroring mode

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.

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:

SELECT DB_PROPERTY( 'MirrorMode' );
 Synchronous mode
 Asynchronous mode
 Asyncfullpage mode
 See also

Synchronization states
State information files