Re: Log compression for replication ??
Although I agree with others that this is probably not the problem, you could achieve your log compression using socat on each end and make the transport ssh -C or something similar. You'll need to create a new ip address in each host, and point informix on each end to the new local ip address and use socat to 'join them'. http://www.dest-unreach.org/socat/ -- Clive Eisen mob: +44 (0) 7957 626 324 email: clive@serendipita.com internet: http://www.serendipita.com Quoting Paul Watson <paul@oninit.com>: > We'd had HDR cause a port to close on a hardware firewall when > running over a VPN - very irritating > > Alexey Sonkin wrote: > > > > Jack, > > > > It's really hard to believe that HDR can cause > > a bad network problem. > > > > AFAIK the amount of data transferred should be close to the > > amount of data accumulated in logical logs. > > How often do Your logical logs switch of what is the size of the logical > > log on Your system? > > > > If You still feel that HDR is responsible for Your network problem, > > You can use dedicated physical network adapter for HDR on > > both machines and connect those adapters by dedicated network cable. > > You should attach dedicated IDS network listener to that dedicated > > network adapter on each machine. > > > > For better diagnostics, use different listener TCP port > > numbers for 'user' and 'replication' ports. > > > > ------------------------------------------ > > Alexey Sonkin > > Senior Database Administrator > > > > > -----Original Message----- > > > From: Jack A [mailto:hrehal@yahoo.com] > > > Sent: Thursday, August 14, 2003 11:02 PM > > > To: informix-list@iiug.org > > > Subject: Re: Log compression for replication ?? > > > > > > Oh no. I think i havent given you the complete picture. The backbone > gets > > > used for a lot of stuff. There are many other applications that use the > > > back > > > bone apart from Informix users. Connections to the primary are working > > > fine. > > > There are no problems with that. But we have other servers here in the > > > head > > > office which are accessed using the same back bone by different users. > > > When > > > the purge runs and the network gets clogged, these users are the ones > > > which > > > have a problem. > > > > > > So seperating replicaton traffic from user traffic is really not my > goal. > > > I > > > only want to minimize replication traffic any way I can. > > > > > > "Madison Pruet" <mpruet@comcast.net> wrote in message > > > news:Gp5%a.149060$o%2.64395@sccrnsc02... > > > > Jack, > > > > > > > > You should be able to separate the replication traffic from the user > > > traffic > > > > by setting up separate ports (listener threads), one for the HDR > > > traffic > > > > and the other for the user apps. > > > > > > > > I'm a bit puzzled by this, however. If the network bandwidth is the > > > cause > > > > of the problem, then I would expect only connections to the secondary > to > > > be > > > > a problem, not the primary. Could it be that the real problem is > that > > > the > > > > users are locking because the purge program is not committing often > > > enough > > > > and thus causing users to be in a wait state on rows to be deleted? > > > > > > > > > > > > "Jack A" <hrehal@yahoo.com> wrote in message > > > > news:5b83c3e5548b78f5201f76f39bc79d8d@news.teranews.com... > > > > > As I mentioned a few days ago, replication traffic has spiked up on > > > our > > > > > network. It was because of periodic purges that were running. This > is > > > > > becoming a big issue in my company that we are eating up bandwidth > > > because > > > > > online users get bloced. Is there any way to have Informix compress > > > the > > > > logs > > > > > before they are shipped out to the secondary ? I've looked through > the > > > > > manuals and havent found anything and was surprised. > > > > > > > > > > This might be a good enhancement to suggest to the Informix > > > development > > > > > group. > > > > > > > > > > TIA, > > > > > Jack > > > > > > > > > > > > > > > > > > > > > > sending to informix-list > > -- > Paul Watson # > Oninit Ltd # Growing old is mandatory > Tel: +44 1436 672201 # Growing up is optional > Fax: +44 1436 678693 # > Mob: +44 7818 003457 # > www.oninit.com # > sending to informix-list