Re: Log compression for replication ??

Apart from one site where there was a hardware firewall problem, we've got other sites successfully running HDR over WAN (500 miles between servers), Ok there is a 2MB link. Alexey Sonkin wrote: > > Paul, > > For VPN and WAN - HDR is not a good solution anyway > because of the synchronous nature of HDR checkpoints. > > I didn't see any hint to the WAN environment in original > message. > > As for the HDR over LAN, we use it under very high > database load and do not see any network problem > > > ------------------------------------------ > Alexey Sonkin > Senior Database Administrator > > > -----Original Message----- > > From: Paul Watson [mailto:paul@oninit.com] > > Sent: Friday, August 15, 2003 2:23 PM > > To: informix-list@iiug.org > > Subject: Re: Log compression for replication ?? > > > > 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 -- 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 #