Difference Between PREPARE and PREPARE OFFLINE
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 OFFILE.
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.
Â