[Sqlrelay-discussion] redirect Q.

[Peter C. <pc...@sa...>]

Hello Dave,

I *think* I'm almost there with query redirection. Basically he 
objective is if a user wishes to connect to database test1 then the 
query needs to be directed to instance on server 1 port xxx and if a 
query is made for database test2 then it needs to be directed to server 
instance 2 on port yyyy etc.

I've included the config used but  I think I'm missing something with 
the route section as there it generates an error starting the routing. 
I'm also unsure as to which usernamr / password the route part is 
expecting... is this a generic pair that needs to exist on all instances ?

Any pointers, as always much appreciated.


Pete


P.S. You previous suggestion of removing the Debian included xllint has 
allowed things to move a tad more smoothly, thanks for hte heads up.


-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE.