Re: Selecting backend based on the user connecting

[Jesper Juhl]

> 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.