Thu Nov 20 17:00:59 PST 2008
- Previous message: [Slony1-general] replication for multiple databases
- Next message: [Slony1-general] okay to drop listen entries?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] replication for multiple databases
- Next message: [Slony1-general] okay to drop listen entries?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list