Mimeo - Incremental Replication
Continuing from my introductory post to mimeo, I’ll now discuss one of the methods that’s more unique to this replication tool.
If a table happens to have a timestamp column that is set on every insert or update of a row, the incremental replication methods can be used. This simply uses that column to track where in the replication process it left off each time it is run. There’s one for insert-only tables and another that can handle if that column is also set on every row update.