[Info-ingres] Redirect local connections to a vnode?
daveh471 at gmail.com
daveh471 at gmail.com
Sun Aug 26 09:12:53 UTC 2018
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.
More information about the Info-ingres
mailing list