Enabling or Disabling Full Sync Replication
When activated the full sync option for system replication ensures that a log buffer is shipped to the secondary system before a commit takes place on the local primary system.
Prerequisites
You have permission Service(ForcedPrepare,ForcedUnPrepare,ForcedStart,ForcedStop).
Context
The full sync option can be enabled for sync replication (that is not for syncmem). With the activated full sync option, transaction processing on the primary blocks, when the secondary is currently not connected and newly created log buffers cannot be shipped to the secondary site. This behavior ensures that no transaction can be locally committed without shipping the log buffers to the secondary site.
-
DISABLED
Full sync is not configured at all. The parameter enable_full_sync = false in the system_replication section of the global.ini file.
-
ENABLED
Full sync is configured, but it is not yet active, so transactions do not block in this state. To become active the secondary has to connect and REPLICATION_STATUS has to be ACTIVE.
-
ACTIVE
Full sync mode is configured and active. If the network connection to a connected secondary is closed, transactions on the primary side will block in this state.