Replication Operators

The SQL procedures and functions below are used by the Lazy Replication scheme.

ProcedureDescriptionExample
wlc.beat(duration int)set beatcall wlc.beat(123)
wlc.flush()flush capture datacall wlc.flush()
wlc.master(path string)set master with pathcall wlc.master('dbfarm/dbfree')
wlc.master()set mastercall wlc.master()
wlc.stop()stop capturecall wlc.stop()
FunctionReturn typeDescriptionExample
wlc.clock()clobget clock as stringselect wlc.clock()
wlc.tick()bigintget tickselect wlc.tick()

Workload Replay Procedures

ProcedureDescriptionExample
wlr.accept()accept the error reported an skip the recordcall wlr.accept()
wlr.beat(duration integer)control the interval for replicationcall wlr.beat(123)
wlr.master(dbname string)set database name of mastercall wlr.master('dbfree')
wlr.replicate(id integer)run replicator until condition is metcall wlr.replicate(12)
wlr.replicate(id smallint)run replicator until condition is metcall wlr.replicate(12)
wlr.replicate(id tinyint)run replicator until condition is metcall wlr.replicate(12)
wlr.replicate(pointintime timestamp)run replicator until condition is metcall wlr.replicate(timestamp '2020-07-25 09:00:00')
wlr.replicate(id bigint)run replicator until condition is metcall wlr.replicate(12)
wlr.replicate()run it forevercall wlr.replicate()
wlr.stop()stop replicatorcall wlr.stop()
FunctionReturn typeDescriptionExample
wlr.clock()CLOBget clock as string`select wlr.clock()
wlr.tick()BIGINTget tick`select wlr.tick()

You must include the wlc. prefix for these procedures and functions (see examples) in order to work properly.