[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