RE: informix 9.4 configuration - DRAUTO
If DRINTERVAL in your onconfig is set to -1, then it's synchronous;
otherwise it's async. Current setting is also displayed in 'onstat -g dri'.
For performance reasons, we use async mode. We have never had any problem
with lost data, nor with big lag times. Replication almost always occurs
within a second or two, with one server in Sacramento and the other in
Minneapolis.
Suggest that you RTFineM, if you haven't already -- Admin Guide, ch. 19-20.
If you don't have the hard copies, try
http://www-3.ibm.com/software/data/informix/pubs/library/ids_94.html
-or-
http://publibfi.boulder.ibm.com/epubs/pdf/ct1ucna.pdf
HTH,
Paul Mosser
-----Original Message-----
From: owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org]On Behalf Of tomcaml@yahoo.com
Sent: Thursday, October 30, 2003 12:51 PM
To: informix-list@iiug.org
Subject: Re: informix 9.4 configuration - DRAUTO
thanks, Paul.
Can you tell me if there is a way for me to find out if the
replication is currently in synchronous or asynchronous transfer
mode....?
Thanks,
Tom
mosserp@wellsfargo.com wrote in message
news:<bnpl38$oa2$1@terabinaries.xmission.com>...
> DRAUTO was disabled in version 9.2x. My understanding is that it caused
> more problems than it fixed for most customers (i.e., possible in some
cases
> for *both* servers to think that they are primary, and both start
accepting
> update txns), so Informix removed it. We depend upon HDR for some
critical
> applications here at the bank, and we have always used manual failover
> (DRAUTO=0), even prior to 9.2x.
>
> HTH,
> Paul Mosser
>
sending to informix-list