Versions Compared

Key

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

All keywords are case-insensitive.

...

Note that the CHOOSE REPLICATON command selects all processes for the indicated replication.On the contrary 

Example:

CHOOSE REPLICATION MINE1

The above command will choose the replication pair that is associated with MINE1. Typically this is MINE1->APPLY1

In contrast, CHOOSE PROCESS selects only the one selected process and it's use is thus not a recommended, unless really needed, e.g. in some convoluted multi-database configurations.(not the pair) and is generally not recommended. It can be used in special cases such as one to many replications to specify a specific process. 

PAUSE

Asks the given process to pause.

...

The DEFAULT conflict handler will not be applied to existing prepared (replicated) tables. The DEFAULT conflict handler will only be applied to tables that are prepared after the DEFAULT conflict handler is set. To change the conflict handler for existing prepared tables, each table has to be individually set using FOR TABLE conflict handler.

SHOW_CONFLICT_HANDLERS

Shows current setting of conflict handlers for given table (schema.name refers to table at mine).

...