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

[Jean-Pierre Zuate]

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 <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
> 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/20180826/6c21fd77/attachment.html>