[Info-ingres] Redirect local connections to a vnode?

[Martin Bowes]

The parameter is called: remote_vnode

We use it extensively, and it works perfectly well.

Use netutil to create the vnode required. Depending upon circumstance this may need to be a global vnode and require an installation password configured on the remote host.

Then CBF Name Server / Configure and install the node created above into remote_vnode.

Martin Bowes

From: Jean-Pierre Zuate [mailto:jpzuate at gmail.com]
Sent: 26 August 2018 11:17
To: daveh471 at gmail.com
Cc: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Redirect local connections to a vnode?

Hi,

As far I remember you can explore Ingres/Net configuration and default_vnode parameter.

You app still connect to a "local" db, but in  real the db is in an other machine.

You can also imagine your batch running in a client only installation with default_vnode configured to the machine you want they connect to.

Hope this help and is clear, and my English not too poor 😉

Regards,
Jean-Pierre Zuate
Le dim. 26 août 2018 à 11:15, daveh471 at gmail.com<mailto:daveh471 at gmail.com> <daveh471 at gmail.com<mailto:daveh471 at gmail.com>> a écrit :
Hi,
We have lots of C batch programs that connect to Ingres, currently they
run on the same host as the db server.  We'd like to split them up so
the Ingres db runs on separate hardware.

Currently the code connects to a plain database name 'db-live',
unfortunately this has been hardcoded into lots of scripts / programs
rather than having a central shared parameter.

Is it possible inject a vnode into this e.g.   newhost::db-live  with
out changing the connection string in the code?  Recompiling and
redeploying all the code would be difficult at best.

So 'db-live' would become an alias for an Ingres.Net connection
'newhost::db-live' that would direct off to the remote host somehow.

Can we setup an Ingres.NET installation that accepts connections locally
and transparently routes them off to the remote server?

Or any other ideas?

Thanks.
_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org<mailto:Info-ingres at lists.planetingres.org>
http://lists.planetingres.org/mailman/listinfo/info-ingres
--

Envoyé depuis un grille pain Coréen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20180828/528ecd32/attachment.html>