Fri Nov 21 11:40:33 PST 2008
- Previous message: [Slony1-general] okay to drop listen entries?
- Next message: [Slony1-general] okay to drop listen entries?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Thu, 2008-11-20 at 17:00 -0800, Richard Yen wrote: > 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? You should drop the uneeded paths. The listen entries will be reshaped accordingly. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.
- Previous message: [Slony1-general] okay to drop listen entries?
- Next message: [Slony1-general] okay to drop listen entries?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list