MySQL Forums
Forum List  »  Router & Proxy

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

> 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, ...
> This assumes that all servers share the same user + passwords.

Well, the problem is, that they won't be sharing users. I guess I *could* maintain all users on all backend servers - not a big deal if I only have two backend servers, but I expect the number of backends will grow to quite a bit more than two, so I'd really prefer for each backend server to only contain the users relevant to it.

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.