Filip Rembiałkowski plk.zuber at gmail.com
Sun Sep 9 10:58:53 PDT 2007
2007/9/9, Tim Bowden <tim.bowden at westnet.com.au>:

>  Hopefully that will scale well as I've
> got 100+ master db's.

over 100 partitions? you should be careful as slony1 has some
communication overhead  which grows quadratically with the number of
nodes in a cluster.

google for "slony communication costs"

I'm not sure if it applies to your situation though... I've never
tested such setup, maybe we should wait untill someone more
experienced gives a word about it

maybe I should not say this here ... but at worst, you will have to
drop slony in favour of other (simpler) solution - like home-made
trigger-based tool or other replication engine (londiste?)


More information about the Slony1-general mailing list