IDS Forum

Re: How to Setup IDS for all IPs

Posted By: Art S. Kagel (Oninit LLC)
Date: Wednesday, 12 December 2007, at 9:24 a.m.

In Response To: RE: How to Setup IDS for all IPs (Schuran, Sven)

Schuran, Sven wrote:
> Hi,
>

You miss my point. Yes, clients have to reconnect, either in error
aware code that reconnects automatically (perhaps after waiting
sufficient time for the disks to be mounted by the backup machine and
for the backup server to come online (FYI with IDS 11.00 you can make
that backup server live all the time sharing the disks as an SDS
Secondary so apps/users don't have to wait to reconnect) or manually as
you imply.

My point is that if the backup server uses its OWN IP address instead of
becoming the failed primary machine, then both addresses can be in the
sqlhosts files on both servers AND on the client. Then you can either
put the backup server's servername into the DBPATH environment variable
or create a connection group in the sqlhosts files and connect using the
group name. In either case the reconnect attempt will AUTOMATICALLY
fail over to the backup server if the primary server is offline. If, as
is usual in these failover schenarios the primary machine itself is
offline, failover is very fast.

I am also recommending that instead of using shared disk and restarting
the server on the secondary you either use HDR to keep a live secondary
or use the IDS 11.10+ SDS (shared disk secondary) server feature so that
the secondary is always online and recovery from a primary crash is
faster and more reliable without waiting for heartbeat detection.

Art S. Kagel

> cause of application is not able to handle database errors, a reconnect must
> be done.
>
> I tried to use this line within the sqlhosts of my server:
> ids_db onsoctcp * ids_db
>
> and this one within my client
>
> ids_db onsoctcp db01haip ids_db
>
> Starting ids without ha ip and afterwards add haip with ifconfig.
> So the connection via dbhaip is possible.
>
> Thanks Sven
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art S.
> Kagel (Oninit LLC)
> Sent: Tuesday, December 11, 2007 6:58 PM
> To: ids@iiug.org
> Subject: Re: How to Setup IDS for all IPs [10705]
>
> Schuran, Sven wrote:
>
>> Hi,
>>
>> when I am using a "*" as IP/host in my sqlhosts file,
>> I may access the database through every IP with same port existing on the
>> server, even when it is assigned later.
>>
>>
>>
>
> Clients still have to reconnect and the newly 'assigned' address has to
> be listed in the sqlhosts file and has to be named either in the
> INFORMIXSERVER or DBPATH environment variable or INFORMIXSERVER has to
> be set to a group name that includes the assignable or floating
> address. But this all misses the point. My point was, instead of
> having the address failover, just use DBPATH or sqlhosts groups to
> failover to the back up server's real address. Works just as well and
> probably more reliably without waiting for heartbeat detection to switch
> the addressing.
>
> Art S. Kagel
>
>
>> Sven
>>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art S.
>> Kagel (Oninit LLC)
>> Sent: Thursday, November 29, 2007 6:50 PM
>> To: ids@iiug.org
>> Subject: Re: How to Setup IDS for all IPs [10535]
>>
>> Martin Fuerderer wrote:
>>
>>
>>> Hi Art,
>>>
>>>
>>>
>> You do mention DBPATH and 'methods' but I think the focus on:
>>
>> "... 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."
>>
>> Doesn't make it clear that users and apps do NOT need to deal with the
>> two separate IP address/hostnames for the primary and backup servers but
>> can use connection failover mechanisms built into IDS communications
>> protocols (and ODBC/JDBC protocols for that matter) to failover using a
>> single 'server' name.
>>
>> Art S. Kagel
>> Oninit, LLC
>>
>>
>>> I thought I mentioned DBPATH ... no? I think you even
>>> copied my mention of it in the snippet? :-)
>>>
>>> Yes, you are right with the group-concept in sqlhosts.
>>> That's why I wrote that we have mechanisms for such
>>> things and DBPATH is *one* example.
>>>
>>> I thought for one that explaining the group-concept
>>> in sqlhosts is a bit too much in that e-mail as it was
>>> (too) long already.
>>> And secondly I thought this way I give you a chance
>>> to explain the group concept - which you did nicely! :))
>>>
>>> Thanks,
>>> 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.