Re: Selecting backend based on the user connecting

[Jan Kneschke]

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