Description of the HADR Modes

HADR synchronization mode is controlled by the database configuration parameter hadr_syncmode. See High Availability Disaster Recovery (HADR) synchronization mode.

For SYNC and NEARSYNC modes, the primary waits for an ack message from the standby to confirm logs are received and written to disk on standby (SYNC mode) or are received on the standby (NEARSYNC mode). For ASYNC mode, primary considers replication as done as soon as the logs are delivered to the TCP layer of the primary host machine. For SUPERASYNC mode, the primary log writing is independent of log replication. SYNC and NEARSYNC modes are typically used on LAN. ASYNC and SUPERASYNC modes are typically used over WAN.

See:

  1. SYNC mode
  2. NEARSYNC mode
  3. ASYNC mode
  4. SUPERASYNC mode


Parent topic: DB2 HVDB High Availability Disaster Recovery (HADR) guideline