IDS Forum

RE: Connection Manager configuration

Posted By: Mike Walker
Date: Wednesday, 14 June 2017, at 2:20 p.m.

In Response To: Connection Manager configuration (MUKESH TANUKU)

There's a lot to cover with Connection Manager, which is probably why you
haven't seen a rush of responses. I have sent you a presentation by Tom
Beebe that covers some of the configuration. Tom also is giving a webcast
on June 29th on it: http://advancedatatools.com/Informix/NextWebcast.html

Very briefly though, Connection Manager is supplied with Informix, so you
should already have it. Look for the executable "oncmsm" - that's it. It
is not separately licensed from the engine.

Your connections will initially connect to Connection Manager instead of
directly to Informix and it will route them to the applicable server - often
the primary server of an HDR pair. It will either redirect the connection
request, and/or work as a proxy and forward the communication through it -
depends on how it's configured. This will require changes to sqlhosts for
the CM connections (and /etc/services if naming the port) and also onconfig,
maybe DBSERVERNAME and DBSERVERALIAS.

Connection Manger can also monitor the servers and initiate an automatic
failover should the primary fail. This requires another change to the
onconfig - modifying DRAUTO to 3.

It is recommended that the Connection Manager is set up on separate servers
from the Informix instances for resiliency, and also multiple servers, for
redundancy. That is not strictly necessary though depending on your
environment and your needs.

Hopefully this is enough to get started. I understand that the
documentation is a bit challenging but maybe it will make more sense now...

Mike

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MUKESH
TANUKU
Sent: Wednesday, June 14, 2017 11:47 AM
To: ids@iiug.org
Subject: Connection Manager configuration [39378]

Hi All,
I implemented High availability data replication (HDR) on my two dedicated
servers. They are working fine. Presently they are configured as manual
switchover. Now we want to make this a automatic failover.

I had searched in goolge and finally came to know that is Connection
manager.
It is responsible for automatic failover.

Now, could you please help me how to work on this connection manager to get
successful in making this environment as automatic failover.

Searched a lot in google, but didnt get clear idea on where to start and how
to configure.
What is Connection Manager?
Where can i get it, if it is external utility?
How to configure?
Process to configure and steps involved?
Where need to do changes, if required, in onconfig, sqlhosts, hosts,
services etc..?
What is SLA's and how to use this?

Please help me on this. Thank you all for reading my post and for your
answers.

****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Connection Manager configuration
  MUKESH TANUKU -- Wednesday, 14 June 2017, at 1:47 p.m.
  • RE: Connection Manager configuration
    Mike Walker -- Wednesday, 14 June 2017, at 2:20 p.m.
  • Re: Connection Manager configuration
    Madison Pruet -- Wednesday, 14 June 2017, at 2:58 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.