Manual conflict resolution for the trigger-based method v7

Note

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 Conflict prevention – uniqueness case, there's 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 and modify rows in the control schema tables in the primary nodes to resolve the conflict.

Similarly, you must manually correct update/delete and delete/update conflicts. In addition, if the conflict resolution option is set to Manual (see Updating the conflict resolution options) and a conflict occurs, you must also resolve this conflict in a manual fashion.

Make updates to the publication tables and the control schema tables in the primary nodes.

find_conflict conflict_resolution_prep overview_correction_strategies manual_publication_table_correction correction_using_new_txn correction_using_shadow_table_txn