Re: Selecting backend based on the user connecting
> 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.
Subject
Views
Written By
Posted
3503
August 13, 2007 03:42AM
2741
August 13, 2007 04:05AM
Re: Selecting backend based on the user connecting
2572
August 13, 2007 04:11AM
2478
August 13, 2007 04:27AM
2488
August 13, 2007 05:29AM
2456
August 13, 2007 06:17AM
2642
August 20, 2007 05:47AM
2585
August 20, 2007 09:06AM
2608
August 22, 2007 07:45AM
2519
August 13, 2007 04:16AM
2516
August 13, 2007 04:25AM
2314
August 13, 2007 05:57AM
2407
August 13, 2007 06:20AM
2579
August 13, 2007 09:03AM
2324
October 11, 2007 02:31AM
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.