What is the best practice for setting up a differe...
# best-practices
d
What is the best practice for setting up a different sync schedule for a subset of tables in a database? Should that be a separate project or maybe just set that up as an environment in the same project? Use case is that we have a table that receives periodic large bulk inserts and don't want that interfere with the other tables that have small changes which we want to replicate on a faster interval.
m
I would (and do) set this up via plugin inheritance. You can define your connection info etc in a parent plugin, then have two inheriting plugins, each extracting a different set of tables (via the
select
setting) on a different schedule
2
d
Thanks @Matt Menzenski, I will look into how to set that up.