MySQL Forums
Forum List  »  Router & Proxy

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

> This is similar to the keepalive tutorial where we show read/write splitting.
>
> The idea is:
>
> * connect_server() builds a pool of connections to all backends and maintains it
> * read_query() picks a backend based on the user, query, ...

Doing things this way means I'd have to do a lookup for every single query to find the proper backend for a given user. If instead I can do that lookup only once at connect time and then assign a specific connection for each user to their specific backend server, wouldn't this scale a lot better?

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.