Versions Compared

Old Version 198

changes.mady.by.user Federico Valeri

Saved on

compared with

New Version 199

changes.mady.by.user Federico Valeri

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The mirror fetcher thread uses READ_UNCOMMITTED isolation, so records from uncommitted transactions are replicated to the destination before the source decides them. This reduces replication lag compared to READ_COMMITTED, but means uncommitted data is visible to READ_UNCOMMITTED consumers on the destination before failover. When stop mirroring is triggered, all in-flight ongoing transactions are decided by appending explicit ABORT markers, preserving all previously committed data.

...