Richard Yen dba at richyen.com
Thu Nov 20 17:00:59 PST 2008
Hi,

Wondering if it's okay to drop listen entries (in an effort to sculpt  
my cluster).  I have a very small cluster that needs to replicate  
quickly, but there are 15 or so nodes, so all the cross talk across  
the network (sync_interval == 500) is generating a lot of load.

I know that in the past, STORE PATH was modified to imply a STORE  
LISTEN as well.  As a result, it looks like the sl_listen table  
contains entries for nodes that the local node doesn't need to listen  
to.  Furthermore, since the data set is very small (on the order of <  
100MB), we don't anticipate ever needing to fail over or switch  
provider.

Would doing DROP LISTEN on the "unnecessary" nodes create any  
undesirable side effects?

Thought I'd ask before trying to set up a development cluster of 4+  
machines...

Thanks for any tips!
--Richard


More information about the Slony1-general mailing list