I searched the web sites for advice but came up short on something
that looked like what I need. I need to "replicate" a few tables
nightly (2am-6am). Each table will have about 1 million new records
(~100B each, ~5/second) each day.
I have tried using something like a cron job (copy from/copy to) but
it has limitiations as far as handling duplicate keys (just need to
replace) and it will not fill in gaps if there happen to be any. the
servers are also far from each other and only have a 50 KB/s ipsec
link between them so data transfer needs to be somewhat minimized.
thanks for any suggestions,
gene