Versions Compared

Key

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

...

Register target database in mine metadata, must be executed after you load/create mine and apply dictionary.

ENGINE SUPPLEMENTAL LOGGING TABLE  

...

schema.table_name ENABLE PRIMARY KEY
ENGINE SUPPLEMENTAL LOGGING TABLE  schema.table_name DISABLE PRIMARY KEY

...

It is also mandatory to enable supplemental logging at database level. This is done automatically during ENGINE SETUP MINE DICTIONARY.

ENGINE SUPPLEMENTAL LOGGING SCHEMA 

...

schema ENABLE PRIMARY KEY
ENGINE SUPPLEMENTAL LOGGING SCHEMA  

...

schema DISABLE PRIMARY KEY

Enables/disables supplemental logging on all table in the schema for their primary key. This is mandatory on source for replicate tables. (This is done automatically by PREPARE commands.)

...