SET SAFENESS

SET SAFENESS

SET SAFENESS {1SAFE | 2SAFE | DEFAULT}

SET SAFENESS determines whether the replication protocol is synchronous (2-safe) or asynchronous (1-safe).

▪1-safe: the transaction is first committed at Primary and then transmitted to Secondary

▪2-safe: the transaction is not committed before it has been acknowledged by Secondary (default).

SET SAFENESS sets the safeness level for the current session.