[Sqlrelay-discussion] sqlrelay redirect question
Brought to you by:
mused
|
From: Peter C. <pc...@sa...> - 2008-04-17 10:46:03
|
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. |