Sun Oct 15 14:29:24 PDT 2006
- Previous message: [Slony1-general] Delay to replicate in Slony
- Next message: [Slony1-general] new slony-user and a question
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> 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.
- Previous message: [Slony1-general] Delay to replicate in Slony
- Next message: [Slony1-general] new slony-user and a question
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list