Manual Conflict Resolution for the Trigger-Based Method v6.2

Note

The manual conflict resolution discussion in this section applies only to multi-master replication systems configured with the trigger-based method of synchronization replication. See Manual Conflict Resolution for the Log-Based Method for information on manual conflict resolution for multi-master replication systems configured with the log-based method of synchronization replication.

As discussed in Section Conflict Prevention – Uniqueness Case there is no built-in, automatic conflict resolution strategy for the uniqueness (insert/insert) conflict. If a uniqueness conflict occurs, then you must modify rows in the publication tables containing the conflict as well as modify rows in the control schema tables in the primary nodes to resolve the conflict.

Similarly, manual correction must be used for update/delete and delete/update conflicts. In addition, if the conflict resolution option is set to Manual (see Section Updating the Conflict Resolution Options) and a conflict occurs, this conflict must also be resolved in a manual fashion.

This section describes the updates you must make to the publication tables and the control schema tables in the primary nodes.

This discussion is divided into the following topics:

  • Finding Conflicts. Locating unresolved conflicts
  • Conflict Resolution Preparation. Helpful setup steps to aid in the manual conflict resolution process
  • Overview of Correction Strategies. Overview of the methods you can use to perform the corrections
  • Manual Publication Table Correction. Manual correction of the publication tables
  • Correction Using New Transactions. Using new transactions to bring all primary nodes to a consistent state
  • Correction Using Shadow Table Transactions. Using existing shadow table transactions to bring all primary nodes to a consistent state

The following sections describe these topics in detail.

find_conflict conflict_resolution_prep overview_correction_strategies manual_publication_table_correction correction_using_new_txn correction_using_shadow_table_txn