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
Matt Menzenski
05/06/2025, 12:20 AM
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
Don Venardos
05/06/2025, 3:54 PM
Thanks @Matt Menzenski, I will look into how to set that up.