cbbrowne at ca.afilias.info cbbrowne
Sun Oct 15 14:29:24 PDT 2006
>  I look that slony replicate table in 1 seg or 10 seconds (max), Is there
> how could I have delay between 1 and 3 seconds in the max?

Unfortunately, no.

I had a situation the other week where a system which normally is almost
never more than a few seconds behind got some SYNCs that took ~15 minutes
to process.

We did a system upgrade that modified the entire contents of a couple of
relatively large tables (say, 30,000 rows), twice.  It took a while for
that "glut" of traffic to all get to a remote site.

The only way to "guarantee" that delays remain no more than 1-3 seconds is
if you know you are throttling updates on the master system.  And there's
not really a way to have that throttle take effect on the database side.




More information about the Slony1-general mailing list