MySQL Forums
Forum List  »  Router & Proxy

Re: Selecting backend based on the user connecting
Posted by: Jan Kneschke
Date: August 13, 2007 06:20AM

Yeah,

-- pseudo code ahead

function read_auth_response(...)
-- if auth successful
proxy.connection_backend_ndx = 0
end

function read_query(...)
if proxy.connection.backend_ndx == 0 then
-- pick new backend
proxy.connection.backend_ndx = ndx
end
end

-- no reset of the backend_ndx in read_query_result()

--
Jan Kneschke, MySQL Enterprise Tools

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.