Difference Between PREPARE and PREPARE OFFLINE

Owned by Jakub Sejba
Last updated: Aug 19, 2014 by Chris Lawless (Unlicensed)

PREPARE

The prepare command connects to a running APPLY and MINE process and instructs them to replicate the schema/table. This is the default command that should be used when preparing new tables.

If the MINE and APPLY process have a slow network connection between them, consider using PREPARE OFFLINE.

PREPARE OFFLINE

This can only be used when APPLY and MINE processes are NOT running. The APPLY and MINE process will pickup the new tables on the next start.

PREPARE OFFLINE cannot be used while APPLY and MINE are running. Pausing and then resuming the processes is not sufficient either.

The advantage with PREPARE OFFLINE is when there is a slow network between the MINE and APPLY process and timeouts can occur if a connection has to be made to both MINE and APPLY to instruct them to replicate the new object.