[Sqlrelay-discussion] sqlrelay redirect question

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

Dear all,

Having just started playing with sqlrealy I apologise if this is a daft 
Q, I've browsed the archives but I'm not sure I've found how best to 
tackle the following problem.

We have a number of mysql instances running on various hosts and ports. 
We would like to be able to rediect queries to a given instance 
depending upon the database requested. So in essence we'd have:

server1  port 3306  database1
server2  port 3307  database2
server2  port 5307  database3
server3  port 5304  database4

So user points connection at sqlrelay for a given database connection 
this is then (hopefully) redirected transparently to the required server .

Pointers of best way forward would be much appreciated.

Many thanks

Pete


-- 
 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.