Versions Compared

Key

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

Simple DML operations:

 

 

Prepare sample schema to replicate

With NODDL option

With DDL option

 

Creation of duplicate rows (potential conflict):

Create duplicate using 1 row DML

insert into repl_dba_tablespaces (select * from repl_dba_tablespaces where tablespace_name='TEMP');

update repl_dba_tablespaces set tablespace_name='TEMP2' where tablespace_name='TEMP';

List conflict

Show, how the problematic query transformed

Create duplicate using more rows DML

How many conflicts were created (1 conflict for 1 row) = >large transactions are separated into single rows

Resolve conflict

 

DML operation with trigger / constraint DML - show cascade constraint problem (smile)

 

 

 

SwingBench can now be started to produce a transaction load and simulate an order-entry system to test the replication. 

...