Replication Operators
The SQL procedures and functions below are used by the Lazy Replication scheme.
| Procedure | Description | Example |
|---|
| wlc.beat(duration int) | set beat | call wlc.beat(123) |
| wlc.flush() | flush capture data | call wlc.flush() |
| wlc.master(path string) | set master with path | call wlc.master('dbfarm/dbfree') |
| wlc.master() | set master | call wlc.master() |
| wlc.stop() | stop capture | call wlc.stop() |
| Function | Return type | Description | Example |
|---|
| wlc.clock() | clob | get clock as string | select wlc.clock() |
| wlc.tick() | bigint | get tick | select wlc.tick() |
Workload Replay Procedures
| Procedure | Description | Example |
|---|
| wlr.accept() | accept the error reported an skip the record | call wlr.accept() |
| wlr.beat(duration integer) | control the interval for replication | call wlr.beat(123) |
| wlr.master(dbname string) | set database name of master | call wlr.master('dbfree') |
| wlr.replicate(id integer) | run replicator until condition is met | call wlr.replicate(12) |
| wlr.replicate(id smallint) | run replicator until condition is met | call wlr.replicate(12) |
| wlr.replicate(id tinyint) | run replicator until condition is met | call wlr.replicate(12) |
| wlr.replicate(pointintime timestamp) | run replicator until condition is met | call wlr.replicate(timestamp '2020-07-25 09:00:00') |
| wlr.replicate(id bigint) | run replicator until condition is met | call wlr.replicate(12) |
| wlr.replicate() | run it forever | call wlr.replicate() |
| wlr.stop() | stop replicator | call wlr.stop() |
| Function | Return type | Description | Example |
|---|
| wlr.clock() | CLOB | get clock as string | `select wlr.clock() |
| wlr.tick() | BIGINT | get tick | `select wlr.tick() |
You must include the wlc. prefix for these procedures and functions (see examples) in order to work properly.