Chapter 4
AlwaysOn Availability Group
Section 3
Data Synchronization
In synchronous commit mode, a transaction takes a longer time to complete as it has to be committed at primary and secondary replicas. A synchronous commit, however, ensures zero data loss. The primary and secondary replicas always ping each other to check connectivity. If there's a delay of more than 10 seconds in receiving a response, the synchronous replica mode changes to asynchronous. The mode is restored back to synchronous once the connectivity is restored Here you will learn about the following: - Synchronous Commit - Asynchronous Commit - Primary Replica Fails - Planned - Forced and, - Automatic - Secondary Replica Fails