IDS Forum

Re: How to Setup IDS for all IPs

Posted By: Art S. Kagel (Oninit LLC)
Date: Thursday, 29 November 2007, at 10:10 a.m.

In Response To: Re: How to Setup IDS for all IPs (Martin Fuerderer)

Martin Fuerderer wrote:
> <SNIP>
> Alternatively you could of course configure the
> two IDS servers (Primary and Secondary) not
> using the virtual IP-address at all, but instead
> using simply different IP-addresses. Then the
> switch of the virtual IP-address during failover
> does not affect the IDS servers, i.e. the Secondary
> can keep running using its own IP-address. Then of
> course the clients will have to use that IP-address
> for the re-connect after failover. For this we have
> mechanisms, e.g. via the DBPATH environment
> variable.
> <SNIP>
>

Martin, you are forgetting about sqlhosts group names and DBPATH.
Either the clients can use DBPATH to automatically fail over to the back
up server on reconnect (yes, using that server's ACTUAL IP address not
the virtual IP the HA system uses) or they can set up a GROUP in
sqlhosts including the two servers with the primary named first in the
group. Clients then connect using the group name instead of a specific
servername. If the connection fails due to a server or server host
failure the client apps can reconnect (or users or the HA software can
rerun their apps to reconnect) again using the group name - only this
time the group will failover to the secondary. I know that Informix
create groups for ER, but they work fine in HDR and even non-replicated
sister server environments. Discovered this years ago when the first
CSDK & iConnect version 2.xx releases broke DBPATH and our apps stopped
failing over on reconnect. If you use groups note that failover timing
is more dependent on the settings of INFORMIXCONTIME and
INFORMIXCONRETRY than when using DBPATH. I prefer using groups since
it's not as dependent on the user's environment and in a 4GL environment
DBPATH is also used for locating screen files so it's often cluttered
with irrelevant info and prone to muck ups.

Art S. Kagel
Oninit, LLC

> Regards,
> Martin
>

Messages In This Thread

• How to Setup IDS for all IPs
  Schuran, Sven -- Wednesday, 28 November 2007, at 7:24 a.m.
  • RE: How to Setup IDS for all IPs
    Veronica Gomes -- Wednesday, 28 November 2007, at 7:55 a.m.
  • Re: How to Setup IDS for all IPs
    Martin Fuerderer -- Thursday, 29 November 2007, at 9:50 a.m.
    • Re: How to Setup IDS for all IPs
      Art S. Kagel (Oninit LLC) -- Thursday, 29 November 2007, at 10:10 a.m.
      • Re: How to Setup IDS for all IPs
        Martin Fuerderer -- Thursday, 29 November 2007, at 11:54 a.m.
        • Re: How to Setup IDS for all IPs
          Art S. Kagel (Oninit LLC) -- Thursday, 29 November 2007, at 12:50 p.m.
          • RE: How to Setup IDS for all IPs
            Schuran, Sven -- Tuesday, 11 December 2007, at 9:08 a.m.
            • Re: How to Setup IDS for all IPs
              Art S. Kagel (Oninit LLC) -- Tuesday, 11 December 2007, at 12:57 p.m.
              • RE: How to Setup IDS for all IPs
                Schuran, Sven -- Wednesday, 12 December 2007, at 7:14 a.m.
                • Re: How to Setup IDS for all IPs
                  Art S. Kagel (Oninit LLC) -- Wednesday, 12 December 2007, at 9:24 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.