Resynchronizing replicate databases

Replication Server 15.5 introduces database resynchronization, which allows you to rematerialize your replicate database and resume further replication without data loss or inconsistency, and without forcing a quiesce of your primary database.

Database resynchronization is based on obtaining a dump of data from a trusted source and applying the dump to the target database you want to resynchronize. Database resynchronization includes these steps:

  1. Stop replication processing by suspending Replication Agent.

  2. Place Replication Server in resync mode. In resync mode, Replication Server skips transactions and purges replication data from replication queues in anticipation of the replicate database being repopulated from a dump taken from the primary database or trusted source.

  3. Restart Replication Agent and send a resync database marker to Replication Server to indicate that a resynchronization effort is in progress.

  4. Obtain a dump from the primary database.

  5. When Replication Server detects a dump marker that indicates the completion of the primary database dump, Replication Server stops skipping transactions and can determine which transactions to apply to the replicate database.

  6. Apply the dump to the replicate database.

  7. Resume replication.