MySQL Forums
Forum List  »  Router & Proxy

Re: Selecting backend based on the user connecting
Posted by: Jesper Juhl
Date: August 13, 2007 05:57AM

> You can leave out the read_query_result() and its backend_ndx = 0 and it will keep
> the connection once it is selected.

Hmm, ok, so I can do something like this in read_query() ??

global variable this_is_first_query = true

if (this_is_first_query) {
look_at_username_and_pick_proper_backend()
this_is_first_query = false
}

so I only do the lookup once for each connection?


> Perhaps I should cut down the tutorial an split it into smaller pieces to show the
> steps.

That would be great.

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.