RE: Connection Manager and I4GL
Sigh. KISS applies. 4GL apps are client/server. You may want to consider some sort of DNS / host mapping solution. That is, your application connects to the server via hostname. If the heart beat of the host goes down, your DNS system catches the alert and the secondary's IP address is given instead of the primary when the DNS is queried to get the IP address of the host. (Assuming that the local client isn't caching the ip address so it doesn't do a DNS lookup.) At least that's the theory and its OS independent. Your users will lose their last transaction no matter what since the cursors go away with the loss of connection. Doesn't Veritas (now Symantec) have something similar to this concept? -G > Date: Fri, 14 Aug 2009 13:57:36 +0100 > Subject: Re: Connection Manager and I4GL > From: smiley73@googlemail.com > To: goddai01@hotmail.co.uk > CC: informix-list@iiug.org > > 2009/8/14 Ian Goddard <goddai01@hotmail.co.uk>: > > Clive Eisen wrote: > >> On 14/08/2009 12:25, Ian Goddard wrote: > >> > >>> As an alternative you could handle this through the IP addresses. Have > >>> the standby change its address to that of the main. When the previous > >>> main is repaired you could either allocate it to the standby address or > >>> switch the standby machine back to its original address. > >>> > >> > >> IMHO this is a 'Bad Idea' (tm) > >> > >> a) It will confuse the shit out of admin people > > > > Admin people would have to put it into place. They're paid to look > > after stuff like this. > > > >> b) You would have to wait for the arp caches to flush or do it manually > > > > Agreed. It wouldn't be invisible. But it's easier than going round all > > the clients changing them to connect to a different host if Connection > > Manager isn't usable; especially so when some of the clients are a > > couple of hundred miles away. > > > >> > >> If you are going to go down this route then at least have a floating IP > >> address for the 'active' engine - don't change the primary IP of a given > >> piece of tin. > >> > >> If you are on linux take a look at linux-ha - it would allow you to > >> automate many of the tasks. > > > > HP-UX had an add-on something like this which is what prompted the > > thought. For all I know they might still have it. I think Keith said > > somewhere that he was on AIX, maybe IBM have their own solution. > > > > -- > > Ian > > > > Hotmail is for spammers. Real mail address is igoddard > > at nildram co uk > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > I am the admin, but as the DR machine is on a different physical site > with separate sub-netting this is a non-starter. AIX !!! so linux/hp > solutions are no good. > There is not going to be a quick or easy resolution for this issue, > need to do a bit more investigation/testing. > > Keith > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ Get your vacation photos on your phone! http://windowsliveformobile.com/en-us/photos/default.aspx?&OCID=0809TL-HM